RAC Manual Patching Steps On 12c
On NODE.1
1. Stop the database resources from DB home.
[oracle@test01 ~]$ ps -ef|grep pmon
oracle 15294 1 0 00:35 ? 00:00:00 asm_pmon_+ASM1
oracle 18171 1 0 00:39 ? 00:00:00 ora_pmon_RUMPROD1
oracle 19097 9655 0 00:40 pts/2 00:00:00 grep pmon
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
[oracle@test01 ~]$ ps -ef|grep pmon
oracle 15294 1 0 00:35 ? 00:00:00 asm_pmon_+ASM1
oracle 28749 9655 0 01:16 pts/2 00:00:00 grep pmon
2. On GI Home, as the root user or sudo execute below:
[root@test01 install]# ps -ef|grep pmon
oracle 15294 1 0 00:35 ? 00:00:00 asm_pmon_+ASM1
root 29836 6253 0 01:20 pts/1 00:00:00 grep pmon
[root@test01 install]# $ORACLE_HOME/crs/install/rootcrs.pl -prepatch
Using configuration parameter file: /u01/app/12.1.0/grid/crs/install/crsconfig_params
Oracle Clusterware active version on the cluster is [12.1.0.2.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [0].
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'test01'
CRS-2673: Attempting to stop 'ora.crsd' on 'test01'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'test01'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'test01'
CRS-2673: Attempting to stop 'ora.OCR.dg' on 'test01'
CRS-2677: Stop of 'ora.OCR.dg' on 'test01' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'test01'
CRS-2677: Stop of 'ora.asm' on 'test01' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'test01' succeeded
CRS-2673: Attempting to stop 'ora.test01.vip' on 'test01'
CRS-2677: Stop of 'ora.test01.vip' on 'test01' succeeded
CRS-2672: Attempting to start 'ora.test01.vip' on 'test02'
CRS-2676: Start of 'ora.test01.vip' on 'test02' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'test01'
CRS-2677: Stop of 'ora.ons' on 'test01' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'test01'
CRS-2677: Stop of 'ora.net1.network' on 'test01' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'test01' has completed
CRS-2677: Stop of 'ora.crsd' on 'test01' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'test01'
CRS-2673: Attempting to stop 'ora.evmd' on 'test01'
CRS-2673: Attempting to stop 'ora.storage' on 'test01'
CRS-2673: Attempting to stop 'ora.crf' on 'test01'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'test01'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'test01'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'test01'
CRS-2677: Stop of 'ora.storage' on 'test01' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'test01'
CRS-2677: Stop of 'ora.drivers.acfs' on 'test01' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'test01' succeeded
CRS-2677: Stop of 'ora.evmd' on 'test01' succeeded
CRS-2677: Stop of 'ora.crf' on 'test01' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'test01' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'test01' succeeded
CRS-2677: Stop of 'ora.asm' on 'test01' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'test01'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'test01' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'test01'
CRS-2677: Stop of 'ora.cssd' on 'test01' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'test01'
CRS-2677: Stop of 'ora.gipcd' on 'test01' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'test01' has completed
CRS-4133: Oracle High Availability Services has been stopped.
2021/04/14 01:22:01 CLSRSC-4012: Shutting down Oracle Trace File Analyzer (TFA) Collector.
2021/04/14 01:22:37 CLSRSC-4013: Successfully shut down Oracle Trace File Analyzer (TFA) Collector.
2021/04/14 01:22:37 CLSRSC-347: Successfully unlock /u01/app/12.1.0/grid
[root@test01 install]# ps -ef|grep pmon
root 3037 6253 0 01:27 pts/1 00:00:00 grep pmon
3. Check the patch Conflicts
4. Patch GI home [as GI home owner]
Goto patch directory and apply the patch.
opatch apply
5. Run the post script (as the root or sudo user)
[root@test01 install]# $ORACLE_HOME/rdbms/install/rootadd_rdbms.sh
[oracle@test01 ~]$ ps -ef|grep pmon
oracle 21867 9655 0 01:30 pts/2 00:00:00 grep pmon
[root@test01 install]# $ORACLE_HOME/crs/install/rootcrs.pl -postpatch
Using configuration parameter file: /u01/app/12.1.0/grid/crs/install/crsconfig_params
2021/04/14 01:30:33 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.
2021/04/14 01:30:49 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.
CRS-4123: Starting Oracle High Availability Services-managed resources
CRS-2672: Attempting to start 'ora.mdnsd' on 'test01'
CRS-2672: Attempting to start 'ora.evmd' on 'test01'
CRS-2676: Start of 'ora.mdnsd' on 'test01' succeeded
CRS-2676: Start of 'ora.evmd' on 'test01' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'test01'
CRS-2676: Start of 'ora.gpnpd' on 'test01' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'test01'
CRS-2676: Start of 'ora.gipcd' on 'test01' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'test01'
CRS-2676: Start of 'ora.cssdmonitor' on 'test01' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'test01'
CRS-2672: Attempting to start 'ora.diskmon' on 'test01'
CRS-2676: Start of 'ora.diskmon' on 'test01' succeeded
CRS-2676: Start of 'ora.cssd' on 'test01' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'test01'
CRS-2672: Attempting to start 'ora.ctssd' on 'test01'
CRS-2676: Start of 'ora.ctssd' on 'test01' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'test01' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'test01'
CRS-2676: Start of 'ora.asm' on 'test01' succeeded
CRS-2672: Attempting to start 'ora.storage' on 'test01'
CRS-2676: Start of 'ora.storage' on 'test01' succeeded
CRS-2672: Attempting to start 'ora.crf' on 'test01'
CRS-5013: Agent "ORAROOTAGENT" failed to start process "/u01/app/12.1.0/grid/bin/osysmond" for action "start": details at "(:CLSN00008:)" in "/u01/app/oracle/diag/crs/test01/crs/trace/ohasd_orarootagent_root.trc"
CRS-2674: Start of 'ora.crf' on 'test01' failed
CRS-2679: Attempting to clean 'ora.crf' on 'test01'
CRS-2681: Clean of 'ora.crf' on 'test01' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'test01'
CRS-2676: Start of 'ora.crsd' on 'test01' succeeded
CRS-6017: Processing resource auto-start for servers: test01
CRS-2672: Attempting to start 'ora.net1.network' on 'test01'
CRS-2676: Start of 'ora.net1.network' on 'test01' succeeded
CRS-2672: Attempting to start 'ora.ons' on 'test01'
CRS-2673: Attempting to stop 'ora.test01.vip' on 'test02'
CRS-2677: Stop of 'ora.test01.vip' on 'test02' succeeded
CRS-2672: Attempting to start 'ora.test01.vip' on 'test01'
CRS-2676: Start of 'ora.test01.vip' on 'test01' succeeded
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'test01'
CRS-2676: Start of 'ora.ons' on 'test01' succeeded
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'test01' succeeded
CRS-6016: Resource auto-start has completed for server test01
CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
CRS-4123: Oracle High Availability Services has been started.
Oracle Clusterware active version on the cluster is [12.1.0.2.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [0].
PRCC-1010 : _mgmtdb was already enabled
PRCR-1002 : Resource ora.mgmtdb is already enabled
[oracle@test01 ~]$ ps -ef|grep pmon
oracle 1099 9655 0 01:36 pts/2 00:00:00 grep pmon
oracle 1502 1 0 01:32 ? 00:00:00 asm_pmon_+ASM1
6. Start the database resources from DB home.
[oracle@test01 ~]$ ps -ef|grep pmon
oracle 1099 9655 0 01:36 pts/2 00:00:00 grep pmon
oracle 1502 1 0 01:32 ? 00:00:00 asm_pmon_+ASM1
SQL> startup;
ORACLE instance started.
Total System Global Area 754974720 bytes
Fixed Size 2928968 bytes
Variable Size 385879736 bytes
Database Buffers 360710144 bytes
Redo Buffers 5455872 bytes
Database mounted.
Database opened.
[oracle@test01 ~]$ ps -ef|grep pmon
oracle 1502 1 0 01:32 ? 00:00:00 asm_pmon_+ASM1
oracle 16180 1 0 01:37 ? 00:00:00 ora_pmon_RUMPROD1
oracle 19651 19507 0 01:38 pts/2 00:00:00 grep pmon
Perform all the above steps in same manner on NODE.2
Note:
Always read the patch readme to understand the patching instructions, general procedure to apply the database prepatch and postpatch steps.
7. Run the postpatch datapatch apply (In rac only datapatch will be run only one node)
[oracle@test01 ~]$ cd $ORACLE_HOME/OPatch
[oracle@test01 OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.2.0.0.0 on Wed Apr 14 01:41:32 2021
Copyright (c) 2014, Oracle. All rights reserved.
Connecting to database...OK
Determining current state...done
Current state of SQL patches:
Adding patches to installation queue and performing prereq checks...
Installation queue:
Nothing to roll back
Nothing to apply
SQL Patching tool complete on Wed Apr 14 01:43:17 2021
No comments:
Post a Comment