Hi,
When I apply 18650065 patch to Oracle database 12c, I got ” Central Inventory is locked by another OUI instance No read permission to Central Inventory ” errors.
I have created Test database from Production database in the new Server. When I apply 18650065 patch to test database i got error like following.
[oracle@MehmetSalih 18650065]$ opatch apply Oracle Interim Patch Installer version 12.2.0.1.14 Copyright (c) 2019, Oracle Corporation. All rights reserved. Oracle Home : /oracle/12.1.0/dbhome_1 Central Inventory : /home/oracle/oraInventory from : /etc/oraInst.loc OPatch version : 12.2.0.1.14 OUI version : 12.1.0.2.0 Log file location : /oracle/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-07-18_11-40-57AM_1.log List of Homes on this system: Home name= TEST_DB__u01_oracle_product_11_2_0_3_db, Location= "/u01/oracle/product/11.2.0.3/db" OPatchSession cannot load inventory for the given Oracle Home /oracle/12.1.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 UtilSession failed: RawInventory gets null OracleHomeInfo Log file location: /oracle/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-07-18_11-40-57AM_1.log OPatch failed with error code 73 [oracle@MehmetSalih 18650065]$
This errors are related with incorrect oraInventory parameters.
I have checked oraInventory, parameters are the Old one like following.
[oracle@MehmetSalih ContentsXML]$pwd /home/oracle/oraInventory/ContentsXML [oracle@MehmetSalih ContentsXML]$ [oracle@MehmetSalih ContentsXML]$ cat inventory.xml <?xml version="1.0" standalone="yes" ?> <!-- Copyright (c) 1999, 2011, Oracle. All rights reserved. --> <!-- Do not modify the contents of this file by hand. --> <INVENTORY> <VERSION_INFO> <SAVED_WITH>11.2.0.3.0</SAVED_WITH> <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER> </VERSION_INFO> <HOME_LIST> <HOME NAME="TEST_DB__u01_oracle_product_11_2_0_3_db" LOC="/u01/oracle/product/11.2.0.3/db" TYPE="O" IDX="1"/> </HOME_LIST> <COMPOSITEHOME_LIST> </COMPOSITEHOME_LIST> </INVENTORY> [oracle@MehmetSalih ContentsXML]$
I have corrected HOME NAME with new Home like following.
[oracle@MehmetSalih ContentsXML]$ cat inventory.xml <?xml version="1.0" standalone="yes" ?> <!-- Copyright (c) 1999, 2011, Oracle. All rights reserved. --> <!-- Do not modify the contents of this file by hand. --> <INVENTORY> <VERSION_INFO> <SAVED_WITH>12.1.0.2.0</SAVED_WITH> <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER> </VERSION_INFO> <HOME_LIST> <HOME NAME="DEV2_HOME" LOC="/oracle/12.1.0/dbhome_1" TYPE="O" IDX="1"/> </HOME_LIST> <COMPOSITEHOME_LIST> </COMPOSITEHOME_LIST> </INVENTORY> [oracle@MehmetSalih ContentsXML]
Now When I try to apply patch again, it is successfull like following.
[oracle@MehmetSalih 18650065]$ opatch apply Oracle Interim Patch Installer version 12.2.0.1.14 Copyright (c) 2019, Oracle Corporation. All rights reserved. Oracle Home : /oracle/12.1.0/dbhome_1 Central Inventory : /home/oracle/oraInventory from : /etc/oraInst.loc OPatch version : 12.2.0.1.14 OUI version : 12.1.0.2.0 Log file location : /oracle/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-07-18_11-47-20AM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 18650065 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/oracle/12.1.0/dbhome_1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '18650065' to OH '/oracle/12.1.0/dbhome_1' Patching component oracle.rdbms, 12.1.0.2.0... Patch 18650065 successfully applied. Log file location: /oracle/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-07-18_11-47-20AM_1.log OPatch succeeded. [oracle@MehmetSalih 18650065]$
Patch 18650065 successfully applied to Oracle database 12c.
Do you want to learn Oracle Database for Beginners, then read the following articles.
https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/