This document describes step by step process for upgrading Oracle Applications from 12.0.4 to 12.1.2.

References :
Interoperability Notes E-Business Suite R12 with Oracle Database 11gR1 (11.1.0) [ID 735276.1] – for Database
Oracle E-Business Suite Release 12.1.1 Maintenance Pack Installation Instructions [ID 752619.1] – for Application

Upgrade OracleAS 10g Release 3 (10.1.3) to Patchset 4 (10.1.3.4) (Required) – Note 454811.1
——————————————————————————————-
Step 1. Download OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)

Download OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0) delivered via Patch 8626084 from My Oracle Support.

Step 2.Download Environment Preparation Patch for OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)

Download patch 8920270 from My Oracle Support .
If you are currently on Release 12.0.x and applying this patch as part of an upgrade to 12.1.1, then proceed immediately to Step 5 (skip Steps 3 and 4).
Apply OracleAS 10g Release 3 (10.1.3.0) Patch Set 5 (10.1.3.5.0) – Patch 8626084
—————————————————————-
This patch is applicable when using opatch version 1.0.0.0.58 or higher.
Running the opatch command will display the version number.

$ORACLE_HOME/OPatch/opatch version
Patch 6880880.
Unzip in 10.1.2 ORACLE_HOME - and 10.1.3 ORACLE_HOME.

You will have to modify the 10.1.3.5 Patchset home to install this fix.

1) Make sure the 10.1.3.5 Patchset home is in a writable location.
2) Backup $PATCHSETHOME/Disk1/stage/Patches/oracle.as.j2ee.top/10.1.3.5.0/1/DataFiles/other.jar to $PATCHSETHOME/Disk1/stage/Patches/oracle.as.j2ee.top/10.1.3.5.0/1/DataFiles/other.jar.pre8920270
3) Copy the other.jar provided in this patch to the location $PATCHSETHOME/Disk1/stage/Patches/oracle.as.j2ee.top/10.1.3.5.0/1/DataFiles/other.jar
4) Run the install of the 10.1.3.5 patchset.

*** *** ***
OPTIONAL
*** *** ***
If you have already tried to run the 10.1.3.5 Patchset without this patch and
the “Run One-off Generic OPatches” configuration assistant has failed.

Then the following steps need to be performed.

1) Make a backup of the file $ORACLE_HOME/config/run_opatch_generic.sh

cd $ORACLE_HOME/config
cp run_opatch_generic.sh run_opatch_generic.sh.pre8920270

2) Edit the $ORACLE_HOME/config/run_opatch_generic.sh and add the line

 

“-ocmrf /config/ias.properties” immediately after the -silent
switch. i.e.
#!/bin/sh
#
#opatch apply -silent -oh -invPtrLoc #
# This file is really for SOLARIS only currently other platforms are
# using separate files.
/OPatch/opatch apply -silent -ocmrf /config/ias.properties -oh -invPtrLoc /oraInst.loc /opatches/4601861
if [ “$?” != “0” ]; then
echo “OPatch did not complete successfully…”
exit 1
fi

3) If this is a GUI install then retry the configuration assistant “Run One-off Generic OPatches”. For a failure in the silent install

a) Set the LD_LIBRARY_PATH
$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib

b) Set the PERL5LIB

export PERL5LIB=$ORACLE_HOME/perl/lib/5.6.1:$PERL5LIB

c) Run the configToolCommands

cd $ORACLE_HOME/cfgtoollogs
./configToolCommands > /tmp/configtoolcommands.out

Unzip patch 8626084 – Disk1 will be availbale after unzip patch 8626084

cd /oracle/liveappl/patches/Disk1/stage/Patches/oracle.as.j2ee.top/10.1.3.5.0/1/DataFiles
mv other.jar other.jar.pre8920270

Unzip patch 8920270 (required patch for OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0))
into an alternative temporary directory.

[appllive@erp patches]$ cd 8920270
[appllive@erp 8920270]$ ls
other.jar p8920270_101350_LINUX.zip README.txt
[appllive@erp 8920270]$ cp -r other.jar /oracle/liveappl/patches/Disk1/stage/Patches/oracle.as.j2ee.top/10.1.3.5.0/1/DataFiles/
Follow the patch readme (perform steps 1, 2 and 3 only), then:

Please do not shutdown the Application Tier Services: the services should be up and running when applying this patch.

