How to apply the Oracle PATCH’S AT OS & Database Level
Posted by Mir Sayeed Hassan on June 20th, 2020
How to apply the Oracle PATCH’S AT OS & Database Level
The below patch are applied to one of our production database, due to the wrong result at standby level compare to primary database.
Download the OPatch (OS LEVEL)
p6880880_112000_Linux-x86-64.zip
Download the patch to be applied (DB LEVEL)
p19282021_112040_Linux-x86-64.zip p20299013_112040_Linux-x86-64.zip p17217593_112040_Linux-x86-64.zip
Transfer all the above downloaded files to the /tmp directory using winscp
Apply the OPATCH
[root@swdbn1 tmp]# ls p6880880_112000_Linux-x86-64.zip
[root@swdbn1 tmp]# mkdir OPatch
[root@swdbn1 tmp]# mv p6880880_112000_Linux-x86-64.zip OPatch
[root@swdbn1 patch]# cd OPatch/
[root@swdbn1 OPatch]# chown oracle:oinstall p6880880_112000_Linux-x86-64.zip
[root@swdbn1 patch]# chmod 777 p6880880_112000_Linux-x86-64.zip
Move the existing OPTACH File
[oracle@swdbn1 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/ [oracle@swdbn1 db_1]$ mv OPatch OPatch_21apr20/
APPLY THE OPATCH AS UNZIP
[oracle@swdbn1 ~]$ cd /tmp/patch/OPatch/ [oracle@swdbn1 OPatch]$ unzip p6880880_112000_Linux-x86-64.zip -d /u01/app/oracle/product/11.2.0/db_1/
OPATCH IS COMPLETED
Note: Fallow the same OPATCH Method on another node (122)
First PATCH APPLY
p19282021_112040_Linux-x86-64.zip
[root@swdbn1 tmp]# ls p19282021_112040_Linux-x86-64.zip
[root@swdbn1 patch]# mkdir patch [root@swdbn1 patch]# mv p19282021_112040_Linux-x86-64.zip patch [root@swdbn1 tmp]# chown -R oracle:oinstall patch/ [root@swdbn1 tmp]# su – oracle [oracle@swdbn1 patch]$ mkdir PATCH_TOP_DIR
[oracle@swdbn1 patch]$ unzip -d PATCH_TOP_DIR p19282021_112040_Linux-x86-64.zip Archive: p19282021_112040_Linux-x86-64.zip creating: PATCH_TOP_DIR/19282021/ extracting: PATCH_TOP_DIR/19282021/README.txt inflating: PATCH_TOP_DIR/19282021/postdeinstall.sql inflating: PATCH_TOP_DIR/19282021/README.html creating: PATCH_TOP_DIR/19282021/custom/ inflating: PATCH_TOP_DIR/19282021/custom/post.txt creating: PATCH_TOP_DIR/19282021/files/ creating: PATCH_TOP_DIR/19282021/files/sqlj/ creating: PATCH_TOP_DIR/19282021/files/sqlj/lib/ inflating: PATCH_TOP_DIR/19282021/files/sqlj/lib/sqljutl.jar creating: PATCH_TOP_DIR/19282021/files/lib/ inflating: PATCH_TOP_DIR/19282021/files/lib/libjavavm11.a creating: PATCH_TOP_DIR/19282021/files/sqlpatch/ creating: PATCH_TOP_DIR/19282021/files/sqlpatch/19282021/ inflating: PATCH_TOP_DIR/19282021/files/sqlpatch/19282021/postdeinstall.sql inflating: PATCH_TOP_DIR/19282021/files/sqlpatch/19282021/postinstall.sql creating: PATCH_TOP_DIR/19282021/files/javavm/ creating: PATCH_TOP_DIR/19282021/files/javavm/lib/ inflating: PATCH_TOP_DIR/19282021/files/javavm/lib/sunjce_provider.jar creating: PATCH_TOP_DIR/19282021/files/javavm/lib/security/ inflating: PATCH_TOP_DIR/19282021/files/javavm/lib/security/cacerts inflating: PATCH_TOP_DIR/19282021/files/javavm/lib/security/java.security inflating: PATCH_TOP_DIR/19282021/files/javavm/lib/jce.jar creating: PATCH_TOP_DIR/19282021/files/javavm/install/ inflating: PATCH_TOP_DIR/19282021/files/javavm/install/jvmsec5.sql inflating: PATCH_TOP_DIR/19282021/files/javavm/install/jvmrm.sql inflating: PATCH_TOP_DIR/19282021/files/javavm/install/initdbj.sql inflating: PATCH_TOP_DIR/19282021/files/javavm/install/initsqlj.sql inflating: PATCH_TOP_DIR/19282021/files/javavm/install/jvmpsu.sql creating: PATCH_TOP_DIR/19282021/files/javavm/admin/ inflating: PATCH_TOP_DIR/19282021/files/javavm/admin/jox.o inflating: PATCH_TOP_DIR/19282021/files/javavm/admin/classes.bin creating: PATCH_TOP_DIR/19282021/files/jpub/ creating: PATCH_TOP_DIR/19282021/files/jpub/sql/ inflating: PATCH_TOP_DIR/19282021/files/jpub/sql/sqljutl2.sql creating: PATCH_TOP_DIR/19282021/files/jpub/demo/ inflating: PATCH_TOP_DIR/19282021/files/jpub/demo/README.txt creating: PATCH_TOP_DIR/19282021/files/rdbms/ creating: PATCH_TOP_DIR/19282021/files/rdbms/admin/ inflating: PATCH_TOP_DIR/19282021/files/rdbms/admin/initdbj.sql inflating: PATCH_TOP_DIR/19282021/files/rdbms/admin/initsqlj.sql creating: PATCH_TOP_DIR/19282021/etc/ creating: PATCH_TOP_DIR/19282021/etc/config/ inflating: PATCH_TOP_DIR/19282021/etc/config/inventory.xml inflating: PATCH_TOP_DIR/19282021/etc/config/actions.xml inflating: PATCH_TOP_DIR/19282021/etc/config/deploy.xml creating: PATCH_TOP_DIR/19282021/etc/xml/ inflating: PATCH_TOP_DIR/19282021/etc/xml/GenericActions.xml inflating: PATCH_TOP_DIR/19282021/etc/xml/ShiphomeDirectoryStructure.xml inflating: PATCH_TOP_DIR/19282021/postinstall.sql inflating: PATCH_TOP_DIR/PatchSearch.xml
[oracle@swdbn1 patch]$ cd PATCH_TOP_DIR/
[oracle@swdbn1 PATCH_TOP_DIR]$ ls 19282021 PatchSearch.xml
[oracle@swdbn1 PATCH_TOP_DIR]$ cd 19282021/
[oracle@swdbn1 19282021]$ ls custom etc files postdeinstall.sql postinstall.sql README.html README.txt
Run the pre-req check
[oracle@swdbn1 19282021]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 11.2.0.3.23 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/11.2.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc OPatch version : 11.2.0.3.23 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-04-21_11-14-53AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
Note:
Before applying the above patch, Cancel the recovery process & stop all the services like database, asm, listener, nodeapps & crs daemons.
SQL> alter database recover managed standby database cancel; Database altered.
STOP THE DATABASE
[oracle@swdbn1 ~]$ srvctl stop db -d pspswi
STOP THE LISTENER
[oracle@swdbn1 ~]$ srvctl stop listener
STOP THE CRS FROM THE ROOT LOGIN WITH GRID HOME
[root@swdbn1 ~]# cd /u01/app/11.2.0/grid/bin/
[root@swdbn1 bin]# ./crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'swdbn1' CRS-2673: Attempting to stop 'ora.crsd' on 'swdbn1' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'swdbn1' CRS-2673: Attempting to stop 'ora.oc4j' on 'swdbn1' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'swdbn1' CRS-2673: Attempting to stop 'ora.cvu' on 'swdbn1' CRS-2673: Attempting to stop 'ora.swdbn1.vip' on 'swdbn1' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'swdbn1' CRS-2673: Attempting to stop 'ora.CLUSTERDG.dg' on 'swdbn1' CRS-2673: Attempting to stop 'ora.ARCH.dg' on 'swdbn1' CRS-2673: Attempting to stop 'ora.ORADATA.dg' on 'swdbn1' CRS-2673: Attempting to stop 'ora.ORL.dg' on 'swdbn1' CRS-2677: Stop of 'ora.cvu' on 'swdbn1' succeeded CRS-2672: Attempting to start 'ora.cvu' on 'swdbn2' CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'swdbn1' succeeded CRS-2673: Attempting to stop 'ora.scan3.vip' on 'swdbn1' CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'swdbn1' succeeded CRS-2673: Attempting to stop 'ora.scan2.vip' on 'swdbn1' CRS-2676: Start of 'ora.cvu' on 'swdbn2' succeeded CRS-2677: Stop of 'ora.ARCH.dg' on 'swdbn1' succeeded CRS-2677: Stop of 'ora.ORADATA.dg' on 'swdbn1' succeeded CRS-2677: Stop of 'ora.ORL.dg' on 'swdbn1' succeeded CRS-2677: Stop of 'ora.swdbn1.vip' on 'swdbn1' succeeded CRS-2672: Attempting to start 'ora.swdbn1.vip' on 'swdbn2' CRS-2677: Stop of 'ora.scan3.vip' on 'swdbn1' succeeded CRS-2672: Attempting to start 'ora.scan3.vip' on 'swdbn2' CRS-2677: Stop of 'ora.oc4j' on 'swdbn1' succeeded CRS-2672: Attempting to start 'ora.oc4j' on 'swdbn2' CRS-2677: Stop of 'ora.scan2.vip' on 'swdbn1' succeeded CRS-2672: Attempting to start 'ora.scan2.vip' on 'swdbn2' CRS-2676: Start of 'ora.swdbn1.vip' on 'swdbn2' succeeded CRS-2676: Start of 'ora.scan3.vip' on 'swdbn2' succeeded CRS-2672: Attempting to start 'ora.LISTENER_SCAN3.lsnr' on 'swdbn2' CRS-2676: Start of 'ora.scan2.vip' on 'swdbn2' succeeded CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'swdbn2' CRS-2676: Start of 'ora.LISTENER_SCAN3.lsnr' on 'swdbn2' succeeded CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'swdbn2' succeeded CRS-2677: Stop of 'ora.CLUSTERDG.dg' on 'swdbn1' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'swdbn1' CRS-2677: Stop of 'ora.asm' on 'swdbn1' succeeded CRS-2676: Start of 'ora.oc4j' on 'swdbn2' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'swdbn1' CRS-2677: Stop of 'ora.ons' on 'swdbn1' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'swdbn1' CRS-2677: Stop of 'ora.net1.network' on 'swdbn1' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'swdbn1' has completed CRS-2677: Stop of 'ora.crsd' on 'swdbn1' succeeded CRS-2673: Attempting to stop 'ora.crf' on 'swdbn1' CRS-2673: Attempting to stop 'ora.ctssd' on 'swdbn1' CRS-2673: Attempting to stop 'ora.evmd' on 'swdbn1' CRS-2673: Attempting to stop 'ora.asm' on 'swdbn1' CRS-2673: Attempting to stop 'ora.mdnsd' on 'swdbn1' CRS-2677: Stop of 'ora.crf' on 'swdbn1' succeeded CRS-2677: Stop of 'ora.evmd' on 'swdbn1' succeeded CRS-2677: Stop of 'ora.mdnsd' on 'swdbn1' succeeded CRS-2677: Stop of 'ora.ctssd' on 'swdbn1' succeeded CRS-2677: Stop of 'ora.asm' on 'swdbn1' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'swdbn1' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'swdbn1' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'swdbn1' CRS-2677: Stop of 'ora.cssd' on 'swdbn1' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'swdbn1' CRS-2677: Stop of 'ora.gipcd' on 'swdbn1' succeeded CRS-2673: Attempting to stop 'ora.gpnpd' on 'swdbn1' CRS-2677: Stop of 'ora.gpnpd' on 'swdbn1' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'swdbn1' has completed CRS-4133: Oracle High Availability Services has been stopped.
NOW APPLY THE PATCH
[oracle@swdbn1 ~]$ cd /tmp/patch/PATCH_TOP_DIR/19282021/
[oracle@swdbn1 19282021]$ ls custom etc files postdeinstall.sql postinstall.sql README.html README.txt
[oracle@swdbn1 19282021]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply Oracle Interim Patch Installer version 11.2.0.3.23 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc OPatch version : 11.2.0.3.23 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-04-21_11-30-04AM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 19282021 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 = '/u01/app/oracle/product/11.2.0/db_1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '19282021' to OH '/u01/app/oracle/product/11.2.0/db_1' ApplySession: Optional component(s) [ oracle.sqlj, 11.2.0.4.0 ] , [ oracle.sqlj.companion, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.javavm.server, 11.2.0.4.0... Patching component oracle.rdbms, 11.2.0.4.0... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0... -------------------------------------------------------------------------------- *************************************************************************************** *************************************************************************************** ** ATTENTION ** ** ** ** For Database PSU, Oracle JavaVM Component, it is mandatory to complete the ** ** post installation(deinstallation) steps to avoid inconsistencies in the database. ** ** Please refer to the README for detailed instructions. ** ** ** *************************************************************************************** *************************************************************************************-------------------------------------------------------------------------------- Make failed to invoke "/usr/bin/make -f ins_rdbms.mk jox_refresh_knlopt ioracle ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1"....'make: *** No rule to make target `jox_refresh_knlopt'. Stop. ' The following make actions have failed : Re-link fails on target "jox_refresh_knlopt ioracle". Do you want to proceed? [y|n] y User Responded with: Y Patch 19282021 successfully applied. OPatch Session completed with warnings. Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-04-21_11-30-04AM_1.log OPatch completed with warnings.
VERIFY THE PATCH APPIED
[oracle@swdbn1 19282021]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.23 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc OPatch version : 11.2.0.3.23 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-04-21_11-33-14AM_1.log Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2020-04-21_11-33-14AM.txt ------------------------------------------------------------------------------- Local Machine Information:: Hostname: swdbn1 ARU platform id: 226 ARU platform description:: Linux x86-64 Installed Top-level Products (1): Oracle Database 11g 11.2.0.4.0 There are 1 products installed in this Oracle Home. Interim patches (2) : Patch 19282021 : applied on Tue Apr 21 11:30:18 IRDT 2020 Unique Patch ID: 18156526 Patch description: "ORACLE JAVAVM COMPONENT 11.2.0.4.1 DATABASE PSU (OCT2014)" Created on 13 Oct 2014, 09:16:25 hrs PST8PDT Bugs fixed: 19006757, 19007266, 19153980, 19554117, 17201047, 19058059, 19231857 17285560, 18458318, 17056813, 18933818, 18166577, 14774730, 19223010 Patch 19689979 : applied on Sat Apr 18 16:10:44 IRDT 2020 Unique Patch ID: 18310545 Created on 26 Nov 2014, 00:25:56 hrs PST8PDT Bugs fixed: 19689979 ---------------------------------------------------------------------------- OPatch succeeded.
SECOND PATCH APPLY
p20299013_112040_Linux-x86-64.zip
[root@swdbn1 tmp]# ls p20299013_112040_Linux-x86-64.zip
[root@swdbn1 tmp]# mv p20299013_112040_Linux-x86-64.zip patch [root@swdbn1 tmp]# cd patch [root@swdbn1 patch]# chown -R oracle:oinstall p20299013_112040_Linux-x86-64.zip [root@swdbn1 patch]# chmod 777 p20299013_112040_Linux-x86-64.zip [oracle@swdbn1 patch]$ mkdir p20299013 [oracle@swdbn1 patch]$ unzip p20299013_112040_Linux-x86-64.zip -d p20299013
[oracle@swdbn1 patch]$ cd p20299013 [oracle@swdbn1 p20299013]$ ls 20299013 PatchSearch.xml
[oracle@swdbn1 p20299013]$ cd 20299013/
[oracle@swdbn1 20299013]$ ls 17478514 18031668 18522509 19121551 19769489 20299013 patchmd.xml README.html README.txt
[oracle@swdbn1 20299013]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 11.2.0.3.23 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/11.2.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc OPatch version : 11.2.0.3.23 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-04-21_12-13-30PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
Note:
In case if you get any patch conflict occur, try to rollback & re-issue the prereq command & hence its has to passed
START APPLYING THE PATCH
[oracle@swdbn1 20299013]$ cd /tmp/patch/p20299013/20299013/
[oracle@swdbn1 20299013]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply Oracle Interim Patch Installer version 11.2.0.3.23 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc OPatch version : 11.2.0.3.23 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-04-21_12-23-10PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 17478514 18031668 18522509 19121551 19769489 20299013 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 = '/u01/app/oracle/product/11.2.0/db_1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying sub-patch '17478514' to OH '/u01/app/oracle/product/11.2.0/db_1' Patching component oracle.rdbms, 11.2.0.4.0... Patching component oracle.rdbms.rsf, 11.2.0.4.0... Patching component oracle.sdo, 11.2.0.4.0... Patching component oracle.sysman.agent, 10.2.0.4.5... Patching component oracle.xdk, 11.2.0.4.0... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0... Patching component oracle.sdo.locator, 11.2.0.4.0... Patching component oracle.nlsrtl.rsf, 11.2.0.4.0... Patching component oracle.xdk.rsf, 11.2.0.4.0... Patching component oracle.rdbms.rman, 11.2.0.4.0... Applying sub-patch '18031668' to OH '/u01/app/oracle/product/11.2.0/db_1' Patching component oracle.rdbms, 11.2.0.4.0... Patching component oracle.rdbms.rsf, 11.2.0.4.0... Patching component oracle.ldap.rsf, 11.2.0.4.0... Patching component oracle.rdbms.crs, 11.2.0.4.0... Patching component oracle.precomp.common, 11.2.0.4.0... Patching component oracle.ldap.rsf.ic, 11.2.0.4.0... Patching component oracle.rdbms.deconfig, 11.2.0.4.0... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0... atching component oracle.rdbms.rman, 11.2.0.4.0... pplying sub-patch '18522509' to OH '/u01/app/oracle/product/11.2.0/db_1' Patching component oracle.rdbms.rsf, 11.2.0.4.0... Patching component oracle.rdbms, 11.2.0.4.0... Patching component oracle.precomp.common, 11.2.0.4.0... Patching component oracle.rdbms.rman, 11.2.0.4.0... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0... Patching component oracle.rdbms.deconfig, 11.2.0.4.0... Applying sub-patch '19121551' to OH '/u01/app/oracle/product/11.2.0/db_1' Patching component oracle.precomp.common, 11.2.0.4.0... Patching component oracle.sysman.console.db, 11.2.0.4.0... Patching component oracle.rdbms.rsf, 11.2.0.4.0... Patching component oracle.rdbms.rman, 11.2.0.4.0... Patching component oracle.rdbms, 11.2.0.4.0... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0... Patching component oracle.ordim.client, 11.2.0.4.0... Patching component oracle.ordim.jai, 11.2.0.4.0... Applying sub-patch '19769489' to OH '/u01/app/oracle/product/11.2.0/db_1' ApplySession: Optional component(s) [ oracle.sysman.agent, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.precomp.common, 11.2.0.4.0... Patching component oracle.ovm, 11.2.0.4.0... Patching component oracle.xdk, 11.2.0.4.0... atching component oracle.rdbms.util, 11.2.0.4.0... Patching component oracle.rdbms, 11.2.0.4.0... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0... Patching component oracle.xdk.parser.java, 11.2.0.4.0... atching component oracle.oraolap, 11.2.0.4.0... Patching component oracle.rdbms.rsf, 11.2.0.4.0... Patching component oracle.xdk.rsf, 11.2.0.4.0... Patching component oracle.rdbms.rman, 11.2.0.4.0... Patching component oracle.rdbms.deconfig, 11.2.0.4.0... Applying sub-patch '20299013' to OH '/u01/app/oracle/product/11.2.0/db_1' Patching component oracle.rdbms.dv, 11.2.0.4.0... Patching component oracle.rdbms.oci, 11.2.0.4.0... Patching component oracle.precomp.common, 11.2.0.4.0... Patching component oracle.sysman.agent, 10.2.0.4.5... Patching component oracle.xdk, 11.2.0.4.0... Patching component oracle.sysman.common, 10.2.0.4.5... Patching component oracle.rdbms, 11.2.0.4.0... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0... Patching component oracle.xdk.parser.java, 11.2.0.4.0... Patching component oracle.sysman.console.db, 11.2.0.4.0... Patching component oracle.xdk.rsf, 11.2.0.4.0... Patching component oracle.rdbms.rsf, 11.2.0.4.0... Patching component oracle.sysman.common.core, 10.2.0.4.5... Patching component oracle.rdbms.rman, 11.2.0.4.0... Patching component oracle.rdbms.deconfig, 11.2.0.4.0... Composite patch 20299013 successfully applied. Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-04-21_12-23-10PM_1.log OPatch succeeded.
VERIFY THE APPLIED PATCH
[oracle@swdbn1 20299013]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.23 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc OPatch version : 11.2.0.3.23 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-04-21_12-25-08PM_1.log Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2020-04-21_12-25-08PM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: swdbn1 ARU platform id: 226 ARU platform description:: Linux x86-64 Installed Top-level Products (1): Oracle Database 11g 11.2.0.4.0 There are 1 products installed in this Oracle Home. Interim patches (2) : Patch 20299013 : applied on Tue Apr 21 12:23:42 IRDT 2020 Unique Patch ID: 18573940 Patch description: "Database Patch Set Update : 11.2.0.4.6 (20299013)" Created on 4 Mar 2015, 02:27:44 hrs PST8PDT Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)" Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)" Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)" Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)" Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)" Bugs fixed: 17343514, 18139690, 18277454, 18619917, 19271443, 19309466, 18681862 16992075, 18384391, 17186905, 18189036, 13609098, 17811438, 16285691 18554871, 17025461, 17215560, 16875449, 18430495, 17274537, 17602269 17184721, 17323222, 16472716, 19289642, 14829250, 17762296, 18508861 19466309, 19915271, 16929165, 14602788, 14458214, 17811429, 18441944 18331850, 17945983, 13498382, 17754782, 17752121, 17811789, 20074391 16494615, 16901385, 14852021, 17705023, 13645875, 17201159, 18673304 17610798, 16668584, 18456514, 17786278, 8322815, 18996843, 16198143 18828868, 17586955, 17313525, 17050888, 17174582, 18317531, 16692232 11733603, 17798953, 17649265, 14015842, 16384983, 18031668, 17390160 18316692, 19121551, 17570240, 17957017, 19458377, 14368995, 17787259 19788842, 12905058, 16855292, 16579084, 15990359, 18094246, 13364795 14338435, 13944971, 18235390, 18293054, 18673325, 17375354, 20142975 19393542, 14657740, 17936109, 17393683, 17156148, 17389192, 16315398 17783588, 17852463, 17037130, 19358317, 17441661, 17284817, 14034426 18762750, 20631274, 17891946, 17588480, 16450169, 17478145, 18096714 17238511, 16731148, 17311728, 17648596, 17165204, 18244962, 17891943 17308789, 18282562, 17265217, 17465741, 18674047, 14084247, 18191164 18280813, 16721594, 17614227, 18614015, 19827973, 17348614, 19769489 17006183, 17346671, 18092127, 18482502, 19727057, 16043574, 17205719 17922254, 17360606, 13837378, 19211724, 18084625, 17912217, 11883252 19463893, 12982566, 17477958, 17040764, 14764829, 19463897, 18362222 15861775, 17853456, 13853126, 18273830, 17816865, 13558557, 17237521 16934803, 17951233, 17848897, 18180390, 17040527, 14692762, 17027426 19554106, 17851160, 18199537, 16613964, 16870214, 18009564, 18202441 18334586, 17288409, 17341326, 17622427, 17449815, 18091059, 16903536 19006849, 17299889, 20506699, 15913355, 17865671, 17883081, 16228604 16399083, 17761775, 16306373, 17325413, 17546761, 17082359, 12747740 16091637, 14565184, 19680952, 18155762, 17614134, 16850630, 17468141 17694209, 17877323, 18230522, 16956380, 17446237, 19854503, 14245531 16194160, 15979965, 17889549, 18325460, 16042673, 17437634, 17571039 19049453, 18247991, 16314254, 19972570, 16912439, 17655634, 17246576 17016369, 16833527, 18203835, 17297939, 18203838, 16069901, 20506715 18973907, 18203837, 19615136, 17587063, 18522509, 14285317, 18000422 19972569, 18436647, 19972568, 18641451, 17716305, 20506706, 19972566 19972564, 17397545, 17394950, 17853498, 16785708, 16542886, 17006570 17752995, 17296856, 18051556, 12364061, 18641461, 17546973, 18262334 17346091, 13829543, 16220077, 18061914, 18783224, 18674024, 17227277 18018515, 16180763, 16943711, 17596908, 17982555, 17036973, 18098207 17612828, 18436307, 19584068, 17892268, 18339044, 17282229, 17767676 17232014, 14054676, 17501491, 12611721, 14354737, 18356166, 18228645 17071721, 17835048, 19013183, 18856999, 16863422, 17721717, 17239687 17267114, 17082983, 18471685, 17258090, 18641419, 16392068, 16344544 18744139, 17344412, 16618694, 14133975, 17011832, 14010183, 16595641 18135678, 17080436, 17332800, 18704244, 17786518, 20299015, 17242746 18264060, 13866822, 18673342, 17600719, 19197175, 17842825, 17390431 17835627, 17672719, 17088068, 17393915, 16777840, 17811456, 18765602 9756271, 19730508, 17385178, 16571443, 10136473, 18328509, 20296213 13955826, 18384537, 18607546, 18193833, 16422541, 17545847, 16837842 18306996, 18315328, 17443671, 18964939, 17478514, 16268425, 16360112 17381384, 17726838, 17811447, 18554763, 18723434, 17235750, 17571306 17302277, 12816846, 17889583, 19544839, 17551709, 17634921, 18747196 17042658, 18868646, 17824637, 16538760, 14106803, 16524926, 13951456 Patch 19282021 : applied on Tue Apr 21 11:55:10 IRDT 2020 Unique Patch ID: 18156526 Patch description: "ORACLE JAVAVM COMPONENT 11.2.0.4.1 DATABASE PSU (OCT2014)" Created on 13 Oct 2014, 09:16:25 hrs PST8PDT Bugs fixed: 19006757, 19007266, 19153980, 19554117, 17201047, 19058059, 19231857 17285560, 18458318, 17056813, 18933818, 18166577, 14774730, 19223010 -------------------------------------------------------------------------------- OPatch succeeded.
THIRT PATCH APPLY
p17217593_112040_Linux-x86-64.zip
[root@swdbn1 tmp]# ls p17217593_112040_Linux-x86-64.zip
[root@swdbn1 tmp]# mv p17217593_112040_Linux-x86-64.zip patch [root@swdbn1 patch]# mkdir p17217593 [root@swdbn1 patch]# chown -R oracle:oinstall p17217593
[root@swdbn1 patch]# unzip p17217593_112040_Linux-x86-64.zip -d p17217593 Archive: p17217593_112040_Linux-x86-64.zip creating: p17217593/17217593/ inflating: p17217593/17217593/README.txt creating: p17217593/17217593/files/ creating: p17217593/17217593/files/lib/ creating: p17217593/17217593/files/lib/libserver11.a/ inflating: p17217593/17217593/files/lib/libserver11.a/ktur.o creating: p17217593/17217593/etc/ creating: p17217593/17217593/etc/config/ inflating: p17217593/17217593/etc/config/inventory.xml inflating: p17217593/17217593/etc/config/deploy.xml inflating: p17217593/17217593/etc/config/actions.xml creating: p17217593/17217593/etc/xml/ inflating: p17217593/17217593/etc/xml/GenericActions.xml inflating: p17217593/17217593/etc/xml/ShiphomeDirectoryStructure.xml creating: p17217593/17217593/online/ creating: p17217593/17217593/online/files/ creating: p17217593/17217593/online/files/hpatch/ inflating: p17217593/17217593/online/files/hpatch/bug17217593.pch creating: p17217593/17217593/online/etc/ creating: p17217593/17217593/online/etc/config/ inflating: p17217593/17217593/online/etc/config/actions.xml inflating: p17217593/17217593/online/etc/config/deploy.xml inflating: p17217593/17217593/online/etc/config/inventory.xml creating: p17217593/17217593/online/etc/xml/ inflating: p17217593/17217593/online/etc/xml/ShiphomeDirectoryStructure.xml inflating: p17217593/17217593/online/etc/xml/GenericActions.xml inflating: p17217593/PatchSearch.xml
[root@swdbn1 ~]# su – oracle
[oracle@swdbn1 ~]$ cd /tmp/patch/p17217593/17217593/
[oracle@swdbn1 17217593]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 11.2.0.3.23 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/11.2.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc OPatch version : 11.2.0.3.23 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-04-21_12-49-46PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
NOW APPLY THE PATCH
[oracle@swdbn1 17217593]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply Oracle Interim Patch Installer version 11.2.0.3.23 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc OPatch version : 11.2.0.3.23 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-04-21_12-51-46PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 17217593 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 = '/u01/app/oracle/product/11.2.0/db_1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '17217593' to OH '/u01/app/oracle/product/11.2.0/db_1' Patching component oracle.rdbms, 11.2.0.4.0... Patch 17217593 successfully applied. Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-04-21_12-51-46PM_1.log OPatch succeeded.
VERIFY THE PATCH APPLIED
[oracle@swdbn1 17217593]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.23 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc OPatch version : 11.2.0.3.23 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-04-21_12-52-17PM_1.log Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2020-04-21_12-52-17PM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: swdbn1 ARU platform id: 226 ARU platform description:: Linux x86-64 Installed Top-level Products (1): Oracle Database 11g 11.2.0.4.0 There are 1 products installed in this Oracle Home. Interim patches (3) : Patch 17217593 : applied on Tue Apr 21 12:51:52 IRDT 2020 unique Patch ID: 17735525 Created on 9 Jun 2014, 12:17:27 hrs PST8PDT Bugs fixed: 17217593
Note:
Again this patch also should be applied on another NODE
POST INSTALLATION ON ANY ONE OF THE NODE
[oracle@swdbn1 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/sqlpatch/19282021/
[oracle@swdbn1 19282021]$ sqlplus /nolog SQL*Plus: Release 11.2.0.4.0 Production on Tue Apr 21 13:19:48 2020 Copyright (c) 1982, 2013, Oracle. All rights reserved. SQL> connect / as sysdba Connected.
SQL> @postinstall.sql; Session altered. PL/SQL procedure successfully completed. Package created. Package body created. grant execute on sqljutl to public * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database open for read-only access PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. JVMRMACTION -------------------------------------------------------------------------------- FULL_REMOVAL begin if :jvmrmaction = 'FULL_REMOVAL' or ERROR at line 1: ORA-16000: database open for read-only access ORA-06512: at "SYS.INITJVMAUX", line 32 ORA-06512: at line 5 Package created. Package created. Package created. create or replace package dbms_java_misc authid current_user as * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database open for read-only access create or replace package body dbms_java as * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database open for read-only access CREATE PUBLIC SYNONYM dbms_java FOR dbms_java * RROR at line 1: ORA-00955: name is already used by an existing object GRANT EXECUTE ON dbms_java TO PUBLIC * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database open for read-only access Package body created. Function created. Function created. CREATE PUBLIC SYNONYM "NameFromLastDDL" FOR sys."NameFromLastDDL" * RROR at line 1: ORA-00955: name is already used by an existing object GRANT EXECUTE ON "NameFromLastDDL" TO PUBLIC * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database open for read-only access Function created. CREATE PUBLIC SYNONYM dbj_short_name FOR dbj_short_name * ERROR at line 1: ORA-00955: name is already used by an existing object GRANT EXECUTE ON dbj_short_name TO PUBLIC * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database open for read-only access ackage body created. RANT EXECUTE ON jvmrjbc TO PUBLIC ERROR at line 1: RA-00604: error occurred at recursive SQL level 1 RA-16000: database open for read-only access create or replace package body dbms_java_misc as * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database open for read-only access PL/SQL procedure successfully completed. SQL> SET FEEDBACK 1 SQL> SET NUMWIDTH 10 SQL> SET LINESIZE 80 SQL> SET TRIMSPOOL ON SQL> SET TAB OFF SQL> SET PAGESIZE 100 SQL> SQL> -- do CJS, etc. SQL> SQL> BEGIN 2 3 initjvmaux.drop_sros(); 4 5 EXECUTE IMMEDIATE 'create or replace java system'; 6 7 update dependency$ 8 set p_timestamp=(select stime from obj$ where obj#=p_obj#) 9 where (select stime from obj$ where obj#=p_obj#)!=p_timestamp and 10 (select type# from obj$ where obj#=p_obj#)=29 and 11 (select owner# from obj$ where obj#=p_obj#)=0; 12 13 -- Check the validity of JAVAVM and let the registry be updated accordingly. 14 15 initjvmaux.validate_javavm; 16 17 -- Add a row in registry$history to indicate this script was run. 18 19 EXECUTE IMMEDIATE 'insert into registry$history 20 (action_time, action, namespace, version, id, comments) 21 values(SYSTIMESTAMP, ''jvmpsu.sql'', ''SERVER'', 22 ''11.2.0.4.1OJVMBP'', 0, ''APPLIED jvmpsu.sql'')'; 23 24 END; 25 / BEGIN * ERROR at line 1: ORA-16000: database open for read-only access ORA-06512: at "SYS.INITJVMAUX", line 535 ORA-06512: at line 3
QL> commit; Commit complete.
SQL> begin 2 execute immediate 'drop package SYS.sqljutl2'; 3 exception when others 4 then null; 5 end; 6 / PL/SQL procedure successfully completed.
SQL> ALTER SESSION SET CURRENT_SCHEMA = SYS; Session altered.
RUN ANOTHER SCRIPT
[oracle@swdbn1 19282021]$ cd /u01/app/oracle/product/11.2.0/db_1/rdbms/admin/
[oracle@swdbn1 admin]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Tue Apr 21 13:21:45 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SELECT dbms_registry_sys.time_stamp('utlrp_bgn') as timestamp from dual
*
ERROR at line 1:
ORA-16000: database open for read-only access
ORA-06512: at "SYS.DBMS_REGISTRY_SYS", line 619
DOC> The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC> objects in the database. Recompilation time is proportional to the
DOC> number of invalid objects in the database, so this command may take
DOC> a long time to execute on a database with a large number of invalid
DOC> objects.
DOC>
DOC> Use the following queries to track recompilation progress:
DOC>
OC> 1. Query returning the number of invalid objects remaining. This
OC> number should decrease with time.
DOC> SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC> 2. Query returning the number of objects compiled so far. This number
DOC> should increase with time.
DOC> SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC> This script automatically chooses serial or parallel recompilation
DOC> based on the number of CPUs available (parameter cpu_count) multiplied
DOC> by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC> On RAC, this number is added across all RAC nodes.
DOC>
DOC> UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC> recompilation. Jobs are created without instance affinity so that they
DOC> can migrate across RAC nodes. Use the following queries to verify
DOC> whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC> 1. Query showing jobs created by UTL_RECOMP
DOC> SELECT job_name FROM dba_scheduler_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC> 2. Query showing UTL_RECOMP jobs that are running
DOC> SELECT job_name FROM dba_scheduler_running_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#
DECLARE
*
ERROR at line 1:
ORA-16000: database open for read-only access
ORA-06512: at "SYS.UTL_RECOMP", line 865
ORA-06512: at line 4
SELECT dbms_registry_sys.time_stamp('utlrp_end') as timestamp from dual
*
ERROR at line 1:
ORA-16000: database open for read-only access
ORA-06512: at "SYS.DBMS_REGISTRY_SYS", line 619
DOC> The following query reports the number of objects that have compiled
DOC> with errors.
DOC>
DOC> If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
OC>#
OBJECTS WITH ERRORS
-------------------
0
DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#
ERRORS DURING RECOMPILATION
---------------------------
0
CREATE OR REPLACE FUNCTION local_enquote_name (str varchar2)
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access
PL/SQL procedure successfully completed.
DROP function local_enquote_name
*
ERROR at line 1:
ORA-16000: database open for read-only access
Warning: XDB now invalid, could not find xdbconfig
PL/SQL procedure successfully completed.
==SO FAR PATCHS ARE APPLIED ON BOTH THE NODES==
NOW BRING UP THE CRS,DATABASE.
Login as root & go to grid bin
[root@swdbn1 ~]# cd /u01/app/11.2.0/grid/bin/
START THE CRS
[root@swdbn1 bin]# ./crsctl start crs CRS-4123: Oracle High Availability Services has been started.
Note:
Wait for approximate 10 mins to completely start the CRS & DB automatically. In-case of any one of the node database is not up, bring up the database, In our case NODE 122 DB was not up, we manually issued the srvctl command to start.
[oracle@swdbn2 ~]$ srvctl start instance -d pspswi -i pspswi2
VERIFY THE DATABASE
[root@swdbn1 bin]# ./crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online
[root@swdbn2 bin]# ./crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online
[root@swdbn1 bin]# ./crsctl stat res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.ARCH.dg ONLINE ONLINE swdbn1 ONLINE ONLINE swdbn2 ora.BKP.dg OFFLINE OFFLINE swdbn1 OFFLINE OFFLINE swdbn2 ora.CLUSTERDG.dg ONLINE ONLINE swdbn1 ONLINE ONLINE swdbn2 ora.LISTENER.lsnr ONLINE ONLINE swdbn1 ONLINE ONLINE swdbn2 ora.ORADATA.dg ONLINE ONLINE swdbn1 ONLINE ONLINE swdbn2 ora.ORL.dg ONLINE ONLINE swdbn1 ONLINE ONLINE swdbn2 ora.asm ONLINE ONLINE swdbn1 Started ONLINE ONLINE swdbn2 Started ora.gsd OFFLINE OFFLINE swdbn1 OFFLINE OFFLINE swdbn2 ora.net1.network ONLINE ONLINE swdbn1 ONLINE ONLINE swdbn2 ora.ons ONLINE ONLINE swdbn1 ONLINE ONLINE swdbn2 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE swdbn1 ora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE swdbn2 ora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE swdbn2 ora.cvu 1 ONLINE ONLINE swdbn2 ora.oc4j 1 ONLINE ONLINE swdbn2 ora.pspswi.db 1 ONLINE ONLINE swdbn1 Open 2 ONLINE ONLINE swdbn2 Open ora.scan1.vip 1 ONLINE ONLINE swdbn1 ora.scan2.vip 1 ONLINE ONLINE swdbn2 ora.scan3.vip 1 ONLINE ONLINE swdbn2 ora.swdbn1.vip 1 ONLINE ONLINE swdbn1 ora.swdbn2.vip 1 ONLINE ONLINE swdbn2
Check the database status
[oracle@swdbn2 ~]$ srvctl status database -d pspswi Instance pspswi1 is running on node swdbn1 Instance pspswi2 is running on node swdbn2
[oracle@swdbn2 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Tue Apr 21 14:52:37 2020 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> select status from V$instance; STATUS ------ OPEN
[oracle@swdbn2 ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 21-APR-2020 14:52:56 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 21-APR-2020 09:43:37 Uptime 0 days 1 hr. 39 min. 18 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/swdbn2/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.108.0.122)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.108.0.124)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM2", status READY, has 1 handler(s) for this service... Service "PSPSWI4" has 1 instance(s). Instance "pspswi2", status READY, has 1 handler(s) for this service... Service "pspswiXDB" has 1 instance(s). Instance "pspswi2", status READY, has 1 handler(s) for this service... The command completed successfully