ORACLE_HOME Missing In Central Inventory

Posted: October 17, 2013 in Database General
Tags: ,

While applying a patch on a database i got the below error:


/u01/app/oranine/product/patch/9952216 => opatch apply
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oranine/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oranine/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.5
OUI version       : 11.2.0.1.0
Log file location : /u01/app/oranine/product/11.2.0/dbhome_1/cfgtoollogs/opatch/9952216_Oct_16_2013_08_18_25/apply2013-10-16_08-18-25AM_1.log

Applying interim patch '9952216' to OH '/u01/app/oranine/product/11.2.0/dbhome_1'
Verifying environment and performing prerequisite checks...
OiiolLogger.addFileHandler:Error while adding file handler - /u01/app/oraInventory/logs/OPatch2013-10-16_08-18-26-AM.log
java.io.FileNotFoundException: /u01/app/oraInventory/logs/OPatch2013-10-16_08-18-26-AM.log (No such file or directory)
Unable to lock Central Inventory.  OPatch will attempt to re-lock.
Do you want to proceed? [y|n]
n
User Responded with: N
Unable to lock Central Inventory.  Stop trying per user-request?
OPatchSession cannot load inventory for the given Oracle Home /u01/app/oranine/product/11.2.0/dbhome_1. Possible causes are:
   No read or write permission to ORACLE_HOME/.patch_storage
   Central Inventory is locked by another OUI instance
   No read permission to Central Inventory
   The lock file exists in ORACLE_HOME/.patch_storage
   The Oracle Home does not exist in Central Inventory

OPatch failed: ApplySession failed to prepare the system. Unable to lock Central Inventory.  Stop trying per user-request?
Log file location: /u01/app/oranine/product/11.2.0/dbhome_1/cfgtoollogs/opatch/9952216_Oct_16_2013_08_18_25/apply2013-10-16_08-18-25AM_1.log

OPatch failed with error code 22

As per error i checked and found that i have read, write permission on inventory location. Then i checked the inventory.xml file in ContentsXML folder located in central inventory location and found that there is no entry for this ORACLE_HOME. Below are steps to attach a ORACLE_HOME to central inventory:


./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="/u01/app/oranine/product/11.2.0/dbhome_1" ORACLE_HOME_NAME="OraDb11g_home4"
********************************************************************************

Your platform requires the root user to perform certain pre-installation
OS preparation.  The root user should run the shell script 'rootpre.sh' before
you proceed with Oracle installation.  rootpre.sh can be found at the top level
of the CD or the stage area.

Answer 'y' if root has run 'rootpre.sh' so you can proceed with Oracle
installation.
Answer 'n' to abort installation and then ask root to run 'rootpre.sh'.

********************************************************************************

Has 'rootpre.sh' been run by root? [y/n] (n)
y

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 190 MB.   Actual 1350 MB    Passed
Checking swap space: 0 MB available, 150 MB required.    Failed <<<<

>>> Ignoring required pre-requisite failures. Continuing...

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-10-16_10-17-01AM. Please wait .../mnt/software/Ora11201/database =>
/mnt/software/Ora11201/database => The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oranine/product/oraInventory
'AttachHome' was successful.

Once ORACLE_HOME is attached with central inventory then the patch applied successfully.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s