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