How to change SYSADMIN password

Instead of oracle application, there are 3 ways to change sysadmin password, but second method only is legal to proceed

Use the following methods to change the sysadmin password if you forget the password

1. select APPS.fnd_web_sec.change_password('SYSADMIN','new password') from dual;
2. FNDCPASS APPS/password 0 Y SYSTEM/password USER SYSADMIN 'new password'
3. fnd_user_pkg.UPDATEUSER('SYSADMIN',NULL,'new password');

Method # 1
sqlplus /nolog

SQL>conn apps/
SQL>select APPS.fnd_web_sec.change_password('SYSADMIN','CLONE') from dual;

APPS.FND_WEB_SEC.CHANGE_PASSWORD('SYSADMIN','CLONE')
--------------------------------------------------------------------------------
Y
SQL>exit

Method # 2
Login as APPLMGR user from concurrent + admin tier

[applmgr@drdb ~]$ FNDCPASS APPS/ 0 Y SYSTEM/ USER SYSADMIN
Log filename    : L2940426.log
Report filename : O2940426.out

check the log file for output of this request.

Method # 3
[oracle@drdb ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Tue May 11 15:47:24 2010
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> conn apps/
Connected.

SQL> exec fnd_user_pkg.updateuser('sysadmin',null,'99999');

PL/SQL procedure successfully completed.
SQL>

Cheers!

Please leave your comments....

Related Posts by Categories