12c to 19c RAC Upgrade with EBS R12.2 - Linux

EBS R12.2 supports single pluggable database (PDB) under CDB architecture.

Requirements for Installing Oracle Database/Client 19c on OL8 or RHEL8 64-bit (x86-64) (Doc ID 2668780.1)

-Download the Oracle Database 19c software from OTN - 

https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html

Database Pre-Install RPM Download Links(External & Internal Repositories)

https://public-yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm

https://public-yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el8.x86_64.rpm

The download for the oracle-database-preinstall-19c RPM can be done with below commands (without the need to provide version numbers)

# dnf update -y

# dnf install oracle-database-preinstall-19c -y

The Oracle ORAchk utility provides system checks that can help to prevent issues before and after installation. These checks include kernel requirements, operating system resource allocations, and other system requirements.

Before you perform a fresh database installation:

./orachk -profile preinstall

Ensure that OpenSSH is installed on your servers. OpenSSH is the required SSH software.

Create the Oracle home directory and extract the image files that you have downloaded in to this Oracle home directory. For example:

$ mkdir -p /u01/app/oracle/product/19c/dbhome_1

$ chgrp oinstall /u01/app/oracle/product/19c/dbhome_1

$ cd /u01/app/oracle/product/19c/dbhome_1

$ unzip -q /tmp/db_home.zip

Apply Latest RU and one-offs

$ export CV_ASSUME_DISTID=OL7

$ ./runInstaller -applyRU <Latest 19c DBRU Patch unzip location> -applyOneOffs <Latest 19c OJVM RU Patch unzip location>,<Latest 19c OCWRU Patch unzip location>

For eg-

$ ./runInstaller -applyRU /u01/app/30557433 -applyOneOffs /u01/app/30484981,/u01/app/30501910/30489227

Note -

a. EM Express One-Off Patch 30150710 is fixed in October 2020 19.9 DBRU Patch 31771877

b. OCW RU Patches are not separately available for download from MOS Patches & Updates.Download latest GI RU & then unzip to locate the OCWRU Patch

c. EM Express One-Off Patch 30150710 is fixed in October 2020 19.9 DBRU Patch 31771877. If DB RU earlier than 19.9 is being applied,then Patch 30150710 needs to be downloaded separately & applied as shown below-

$ ./runInstaller -applyRU <Latest 19c DBRU Patch unzip location> -applyOneOffs <Latest 19c OJVM RU Patch unzip location>,<Latest 19c OCWRU Patch unzip location>,<Oneoff patch 30150710 unzip location>

For eg -

$ ./runInstaller -applyRU /u01/app/30557433 -applyOneOffs /u01/app/30484981,/u01/app/30501910/30489227,/u01/app/30150710

d. Latest RU Patch Numbers can be obtained from the below MOS Note -

Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (Doc ID 2118136.2)

Below steps mentions 12c 12102 to 19c (19.13) RAC Upgrade latest steps - OEL8

Step 1 ) 

Setup ssh password less between RAC nodes node1 and node2 

Step 2) 

export ORACLE_BASE=/oraapp/VIJ/oracle/product/

export ORACLE_HOME=/oraapp/VIJ/oracle/product/19c

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$ORACLE_HOME/OPatch:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export PERL5LIB=/oraapp/VIJ/oracle/product/19c/perl/bin/perl5.28.1:/oraapp/VIJ/oracle/product/19c/perl/lib/site_perl/5.28.1

export CV_ASSUME_DISTID=OL7

[oracle@vijidb01 ~]$ cd $ORACLE_HOME

[oracle@vijidb01 19c]$ pwd

/oraapp/VIJ/oracle/product/19c

--runInstaller and install CDB without PDB