Problém 55:
Nemůžete napatchovat Oracle home, protože z nějakého důvodu není v inventory a Opatch hlásí následující chybu.
[oracle@localhost 5943776]$ opatch lsinventory
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/acfsmounts/acfs_db1
Central Inventory : /u01/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /u01/app/oracle/acfsmounts/acfs_db1/oui
Log file location : /u01/app/oracle/acfsmounts/acfs_db1/cfgtoollogs/opatch/opatch2011-07-21_09-32-06AM.log
Patch history file: /u01/app/oracle/acfsmounts/acfs_db1/cfgtoollogs/opatch/opatch_history.txt
List of Homes on this system:
Home name= OraDb10g_home1, Location= „/u01/app/oracle/product/10.2.0/dbhome_1“
Home name= Ora11g_gridinfrahome1, Location= „/u01/app/oracle/product/11.2.0/grid“
Inventory load failed… OPatch cannot load inventory for the given Oracle Home.
Possible causes are:
Oracle Home dir. path does not exist in Central Inventory
Oracle Home is a symbolic link
Oracle Home inventory is corrupted
LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo
OPatch failed with error code 73
[oracle@localhost ContentsXML]$ cat inventory.xml
<VERSION_INFO>
<SAVED_WITH>11.2.0.1.0
<MINIMUM_VER>2.1.0.6.0
<HOME_LIST>
Řešení:
Jedno z řešení je použití OUI pro registraci daného Oracle home.
[oracle@localhost acfs_db1]$ cd $ORACLE_HOME/oui/bin
[oracle@localhost bin]$ ./runInstaller -silent -attachHome ORACLE_HOME=“/u01/app/oracle/acfsmounts/acfs_db1″ ORACLE_HOME_NAME=“Ora11gDBHome“
Starting Oracle Universal Installer…
Checking swap space: must be greater than 500 MB. Actual 3868 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-07-21_10-33-20AM. Please wait …[oracle@localhost bin]$ The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
‚AttachHome‘ was successful.
Vidíte, že zde přibyl záznam o daném oracle_home.
[oracle@localhost ContentsXML]$ cat inventory.xml
<VERSION_INFO>
<SAVED_WITH>11.2.0.1.0
<MINIMUM_VER>2.1.0.6.0
<HOME_LIST>
Nyní již opatch funguje správně.
[oracle@localhost 5943776]$ opatch lsinventory
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/acfsmounts/acfs_db1
Central Inventory : /u01/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /u01/app/oracle/acfsmounts/acfs_db1/oui
Log file location : /u01/app/oracle/acfsmounts/acfs_db1/cfgtoollogs/opatch/opatch2011-07-21_10-36-37AM.log
Patch history file: /u01/app/oracle/acfsmounts/acfs_db1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /u01/app/oracle/acfsmounts/acfs_db1/cfgtoollogs/opatch/lsinv/lsinventory2011-07-21_10-36-37AM.txt
——————————————————————————–
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.1.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
——————————————————————————–
OPatch succeeded.
My Oracle Support Note:
Steps To Recreate Central Inventory(oraInventory) In RDBMS Homes [ID 556834.1]