Oracle EBS modifies passwords for apps users

Make sure to back up the password before you fix it.

Sql> CREATE TABLE fnd_user_20160614 as SELECT * from Fnd_user;

Table created.

Sql> CREATE TABLE fnd_oracle_userid_20160614 as SELECT * from Fnd_oracle_userid;

Table created.

If the modification fails:

1. truncate table Fnd_user;

2. truncate table Fnd_oracle_userid;

3. Insert into Fnd_user Select * the backup table from the front;

4. Insert into Fnd_oracle_userid Select * from ...;

5. commit;
   

[[email protected] scripts]$ fndcpass Apps/apps 0 Y system/manager SYSTEM applsys llcebs
Log Filename:L392520.log


Report Filename:O392520.out
[[email protected] scripts]$ ls
adalnctl.sh adcmctl.sh adformsctl.sh adoafmctl.sh adstpall.sh ieo L392520.log mwactlwrpr.sh
adapcctl.sh adexecsql.pl adformsrvctl.sh adopmnctl.sh adstrtal.sh java.sh msc Sqlnet.log
adautocfg.sh adforms-c4wsctl.sh adoacorectl.sh adpreclone.pl gsmstart.sh jtffmctl.sh mwactl.sh
[email protected] scripts]$ cat L392520.log
+---------------------------------------------------------------------------+
Application Object library:version:12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

Module
+---------------------------------------------------------------------------+

Current system time is 14-jun-2016 14:28:37

+---------------------------------------------------------------------------+

Working ...


+---------------------------------------------------------------------------+
Concurrent Request completed successfully
Current system time is 14-jun-2016 14:28:38

+---------------------------------------------------------------------------+
Execution AutoCfg:

[[email protected] scripts]$ ls
adalnctl.sh adcmctl.sh adformsctl.sh adoafmctl.sh adstpall.sh ieo L392520.log mwactlwrpr.sh
adapcctl.sh adexecsql.pl adformsrvctl.sh adopmnctl.sh adstrtal.sh java.sh msc Sqlnet.log
adautocfg.sh adforms-c4wsctl.sh adoacorectl.sh adpreclone.pl gsmstart.sh jtffmctl.sh mwactl.sh
[Email protected] scripts]$./adautocfg.sh
Enter the APPS user password:

The log file for this session was located at:/app/appl_prod/inst/apps/prod_ebsprod/admin/log/06141432/adconfig.log

AutoConfig is configuring the applications environment ...

AutoConfig would consider the custom templates if present.
Using config_home Location:/app/appl_prod/inst/apps/prod_ebsprod
Classpath:/app/appl_prod/apps/apps_st/comn/java/lib/appsborg2.zip:/app/appl_prod/apps/apps_st/comn/jav A/classes

Using Context File:/app/appl_prod/inst/apps/prod_ebsprod/appl/admin/prod_ebsprod.xml

Context Value Management would now update the Context file

Updating Context file...completed

Attempting upload of Context file and templates to database...completed

Configuring templates from all of the product tops ...
Configuring ad_top........completed
Configuring fnd_top.......completed
Configuring icx_top.......completed
Configuring msc_top.......completed
Configuring ieo_top.......completed
Configuring bis_top.......completed
Configuring ams_top.......completed
Configuring cct_top.......completed
Configuring wsh_top.......completed
Configuring cln_top.......completed
Configuring oke_top.......completed
Configuring okl_top.......completed
Configuring oks_top.......completed
Configuring csf_top.......completed
Configuring igs_top.......completed
Configuring iby_top.......completed
Configuring jtf_top.......completed
Configuring mwa_top.......completed
Configuring cn_top........completed
Configuring csi_top.......completed
Configuring wip_top.......completed
Configuring cse_top.......completed
Configuring eam_top.......completed
Configuring fte_top.......completed
Configuring ont_top.......completed
Configuring ar_top........completed
Configuring ahl_top.......completed
Configuring ozf_top.......completed
Configuring ies_top.......completed
Configuring csd_top.......completed
Configuring igc_top.......completed

AutoConfig completed successfully.
-Check the log to see if there are any errors:

[Email protected] prod_ebsprod]$ Sqlplus Apps/llcebs

Sql*plus:release 11.1.0.7.0-production on Tue June 14 14:38:27 2016

Copyright (c) 1982, the Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options

Sql>

To modify the sysadmin password:

[[email protected] scripts]$ fndcpass apps/llcebs 0 Y system/manager USER sysadmin Llcebs
Log Filename:L392524.log


Report Filename:O392524.out

If it is a multi-node app: The order of execution is 1-"2--" .... 1

Oracle EBS modifies passwords for apps users