I received an Incident from one of our customer that they are not able to apply patch on 10.1.2 (Developer) Oracle Home for their recently cloned EBS R12 Instance. The command "opatch lsinventory is working fine when trying to apply the actual patch then its failing for "MISSING_COMPONENT : oracle.developer.reports.core, 10.1.2.3.0". Though component is included in the Inventory.
Output from opatch lsinventory command:
Error Stack while applying patch:
After troubleshooting multiple areas I have noticed that location of local and global Inventory was pointing to the same location.
Solution:
>> copy the local/central inventory to some different location and update the same location in "/etc/oraInst.loc" file.
>> Try to apply patch again it should complete without any Issues.
I face this Issue on Oracle EBS R12.1.3 running on IBM-AIX 6.1. This Issue might be applicable on different versions/environments.
thanks for reading :)
regards,
Zaheer
Output from opatch lsinventory command:
[oradev@TESTERP[/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/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-2021_14-24-29.log"
Result:
There is no Interim Patch
OPatch succeeded.
[oradev@TESTERP[/oradev]#
Error Stack while applying patch:
[oradev@TESTERP[/oradev/patches/14374587]#opatch apply 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/14374587/Apply_14374587_11-04-2021_14-28-53.log" Invoking fuser to check for active processes. MISSING_COMPONENT : oracle.developer.reports.core, 10.1.2.3.0 This Oracle Home does not have components/versions required by the patch. ERROR: OPatch failed during pre-reqs check. [oradev@TESTERP[/oradev/patches/14374587]#
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
Solution:
>> copy the local/central inventory to some different location and update the same location in "/etc/oraInst.loc" file.
>> Try to apply patch again it should complete without any Issues.
I face this Issue on Oracle EBS R12.1.3 running on IBM-AIX 6.1. This Issue might be applicable on different versions/environments.
thanks for reading :)
regards,
Zaheer
Comments
At least 160000 men and women are trying a easy and secret "water hack" to drop 2lbs every night while they sleep.
It is very simple and it works every time.
This is how to do it yourself:
1) Go get a drinking glass and fill it half glass
2) And then follow this weight losing hack
so you'll be 2lbs thinner the very next day!