Overview
This procedure installs Oracle 19C and patches it to 19.5.1.0.200114 on the PERSONAL system.
References
- Oracle® Database Database Installation Guide 19c for Linux
- Bug 30446054 - Database Release Update Revision (DB RUR) 19.5.1.0.200114 (Doc ID 30446054.8)
- Patch 30446054 - Database Release Update Revision 19.5.1.0.200114
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 .