Apps DBA Workshop

Saturday, 9 October 2021

MISSING_COMPONENT : oracle.developer.reports.core, 10.1.2.3.0 EBS R12

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:
[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]#
 
After troubleshooting multiple areas I have noticed that location of local and global Inventory was pointing to the same location.
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

Labels: , , , ,

1 Comments:

  • Easy "water hack" burns 2 lbs OVERNIGHT

    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!

    By Blogger Blogger, At 24 February 2020 at 01:23  

Post a Comment

Subscribe to Post Comments [Atom]



<< Home