Wednesday 6 November 2019

Oracle Database 12C Central Inventory Re-Creation

Note:
You can create central Inventory for oracle in running up environment without any hesitation in this scenario I am using Oracle-EBS R12 for yours confident building at this activity I had been done.

ERROR:
----------------------
[oracle@ebstest ~]$ export ORACLE_HOME=/u02/oracle/furdb/db/tech_st/12.1.0
[oracle@ebstest ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH
[oracle@ebstest ~]$ opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u02/oracle/furdb/db/tech_st/12.1.0
Central Inventory : /u01/oracle/oraInventory
   from           : /u02/oracle/furdb/db/tech_st/12.1.0/oraInst.loc
OPatch version    : 12.2.0.1.16
OUI version       : 12.1.0.2.0
Log file location : /u02/oracle/furdb/db/tech_st/12.1.0/cfgtoollogs/opatch/opatch2019-11-07_10-52-44AM_1.log

LsInventorySession failed: OPatch failed to locate Central Inventory.
Possible causes are:
    The Central Inventory is corrupted
    The oraInst.loc file specified is not valid.

OPatch failed with error code 73


Solution:
------------------
[oracle@ebstest oraInventory]$ cd $ORACLE_HOME
[oracle@ebstest 12.1.0]$ cd oui/bin/
[oracle@ebstest bin]$ ls
addLangs.sh  attachHome.sh  detachHome.sh  filesList.bat  filesList.properties  filesList.sh  lsnodes  resource  runConfig.sh  runInstaller  runInstaller.sh  runSSHSetup.sh
[oracle@ebstest bin]$ ./runInstaller -silent -invPtrLoc "/etc/oraInst.loc" -attachHome ORACLE_HOME="/u02/oracle/furdb/db/tech_st/12.1.0" ORACLE_HOME_NAME="Ora121Home"
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 14579 MB    Passed
The inventory pointer is located at /etc/oraInst.loc

'AttachHome' was successful.

[oracle@ebstest oraInventory]$ opatch lsinventory

Source: R&D / Oracle Support