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

Friday, 9 January 2015

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-2014_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-2014_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 som 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,
X A H E E R

1 comment:

Sridevi K said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.