In Oracle : Oracle AutoConfig in Oracle Applications 11i

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Applications EBS

Oracle Apps 11i DBA (I) Oracle Apps 11i DBA (II) Oracle Apps 11i DBA (III) Oracle Apps 11i Sys Admin UPGRADE 11i Apps to R12 Oracle Apps R12 DBA

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle Applications (apps)  -> 11i

-> Oracle AutoConfig in Oracle Applications 11i

 

Oracle AutoConfig in Oracle Applications 11i 

1. What AutoConfig is ?

2. How do I determine if AutoConfig is enabled ?

3. Is AutoConfig compatible with Oracle Applications 11.5.x ?

4. How could I modify the Context File ?

5. When should I run AutoConfig ?

6. How could I run AutoConfig ?

7. Where is the AutoConfig log file ?

8. How can I roll back an AutoConfig session ?

 

 

1. What is AutoConfig ?

 

AutoConfig is a configuration tool that automates the configuration of an Oracle Applications system. The information required for configuring an Applications system is collected into a repository, called the Applications Context; there is one Applications Context for each application tier (example: /APPS/visappl/admin/VIS_apps.xml), and one for the database tier (example: /APPS/visdb/9.2.0/appsutil/VIS_apps.xml). When AutoConfig runs, it uses information from the Applications Context file to generate all configuration files and update database profiles.

2. How do I determine if AutoConfig is enabled ?

  • On the Database Node:

         1. Source the database:    

             . /APPS/visdb/9.2.0/VIS_apps.env       (example)

       

         2. Go to the listener folder:

             cd $ORACLE_HOME/network/admin/VIS_apps  (example)

 

         3. Show the listener.ora file

            $ more listener.ora   (on Linux/ UNIX, Solaris)

 

            If the header of this file contains the following message, that means the database is AutoConfig enable:

 

# ###############################################################
#
# This file is automatically generated by AutoConfig. It will be read and
# overwritten. If you were instructed to edit this file, or if you are not
# able to use the settings created by AutoConfig, refer to Metalink document
# 165195.1 for assistance.
#
# ###############################################################

For this header we can check each application and DB configuration file as well. 

 

NOTES:

  • If the database is AutoConfig enabled, the Applications tier must be AutoConfig enabled as well. 

  • For the APPL_TOP
    $AD_TOP/bin/adcfginfo.sh contextfile=<CONTEXT> 

    For products
    $AD_TOP/bin/adcfginfo.sh contextfile=<CONTEXT> show=enabled 

       Example:

       $AD_TOP/bin/adcfginfo.sh contextfile=/APPS/visappl/admin/VIS_apps.xml      (Use a full path here !)

       This system is AutoConfig enabled

       Log file created at location :/APPS/visappl/admin/VIS_apps/log/03210211.log


       [oracle@APPS bin]$ more /APPS/visappl/admin/VIS_apps/log/03210210.log
       #----------------------------------------------
       #------Log File created at: 14:10:20------------
       #----------------------------------------------

       # AUTOCONFIG ENABLED PRODUCTS

       AD ENABLED
       FND ENABLED
       ABM ENABLED
       AHL ENABLED
       AMS ENABLED
       AR ENABLED
       BIS ENABLED
       . . . 

      # AUTOCONFIG DISABLED PRODUCTS

      AK DISABLED
      AU DISABLED
      AHM DISABLED

  • If you manually changed any file containing this file header, it is no longer considered as officially AutoConfig enabled !

3. Is AutoConfig compatible with Oracle Applications 11.5.x ?     

 

Yes, it is compatible with all 11i releases. You can use AutoConfig to configure and maintain any Oracle Applications 11i environment. 

Release 11.5.1 - 11.5.6 (all tiers)
Apply the latest AutoConfig consolidated patch to obtain the AutoConfig utility. 

Release 11.5.7 and higher (application tier)
AutoConfig is included in new Applications installations and in the associated maintenance packs. 

