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
Comments
Wesley was in the army-and soon after leaving-he revealed hidden, "MIND CONTROL" secrets that the CIA and others used to get anything they want.
As it turns out, these are the exact same methods many celebrities (notably those who "became famous out of nothing") and top business people used to become wealthy and famous.
You probably know that you utilize only 10% of your brain.
That's really because the majority of your BRAINPOWER is UNCONSCIOUS.
Maybe that thought has even occurred INSIDE your very own head... as it did in my good friend Wesley Virgin's head 7 years back, while riding a non-registered, beat-up garbage bucket of a vehicle with a suspended driver's license and with $3 on his banking card.
"I'm very frustrated with living paycheck to paycheck! Why can't I become successful?"
You took part in those thoughts, isn't it right?
Your success story is waiting to happen. Go and take a leap of faith in YOURSELF.
WATCH WESLEY SPEAK NOW