Follow below steps to run autoconfig on database tier and Application tier.
EBS version - R12.2.0
DB version - 11.2.0.3
Step 1 : Stop Application (Middle tier) services
Thanks,
Chowdari
EBS version - R12.2.0
DB version - 11.2.0.3
Step 1 : Stop Application (Middle tier) services
a) source APPS environment
-bash-3.2$ source /u01/R122_EBS/EBSapps.env run
b) Check whether you source run edition
-bash-3.2$ echo $FILE_EDITION
run
-bash-3.2$
c) Now stop middle tier services
-bash-3.2$ cd $ADMIN_SCRIPTS_HOME
-bash-3.2$ sh adstpall.sh
Step 2 : run Autoconfig on DB-Tiera) source RDBMS environment
-bash-3.2$ source /u01/R122_EBS/11.2.0.3/testdb_ebstestdb.env
b) check RDBMS environment was sourced
-bash-3.2$ echo $ORACLE_HOME
/u01/R122_EBS/11.2.0.3
-bash-3.2$
c) Now run Autoconfig on DB Tier
-bash-3.2$ cd /u01/R122_EBS/11.2.0.3/appsutil/scripts/
-bash-3.2$ ls -rlt
total 4
drwxr-xr-x 2 oracle dba 4096 Jun 18 00:16 testdb_ebstestdb
-bash-3.2$ cd testdb_ebstestdb/
-bash-3.2$ ls
adautocfg.sh adchknls.pl addbctl.sh addlnctl.sh adexecsql.pl adlsnodes.sh adpreclone.pl adstopdb.sql adstrtdb.sql
-bash-3.2$
-bash-3.2$ sh adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/R122_EBS/11.2.0.3/appsutil/log/testdb_ebstestdb/06180637/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/R122_EBS/11.2.0.3
Classpath:/u01/R122_EBS/11.2.0.3/jdbc/lib/ojdbc6.jar:/u01/R122_EBS/11.2.0.3/appsutil/java/xmlparserv2.jar:/u01/R122_EBS/11.2.0.3/appsutil/java:/u01/R122_EBS/11.2.0.3/jlib/netcfg.jar:/u01/R122_EBS/11.2.0.3/jlib/ldapjclnt11.jar
Using Context file : /u01/R122_EBS/11.2.0.3/appsutil/testdb_ebstestdb.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
-bash-3.2$
Step 3 : Check Autoconfig log filesa) Check the autoconfig logfiles for any errors
-bash-3.2$ cd $ORACLE_HOME/appsutil/log/
-bash-3.2$ pwd
/u01/R122_EBS/11.2.0.3/appsutil/log
-bash-3.2$
Step 4 : run Autoconfig on Application Tiera) source APPS environment
-bash-3.2$ source /u01/R122_EBS/EBSapps.env run
b) Check whether you source run edition
-bash-3.2$ echo $FILE_EDITION
run
-bash-3.2$
c) run Autoconfig on Application Tier
-bash-3.2$ cd $ADMIN_SCRIPTS_HOME
-bash-3.2$ sh adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/R122_EBS/fs1/inst/apps/testdb_ebstestdb/admin/log/06180638/adconfig.log
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /u01/R122_EBS/fs1/inst/apps/testdb_ebstestdb
Classpath : /u01/R122_EBS/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/R122_EBS/fs1/EBSapps/comn/java/classes
Using Context file : /u01/R122_EBS/fs1/inst/apps/testdb_ebstestdb/appl/admin/testdb_ebstestdb.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 CZ_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 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 IES_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed successfully.
-bash-3.2$
Step 5 : Start Application (Middle tier) servicesa) start middle tier services
-bash-3.2$ echo $FILE_EDITION
run
-bash-3.2$ cd $ADMIN_SCRIPTS_HOME
-bash-3.2$ sh adstrtal.sh
That's it..Now check application.Thanks,
Chowdari