Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2

 Issue# 8:

-          After DB Home installation using 11i Stage, and patchset 9.2.0.8, dbua is faile with below error:

[ordpro@dbmig 9.2.0]$ dbua

/u03/db/tech_st/dprodb/9.2.0/bin/dbua: line 110: /nfs/bld/d14/apps/11510cu2/AB1/apps/rivis9db/9.2.0/JRE/bin/jre: No such file or directory

[ordpro@dbmig 9.2.0]$

 

-          Also runInstaller is failing with below error:

[ordpro@dbmig ~]$ /u03/db/tech_st/dprodb/9.2.0/oui/bin/runInstaller -help

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-04-06_08-27-25PM. Please wait ...The Java RunTime Environment was not found at /tmp/OraInstall2017-04-06_08-27-25PM/jre/bin/java. Hence, the Oracle Universal Installer cannot be run.

Please visit http://www.javasoft.com and install JRE version 1.3.1 or higher and try again.

: No such file or directory

[ordpro@dbmig ~]$

 

Solution:

[ordpro@dbmig ~]$ cd $ORACLE_HOME/oui

[ordpro@dbmig oui]$ ls

bin  clusterparam.ini  guide  jlib  lib  oraparam.ini

[ordpro@dbmig oui]$

 

[ordpro@dbmig oui]$ cp oraparam.ini oraparam.ini_org

[ordpro@dbmig oui]$ vi oraparam.ini

[ordpro@dbmig oui]$ diff oraparam.ini oraparam.ini_org

5c5

< JRE_LOCATION=/u03/db/tech_st/dprodb/9.2.0/jre/1.4.2

---

> JRE_LOCATION=../..//nfs/bld/d14/apps/11510cu2/AB1/apps/rivis9db/9.2.0/jre/1.4.2

[ordpro@dbmig oui]$

 

Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2

 

Issue# 8:

-          After DB Home installation using 11i Stage, and patchset 9.2.0.8, dbua is faile with below error:

[ordpro@dbmig 9.2.0]$ dbua

/u03/db/tech_st/dprodb/9.2.0/bin/dbua: line 110: /nfs/bld/d14/apps/11510cu2/AB1/apps/rivis9db/9.2.0/JRE/bin/jre: No such file or directory

[ordpro@dbmig 9.2.0]$

 

-          Also runInstaller is failing with below error:

[ordpro@dbmig ~]$ /u03/db/tech_st/dprodb/9.2.0/oui/bin/runInstaller -help

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-04-06_08-27-25PM. Please wait ...The Java RunTime Environment was not found at /tmp/OraInstall2017-04-06_08-27-25PM/jre/bin/java. Hence, the Oracle Universal Installer cannot be run.

Please visit http://www.javasoft.com and install JRE version 1.3.1 or higher and try again.

: No such file or directory

[ordpro@dbmig ~]$

 

Solution:

[ordpro@dbmig ~]$ cd $ORACLE_HOME/oui

[ordpro@dbmig oui]$ ls

bin  clusterparam.ini  guide  jlib  lib  oraparam.ini

[ordpro@dbmig oui]$

 

[ordpro@dbmig oui]$ cp oraparam.ini oraparam.ini_org

[ordpro@dbmig oui]$ vi oraparam.ini

[ordpro@dbmig oui]$ diff oraparam.ini oraparam.ini_org

5c5

< JRE_LOCATION=/u03/db/tech_st/dprodb/9.2.0/jre/1.4.2

---

> JRE_LOCATION=../..//nfs/bld/d14/apps/11510cu2/AB1/apps/rivis9db/9.2.0/jre/1.4.2

[ordpro@dbmig oui]$

 

Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2

 

Issue# 7:

-          When submitting “PatchWizard - Recommend Patches (Request Set SubmitAdvisorCriteria)” the request failed with:

The set completed normally with outcome Error. The outcome was determined by the stage Submit InfoBundle Upload, Analyze Patches Request (3).

 

Solution:

Patch Wizard: The Set Completed Normally With Outcome Error (Doc ID 1224763.1)

 

-          Download InfoBundle11i.zip from https://updates.oracle.com/download/InfoBundle11i.zip

-          Stage it under the custom location used in “Patch Wizard Preferences”

[applprop@dbmig patch_wizard]$ pwd

/u03/patch_wizard

[applprop@dbmig patch_wizard]$ ls -l InfoBundle11i.zip

-rw-r--r-- 1 applprop dba 267461574 Apr  5 14:08 InfoBundle11i.zip

[applprop@dbmig patch_wizard]$

[applprop@dbmig patch_wizard]$ unzip InfoBundle11i.zip

[applprop@dbmig patch_wizard]$ ls |wc -l

2518

[applprop@dbmig patch_wizard]$

 

Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2

Issue #6:

 

DB upgrade script “catupgrd.sql” failed:

 

Segmentation Fault (core dumped)

{oratest@rsm4k02: admin $}

 

 

Solution:

LD_LIBRARY_PATH was set for old ORACLE_HOME:

 

{oratest@rsm4k02: ~ $} cat .profile

export PS1="{\u@\h: \W $} "

# . /oracle/10.2.0/TEST_rsm4k02.env

export ORACLE_HOME=/oracle/TEST/db/tech_st/11.2.0.4

export ORA_NLS10=/oracle/TEST/db/tech_st/11.2.0.4/nls/data/9idata

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib:/usr/dt/lib:/usr/openwin/lib

export PATH=$PATH:/usr/X/bin:/usr/X11/bin

export PATH=/usr/ccs/bin:$PATH

{oratest@rsm4k02: ~ $}

Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2

Issue #4:

 

Autoconfig failed on DB:

 

ERROR:
ORA-01804: failure to initialize timezone information

 

Solution:

AutoConfig Encounters A ORA-1804 Error: Failure To Initialize Timezone Information (Doc ID 1917923.1)

 

1.       This is resolved by editing the template ad8idbux.env in location .../oracle/db/tech_st/11.2.0/appsutil/template changing:

From:
set ORA_TZFILE=%s_db_oh%\oracore\zoneinfo\timezlrg.dat

To:
set ORA_TZFILE=%s_db_oh%\oracore\zoneinfo\timezlrg_14.dat

2. Running AutoConfig after this change means the environment file is created with the ORA_TZFILE value as timezlrg_14.dat and AutoConfig completes successfully.

 

Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2

Issue #5:

 

Catupgrd.sql failed with below error:

Manual upgrade failed!

 

ERROR at line 1:
ORA-00600: internal error code, arguments: [qcisSetPlsqlCtx:tzi init], [], [],
[], [], [], [], [], [], [], [], []

 

As per note ID 1435823.1:

Oracle returns ORA-00600 [qcisSetPlsqlCtx:tzi init] while setting up a PL/SQL context during a compilation. The qcisSetPlSqlCtx() routine is responsible to set up this PL/SQL context. The error indicates that compilation cannot find a timezone pointer as timezone information being unavailable.

 

As per note ID 1579838.1:

* For 10.2.0.2 , 10.2.0.3 , 10.2.0.4 or 10.2.0.5 there is no need to apply any patchset before upgrading to 11.2.0.4
Upgrade to 11.2.0.4. No need to apply DST patches on the 10.2.0.2 , 10.2.0.3 , 10.2.0.4 or 10.2.0.5 side first. You can skip any DST related upgrade instructions.
The 11.2.0.4 RDBMS DST version after the upgrade to 11.2.0.4 will be the same DST version as used in 10.2.0.2 , 10.2.0.3 , 10.2.0.4 or 10.2.0.5.

 

Solution:

Run automatic upgrade using DBUA.