Autoconfig in Oracle Apps 11i / R12 / 12i

In Oracle Applications 11i & R12 (12i) all the configuration parameters are captured in two context files:

Application context file called the <CONTEXT_NAME>.xml contains the configuration information for the application tier & is located in $APPl_TOP/admin for each node of application tier.

Database context file called the <CONTEXT_NAME>.xml contains the configuration information for the database tier & is located in $ORACLE_HOME/appsutil/.

Details stored in the context file contains host names,domain name , directory structure, port numbers used  ……

The AutoConfig feature of Oracle application manager(OAM) is used to update & manage context files.
Updating Context file

Suppose we want to update the active port from <original port no.> to 80 , for this we will edit the application context file as follows:

Step 1 :Start all services
$ $COMMON_TOP/admin/scripts/<context_name>/adstrtal.sh APPS/<apps password>
Step 2 :log on to OAM & click site map.
Step 3:Click AutoConfig from the list of System Configuration features in the Administration tab.
Step 4 : Click the Edit Parameter button for the application tier context file to access the Context File Parameters page & then click the system tab.
Step 5 : Click the Focus icon (blue triangle) for oa_web_server. This expands oa_web_server and shows the web server related parameters.
Step 6:Update the Web Port (s_active_webport) parameter from < Original port number> to 80.
Step 7 : Save it & answer the tab.Then logout of OAM

AutoConfig Script

The autoconfig script uses information from the context file to generate all applications configuration files & updates database profiles. It is located in

Application tier: $COMMON_TOP/admin/scripts/CONTEXT_NAME/adautoconfig.sh

Database tier: $ORACLE_HOME/appsutil/scripts/CONTEXT_NAME/adautoconfig.sh

Now we run the autoconfig script to reconfigure the oracle application system with the updated Applications context.

Step 1 : Stop all services
$ $COMMON_TOP/admin/scripts/<context_name>/adstpall.sh APPS/<apps password>
Step 2:Run the autoconfig script, $adautocfg.sh & respond to the prompts.
Step 3:Check log files for any errors.log file for autoconfig is adconfig.log & is located in
<APPL_TOP>/admin/<context_name>/log/MMDDhhmm/
Step 4: Restart all services :
$ $COMMON_TOP/admin/scripts/<context_name>/adstrtal.sh APPS/<apps password>
Rolling back an autoconfig session

Each execution of AutoConfig creates a roll back script in case you want to revert back to the previous configuration settings. For this we perform the following steps:

Step 1 :Shut down all services:
$ cd $COMMON_TOP/admin/scripts/<context_name>
$ adstpall.sh APPS/<APPS password>
Step 2:Restore AutoConfig session.
$ cd $APPL_TOP>/admin/<context_name>/out/MMDDhhmm
$ restore.sh
Step 3 : Restart all services:
$ $COMMON_TOP/admin/scripts/<context_name>/adstrtal.sh APPS/<APPS password>

Restoring the AutoConfig updated files and restarting the services allows you to log on to OAM.


Restoring the previous configuration

Now we run OAM AutoConfig to restore the Applications Context.

Step 1 :Log on to the Oracle Application Manager (OAM) & click site map.You will be able to log on but some services will be down.
Step 2: Click AutoConfig from the list of System Configuration features in the Administration tab.
Step 3 : Click the Show History button for the application tier context file to access the Context File History page.
Step 4 :Click the Show Differences from Current Configuration button to see the recently updated parameters & Select Restore Previous Value for the Web Port and Discoverer Port parameters.
Step 5 :Save & respond the tabs. Log out of OAM.
Step 6 :Shut down all services:
$ cd $COMMON_TOP/admin/scripts/<context_name>
$ adstpall.sh APPS/<APPS password>
Step 7 :Run the AutoConfig script, adautocfg.sh & Respond to the prompts.
Step 8 : View the log file and check for any errors.
Step 9 : Restart all services:
$ $COMMON_TOP/admin/scripts/<context_name>/adstrtal.sh APPS/<APPS password>
Step 10 :Log on to the Oracle Application Manager (OAM)

If the status of some services appears to be down, click the Refresh icon to update the
status.

