DBA Hub

📋Steps in this guide1/1

RAC 19C PATCHING

winscp latest patch to /u01/patches and unzip and change opatch version on both GRID HOME and ORACLE HOME

oracle configurationintermediate
by OracleDba
12 views
1

Overview

RAC 19C PATCHING winscp latest patch to /u01/patches and unzip and change opatch version on both GRID HOME and ORACLE HOME Database patching manual Database Patching: ================== 1) Do database prechks @?/rdbms/admin/utlprp.sql 16 2) Run the database post steps 3) Verify the database post steps Here on node2 auto patch command is used so database patch is done automatically

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
[oracle@node1 ~]$ cd /u01/patches/
[oracle@node1 patches]$
[oracle@node1 patches]$
[oracle@node1 patches]$ ls -lrt
total 2682072
drwxr-x---. 15 grid oinstall       4096 Jan  9  2022 OPatch
drwxr-x---.  8 grid oinstall       4096 Jan 13  2022 33509923
-rw-rw-r--.  1 grid oinstall    1478442 Jan 20  2022 PatchSearch.xml
-rw-r--r--.  1 grid oinstall  122883929 Aug  8 20:25 p6880880_122010_Linux-x86-64.zip
-rw-r--r--.  1 grid oinstall 2622069290 Aug  8 20:28 p33509923_190000_Linux-x86-64.zip

[grid@node1 patches]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_old
[oracle@node1 patches]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_old

[oracle@oraclelab1 patches]$ /u01/app/oracle/product/19.0.0.0/dbhome_1/OPatch/opatch version
OPatch Version: 12.2.0.1.29

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patches/33509923/33515361

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patches/33509923/33529556

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patches/33509923/33534448

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patches/33509923/33239955

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patches/33509923/33575402

$ORACLE_HOME/crs/install/rootcrs.sh -prepatch

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local -silent /u01/patches/33509923/33515361
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local -silent /u01/patches/33509923/33529556
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local -silent /u01/patches/33509923/33534448
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local -silent /u01/patches/33509923/33239955
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local -silent /u01/patches/33509923/33575402

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local -silent /u01/patches/33509923/33515361
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local -silent /u01/patches/33509923/33529556

$ORACLE_HOME/crs/install/rootcrs.sh -postpatch

[oracle@node1 OPatch]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Aug 9 01:27:07 2023
Version 19.14.0.0.0

Copyright (c) 1982, 2021, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0

SQL> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ WRITE NO
3 PDBPRIM MOUNTED
4 PDBPRIM2 MOUNTED
SQL>
SQL>
SQL> alter pluggable database all open instances=all;

Pluggable database altered.

exit

cd $ORACLE_HOME/OPatch
nohup ./datapatch -verbose &

[oracle@node1 rdbms]$ cd $ORACLE_HOME/rdbms/admin
[oracle@node1 admin]$
[oracle@node1 admin]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Aug 9 01:34:28 2023
Version 19.14.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0

SQL> @utlrp.sql

set pagesize 1000;
set linesize 1000;
col STATUS for a10;
col ACTION_TIME format a30;
col DESCRIPTION format a55;
select PATCH_ID,status,ACTION_TIME,DESCRIPTION from dba_registry_sqlpatch;

$ORACLE_HOME/OPatch/opatchauto apply /u02/patches/33509923 -oh $ORACLE_HOME

/u01/app/oracle/product/19C/dbhome/OPatch/opatchauto apply /u02/patches/33509923 -oh /u01/app/oracle/product/19C/dbhome

Comments (0)

Please to add comments

No comments yet. Be the first to comment!