Hello Friends,
This post we will discuss How to apply Merge Patch on RAC database
Note : This steps is only for Patch : p34932268_1918000DBRU
Bug fixed in patch :
The following are the bugs fixed by this patch:
34286265: SAGEASM-E HIT ORA 800 [SET PRIORITY FAILED] WHEN STARTING LMS BACKGROUND PROCESS
34318125: ORA-00800: SOFT EXTERNAL ERROR, ARGUMENTS: [SET PRIORITY FAILED] ON BG PROCESSES
Unzip the Patch :
[root@dm01db01 tmp]# unzip --q p34932268_1918000DBRU_Linux-x86-64.zip
Archive: p34932268_1918000DBRU_Linux-x86-64.zip
creating: 34932268/
creating: 34932268/files/
creating: 34932268/files/lib/
creating: 34932268/files/lib/libgeneric19.a/
inflating: 34932268/files/lib/libgeneric19.a/skgnfs.o
inflating: 34932268/files/lib/libgeneric19.a/sskgm.o
inflating: 34932268/files/lib/libgeneric19.a/skgfr.o
inflating: 34932268/files/lib/libgeneric19.a/kgpcs.o
inflating: 34932268/files/lib/libgeneric19.a/dbnest_ns.o
inflating: 34932268/files/lib/libgeneric19.a/dbnest_res.o
inflating: 34932268/files/lib/libgeneric19.a/kgcs.o
inflating: 34932268/files/lib/libgeneric19.a/skgdism.o
inflating: 34932268/files/lib/libgeneric19.a/kgnfs.o
creating: 34932268/files/lib/libserver19.a/
inflating: 34932268/files/lib/libserver19.a/skofs.o
inflating: 34932268/files/lib/libserver19.a/sp.o
inflating: 34932268/files/lib/libserver19.a/ksns.o
creating: 34932268/files/rdbms/
creating: 34932268/files/rdbms/lib/
inflating: 34932268/files/rdbms/lib/soradism.o
creating: 34932268/files/bin/
inflating: 34932268/files/bin/oradism
creating: 34932268/etc/
creating: 34932268/etc/config/
inflating: 34932268/etc/config/inventory.xml
inflating: 34932268/etc/config/actions.xml
inflating: 34932268/README.txt
inflating: PatchSearch.xml
Step 1 : change ownership and permission of oradism
[root@dm01db01 ~]# ls -ltr /u02/app/oracle/product/19.0.0.0/dbhome_1/bin/oradism
-rwsr-x--- 1 root oinstall 147848 Apr 17 2019 /u02/app/oracle/product/19.0.0.0/dbhome_1/bin/oradism
[root@dm01db01 ~]#
[root@dm01db01 ~]# chown oracle /u02/app/oracle/product/19.0.0.0/dbhome_1/bin/oradism
[root@dm01db01 ~]#
[root@dm01db01 ~]# chmod 0750 /u02/app/oracle/product/19.0.0.0/dbhome_1/bin/oradism
[root@dm01db01 ~]#
[root@dm01db01 ~]#
[root@dm01db01 ~]# ls -ltr /u02/app/oracle/product/19.0.0.0/dbhome_1/bin/oradism
-rwxr-x--- 1 oracle oinstall 147848 Apr 17 2019 /u02/app/oracle/product/19.0.0.0/dbhome_1/bin/oradism
[root@dm01db01 ~]#
Step 2 : Stop the Instance on Node 1
srvctl stop instance -d CDBFINDB -n dm01db01
[oracle@dm01db01 admin]$ srvctl status database -d CDBFINDB_2
Instance CDBFINDB1 is not running on node dm01db01
Instance CDBFINDB2 is running on node dm01db02
Step 3 : Apply the patch on node 1
/u02/app/oracle/product/19.0.0.0/dbhome_1/OPatch/opatch apply -oh /u02/app/oracle/product/19.0.0.0/dbhome_1 -local /tmp/34932268
[oracle@dm01db01 admin]$ /u02/app/oracle/product/19.0.0.0/dbhome_1/OPatch/opatch apply -oh /u02/app/oracle/product/19.0.0.0/dbhome_1 -local /tmp/34932268
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /u02/app/oracle/product/19.0.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u02/app/oracle/product/19.0.0.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u02/app/oracle/product/19.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2023-03-10_20-18-39PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 34932268
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 = '/u02/app/oracle/product/19.0.0.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '34932268' to OH '/u02/app/oracle/product/19.0.0.0/dbhome_1'
Patching component oracle.rdbms.rsf, 19.0.0.0.0...
Patching component oracle.rdbms, 19.0.0.0.0...
Patch 34932268 successfully applied.
Log file location: /u02/app/oracle/product/19.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2023-03-10_20-18-39PM_1.log
OPatch succeeded.
Step 4 : Start the instance on node 1
[oracle@dm01db01 34783802]$ srvctl start instance -d CDBFINDB_2 -n dm01db01
[oracle@dm01db01 34783802]$
[oracle@dm01db01 34783802]$ srvctl status database -d CDBFINDB_2
Instance CDBFINDB1 is running on node dm01db01
Instance CDBFINDB2 is running on node dm01db02
Step 5 : change ownership and permission of oradism back to root
[root@dm01db01 tmp]# ls -ltr /u02/app/oracle/product/19.0.0.0/dbhome_1/bin/oradism
-rwxr-x--- 1 oracle oinstall 145848 Dec 29 21:42 /u02/app/oracle/product/19.0.0.0/dbhome_1/bin/oradism
[root@dm01db01 tmp]#
[root@dm01db01 tmp]# chown root /u02/app/oracle/product/19.0.0.0/dbhome_1/bin/oradism
[root@dm01db01 tmp]#
[root@dm01db01 tmp]# chmod 4750 /u02/app/oracle/product/19.0.0.0/dbhome_1/bin/oradism
[root@dm01db01 tmp]#
[root@dm01db01 tmp]# ls -ld /u02/app/oracle/product/19.0.0.0/dbhome_1/bin/oradism
-rwsr-x--- 1 root oinstall 145848 Dec 29 21:42 /u02/app/oracle/product/19.0.0.0/dbhome_1/bin/oradism
Step 6 : confirm the apply, no need to datapatch in this
[oracle@dm01db01 ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH
[oracle@dm01db01 ~]$ opatch lspatches
35122166;MERGE ON DATABASE RU 19.18.0.0.0 OF 32727143 33726590 33899867 34049216 34132182
34783802;PARALLEL QUERY ON PARTITIONED TABLE RETURNS WRONG RESULT
34932268;MERGE ON DATABASE RU 19.18.0.0.0 OF 34649727
34835593;REFERENCE BUG 34792490 - SCHEDULER LAYER CHANGES TO AVOID CYCLIC DEPENDENCY ON DBMS_AQADM_SYS PACKAGE
34792490;FADBRWT STRESS FA ORA-00060 DEADLOCK DETECTED DURING DATAPATCH
34699616;DSTV40 UPDATE - TZDATA2022E - NEED OJVM FIX
34777391;JDK BUNDLE PATCH 19.0.0.0.230117
34786990;OJVM RELEASE UPDATE: 19.18.0.0.230117 (34786990)
34768559;OCW RELEASE UPDATE 19.18.0.0.0 (34768559)
34765931;DATABASE RELEASE UPDATE : 19.18.0.0.230117 (REL-JAN230131) (34765931)
OPatch succeeded.
Note Patching completed on node 1 :
Start Patching on node 2 . Follow the same steps for node 2 and run data patch
To deinstall patch
Deinstall the patch from DB home(s) as DB home owner :
$ /u02/app/oracle/product/19.0.0.0/dbhome_1/OPatch/opatch rollback -local -id 34932268 -oh /u02/app/oracle/product/19.0.0.0/dbhome_1
ConversionConversion EmoticonEmoticon