Related : Metalink Notes
218089.1  Autoconfig FAQ
165195.1  Using AutoConfig to Manage System Configurations with Oracle Applications 11i
387859.1  Using AutoConfig to Manage System Configurations in Oracle Applications Release 12
270519.1  Customizing an AutoConfig Environment
364927.1 How To Run Autoconfig On Database Tier (DB-Tier)
341322.1 How to change the hostname of an Applications Tier using AutoConfig
338003.1 How to change the hostname and/or port of the Database Tier using AutoConfig
315674.1 How To Verify if Autoconfig is Enabled on 11.5.x
391406.1 How to get a clean Autoconfig Environment

Other Related Posts

Autoconfig Basics
Unwrapping XML/Context File
Autoconfig Basics

Did you get a chance to download 6 Docs Every Apps DBA Must Read for EBS R12.2 ? If not, then get it now by clicking on link below.

6 docs every apps dba must read

 

 

If you need to learn more about Oracle Apps DBA (Architecture, Installation, WebLogic, Patching, Cloning and other maintenance tasks with the upgrade of Oracle E-Business Suite 12.2.0 to 12.2.4 then have a look at our  Oracle Apps DBA Training

About the Author Masroof Ahmad

Leave a Comment:

27 comments
rajesh says January 31, 2008

hi.,atul

the main issue is it is SLOW during month end.

os informatiom
——————-
os and version-IBM-AIX 5.3
SYSTEM BIT-64 BIT
RAM SIZE 8GB

DATABASE INFORMATION
—————————
database version-9.2.0.7
bit-64 bit
archive log- enabled
users-200
size of database 128 allocated,103gb actual

oracle application server version & release-oracle E business 11i(11.5.10)
type of installation-multi node(dual node)
total no users -around 200
concurrent users-around 200

Reply
praveen says January 31, 2008

hi neha mittal
thank u for providing this information.

Reply
Paul says June 24, 2008

Hi Atul,
This is a good documentation.

Thanks.

Reply
Ridhi says January 8, 2009

Hi Neha,
I am facing this issue everytime i run autoconfig. All the configuration files with customization are overwritten everytime i run AC so i need to update it manually all the time. How do i get rid of it?
Thanks

Reply
pinaki007 says April 13, 2009

Hi Neha,
This is a good doc.

Reply
ankur verma says July 4, 2009

Hi how u doing?
Well i have installed oracle apps 11i on my machine
but when i try to login through E-Business Home Page i get page cannot be found also my host entries are as follows

127.0.0.1 localhost mydomain mydomain.com
192.168.1.2 mydomain mydomain.com

Reply
Atul Kumar says July 4, 2009

@ Ankur, I am assuming your server IP is 192.168.1.2 and machine name is mydomain.com

if yes then change entry in /etc/hosts to

127.0.0.1 localhost.localdomain
192.168.1.2 mydomain.com mydomain

and bounce services (bounce middle tier and db tier and try accessing again)

Reply
ankur verma says July 5, 2009

Hi Atul
Thanks for ur kind reply
well i have done some changes
my machine name is hcl.mydomain.com

and now my host entries reads like this

127.0.0.1 localhost.localdomain
192.168.1.2 hcl.mydomain.com hcl

and i have added primary dns suffix as mydomain.com

also if u can tell me how to use and bounce services (bounce middle tier and db tier)

since m not a DBA i am installing oracle apps11i for learning purpose so i would appreciate if you could guide me through the steps in details plz……waiting for ur reply

Reply
Atul Kumar says July 5, 2009

@Ankur,

Check this
http://onlineappsdba.com/index.php/2006/08/02/startup-shutdown-apps-services/

If you are new and unable to start services in 11i raise it in forum at http://teachMeOracle.com/forum

Reply
ankur verma says July 5, 2009

Hi Atul

this is what my error log has to say

[Sun Jul 05 14:16:07 2009] [error] OPM: EW: Fail to start process with mod=JServ and grp=XmlSvcsGrp, it’s possible that your configuration file is not correct.

[Sat Jul 04 17:46:36 2009] [error] [client 192.168.1.2] File does not exist: /oa_servlets/AppsLogin

Reply
ankur verma says July 5, 2009

hi Atul
Also like to add i have done this installation on windows xp sp2 by checking the log its seems File does not exist: /oa_servlets/AppsLogin so its because of this i guess

Reply
ankur verma says July 5, 2009

hi Atul
Sorry to bother u
but m getting no where

can u please tell me the steps to and bounce services (bounce middle tier and db tier

m having windows xp
wher do i run the scripts and how do i run in which directory……….plz

Reply
jay says September 22, 2009

Hi,

I am working on 11i apps on linux os level.
now oracle process is moving slowly.
Some user told me to check the Ram space & speed
now i want to check Ram level from backend
so how can i check it.
please give me reply as quick as possible.

Thanks
Jay.

Reply
Atul Kumar says September 22, 2009

@ Jay
Use “top” command to find free and used memory

Reply
Hi Atul says October 25, 2009

Iam new to apps. I have 11i(11.5.9) running on RHEL4 on my home desktop. Unfortunately I have lost scripts in dbTier (lsnr, DB, adautocfg.sh) while i was messing up with clone software. Is there any way that i can retrieve (no backups) these scripts back in dbTier.

Iam trying to use adadmin utilities and nothing seems to work as all gets hang on giving password and same with opening webpage for e-business suite. I dont know where iam sailing in the ocean.

please help me out i dont want to reinstall apps.

Reply
Harsha says December 15, 2009

Hi Neha,

Service manager in production system shows the node of test server.Can you please tell me how to edit the same in Oracle Apps R12.

Regards,
Harsha

Reply
annonymous says October 23, 2010

hi sir………
while iam connecting to 9i client on windows xp to apps11i server on OEL4.4 error was came.that is tns:connection closed
tns:lost contact
………
how to resolve?could u please send mail to me.

Reply
Atul Kumar says October 23, 2010

@ annonymous,
Error “tns:connection closed – tns:lost contact” means client connection was closed from database server side.

This could be for multiple reasons and to name few it could be because of
a) Network Error
b) DB Listener issue
c) Database Issue

