Shulou(Shulou.com)06/01 Report--

Be 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:

Truncate table fnd_user

Truncate table fnd_oracle_userid

Insert into fnd_user select * backup table in front of from

Insert into fnd_oracle_userid select * from.

Commit

[applprod@ebsprod scripts] $FNDCPASS APPS/APPS 0 Y SYSTEM/MANAGER SYSTEM APPLSYS llcebs

Log filename: L392520.log

Report filename: O392520.out

[applprod@ebsprod 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

[applprod@ebsprod 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

+-- +

Perform autocfg:

[applprod@ebsprod 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

[applprod@ebsprod scripts] $. / adautocfg.sh

Enter the APPS user password:

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

AutoConfig is configuring the Applications environment...

AutoConfig will 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/java/classes

Using Context file: / app/appl_prod/inst/apps/PROD_ebsprod/appl/admin/PROD_ebsprod.xml

Context Value Management will 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:

[oraprod@ebsprod PROD_ebsprod] $sqlplus apps/llcebs

SQL*Plus: Release 11.1.0.7.0-Production on Tue Jun 14 14:38:27 2016

Copyright (c) 1982, 2008, 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 >

Change the password of sysadmin:

[applprod@ebsprod scripts] $FNDCPASS APPS/llcebs 0 Y SYSTEM/MANAGER USER sysadmin llcebs

Log filename: L392524.log

Report filename: O392524.out

In the case of multi-node APP: the execution order is 1-"2mi -". one

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.