This article explains the steps to upgrade Oracle Database RAC 2 nodes with CDB mode enabled from 19.3 to 19.9
The Patch is 31750108 – Database Release Update 19.9.0.0.201020
Patch Number:
- 31771877: Database Release Update 19.9.0.0.201020
- 31772784 OCW Release Update 19.9.0.0.201020
The steps:
- Upgrade the Oracle Clusterware GI from 19.3 to 19.9
- Upgrade the Opatch of the Oracle Home
- Apply patches on node 1
- Apply Patches on node 2
- Apply data patches
- Check the patches
What we have:
- Oracle Linux 8u2
- Oracle Cluster ware 2 nodes 19.3
Step 1: Upgrade the Oracle Clusterware GI from 19.3 to 19.9
Step 2: Upgrade the Opatch of the Oracle Home, just unzip in the ORACLE_HOME
Step 3: Apply patches on node 1
$ unzip p31750108_190000_Linux-x86-64.zip
$ cd 31750108/
$ cd 31771877
$ /u01/app/oracle/product/19c/dbhome_1/OPatch/opatch version
$ cd 31772784
$ /u01/app/oracle/product/19c/dbhome_1/OPatch/opatch version
Step 4: Check patches
$ /u01/app/oracle/product/19c/dbhome_1/OPatch/opatch lspatches
31772784;OCW RELEASE UPDATE 19.9.0.0.0 (31772784)
31771877;Database Release Update : 19.9.0.0.201020 (31771877)
OPatch succeeded.
Step 5: Repeat the same on node 2
Step 6: Upgrade Data dictionary
Execute the command datapatch
Step 7: Check registry
CON_ID COMP_NAME VERSION VERSION_FULL
1 JServer JAVA Virtual Machine 19.0.0.0.0 19.9.0.0.0
1 OLAP Analytic Workspace 19.0.0.0.0 19.9.0.0.0
1 Oracle Database Catalog Views 19.0.0.0.0 19.9.0.0.0
1 Oracle Database Java Packages 19.0.0.0.0 19.9.0.0.0
1 Oracle Database Packages and Types 19.0.0.0.0 19.9.0.0.0
1 Oracle Database Vault 19.0.0.0.0 19.9.0.0.0
1 Oracle Label Security 19.0.0.0.0 19.9.0.0.0
1 Oracle Multimedia 19.0.0.0.0 19.9.0.0.0
1 Oracle OLAP API 19.0.0.0.0 19.9.0.0.0
1 Oracle Real Application Clusters 19.0.0.0.0 19.9.0.0.0
1 Oracle Text 19.0.0.0.0 19.9.0.0.0
1 Oracle Workspace Manager 19.0.0.0.0 19.9.0.0.0
1 Oracle XDK 19.0.0.0.0 19.9.0.0.0
1 Oracle XML Database 19.0.0.0.0 19.9.0.0.0
1 Spatial 19.0.0.0.0 19.9.0.0.0
3 JServer JAVA Virtual Machine 19.0.0.0.0 19.9.0.0.0
3 OLAP Analytic Workspace 19.0.0.0.0 19.9.0.0.0
3 Oracle Database Catalog Views 19.0.0.0.0 19.9.0.0.0
3 Oracle Database Java Packages 19.0.0.0.0 19.9.0.0.0
3 Oracle Database Packages and Types 19.0.0.0.0 19.9.0.0.0
3 Oracle Database Vault 19.0.0.0.0 19.9.0.0.0
3 Oracle Label Security 19.0.0.0.0 19.9.0.0.0
3 Oracle Multimedia 19.0.0.0.0 19.9.0.0.0
3 Oracle OLAP API 19.0.0.0.0 19.9.0.0.0
3 Oracle Real Application Clusters 19.0.0.0.0 19.9.0.0.0
3 Oracle Text 19.0.0.0.0 19.9.0.0.0
3 Oracle Workspace Manager 19.0.0.0.0 19.9.0.0.0
3 Oracle XDK 19.0.0.0.0 19.9.0.0.0
3 Oracle XML Database 19.0.0.0.0 19.9.0.0.0
3 Spatial 19.0.0.0.0 19.9.0.0.0
4 JServer JAVA Virtual Machine 19.0.0.0.0 19.9.0.0.0
4 OLAP Analytic Workspace 19.0.0.0.0 19.9.0.0.0
4 Oracle Database Catalog Views 19.0.0.0.0 19.9.0.0.0
4 Oracle Database Java Packages 19.0.0.0.0 19.9.0.0.0
4 Oracle Database Packages and Types 19.0.0.0.0 19.9.0.0.0
4 Oracle Database Vault 19.0.0.0.0 19.9.0.0.0
4 Oracle Label Security 19.0.0.0.0 19.9.0.0.0
4 Oracle Multimedia 19.0.0.0.0 19.9.0.0.0
4 Oracle OLAP API 19.0.0.0.0 19.9.0.0.0
4 Oracle Real Application Clusters 19.0.0.0.0 19.9.0.0.0
4 Oracle Text 19.0.0.0.0 19.9.0.0.0
4 Oracle Workspace Manager 19.0.0.0.0 19.9.0.0.0
4 Oracle XDK 19.0.0.0.0 19.9.0.0.0
4 Oracle XML Database 19.0.0.0.0 19.9.0.0.0
4 Spatial 19.0.0.0.0 19.9.0.0.0
45 rows selected.
Enjoy
Google+
Facebook
