Oracle RAC Upgrade to 19.11 from 19.6 For Linux (Oracle RAC 19.6 升級 19.11)

1. Download Oracle Support Grid 19.11 Patch & Opatch 12.2

Search Patch 32545008 (19.11.0.0.210420) p32545008_190000_Linux-x86-64.zip
Search Patch 6880880 (OPatch 12.2.0.1.25) p6880880_122010_Linux-x86-64.zip

2. upgrade opatch in all Node by grid & oracle (全節點都需要升級 Opatch，包含 grid & oracle)

# su - grid
$ mv $ORACLE_HOME/Opatch $ORACLE_HOME/Opatch.bak
$ unzip p6880880_122010_Linux-x86-64.zip -d $ORACLE_HOME

3. unzip grid patch 19.11 by grid

$ unzip p32545008_190000_Linux-x86-64.zip

4. analyze opatch (recommend restart service before analyze) (建議在開始分析前先重啟Cluster & Database)

$ su - root
# $ORACLE_HOME/OPatch/opatchauto apply <patch_file_path>/32545008 -analyze

5. apply opatch (Standby-First)

$ su - root
# $ORACLE_HOME/OPatch/opatchauto apply <patch_file_path>/32545008

-- if single RAC
# $ORACLE_HOME/OPatch/opatchauto apply <patch_file_path>/32545008 -nonrolling

6. Check version grid & oracle

# su - grid
$ $ORACLE_HOME/OPatch/opatch lsinventory
$ $ORACLE_HOME/OPatch/opatch lspatches

# su - oracle
$ $ORACLE_HOME/OPatch/opatch lsinventory
$ $ORACLE_HOME/OPatch/opatch lspatches

7. Upgrade RMAN catalog (execute upgrade catalog twice)

$ rman catalog username/password@rman_catalog
RMAN> upgrade catalog;
RMAN> upgrade catalog;

a. Rollback OPatch (need to runing in all node) (退版的話，每個節點都要執行)

# $ORACLE_HOME/OPatch/opatchauto rollback <patch_file_path>/32545008