DBA Hub

📋Steps in this guide1/2

Oracle RAC 12C to 19C ASM Upgradation

PREREQUISITE FOR UPGRADE:

oracle configurationintermediate
by OracleDba
13 views
1

Overview

PREREQUISITE FOR UPGRADE: - Apply required patches on grid home and oracle home. To apply patch on RAC Database , refer this blog : https://learnomate.org/rac-19c-patching/

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
mkdir -p /u02/app/grid/product/19C/dbhome

chown -R grid:oinstall /u02

chmod -R 775 /u02

cd u02/app/grid/product/19C/dbhome

Unzip LINUX.X64_193000_grid_home.zip-------------------------on Node 1

su - grid
cd  /u02/app/grid/product/19C/dbhome -- 19c grid home 
./runcluvfy.sh stage -pre crsinst -upgrade -rolling -src_crshome /u02/app/grid/product/12C/dbhome -dest_crshome p /u02/app/grid/product/19C/dbhome -dest_version 19.3.0.0.0 -fixup –verbose

cd  /u02/app/grid/product/19C/dbhome
gridsetup.sh –dryRunForUpgrade
2

Section 2

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
unset ORACLE_BASE
unset ORACLE_HOME
unset ORACLE_SID

Su root

root# /u02/app/grid/product/12C/dbhome/crs/install/rootcrs.sh –unlock –crshome /u02/app/grid/product/19C/dbhome

cd  /u02/app/grid/product/19C/dbhome
./gridSetup.sh

$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [19.0.0.0.0]
$ crsctl query crs softwareversion
Oracle Clusterware version on node [dc-vt-testdb1] is [19.0.0.0.0]
$  crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [19.0.0.0.0]
$ crsctl query crs softwareversion
Oracle Clusterware version on node [node2] is [19.0.0.0.0]

$ 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
$ crsctl stat res -t -init
$ crsctl stat res -t

# vi .bash_profile
export ORACLE_HOME=/u02/app/grid/product/19C/dbhome
execute bash_profile from the grid user
. .bash_profile

Comments (0)

Please to add comments

No comments yet. Be the first to comment!