Friday, July 17, 2009

How to Implement Autoconfig in the New Upgraded Database Oracle Home

How to Implement Autoconfig in the new Upgraded Database Oracle Home.

Solution
1. Go to Apps tier and create the appsutil.zip file:
perl /bin/admkappsutil.pl
2. Copy the generated appsutil.zip file under $INST_TOP/admin/out to the new upgrade Oracle_Home directory.

3. Unzip it in there:
cd $ORACLE_HOME unzip -o appsutil.zip
4. Install the jre in the appsutil directory: Copy the jre from the old $ORACLE_HOME/appsutil/jre to the new $ORACLE_HOME/appsutil directory. Or download the jre from the Sun website.

5. Create the context file in the new Oracle Home:
perl /appsutil/bin/adbldxml.pl
Note: Script adbldxml.pl can be installed with each of the following patches on release 12.0. If you do not have this script please apply only one chosen patch.
Patch 6636108 6636108:R12.TXK.A
Patch 7207440 TXK - 12.0.4 Consolidated Patch 1
Patch 7237313 R12.TXK.A.DELTA.6
Patch 6728000 ORACLE E-BUSINESS SUITE 12.0.6 RELEASE UPDATE PACK (RUP6)
Patch 7237006 R12.ATG_PF.A.DELTA.6
6. Once the context file is created, run the autoconfig from the $ORACLE_HOME/appsutil/bin directory:
adconfig.pl
When prompted, enter the complete path to the new created context file including the context file name.

7. After autoconfig is executed in the DB tier, run it on the Apps tier.

1 comment:

ERic said...

It does not work. When I try to run perl adbldxml.pl command, I get the following message:
Incorrect environment file sourced. Unset apps environment