Patch 31718813 - Database Proactive Bundle Patch 12.1.0.2.201020 Manual RAC Database patch

RAC Database version =12.1.0.2 ===================Manual RAC Database patching=========================== As document As the database home owner execute: $ /%BUGNO%/%OCW TRACKING BUG%/custom/scripts/prepatch.sh -dbhome $ /OPatch/opatch apply -oh -local /%BUGNO%/%OCW TRACKING BUG% $ /OPatch/opatch apply -oh -local /%BUGNO%/%RDBMS PSU TRACKING BUG% $ /%BUGNO%/%OCW TRACKING BUG%/custom/scripts/postpatch.sh -dbhome We need to apply patch on TESTRAC [root@TESTNODE1 ~]# ps -ef|grep pmon oracrs 14403 1 0 May26 ? 00:01:00 asm_pmon_+ASM1 TESTRAC 22666 1 0 May26 ? 00:01:18 ora_pmon_TESTRAC1 root 32376 32199 0 05:09 pts/0 00:00:00 grep pmon [root@TESTNODE1 ~]# srvctl stop instance -d TESTRAC -i TESTRAC1 -o immediate patch location - /staging/gridoct2020patch/31718813 home location -- /u01/oracle/TESTRAC/product/12.1.0.2 For Database home, as home user: % $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /31718813/31511219 % $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /31718813/31704029 root@TESTNODE1 scripts]# ls -ltr total 20 -rwxrwxr-x 1 oracrs dba 4566 Oct 2 2020 prepatch.sh -rwxrwxr-x 1 oracrs dba 9007 Oct 2 2020 postpatch.sh [root@TESTNODE1 scripts]# pwd /staging/gridoct2020patch/31718813/31704029/custom/scripts [root@TESTNODE1 scripts]# As the database home owner execute: $ /staging/gridoct2020patch/31718813/31704029/custom/scripts/prepatch.sh -dbhome /u01/oracle/TESTRAC/product/12.1.0.2 $ /u01/oracle/TESTRAC/product/12.1.0.2/OPatch/opatch apply -oh /u01/oracle/TESTRAC/product/12.1.0.2 -local /staging/gridoct2020patch/31718813/31704029 $ /u01/oracle/TESTRAC/product/12.1.0.2/OPatch/opatch apply -oh /u01/oracle/TESTRAC/product/12.1.0.2 -local /staging/gridoct2020patch/31718813/31511219 $ /staging/gridoct2020patch/31718813/31704029/custom/scripts//postpatch.sh -dbhome /u01/oracle/TESTRAC/product/12.1.0.2 [root@TESTNODE1 31511219]# [root@TESTNODE1 31511219]# ls -ltr /staging/gridoct2020patch/31718813/31704029/custom/scripts/prepatch.sh -rwxrwxr-x 1 oracrs dba 4566 Oct 2 2020 /staging/gridoct2020patch/31718813/31704029/custom/scripts/prepatch.sh [root@TESTNODE1 31511219]# ls -ltr /staging/gridoct2020patch/31718813/31704029 total 80 -rwxrwxr-x 1 oracrs dba 67875 Oct 2 2020 README.txt drwxrwxr-x 3 oracrs dba 4096 Oct 2 2020 custom drwxrwxr-x 15 oracrs dba 4096 Oct 2 2020 files drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 etc [root@TESTNODE1 31511219]# ls -ltr /staging/gridoct2020patch/31718813/31511219 total 200 -rwxrwxr-x 1 oracrs dba 21 Oct 2 2020 README.txt -rwxrwxr-x 1 oracrs dba 74974 Oct 2 2020 README.html drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 27547374 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 24340679 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 20788771 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 29141038 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 28259867 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 24732088 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 21125181 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 26925263 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 25397136 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 20243804 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 31001106 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 27338029 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 30364137 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 20415006 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 28731800 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 31511219 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 22806133 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 21527488 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 29496791 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 20594149 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 29972716 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 26717470 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 30691015 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 20950328 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 23144544 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 26609798 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 21949015 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 25869760 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 21359749 drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 21694919 [root@TESTNODE1 31511219]# =========================================== root@TESTNODE1 31511219]# [root@TESTNODE1 31511219]# [root@TESTNODE1 31511219]# su - oracrs [oracrs@TESTNODE1 ~]$ [oracrs@TESTNODE1 ~]$ [oracrs@TESTNODE1 ~]$ ps -ef|grep pmon oracrs 3044 2997 0 06:34 pts/0 00:00:00 grep pmon oracrs 14403 1 0 May26 ? 00:01:01 asm_pmon_+ASM1 TESTRAC 22666 1 0 May26 ? 00:01:19 ora_pmon_TESTRAC1 [oracrs@TESTNODE1 ~]$ srvctl stop instance -d TESTRAC -i TESTRAC1 -o immediate [oracrs@TESTNODE1 ~]$ exit logout [root@TESTNODE1 31511219]# su - TESTRAC [TESTRAC@TESTNODE1 ~]$ . oraenv ORACLE_SID = [TESTRAC1] ? TESTRAC The Oracle base remains unchanged with value /u01/oracle/TESTRAC [TESTRAC@TESTNODE1 ~]$ export ORACLE_SID=TESTRAC1 [TESTRAC@TESTNODE1 ~]$ ls -ltr /staging/gridoct2020patch/31718813/31704029/custom/scripts/prepatch.sh -rwxrwxr-x 1 oracrs dba 4566 Oct 2 2020 /staging/gridoct2020patch/31718813/31704029/custom/scripts/prepatch.sh [TESTRAC@TESTNODE1 ~]$ /staging/gridoct2020patch/31718813/31704029/custom/scripts/prepatch.sh -dbhome /u01/oracle/TESTRAC/product/12.1.0.2 /staging/gridoct2020patch/31718813/31704029/custom/scripts/prepatch.sh completed successfully. [TESTRAC@TESTNODE1 ~]$ ls -ltr /staging/gridoct2020patch/31718813/31704029 total 80 -rwxrwxr-x 1 oracrs dba 67875 Oct 2 2020 README.txt drwxrwxr-x 3 oracrs dba 4096 Oct 2 2020 custom drwxrwxr-x 15 oracrs dba 4096 Oct 2 2020 files drwxrwxr-x 4 oracrs dba 4096 Oct 2 2020 etc [TESTRAC@TESTNODE1 ~]$ ls -ltr /u01/oracle/TESTRAC/product/12.1.0.2/OPatch/opatch -rwxr-x--- 1 TESTRAC dba 49544 Nov 5 2020 /u01/oracle/TESTRAC/product/12.1.0.2/OPatch/opatch [TESTRAC@TESTNODE1 ~]$ /u01/oracle/TESTRAC/product/12.1.0.2/OPatch/opatch apply -oh /u01/oracle/TESTRAC/product/12.1.0.2 -local /staging/gridoct2020patch/31718813/31704029 Oracle Interim Patch Installer version 12.2.0.1.23 Copyright (c) 2021, Oracle Corporation. All rights reserved. Oracle Home : /u01/oracle/TESTRAC/product/12.1.0.2 Central Inventory : /u01/oracle/oraInventory from : /u01/oracle/TESTRAC/product/12.1.0.2/oraInst.loc OPatch version : 12.2.0.1.23 OUI version : 12.1.0.2.0 Log file location : /u01/oracle/TESTRAC/product/12.1.0.2/cfgtoollogs/opatch/opatch2021-06-01_06-38-38AM_1.log Unable to lock Central Inventory. OPatch will attempt to re-lock. Do you want to proceed? [y|n] y User Responded with: Y OPatch will sleep for few seconds, before re-trying to get the lock... Unable to lock Central Inventory. OPatch will attempt to re-lock. Do you want to proceed? [y|n] y User Responded with: Y OPatch will sleep for few seconds, before re-trying to get the lock... Unable to lock Central Inventory. OPatch will attempt to re-lock. Do you want to proceed? [y|n] n User Responded with: N OPatchSession cannot load inventory for the given Oracle Home /u01/oracle/TESTRAC/product/12.1.0.2. 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: Unable to lock Central Inventory. Stop trying per user-request? Log file location: /u01/oracle/TESTRAC/product/12.1.0.2/cfgtoollogs/opatch/opatch2021-06-01_06-38-38AM_1.log OPatch failed with error code 73 [TESTRAC@TESTNODE1 ~]$ To Troubleshoot inventory lock Please provide cat "/etc/oraInst.loc" -- See the inv path listed in above file and provide below ls -ld /u01/oracle/oraInventory/locks ls -la /u01/oracle/oraInventory/locks ls -la /u01/oracle/oraInventory ls -ltr /u01/oracle/oraInventory chmod -R g+w /u01/oracle/oraInventory chmod -R 770 /u01/oracle/oraInventory