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

Run autoconfig on db tier and apps tier| Basically autoconfig is tool to reconfigure your Oracle Application configuration files using context (XML file) and template files.

Best steps to Run autoconfig on db tier and apps tier.

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

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 appsTier .

$ cd $ADMIN_SCRIPTS_HOME

$sh adstpall.sh   

Run Autoconfig on dbTier

source dbTier environment:-

$cd $ORACLE_HOME

$source PHASE1_aceapps.env run

Go to under $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME and run run autoconfig on database.

$ls

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

Now run autoconfig in 19c database or any other oracle database.

$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/jli

b/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.

Autoconfig logs in r12.2

To Check the autoconfig logs just go under mentioned location.

$cd $ORACLE_HOME/appsutil/log/

$pwd

/data01/GSTUAT3/orahome1124/appsutil/log

Steps to Run autoconfig in 12.2 :-

Run autoconfig on appTier

source APPSPHASE1_acetest.env run

Check whether you source run edition

$echo $FILE_EDITION

run

Now run the Autoconfig on Middle(APPS) Tier.