Install Oracle RDBMS 19.5.1.0.200114 without Grid Infrastructure

Overview

This procedure installs Oracle 19C and patches it to 19.5.1.0.200114 on the PERSONAL system.

References

Procedure

Download 19c RPM

I downloaded the Oracle 19c RPM from Oracle Database Software Downloads.

Install Database Pre-Installation RPM

I followed the procedure in "Running RPM Packages to Install Oracle Database" as the root user on the PERSONAL system.

I downloaded the pre-installation RPM as follows:

curl -o oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

The output was:

% Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 18204 100 18204 0 0 25716 0 --:--:-- --:--:-- --:--:-- 237k

I installed the 19c pre-installation RPM as follows:

yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

The output was:

Loaded plugins: security Setting up Local Package Process Examining oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm: oracle-database-preinstall-19c-1.0-1.el7.x86_64 Marking oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm to be installed Could not get metalink https://mirrors.fedoraproject.org/metalink?repo=epel-6&arch=x86_64 error was 14: problem making ssl connection ol6_UEKR3_latest | 2.5 kB 00:00 ol6_UEKR3_latest/primary_db | 70 MB 01:29 ol6_latest | 2.7 kB 00:00 ol6_latest/primary_db | 21 MB 00:27 ol6_oracle_instantclient | 1.2 kB 00:00 ol6_oracle_instantclient/primary | 3.0 kB 00:00 ol6_oracle_instantclient 14/14 Resolving Dependencies --> Running transaction check ---> Package oracle-database-preinstall-19c.x86_64 0:1.0-1.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Installing: oracle-database-preinstall-19c x86_64 1.0-1.el7 /oracle-database-preinstall-19c-1.0-1.el7.x86_64 55 k Transaction Summary ================================================================================ Install 1 Package(s) Total size: 55 k Installed size: 55 k Downloading Packages: Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Installing : oracle-database-preinstall-19c-1.0-1.el7.x86_64 1/1 Verifying : oracle-database-preinstall-19c-1.0-1.el7.x86_64 1/1 Installed: oracle-database-preinstall-19c.x86_64 0:1.0-1.el7 Complete!

I removed the 19c pre-installation RPM as follows:

rm oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

The output was:

