Oracle Apps DBA

My photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Tuesday, 30 December 2014

OPATCH_JAVA_ERROR : An exception of type "OPatchException" has occurred - 10.1.2 Home in EBS R12

There is a requirement to Install one-off patch on Developer Oracle Home of EBS R12.1.3 cloned Instance. opatch was unable to locate the Inventory. When we check the Inventory 10.1.2 Home is not included.

Error Stack  from "opatch lsinvenory":

[oradev@ERPDEV[/oradev/R12_app/apps/tech_st/10.1.2]#opatch lsinventory

Oracle Interim Patch Installer version 1.0.0.0.57
Copyright (c) 2007 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com

Oracle Home           : /oradev/R12_app/apps/tech_st/10.1.2
Oracle Home Inventory : /oradev/R12_app/apps/tech_st/10.1.2/inventory
Central Inventory     : /oradev/R12_app/apps/tech_st/10.1.2/inventory
   from               : /etc/oraInst.loc
OUI location          : /oradev/R12_app/apps/tech_st/10.1.2/oui
OUI shared library    : /oradev/R12_app/apps/tech_st/10.1.2/oui/lib/ibm_aix/liboraInstaller.so
Java location         : /oradev/R12_app/apps/tech_st/10.1.2/jre/1.4.2/bin/java
Log file location     : /oradev/R12_app/apps/tech_st/10.1.2/.patch_storage//*.log

Creating log file "/oradev/R12_app/apps/tech_st/10.1.2/.patch_storage/LsInventory__11-04-2014_13-26-09.log"

Result:

LsInventory: OPatch Exception while accessing O2O


OPATCH_JAVA_ERROR  : An exception of type "OPatchException" has occurred:
OPatch Exception:
  OUI found no such ORACLE_HOME set in the environment
  Can not get details for given Oracle Home
  An exception occurs
  null


There is no Interim Patch



OPATCH_JAVA_ERROR  : An exception of type "OPatchException" has occurred:
Can not get a list of inventory on this home.

ERROR: OPatch failed because of Inventory problem.
[oradev@ERPDEV[/oradev/R12_app/apps/tech_st/10.1.2]#

As a workaround downloaded the latest opatch utility but still same Issue exists.

Cause: 

ORACLE_HOME (10.1.2) not exists in the central Inventory. Hence the Opatch is failing.

Solution:

Attach (10.1.2) ORACLE_HOME to an existing Inventory/new Inventory  using OUI - Installer.

[oradev@ERPDEV[/oradev/R12_app/apps/tech_st/10.1.2/oui/bin]#./runInstaller -silent -attachHome ORACLE_HOME=/oradev/R12_app/apps/tech_st/10.1.2 ORACLE_HOME_NAME=dev_1012_home
Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be 5200, 5300 or 6100
                                      Passed


All installer requirements met.

Checking operating system packages: bos.adt.base,bos.adt.lib,bos.adt.libm,bos.perf.libperfstat,bos.perf.perfstat,bos.perf.proctools,X11.motif.lib    Passed
Checking swap space: must be greater than 1536 MB.   Actual 10240MB    Passed
Checking Temp space: must be greater than 1000 MB.   Actual 1264 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-11-04_02-22-21PM. Please wait ...[oradev@ERPDEV[/oradev/R12_app/apps/tech_st/10.1.2/oui/bin]#'AttachHome' was successful.

[oradev@ERPDEV[/oradev/R12_app/apps/tech_st/10.1.2/oui/bin]#


Now run opatch and check it should work fine.

[oradev@ERPDEV[/oradev]#opatch lsinventory

Oracle Interim Patch Installer version 1.0.0.0.57
Copyright (c) 2007 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com

Oracle Home           : /oradev/R12_app/apps/tech_st/10.1.2
Oracle Home Inventory : /oradev/R12_app/apps/Inventory
Central Inventory     : /oradev/R12_app/apps/tech_st/10.1.2/inventory
   from               : /etc/oraInst.loc
OUI location          : /oradev/R12_app/apps/tech_st/10.1.2/oui
OUI shared library    : /oradev/R12_app/apps/tech_st/10.1.2/oui/lib/ibm_aix/liboraInstaller.so
Java location         : /oradev/R12_app/apps/tech_st/10.1.2/jre/1.4.2/bin/java
Log file location     : /oradev/R12_app/apps/tech_st/10.1.2/.patch_storage//*.log

Creating log file "/oradev/R12_app/apps/tech_st/10.1.2/.patch_storage/LsInventory__11-04-2014_14-24-29.log"

Result:

There is no Interim Patch

OPatch succeeded.
[oradev@ERPDEV[/oradev]#


These steps will be applicable also for 10.1.3 ORACLE_HOME of EBS R12 Instance.

thanks for reading.

regards,
X A H  E E R

No comments: