How To Run Autoconfig

perl <AD_TOP>/bin/admkappsutil.pl

cd <RDBMS ORACLE_HOME>

unzip -o appsutil.zip

sh $ORACLE_HOME/appsutil/bin/adchkcfg.sh contextfile=$CONTEXT_FILE

sh <AD_TOP>/bin/adchkcfg.sh contextfile=<CONTEXT_FILE>

sh <RDBMS_ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>/adautocfg.sh

sh <INST_TOP>/admin/scripts/adautocfg.sh

Hi 

Please do the following action plan: 

1. 
$ sqlplus apps/<APPS password> 
SQL>exec fnd_conc_clone.setup_clean; 

2. 
Run AutoConfig on the database tier. 

3. 
Run AutoConfig on the run file system of the application tier. 

Thanks 
Oracle Support 

=======================================清除节点信息

sqlplus apps/apps

exec fnd_conc_clone.setup_clean;

commit;

 

conn apps/trnapps

exec fnd_conc_clone.setup_clean;

commit;

=======================================dbTier autoconfig

rac1

ls -l $CONTEXT_FILE

cd $ORACLE_HOME/appsutil/bin

./adconfig.sh

 

/u01/app/oracle/product/11.2/appsutil/PROD1_rac1.xml

 

rac2

ls -l $CONTEXT_FILE

cd $ORACLE_HOME/appsutil/bin

./adconfig.sh

 

/u01/app/oracle/product/11.2/appsutil/PROD2_rac2.xml

=======================================appsTier autoconfig

cd $ADMIN_SCRIPTS_HOME

./adautocfg.sh

 

ls -l $CONTEXT_FILE

cd $AD_TOP/bin/

./adconfig.sh

=======================================

 

-------------------------------------------------------
sh $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/adautocfg.sh
sh $ADMIN_SCRIPTS_HOME/adstpall.sh
sh $INST_TOP/admin/scripts/adautocfg.sh
-------------------------------------------------------
sqlplus apps/apps
exec fnd_conc_clone.setup_clean;
commit;

ls -l $CONTEXT_FILE
cd $ORACLE_HOME/appsutil/bin
./adconfig.sh

ls -l $CONTEXT_FILE
cd $AD_TOP/bin/
./adconfig.sh
-------------------------------------------------------
su - applvis
. /EBS/VIS/EBSapps.env run
perl $AD_TOP/bin/admkappsutil.pl

su - oravis
cd $ORACLE_HOME
cp /EBS/VIS/fs1/inst/apps/VIS_ol7-122-ebs/admin/out/appsutil.zip .
unzip -o appsutil.zip
$ORACLE_HOME/appsutil/bin/adconfig.sh contextfile=$CONTEXT_FILE

truncate table fnd_oam_context_files;
truncate table fnd_nodes;
truncate table adop_valid_nodes;

. /EBS/VIS/EBSapps.env run
$AD_TOP/bin/adconfig.sh contextfile=$CONTEXT_FILE

. /EBS/VIS/EBSapps.env patch
sqlplus system/manager
alter trigger ebs_logon disable;
exit;
$AD_TOP/bin/adconfig.sh contextfile=$CONTEXT_FILE
sqlplus system/manager
alter trigger ebs_logon enable;
exit;
-------------------------------------------------------

 

Post Install Steps

1. On the Application Tier

su - apjtsit

 . Source the environment variables for Oracle Applications

. $APPL_TOP/APPSJTSIT_c3-jtcwebs2.env

 . Run AutoConfig on the APPL_TOP

$AD_TOP/bin/adconfig.sh

 

 . Execute admkappsutil.pl utility to create the file appsutil.zip

perl $AD_TOP/bin/admkappsutil.pl

 

2. On the Database Tier

 . Copy or FTP the appsutil.zip file to the $ORACLE_HOME

sftp> lcd E:\

sftp> cd /home/db/JTSIT/11.2

sftp> put appsutil.zip

 

chown -fR dbjtsit.dba appsutil.zip

chmod -fR 777 appsutil.zip

 

cd $ORACLE_HOME

cp -RH appsutil appsutil.20140729

unzip -o appsutil.zip

   . Run AutoConfig on the <RDBMS ORACLE_HOME>

$ORACLE_HOME/appsutil/bin/adconfig.sh

/home/db/JTSIT/11.2/appsutil/JTSIT_adb.xml

 

3. Re-run adpreclone.pl on the dbTier and appsTier

cd $ORACLE_HOME/appsutil/scripts

cd JTSIT_adb

perl adpreclone.pl dbTier

 

cd $INST_TOP/admin/scripts

perl adpreclone.pl appsTier

 

SQL> update FND_PROFILE_OPTION_VALUES  fpoa

  2  set profile_option_value='TEST测试环境(由2014年11月22日23:26:55生产数据克隆)'

  3  where fpoa.application_id=0

  4  and fpoa.profile_option_id=125

  5  and level_id=10001;

 

1 row updated.

 

SQL> select profile_option_value from FND_PROFILE_OPTION_VALUES  fpoa  where fpoa.application_id=0 and fpoa.profile_option_id=125 and level_id=10001;

 

PROFILE_OPTION_VALUE

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

TEST测试环境(由2014年11月22日23:26:55生产数据克隆)

 

SQL> commit;

 

Commit complete.

 

Reference about AutoConfig 

165195.1 - Using AutoConfig to Manage System Configurations with Oracle Applications 11i 
387859.1 - Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12 

http://www.appsdba.info/docs/oracle_apps/R12/AutoConfig.pdf

http://onlineappsdba.com/index.php/2008/01/28/autoconfig-in-oracle-apps-11i-r12-12i/

218089.1 Autoconfig FAQ 
270519.1 Customizing an AutoConfig Environment 
364927.1 How To Run Autoconfig On Database Tier (DB-Tier) 
341322.1 How to change the hostname of an Applications Tier using AutoConfig 
338003.1 How to change the hostname and/or port of the Database Tier using AutoConfig 
315674.1 How To Verify if Autoconfig is Enabled on 11.5.x 
391406.1 How to get a clean Autoconfig Environment