$ Set your environment to 10.1.3 ORACLE_HOME
$INST_TOP/ora/10.1.3 - Source the .env file.
Point ORACLE_CONFIG_HOME to 10.1.3 home and test by running the below command before running the installer again.
$IAS_ORACLE_HOME/opmn/bin/opmnctl status (or) startall
$ cd /oracle/liveappl/patches/Disk1
$ linux32 bash
$ ./runInstaller -invPtrLoc /oraInst.loc
$ ./runInstaller -invPtrLoc /oracle/liveappl/apps/tech_st/10.1.3/oraInst.loc

d) Review /tmp/configtoolcommands.out.
*** *** ***
*** *** ***

Unzip patch 8626084 – Disk1 will be availbale after unzip patch 8626084

cd /oracle/liveappl/patches/Disk1/stage/Patches/oracle.as.j2ee.top/10.1.3.5.0/1/DataFiles
mv other.jar other.jar.pre8920270

Unzip patch 8920270 (required patch for OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0))
into an alternative temporary directory.

[appllive@erp patches]$ cd 8920270
[appllive@erp 8920270]$ ls
other.jar p8920270_101350_LINUX.zip README.txt
[appllive@erp 8920270]$ cp -r other.jar /oracle/liveappl/patches/Disk1/stage/Patches/oracle.as.j2ee.top/10.1.3.5.0/1/DataFiles/

Follow the patch readme (perform steps 1, 2 and 3 only), then:
Please do not shutdown the Application Tier Services: the services should be up and running when applying this patch.

$ Set your environment to 10.1.3 ORACLE_HOME
$INST_TOP/ora/10.1.3 - Source the .env file.

Point ORACLE_CONFIG_HOME to 10.1.3 home and test by running the below command before running the installer again.

$IAS_ORACLE_HOME/opmn/bin/opmnctl status (or) startall
$ cd /oracle/liveappl/patches/Disk1
$ linux32 bash
$ ./runInstaller -invPtrLoc <1013_ORACLE_HOME>/oraInst.loc
$ ./runInstaller -invPtrLoc /oracle/liveappl/apps/tech_st/10.1.3/oraInst.loc
Select Name: LIVE
PATH: Existing 10.1.3 ORACLE_HOME: /oracle/liveappl/apps/tech_st/10.1.3

Enter the user password for the OracleAS 10g 10.1.3 instance that is being patched.
If you are upgrading from OracleAS 10g 10.1.3.0, the default password is ‘secret’.
Otherwise the default password is ‘oafm’, if it was not changed after Release 12 installation.
Proceed to the end of the installation.

[appllive@erp admin]$ vi /oracle/liveappl/inst/apps/LIVE_erp/admin/oraInventory/logs/installActions2010-01-10_11-26-58AM.log
Calling Query SpawnQueries1.1.4 Spawn
command = ant -f /oracle/liveappl/apps/tech_st/10.1.3/webservices/lib/ws-jaxrpc-shlib-patch.xml -Denv.ORACLE_HOME=/oracle/liveappl/apps/tech_st/10.1.3 -Denv.JAVA_HOME=/oracle/liveappl/apps/tech_st/10.1.3/jdk -DOC4JNAME=oc4jInstanceName= -logfile /oracle/liveappl/apps/tech_st/10.1.3/install/ant_oc4j_build.log
Query Exception: RuntimeException
Query Exception Class: class oracle.sysman.oii.oiil.OiilQueryException
Query Exception: RuntimeException
Query Exception Class: class oracle.sysman.oii.oiil.OiilQueryException
[appllive@erp admin]$ vi /oracle/liveappl/apps/tech_st/10.1.3/install/ant_oc4j_build.log

Export “ant” it should work fine:
——————————–

[applvis@fresh appl]$ which ant
/VISION/visappl/apps/tech_st/10.1.3/ant/bin/ant

Shutdown all the Application Tier Services.
Run AutoConfig on the Application Tier.

adadmin
Regenerate product JAR files : no force option - Default.
AD Administration error:
Error copying the Forms Registry file to /oracle/liveappl/apps/apps_st/comn/java/classes/oracle/forms/registry/Registry.dat.
adogjf() Unable to copy Registry.Dat.

adogjf() Unable to copy Registry.Dat When Applying Patch 5866720 at R12 [ID 438882.1]
————————————————————————————-
To implement the solution, please execute the following steps:

1. Create a 0 byte file called Registry.dat under:
<COMMON_TOP>/java/classes/oracle/forms/registry
2. Grant full permissions over Registry.dat.
3. Re-try applying the patch with a new AD Patch session; do not continue with the old session.
Share →
0 comments
Skip to toolbar