Oracle Downloads

Based on 18c rac to delete and build:

hostnamectl set-hostname raclhr-19c-n1
hostnamectl set-hostname raclhr-19c-n2
#Public IP
192.168.59.52 raclhr-19c-n1
192.168.59.53 raclhr-19c-n2
#Private IP
192.168.2.52 raclhr-19c-n1-priv
192.168.2.53 raclhr-19c-n2-priv
#Virtual IP
192.168.59.54 raclhr-19c-n1-vip
192.168.59.55 raclhr-19c-n2-vip
#Scan IP
192.168.59.56 raclhr-19c-scan
192.168.59.57 raclhr-19c-scan
192.168.59.58 raclhr-19c-scan
mkdir -p /u01/app/19.3.0/grid
mkdir -p /u01/app/grid
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oracle/product/19.3.0/dbhome_1
chown -R grid:oinstall /u01
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/
mkdir -p /u01/app/oraInventory
chown -R grid:oinstall /u01/app/oraInventory
chmod -R 775 /u01/app/oraInventory
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/19.3.0/grid
export GRID_BASE=$ORACLE_BASE
export GRID_HOME=$ORACLE_HOME
export PATH=$PATH:$ORACLE_HOME/bin
yum install bc gcc gcc-c++ binutils make gdb cmake glibc ksh \
elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc-devel \
libaio libaio-devel libXrender libXrender-devel libX11 libXau sysstat \
libXi libXtst libgcc librdmacm-devel libstdc++ libstdc++-devel libxcb \
net-tools nfs-utils compat-libcap1 compat-libstdc++ smartmontools targetcli \
python python-configshell python-rtslib python-six unixODBC unixODBC-devel
Grid user:
unzip /soft/LINUX.X64_193000_grid_home.zip -d /u01/app/19.3.0/grid
Oracle user:
unzip /soft/LINUX.X64_193000_db_home.zip -d /u01/app/oracle/product/19.3.0/dbhome_1
$ORACLE_HOME/runcluvfy.sh stage -pre crsinst -n "raclhr-19c-n1,raclhr-19c-n2" -verbose

/u01/app/19.3.0/grid/oui/prov/resources/scripts/sshUserSetup.sh -user grid -hosts "raclhr-19c-n1 raclhr-19c-n2" -advanced exverify –confirm
/u01/app/19.3.0/grid/oui/prov/resources/scripts/sshUserSetup.sh -user oracle -hosts "raclhr-19c-n1 raclhr-19c-n2" -advanced exverify -confirm
--19c mgmtdb can choose not to install
$GRID_HOME/gridSetup.sh -silent -force -noconfig -waitforcompletion -ignorePrereq \
INVENTORY_LOCATION=/u01/app/oraInventory \
oracle.install.option=CRS_CONFIG \
ORACLE_BASE=/u01/app/grid \
oracle.install.asm.OSDBA=asmdba \
oracle.install.asm.OSOPER=asmoper \
oracle.install.asm.OSASM=asmadmin \
oracle.install.crs.config.scanType=LOCAL_SCAN \
oracle.install.crs.config.gpnp.scanName=raclhr-19c-scan \
oracle.install.crs.config.gpnp.scanPort=1521 \
oracle.install.crs.config.ClusterConfiguration=STANDALONE \
oracle.install.crs.config.configureAsExtendedCluster=false \
oracle.install.crs.config.clusterName=raclhr-cluster \
oracle.install.crs.config.gpnp.configureGNS=false \
oracle.install.crs.config.autoConfigureClusterNodeVIP=false \
oracle.install.crs.config.clusterNodes=raclhr-19c-n1:raclhr-19c-n1-vip:HUB,raclhr-19c-n2:raclhr-19c-n2-vip:HUB \
oracle.install.crs.config.networkInterfaceList=ens33:192.168.59.0:1,ens37:192.168.2.0:5,virbr0:192.168.122.0:3 \
oracle.install.asm.configureGIMRDataDG=true \
oracle.install.crs.config.useIPMI=false \
oracle.install.asm.storageOption=ASM \
oracle.install.asmOnNAS.configureGIMRDataDG=false \
oracle.install.asm.SYSASMPassword=lhr \
oracle.install.asm.diskGroup.name=OCR \
oracle.install.asm.diskGroup.redundancy=EXTERNAL \
oracle.install.asm.diskGroup.AUSize=4 \
oracle.install.asm.diskGroup.disksWithFailureGroupNames=/dev/asm-diskc,,/dev/asm-diskd,,/dev/asm-diske, \
oracle.install.asm.diskGroup.disks=/dev/asm-diskc,/dev/asm-diskd,/dev/asm-diske \
oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asm-* \
oracle.install.asm.configureAFD=false \
oracle.install.crs.configureRHPS=false \
oracle.install.crs.config.ignoreDownNodes=false \
oracle.install.config.managementOption=NONE \
oracle.install.crs.rootconfig.executeRootScript=false
/u01/app/19.3.0/grid/gridSetup.sh -executeConfigTools -silent -responseFile /u01/app/19.3.0/grid/install/response/grid_2019-08-23_03-14-44PM.rsp
$GRID_HOME/bin/kfod disks=asm st=true ds=true cluster=true
$ORACLE_HOME/runcluvfy.sh stage -post crsinst -n "raclhr-19c-n1,raclhr-19c-n2" -verbose
$ORACLE_HOME/runInstaller -silent -force -noconfig -ignorePrereq \
oracle.install.option=INSTALL_DB_SWONLY \
UNIX_GROUP_NAME=oinstall \
INVENTORY_LOCATION=/u01/app/oraInventory \
ORACLE_BASE=/u01/app/oracle \
ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1 \
oracle.install.db.InstallEdition=EE \
oracle.install.db.OSDBA_GROUP=dba \
oracle.install.db.OSOPER_GROUP=oper \
oracle.install.db.OSBACKUPDBA_GROUP=backupdba \
oracle.install.db.OSDGDBA_GROUP=dgdba \
oracle.install.db.OSKMDBA_GROUP=kmdba \
oracle.install.db.OSRACDBA_GROUP=racdba \
oracle.install.db.CLUSTER_NODES=raclhr-19c-n1,raclhr-19c-n2 \
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
create diskgroup DATA external redundancy disk '/dev/asm-diski','/dev/asm-diskj','/dev/asm-diskk' ATTRIBUTE 'compatible.rdbms' = '19.0', 'compatible.asm' = '19.0';
create diskgroup FRA external redundancy disk '/dev/asm-diskl','/dev/asm-diskm','/dev/asm-diskn' ATTRIBUTE 'compatible.rdbms' = '19.0', 'compatible.asm' = '19.0';
srvctl start diskgroup -diskgroup data
srvctl start diskgroup -diskgroup fra
alter diskgroup all mount;
dbca -silent -ignorePreReqs -ignorePrereqFailure -createDatabase -templateName General_Purpose.dbc -responseFile NO_VALUE \
-gdbname rac19c -sid rac19c \
-createAsContainerDatabase TRUE \
-sysPassword lhr -systemPassword lhr -pdbAdminPassword lhr -dbsnmpPassword lhr \
-datafileDestination '+DATA' -recoveryAreaDestination '+FRA' \
-storageType ASM \
-characterset AL32UTF8 \
-sampleSchema true \
-totalMemory 1024 \
-databaseType MULTIPURPOSE \
-emConfiguration none \
-nodeinfo raclhr-19c-n1,raclhr-19c-n2
-------------------- 19c MGMTDB is optional
1. Complete the creation of CDB
create diskgroup MGMT external redundancy disk '/dev/asm-diskf','/dev/asm-diskg','/dev/asm-diskh' ATTRIBUTE 'compatible.rdbms' = '19.0', 'compatible.asm' = '19.0';
/u01/app/19.3.0/grid/bin/dbca -silent -createDatabase -createAsContainerDatabase true -templateName MGMTSeed_Database.dbc -sid -MGMTDB -gdbName _mgmtdb -storageType ASM -diskGroupName MGMT -datafileJarLocation /u01/app/19.3.0/grid/assistants/dbca/templates -characterset AL32UTF8 -autoGeneratePasswords -skipUserTemplateCheck
2. Complete the creation of pdb
Mgmtca -local

