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

by

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.

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

Related posts:-

Autoconfig in Oracle Apps R12 adautocfg.sh – Online Apps DBA

1 thought on “How to run Autoconfig On DB Tier and Apps Tier on R12”

Leave a Comment