How to run Autoconfig On DB Tier and Apps Tier on R12

Basically autoconfig is tool to reconfigure your Oracle Application configuration files using context (XML file) and template files.

To run autoconfig in ebs R12.*.*. We need to follow the below steps to run autoconfig on DB-Tier and Middle(APPS) Tier.

1.    Stop the Middle Tier Services.

source the APPS environment

Go under $APPL_TOP and run the APPSPHASE1_acetest.env .

$ .  APPSPHASE1_acetest.env  or source APPSPHASE1_acetest.env  run

Check if apps environment was sources.

$ env or echo $ORACLE_HOME

Now stop the Middle(APPS) Tier .

$ cd $ADMIN_SCRIPTS_HOME

$sh adstpall.sh   

2.     Run Autoconfig on DB-Tier

source dbTier environment:-

$cd $ORACLE_HOME

$source PHASE1_aceapps.env run

Go under  $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME

$ls 

$adautocfg.sh  adchknls.pl  addbctl.sh  addlnctl.sh  adexecsql.pl  adpreclone.pl  adstopdb.sql  adstrtdb.sql

Now run the autoconfig on DB-Tier.

$cd $ORACLE_HOME/$CONTEXT_NAME

$ sh adautocfg.sh

Enter the APPS user password:

The log file for this session is located at: /data01/GSTUAT3/orahome1124/appsutil/log/PHASE1_aceapps/08201500/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.

        Using ORACLE_HOME location : /data01/GSTUAT3/orahome1124

        Classpath                   : :/data01/GSTUAT3/orahome1124/jdbc/lib/ojdbc6.jar:/acedata01/GSTUAT3/orahome1124/appsutil/java/xmlparserv2.jar:/data01/GSTUAT3/orahome1124/appsutil/java:/acedata01/GSTUAT3/orahome1124/jlib/netcfg.jar:/data01/GSTUAT3/orahome1124/jlib/ldapjclnt11.jar

        Using Context file          : /data01/GSTUAT3/orahome1124/appsutil/PHASE1_aceapps.xml

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.

Check the autoconfig logs.

$cd $ORACLE_HOME/appsutil/log/

$pwd

/data01/GSTUAT3/orahome1124/appsutil/log

3.    Run Autoconfig on Application Tier

source APPSPHASE1_acetest.env run

Check whether you source run edition

 

$echo $FILE_EDITION

run

Now run the Autoconfig on Middle(APPS) Tier.

$cd $ADMIN_SCRIPTS_HOME

$sh adautocfg.sh

Enter the APPS user password:

The log file for this session is located at: /data05/EBS_FS_12.2.5/fs1/inst/apps/PHASE1_acetest/admin/log/08201454/adconfig.log

wlsDomainName: EBS_domain

WLS Domain Name is VALID.

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.

        Using CONFIG_HOME location     : /data05/EBS_FS_12.2.5/fs1/inst/apps/PHASE1_acetest

        Classpath                   : /data05/EBS_FS_12.2.5/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/acedata05/EBS_FS_12.2.5/fs1/EBSapps/comn/java/classes

        Using Context file          : /data05/EBS_FS_12.2.5/fs1/inst/apps/PHASE1_acetest/appl/admin/PHASE1_acetest.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 SHT_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 GMF_TOP.......COMPLETED

        Configuring PON_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.

Check the Autoconfig logs in APPS Tier.

$cd $APPL_TOP/admin/$TWO_TASK/log

4.    Restart Application (Middle Tier) services

source the APPS environment

Go under $APPL_TOP and run the APPSPHASE1_acetest.env .

$echo $FILE_EDITION

run

$cd $ADMIN_SCRIPTS_HOME

$sh adstrtal.sh