Oracle Database 19c, also known as 12.2.0.3, was originally released on livesql.oracle.com and is the final version of the Oracle Database 12c and 18c series, and is therefore a "long-term support" version (formerly known as the "terminal version"). "Long-term support" means that Oracle Database 19c offers four years of advanced support (as of the end of January 2023) and at least three years of extended support (as of the end of January 2026). This extended support window is critical to many of our customers because many customers have developed relevant upgrade strategies. For the latest Oracle support plan, see Document ID 742060.1 on My Oracle Support. As of now, Oracle Database 19c is already available on the Oracle Database Appliance.

Description of the Oracle12c version:
Oracle12cR2=12.2.0.1
Oracle18C=12.2.0.2
Oracle19c=12.2.0.3

In the MOS official article: Release Schedule of Current Database Releases (document ID 742060.1), Oracle's version plan can be clearly see

The goal of Oracle Database 19c

Oracle Database 19c is the version that most customers are ready to upgrade, and Oracle has made stability a core goal of this release. In Oracle Database 19c, developers focus on fixing known issues instead of adding new features. In a few years we have hundreds of people and thousands of servers running tests 24 hours a day. Testing includes the core of the database, the installer, and all the aspects of the subroutines that make up the product and the stack of utilities. There is only one goal to ensure the stability of the database. Really bring benefits to customers.

Installing Oracle Database 19c on Linux requires OL7, RHEL7, SLES12 and above. The following content is from the official documentation

The following Linux x86-64 kernels are supported:
Oracle Linux 7.4 with the Unbreakable Enterprise Kernel 4: 4.1.12-112.16.7.el7uek.x86_64 or later
Oracle Linux 7.4 with the Unbreakable Enterprise Kernel 5: 4.14.35-1818.1.6.el7uek.x86_64 or later
Oracle Linux 7.4 with the Red Hat Compatible kernel: 3.10.0-693.5.2.0.1.el7.x86_64 or later
Red Hat Enterprise Linux 7.4: 3.10.0-693.5.2.0.1.el7.x86_64 or later
SUSE Linux Enterprise Server 12 SP3: 4.4.103-92.56-default or later

Oracle Enterprise Linux 6 and RedHat Linux 6 did not appear in the official list. Over time, not only to upgrade the operating system, but also to upgrade the database. Make an upgrade plan. There will be unexpected problems in the later stages. 19c is 12.2.0.3, which is the ultimate version in the 12c series. It is stable!

Oracle19C installation package download

The download address is as follows:

Https://edelivery.oracle.com