Check in DB Listener log and Database alert log to start with.

Reply
superviks says January 28, 2011

Hello,

I need to install R12 and hhi ERP on the same server. Would like to know if this is possibe, if so how?

Kind Regards,
Vikram

Reply
superviks says January 28, 2011

On the same server means, to install both the versions of ERP on the same OS of Linux 5.4. Appreciate any help on this asap

Reply
Atul Kumar says January 28, 2011

@ superviks,
what does hhi means ?

Reply
Anjan says May 5, 2011

Hi,

I have installed R12 on windows xp after restart my system i am unable to login R12 login page it will shows like 404 url page not found

Please let me know how could i resolve this problem

Best Regards,
V.Anjan

Reply
Atul Kumar says May 5, 2011

@ Anjan,
Check if your services are running or not

Check for Apache (OHS) and OC4J (3 OC4Js)

1. Set environment variable by running env file for middle tier
2. cd $ADMIN_SCRIPTS_HOME
3. adopmnctl[.bat] status
4. adapcctl[.bat] status

netstat -an (and see if port 8000 is listening or not where 8000 is OHS/Apache port for port pool 0)

Reply
» EBS R12 integration with WebCenter : Error retrieving WSDL at URL OA_HTML/ portlets/ WSRPBaseService?WSDL Online Apps DBA: One Stop Shop for Apps DBA’s says February 1, 2012

[…] This is done by adding webcenter server name in s_trusted_portal in Context File and run AutoConfig here and here […]

Reply
Vara says September 6, 2012

Hi Atul,

We are upgrading from 11.5.10.2 to R12.1.3. In 11i we have some DADs defined in wdbsrv.app and we used to manage them using custom autoconfig template file (wdbsrv.app under $FND_TOP/admin/template/custom). Now in R12 this file is no longer used, we need to migrate the DADs to dads.conf, which we are doing manually. Wondering if we can manage the dads.conf using custom template. I could not find any template file provided by Oracle (used adtmplreport.sh). How do we handle this? If there is no template file available can we create our own? How does autoconfig recognises this?

Appreciate your help.

Reply
Vivek Sharma says December 15, 2013

Hi Atul/Neha,

If we choose option 4 in provisioning, the Preferences SSWA resp does not get assigned, is that an expected thing in OAM 11g enabled SSO for R12.1.3. I have always used other provisioning options and it has always appeared as a resp.

Also does running autoconfig on EBS affect SSO in any way? As it updates dbc file!

Reply
Oracle EBS AutoConfig详解 | 甲骨有文 says January 23, 2018

[…] Autoconfig in Oracle Apps 11i / R12 / 12i […]

Reply
Add Your Reply