Here are the steps on How to run autoconfig in oracle apps R12 including both the Database and Application Tier. It is the same for all the versions of R12 i.e R12.0., R12.1 and R12.2
Stop Services on Middle and CM Tier
First, bring down all the services on Middle Tier and CM Tier
a. cd $ADMIN_SCRIPTS_HOME
b. run adstpall.sh
Autoconfig on the Database tier
(a) Source the Oracle Database env
(b) cd $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME
ii. run adautocfg.sh
iii) Check the autoconfig log files for any errors
cd $ORACLE_HOME/appsutil/log/$CONTEXT_NAME
If this is a RAC(Real Application Cluster) environment, we need to run on all the Nodes
Autoconfig on Apps Tier
Please run autoconfig on all the app tiers. Start with the Primary Tier and once all the nodes are done, Please run the autoconfig on the Primary node again
(a) Please source the APPS environment
(b) cd $ADMIN_SCRIPTS_HOME
(c) run adautocfg.sh
Start the services on App Tiers
Now once the autoconfig is completed, please start the services on all the nodes and verify the application
Restart the Middle (APPS) Tier
a. cd $ADMIN_SCRIPTS_HOME
b. run adstrtal.sh
I hope you like this post on How to run autoconfig in oracle apps R12. Please do provide the feedback
Related Articles
How to run Autoconfig in parallel: Check out this post on how to run autoconfig on multiple Apps tier in Parallel to save time.
Important Changes in Autoconfig R12.2: Autoconfig on R12.2 does not manage all the configurations like R12.0 and R12.1, This post gives us an overview of that
Oracle apps autoconfig templates location and customization: Check out this post for all the steps for Autoconfig templates customization, what important points to consider while customizing the autoconfig template
R12.2/R12/11i Common log file locations: This post has information for logfile locations in All the EBS Versions
https://docs.oracle.com/cd/E18727_01/doc.121/e12841/T120505T120514.htm
