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 –
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 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 220.127.116.11 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>
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