AutoConfig Tools

Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12 [ID 387859.1]

----------------------------------------------

Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12 

AutoConfig Tools

----adautocfg.sh/cmd 

On Applications Tier:

<INST_TOP>/admin/scripts 

On Database Tier:

<RDBMS_ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>

----adchkcfg.sh/cmd 

On Applications Tier:

<AD_TOP>/bin

On Database Tier:

<RDBMS_ORACLE_HOME>/appsutil/bin 

 

①Before running AutoConfig, the Check Config utility may be run to review the changes that would occur in the file system as well as the database in the next AutoConfig run. This step is optional. 

 On the Database tier: 

### On Unix: 

sh <RDBMS_ORACLE_HOME>/appsutil/bin/adchkcfg.sh contextfile=<CONTEXT_FILE> 

### On Windows: 

<RDBMS_ORACLE_HOME>\appsutil\bin\adchkcfg.cmd contextfile=<CONTEXT_FILE> 

 On the Applications tier: 

### On Unix: 

sh <AD_TOP>/bin/adchkcfg.sh contextfile=<CONTEXT_FILE> 

### On Windows: 

<AD_TOP>\bin\adchkcfg.cmd contextfile=<CONTEXT_FILE> 

②Run AutoConfig on the Database Tier

Running AutoConfig on the database tier is required in the following scenarios: 

## After migrating a patch to the database tier, the Check Config utility reports any potential changes to the templates.

## After customizations on the database tier 

## After a database or application tier upgrade

## After restoration of the database or Oracle Home from a backup tape

## After a JDK upgrade on the database tier

## After the Net Services Topology Information is manually cleaned up using one of the supported procedures(eg. fnd_conc_clone.setup_clean). Subsequently, AutoConfig must be run on the application tier nodes.

## After registration of a RAC node.

## After setting up the APPL_TOP on a shared file system.

## All other cases where documentation says that AutoConfig should be run on the database tier. 

Execute the following command to run AutoConfig on the database tier. 

### On Unix: 

sh <RDBMS_ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>/adautocfg.sh 

### On Windows: 

<RDBMS_ORACLE_HOME>\appsutil\scripts\<CONTEXT_NAME>\adautocfg.cmd

Attention: 

## The database server and the database listener must remain available during the AutoConfig run. All the other database tier services should be shut down. 

## Running AutoConfig may change your existing environment files. After running AutoConfig, you should always set the environment before you run any Applications utilities, in order to apply the changed environment variables.

 

③Run AutoConfig on the Application Tier

Run AutoConfig on all application tier nodes. 

### On Unix: 

sh <INST_TOP>/admin/scripts/adautocfg.sh 

### On Windows: 

<INST_TOP>\admin\scripts\adautocfg.cmd

Attention: 

## The database server and the database listener must remain available during the AutoConfig run. Only the application tier servers should be shut down.

## Running AutoConfig may change your existing environment files. After running AutoConfig, you should always set the environment before you run any Applications utilities, in order to apply the changed environment variables.

 

④Reviewing AutoConfig Log Files

AutoConfig logfiles are stored under:

Application: <INST_TOP>/admin/log/<MMDDhhmm> 

Database: <RDBMS ORACLE_HOME>/appsutil/log/<CONTEXT_NAME>/<MMDDhhmm> 

One log file is created per AutoConfig session. It will contain details of every action that AutoConfig performed during the run.

⑤Rolling Back an AutoConfig Session

Each AutoConfig run of creates a rollback script you can use to revert to the previous configuration settings if necessary. The script and all backup configuration files from each AutoConfig session are stored in:

Tier  Directory  

Application: <INST_TOP>/admin/out/<MMDDhhmm> 

Database: <RDBMS ORACLE_HOME>/appsutil/out/<CONTEXT_NAME>/<MMDDhhmm> 

To roll back an AutoConfig session, execute the following commands: 

### On UNIX 

restore.sh

### On Windows 

restore.cmd

⑥Applying the Latest AutoConfig Updates 

In order to get the latest AutoConfig updates on both the applications tier and the database tier, perform the following steps in the order listed:

a.Apply the TXK AutoConfig Template patch

Update the Oracle Applications file system with the AutoConfig files by applying the latest AutoConfig Template patch (Patch 9386653 for 12.0.X customers and Patch 8919489 for 12.1.X customers) to all application tier nodes in the Applications instance.

Note: ADX and TXK rollup patches for configuration management have been combined.  

b.Copy AutoConfig to the RDBMS ORACLE_HOME 

Update the RDBMS ORACLE_HOME file system with the AutoConfig files by performing the following steps:

?On the application tier (as the APPLMGR user):

■Log in to the APPL_TOP environment (source the environment file)

■Create appsutil.zip file 

perl <AD_TOP>/bin/admkappsutil.pl

■This will create appsutil.zip in <INST_TOP>/admin/out

?On the database tier (as the ORACLE user): 

■Copy or FTP the appsutil.zip file to the <RDBMS ORACLE_HOME> 

cd <RDBMS ORACLE_HOME>

unzip -o appsutil.zip

c.Run AutoConfig 

Run AutoConfig on the database tier and then on the applications tier