How to change SYSADMIN Password in Oracle EBS R12

How to change SYSADMIN Password in Oracle EBS R12

Test environment:
SQL> select * from v $ version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0-64bit Production
PL/SQL Release 11.1.0.7.0-Production
CORE 11.1.0.7.0 Production
TNS for Linux: Version 11.1.0.7.0-Production
NLSRTL Version 11.1.0.7.0-Production

SQL> select release_name from fnd_product_groups;

RELEASE_NAME
--------------------------------------------------
12.1.1

SQL>

1. Change sysadmin Password
1.1 if you have a shell password, you can use the CPASS tool to change it:
FNDCPASS apps/appspwd 0 Y system/manager user sysadmin newspassword

Demo:
-Bash-3.2 $FNDCPASS apps/apps 0 Y system/manager user sysadmin welcome1
Log filename: L5818900.log


Report filename: O5818900.out


1.2 if you have an app password, you can change it through the fnd_user_pkg stored procedure:
Declare
Rochelle flag boolean;
Begin
Rochelle flag = fnd_user_pkg.change_password ('sysadmin', 'newpassword ');
End;

Demo:
SQL> set serveroutput on
SQL> DECLARE
2 l_flag BOOLEAN;
3 BEGIN
4 l_flag: =Fnd_user_pkg.changepassword ('sysadmin', 'welcome2 ');
5 DBMS_OUTPUT.put_line ('L _ flag ='
6 | CASE l_flag
7 WHEN TRUE
8 THEN 'true'
9 ELSE 'false'
10 END
11 );
12 END;
13/
Rochelle flag = true

PL/SQL procedure successfully completed.

SQL> commit; -- Do not forget to submit, otherwise it will not take effect

Commit complete.

SQL>


2. Verify that the logon password is correct.
2.1 verify with fnd_user_pkg.validatelogin:
Demo:
SQL> DECLARE
2 l_flag BOOLEAN;
3 BEGIN
4 l_flag: = fnd_user_pkg.validatelogin ('sysadmin', 'welme2 ');
5 DBMS_OUTPUT.put_line ('L _ flag ='
6 | CASE l_flag
7 WHEN TRUE
8 THEN 'true'
9 ELSE 'false'
10 END
11 );
12 END;
13/
Rochelle flag = true

PL/SQL procedure successfully completed.

SQL>


2.2 perform verification through the fnd_web_sec.validate_login process:
Demo:
SQL> SELECT fnd_web_sec.validate_login ('sysadmin', 'welcome2') FROM DUAL;

FND_WEB_SEC.VALIDATE_LOGIN ('sysadmin', 'welcome2 ')
--------------------------------------------------------------------------------
Y

SQL>