Monday, 31 May 2010

AutoConfig on the Database Tier for a New ORACLE_HOME

When upgrading database to new version, required to do this migration of autoconfig on to the new Oracle Home. I have summarized the steps involving in this process as:

1. 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 file
perl < AD_TOP>/bin/
This will create in $APPL_TOP/admin/out .

On the Database Tier (as the ORACLE user):

Copy or FTP the file to the < RDBMS ORACLE_HOME>
unzip -o

2. Generate your Database Context File
If you already have a Database Context File, go to Task 3 in this section.
If your Applications system was created with the Release 11.5.8 Rapid Install or earlier, execute the following commands to create your Database Context File:

cd < RDBMS ORACLE_HOME>/appsutil/bin
perl tier=db appsuser=< APPSuser>

On Windows
Source the .cmd file using < RDBMS ORACLE_HOME>\< CONTEXT_NAME>.cmd
cd /d < RDBMS ORACLE_HOME>\appsutil\bin
perl tier=db appsuser=< APPSuser>

Attention: adbldxml uses your current environment settings to generate the context file. Therefore ensure that your environment is correctly sourced.

3. Generate and Apply AutoConfig Configuration files

Attention: This step performs the conversion to AutoConfig. Once completed, the previous configuration will not be available.

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.
Execute the following commands:
cd < RDBMS ORACLE_HOME>/appsutil/bin contextfile=< CONTEXT>

On Windows
cd /d < RDBMS ORACLE_HOME>\appsutil\bin
adconfig.cmd contextfile=< CONTEXT>

Warning: Running AutoConfig on the database node will update the RDBMS network listener file. Be sure to review the configuration changes from step 3. The new AutoConfig network listener file supports the use of IFILE to allow for values to be customized or added as needed.

Note: Running AutoConfig on the database tier will NOT overwrite any existing init.ora file in the < ORACLE_HOME>/dbs directory. If no init.ora file exists in your instance, AutoConfig will generate an init.ora file in the < ORACLE_HOME>/dbs directory for you.

On Windows platform, during each AutoConfig run the init.ora file in < ORACLE_HOME>/dbs directory is copied over to < ORACLE_HOME>/database directory.

Note: Running AutoConfig might 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.

Related Posts by Categories

No comments: