Continuation of my last post Migrating to AutoConfig on the Database Tier

After upgradation of database , DB Tier would not have the auto config features , we need to make sure that we enable the auto config. The below steps helps us to do so

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 Application Tier

i) On the Application Tier (as the APPLMGR user), source the environment file from APPL_TOP.
ii) Create appsutil.zip file –
—perl $AD_TOP/bin/admkappsutil.pl
  This will create appsutil.zip in $APPL_TOP/admin/out

On Database Tier
iii) On the Database Tier (as the ORACLE user), Copy or FTP the appsutil.zip file to the <RDBMS ORACLE_HOME>·
iv) cd <RDBMS ORACLE_HOME>
v) unzip -o appsutil.zip

.

2. Copy Source Database Tier Context file to Target ORACLE_HOME
.

i) Login as Source Database Tier Owner  
ii) cd $ORACLE_HOME/appsutil
iii) Copy $CONTEXT_NAME.xml ($CONTEXT_FILE) file to Target <RDBMS HOME>/appsutil


3. The AutoConfig check utility
   The AutoConfig check utility is located at Target Database Tier <RDBMS ORACLE_HOME>/appsutil/bin

.

i) Check the AutoConfig configuration files by executing the following command
adchkcfg.sh contextfile=<CONTEXT>.xml  appspass=<APPSpwd>
— This report provides information about All the profile options that get changed during the next normal execution of AutoConfig.
— For every profile option there is information about the current value in the database, the changed value and the AutoConfig script that changes the profile option.
— The script will also create a zip file report “ADXcfgcheck.zip” that contains all the files and reports mentioned above, so that you can copy the ADXcfgcheck.zip to a local desktop PC and view the html report from there without breaking the hyper-links in the report.

The snapshot of  the profile report

.

The snapshot of  Configuration Check File

3. Copy Script directory from source home to Target Home

i) Login to Source Oracle database Tier owner
ii) Go to <RDBMS HOME>/appsutil
iii) Copy  Script directory to Target <RDBMS HOME>
iv) Check autoconfig script and change the PATH
v) Check the environment file whether TNS_ADMIN is pointing to  the correct directory

The below step we can do it while upgradation from 9.2.0.6 to 10.2.0.1

.
4. Create nls/data/9idata directory 
On the database server node, as the owner of the Oracle RDBMS file system and database instance.
run the $ORACLE_HOME/nls/data/old/cr9idata.pl script to create the $ORACLE_HOME/nls/data/9idata directory

.

5. Context file Generation
Log in as Target database
Go to <RDBMS Home>/appsutil/bin    
perl adbldxml.pl tier=db appsuser=<APPSuser> appspasswd=<APPSpwd>

About the Author Rajat

I am Rajat Dey and I have more than decade of Oracle experience from all major regions throughout the globe. I am well versed in most facets of Oracle, supporting database, fusion middleware and the eBusiness suite across many operating system platforms.Currently I am located in Sydney  Oracle Financials 11i and Release 12,12.2  Oracle RDBMS 7x,8i , 9i,10g and 11g  Amazon cloud .  Oracle RAC 10g and 11g  Oracle Applications Server  Oracle Web logic Server  OBIEE  Hyperion  SSO  Oracle Portal  PL/SQL  UNIX  SQL  MS-SQL 2008.  OEM 12c .  Data Guard .  Essbase .  Database backup and recovery.  Performance Tunning.  TimeSten

Leave a Comment:

1 comments
Add Your Reply

Not found