• Find us:
    +1-669-900-5138   |   +44-203-372-5553
  • Free Newsletter

    Get Latest Updates

  • Make Training Enquiry


    Company

  • Categories

  • Archive

  • Autoconfig in Oracle Apps 11i / R12 / 12i

    Posted by "" in "autoconfig" on 2008-01-28

    Share on FacebookTweet about this on TwitterShare on Google+Share on LinkedInEmail this to someone

    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

    26 Responses to “Autoconfig in Oracle Apps 11i / R12 / 12i”

    1. rajesh says:

      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

    2. praveen says:

      hi neha mittal
      thank u for providing this information.

    3. Paul says:

      Hi Atul,
      This is a good documentation.

      Thanks.

    4. Ridhi says:

      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

    5. pinaki007 says:

      Hi Neha,
      This is a good doc.

    6. ankur verma says:

      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

    7. Atul Kumar says:

      @ 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)

    8. ankur verma says:

      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

    9. Atul Kumar says:

      @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

    10. ankur verma says:

      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

    11. ankur verma says:

      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

    12. ankur verma says:

      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

    13. jay says:

      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.

    14. Atul Kumar says:

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

    15. Hi Atul says:

      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.

    16. Harsha says:

      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

    17. annonymous says:

      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.

    18. Atul Kumar says:

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

    19. superviks says:

      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

    20. superviks says:

      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

    21. Atul Kumar says:

      @ superviks,
      what does hhi means ?

    22. Anjan says:

      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

    23. Atul Kumar says:

      @ 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)

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

    25. Vara says:

      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.

    26. Vivek Sharma says:

      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!

    Leave a Reply



  • K21 Technologies is among the most experienced Oracle Gold Partner for Identity Access Management service providers. We work with application development companies and in-house technology division to help achieve significant returns on their IT security investment. Our clientele includes some of the globally renowned corporate, which speaks of our expertise in our field.

    We have the most talented and experienced team that can swiftly deploy security solutions even in complex IT ecosystem. Our clients highly appreciate our timely implementation, interactive training, on-demand support and community resources.
  • CONTACTS

    K21 Technologies
    8 Magnolia Place, Harrow,
    London, HA2 6DS

    UK: +44(0)7476444481
    USA: +1-888-414-1821

  • 2014, K21 Technologies. All rights reserved DMCA.com
  • TOP