This procedure installs Oracle 19C and patches it to 19.5.1.0.200114 on the PERSONAL system.
I downloaded the Oracle 19c RPM from Oracle Database Software Downloads.
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
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!
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';
The script, /etc/init.d/oracledb_ORCLCDB-19c, shows:
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
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.
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/
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.
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.
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 .
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.
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.