Release 11.5.9 and higher (database tier)
AutoConfig is included in new Applications installations and in the associated maintenance packs. 

NOTE: 

If you upgrade from a maintenance pack version that does not include AutoConfig to a maintenance pack version that includes AutoConfig (for example you upgrade from 11.5.3 to 11.5.10), you have to separately migrate to AutoConfig as part of the pre-upgrade process. Follow the instructions of the corresponding maintenance pack. 


4. How could I modify the Context File ?

a) Access OAM

 

Oracle AutoConfig 

 

b) Login as sysadmin (default password is sysadmin)

 

Oracle AutoConfig

c) Click on "Site Map" link and after that on "AutoConfig"

 

Oracle AutoConfig

 

d) Choose the Context file you want to modify

 

Oracle AutoConfig

Supposing you will choose the context file for the application tier (the first on the list), by clicking on the Edit parameter image. 

 

e)  Modify and save the context file

 

Oracle AutoConfig

Note: Manually editing the Applictions Context file is not supported (can be done using editcontext (Context Editor Wizard) located at <COMMON_TOP>/util/editcontext and <RDBMS ORACLE_HOME>/appsutil/editcontext ). Many context variables have dependencies between each other. The OAM AutoConfig resolves all these dependencies when changing the value of a variable. By manually editing the Applications Context file you will bring the data into an inconsistent state.

 

 

5. When should I run AutoConfig ?

  • You did updates to your Applications Context file. 

  • An Oracle Metalink Note instructs you to run AutoConfig as part of an upgrade, migration, cloning and/or configuration process. 

  • The Readme of an Oracle patch instructs you to run AutoConfig after the application of the patch. 

  • You apply any ADX Product patch. 

Note: When you have AD.I or higher applied on your system, then adpatch will automatically invoke AutoConfig if the patch that you apply requires AutoConfig to run. 

To find the AD patch level you can run SELECT PATCH_LEVEL FROM FND_PRODUCT_INSTALLATIONS WHERE PATCH_LEVEL LIKE '%AD%';

6. How could I run AutoConfig ?

 

a) Log on as the appropriate user and set the environment

 

b) Stop all server processes

 

c) Start the AutoConfig on the Application Tier

    <COMMON_TOP>/admin/scripts/<CONTEXT_NAME>/adautocfg.sh  ( UNIX; for Windows : adautocfg.cmd )

 

d) Start the AutoConfig on the DB Tier

    <RDBMS ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>/adautocfg.sh    ( UNIX; for Windows : adautocfg.cmd )

 

    NOTE:

    adautocfg.sh script runs the AutoConfig utility $AD_TOP/bin/adconfig.sh    ( UNIX; for Windows : adconfig.cmd ) 

 

e) Start all server processes

 

 

7. Where is the AutoConfig log file ?

 

The log file that AutoConfig creates is located at: 


On the application tier:
<APPL_TOP>/admin/<Context_name>/log/<MMDDhhmm>/adconfig.log 

On the database tier:
<RDBMS ORACLE_HOME>/appsutil/log/<Context_name>/<MMDDhhmm>/adconfig.log 

where: <MMDDhhmm> = (month, day, hour and minute of the AutoConfig run) 

 

 

8. How can I roll back an AutoConfig session ?

 

The backup configuration files from each AutoConfig session are stored in: 


On the application tier: 
<APPL_TOP>/admin/<Context_name>/out/<MMDDhhmm>/ 


On the database tier: 
<RDBMS ORACLE_HOME>/appsutil/out/<Context_name>/<MMDDhhmm>/ 

where: <MMDDhhmm> = (month, day, hour, and minute of the AutoConfig run) 

You can run restore.sh (Unix) or restore.cmd (Windows) to roll back an AutoConfig session.

 

 

In-Oracle.com  -> Oracle Applications (apps)  -> 11i

-> Oracle AutoConfig in Oracle Applications 11i

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.