EBS R12 Change the sysadmin password

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 the sysadmin password
1.1 If you have a shell password, you can change it using the CPASs tool:
Fndcpass apps/appspwd 0 Y system/manager USER SYSADMIN Newspassword

Demonstrate:
-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 apps password, you can make changes through the fnd_user_pkg stored procedure:
Declare
L_flag Boolean;
Begin
L_flag = Fnd_user_pkg.change_password (' sysadmin ', ' newpassword ');
End

Demonstrate:
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 '
Ten END
11);
The END;
13/
L_flag = True

PL/SQL procedure successfully completed.

Sql> commit; --Don't forget to submit, otherwise it won't take effect.

Commit complete.

Sql>

2. Verify that the login password is correct
2.1 Validation via Fnd_user_pkg.validatelogin:
Demonstrate:
Sql> DECLARE
2 L_flag BOOLEAN;
3 BEGIN
4 L_flag: = Fnd_user_pkg.validatelogin (' sysadmin ', ' welcome2 ');
5 Dbms_output.put_line (' L_flag = '
6 | | Case L_flag
7 when TRUE
8 Then ' true '
9 ELSE ' false '
Ten END
11);
The END;
13/
L_flag = True

PL/SQL procedure successfully completed.

Sql>

2.2 Validation through the Fnd_web_sec.validate_login process:
Demonstrate:
sql> SELECT fnd_web_sec.validate_login (' sysadmin ', ' welcome2 ') from DUAL;

Fnd_web_sec. Validate_login (' SYSADMIN ', ' WELCOME2 ')
--------------------------------------------------------------------------------
Y

Sql>

----------------------

He has changed his own good.

--set Serveroutput on

DECLARE

L_flag BOOLEAN;

BEGIN

L_flag: = Fnd_user_pkg.changepassword (' sysadmin ', ' sysadmin ');

END;

Set Serveroutput on-this is done for the output and executes this line individually

DECLARE

L_flag BOOLEAN;

BEGIN

L_flag: = Fnd_user_pkg.changepassword (' sysadmin ', ' sysadmin ');

Dbms_output.put_line (' L_flag = ' | | Case

L_flag

When TRUE

Then ' true '

ELSE ' false '

END

);

END;

/

EBS R12 Change the sysadmin password