rm: remove regular file `oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm'? y

Install Database Software from RPM

I followed the procedure in "Running RPM Packages to Install Oracle Database" as the root user on the PERSONAL system.

The database software is installed using the following commands:

cd /opt/share/Software/database yum -y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm

The output was:

Loaded plugins: security Setting up Local Package Process Examining oracle-database-ee-19c-1.0-1.x86_64.rpm: oracle-database-ee-19c-1.0-1.x86_64 Marking oracle-database-ee-19c-1.0-1.x86_64.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package oracle-database-ee-19c.x86_64 0:1.0-1 will be installed --> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Installing: oracle-database-ee-19c x86_64 1.0-1 /oracle-database-ee-19c-1.0-1.x86_64 6.9 G Transaction Summary ================================================================================ Install 1 Package(s) Total size: 6.9 G Installed size: 6.9 G Downloading Packages: Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Installing : oracle-database-ee-19c-1.0-1.x86_64 1/1 [INFO] Executing post installation scripts... [INFO] Oracle home installed successfully and ready to be configured. To configure a sample Oracle Database you can execute the following service configuration script as root: /etc/init.d/oracledb_ORCLCDB-19c configure Verifying : oracle-database-ee-19c-1.0-1.x86_64 1/1 Installed: oracle-database-ee-19c.x86_64 0:1.0-1 Complete!

Backup PERSONAL Database

I backed up the PERSONAL database using the following RMAN commands:

backup database plus archivelog delete input; delete noprompt obsolete; backup recovery area to destination '/opt/share/Backup/personal';

Finding the New Oracle Home

The script, /etc/init.d/oracledb_ORCLCDB-19c, shows:

export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1

Check OPatch Version

I used the following command to get the current version of OPatch:

/opt/oracle/product/19c/dbhome_1/OPatch/opatch version

The output was:

OPatch Version: 12.2.0.1.17 OPatch succeeded.

According to "Patch 30446054 - Database Release Update Revision 19.5.1.0.200114", I need:

You must use the OPatch utility version 12.2.0.1.17 or later to apply this patch.

Thus, there is no need to update the OPatch utility.

Prepare PSU

As user, douglas, on PENRITH, I ran the following commands to unzip the PSU:

cd /opt/share/Software/database mkdir p30446054_190000_Linux-x86-64 unzip -q p30446054_190000_Linux-x86-64.zip -d p30446054_190000_Linux-x86-64 mv p30446054_190000_Linux-x86-64.zip ../Patches/

First Attempt Check PSU Conflicts

As the oracle user on PERSONAL, I ran the following commands to check for patch conflicts as advised by "Patch 30446054 - Database Release Update Revision 19.5.1.0.200114":

cd /opt/share/Software/database/p30446054_190000_Linux-x86-64/30446054/ /opt/oracle/product/19c/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

The command failed with:

Oracle Interim Patch Installer version 12.2.0.1.17 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session OPatch failed with error code 255

I could not find any relevant hits on My Oracle Support.

Second Attempt to Check PSU Conflicts

As the oracle user on PERSONAL, I ran the following commands to configure the ORACLE environment and put OPatch into the execution path, and to check for patch conflicts:

cd /opt/share/Software/database/p30446054_190000_Linux-x86-64/30446054/ export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1 export PATH=${ORACLE_HOME}/OPatch:${PATH} opatch prereq CheckConflictAgainstOHWithDetail -ph ./

The command failed with:

Oracle Interim Patch Installer version 12.2.0.1.17 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /opt/oracle/product/19c/dbhome_1 Central Inventory : /opt/app/oraInventory from : /opt/oracle/product/19c/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.17 OUI version : 12.2.0.7.0 Log file location : /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatch/opatch2020-03-06_20-03-23PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" is not executed. The details are: Unable to create Patch Object. Exception occured : PatchObject constructor: Input file "/opt/share/Software/database/p30446054_190000_Linux-x86-64/30446054/etc/config/actions" or "/opt/share/Software/database/p30446054_190000_Linux-x86-64/30446054/etc/config/inventory" does not exist. OPatch failed with error code 2

This problem is caused by unzipping as the douglas user and running OPatch as the oracle user:

douglas@penrith:/opt/share/Software/database$ ls -ld /opt/share/Software/database/p30446054_190000_Linux-x86-64/30446054/etc drwxr-x--- 1 douglas douglas 12 Jan 5 16:15 /opt/share/Software/database/p30446054_190000_Linux-x86-64/30446054/etc

Note that other users (not douglas) cannot enter this directory as the execute bit is not set.

Prepare PSU as ORACLE User

As user, oracle, on PERSONAL, I ran the following commands to unzip the PSU:

cd /tmp mkdir p30446054_190000_Linux-x86-64 cd p30446054_190000_Linux-x86-64 unzip -q /opt/share/Software/Patches/p30446054_190000_Linux-x86-64.zip -d .

Third Attempt to Check PSU Conflicts

As the oracle user on PERSONAL, I ran the following commands to check for patch conflicts:

cd /tmp/p30446054_190000_Linux-x86-64/30446054/ export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1 opatch prereq CheckConflictAgainstOHWithDetail -ph ./

The command succeeded with:

Oracle Interim Patch Installer version 12.2.0.1.17 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /opt/oracle/product/19c/dbhome_1 Central Inventory : /opt/app/oraInventory from : /opt/oracle/product/19c/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.17 OUI version : 12.2.0.7.0 Log file location : /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatch/opatch2020-03-06_20-35-16PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.

Apply PSU

As the oracle user on PERSONAL, I ran the following commands to apply the PSU:

cd /tmp/p30446054_190000_Linux-x86-64/30446054/ opatch apply

This succeeded. The log is attached as 2020_03_06_Apply_19_5_PSU.log.