This post is superseded - see this link:
https://www.durham.computer/2019/06/oracle-psu-patch.html
NB - This patch is not to be installed to an environment that has a
Grid Infrastructure (GI) home. Please refer to the following My
Oracle Support Document 756671.1
to determine the appropriate Grid Infrastructure patch to be
installed.
i.e.
$ cd /u01/software/patch_apr2019/29314339
$ /u01/app/oracle/product/12.2.0.1/dbhome_1/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.2.0.1/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.2.0.1/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/opatch2019-05-09_13-23-27PM_1.log
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following active executables are not used by opatch process :
/u01/app/oracle/product/12.2.0.1/dbhome_1/lib/libskgxp12.so
/u01/app/oracle/product/12.2.0.1/dbhome_1/bin/oracle
Following active executables are used by opatch process :
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u01/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/opatch2019-05-09_13-23-27PM_1.log
OPatch failed with error code 73
This was because we had an oracle database running, so we shutdown the database and ran the prereq which should have been ran in the first place :
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/12.2.0.1/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.2.0.1/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/opatch2019-05-09_13-48-08PM_1.log
Invoking prereq "checkactivefilesandexecutables"
Prereq "checkActiveFilesAndExecutables" for patch 29314339 passed.
OPatch succeeded.
Now able to run the patch
/u01/app/oracle/product/12.2.0.1/dbhome_1/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.17Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.2.0.1/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.2.0.1/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/opatch2019-05-09_13-43-05PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 29314339
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.2.0.1/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '29314339' to OH '/u01/app/oracle/product/12.2.0.1/dbhome_1'
ApplySession: Optional component(s) [ oracle.has.crs, 12.2.0.1.0 ] , [ oracle.network.cman, 12.2.0.1.0 ] , [ oracle.ons.daemon, 12.2.0.1.0 ] , [ oracle.oid.client, 12.2.0.1.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.util, 12.2.0.1.0...
Patching component oracle.precomp.rsf, 12.2.0.1.0...
Patching component oracle.rdbms.rsf.ic, 12.2.0.1.0...
....etc
Patching component oracle.sdo, 12.2.0.1.0...
Patch 29314339 successfully applied.
Log file location: /u01/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/opatch2019-05-09_13-43-05PM_1.log
OPatch succeeded.
Startup the database and apply the datapach as per the README.html in the patch directory.
Load Modified
SQL Files into the Database
[oracle@ol7-122-dg1 OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.2.0.1.0 Production on Thu May 9 13:51:46 2019
Copyright (c) 2012, 2019, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_10215_2019_05_09_13_51_46/sqlpatch_invocation.log
Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of SQL patches:
Bundle series DBRU:
ID 190416 in the binary registry and not installed in the SQL registry
Adding patches to installation queue and performing prereq checks...
Installation queue:
Nothing to roll back
The following patches will be applied:
29314339 (DATABASE APR 2019 RELEASE UPDATE 12.2.0.1.190416)
Installing patches...
Please refer to MOS Note 1609718.1 and/or the invocation log
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_10215_2019_05_09_13_51_46/sqlpatch_invocation.log
for information on how to resolve the above errors.
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_10215_2019_05_09_13_51_46/sqlpatch_invocation.log
for information on how to resolve the above errors.
SQL Patching tool complete on Thu May 9 13:53:29 2019
SQL> select patch_id, status, description from dba_registry_sqlpatch
2 /
2 /
PATCH_ID STATUS
---------- -------------------------
DESCRIPTION
--------------------------------------------------------------------------------
29314339 BEGIN
DATABASE APR 2019 RELEASE UPDATE 12.2.0.1.190416
---------- -------------------------
DESCRIPTION
--------------------------------------------------------------------------------
29314339 BEGIN
DATABASE APR 2019 RELEASE UPDATE 12.2.0.1.190416
Please check for any invalid objects and run ultrp as per the readme if you have any.
