Upgrade Oracle Database RAC 2 nodes CDB, 2 PDBs from 19.3 to 19.9

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

Bookmark the permalink.
Loading Facebook Comments ...

Leave a Reply