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.

Table of Contents

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.

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 dbTier

source dbTier environment:-

$cd $ORACLE_HOME

$source PHASE1_aceapps.env run

Go 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 on dbTier.

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

Check the autoconfig logs.

$cd $ORACLE_HOME/appsutil/log/

$pwd

/data01/GSTUAT3/orahome1124/appsutil/log

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

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

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