This note describes the steps used to apply the latest July 2019 Database Release Update Patch for Oracle 12c Release 2.
The environment is single instance Multitenant database.
Notes
1)Review MOS note Master Note for Database Proactive Patch Program (Doc ID 756671.1)
2)Download patch p29699168_122010_Linux-x86-64.zip – COMBO OF OJVM RU COMPONENT 12.2.0.1.190716 + 12.2.0.1.190716 DBJUL2019RU
3)Make sure the opatch version is minimum 12.2.0.1.17
4)Patch 29699168 comprises two patches:
Patch 29774415 (OJVM RELEASE UPDATE: 12.2.0.1.190716)
Patch 29757449 (DATABASE JUL 2019 RELEASE UPDATE 12.2.0.1.190716)
Apply patch 29774415
[oracle@host02 OPatch]$ pwd /u01/app/oracle/patch/29699168/29774415 [oracle@host02 29774415]$ $ORACLE_HOME/OPatch/opatch apply Oracle Interim Patch Installer version 12.2.0.1.17 Copyright (c) 2019, Oracle Corporation. All rights reserved. Oracle Home : /u02/app/oracle/product/12.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u02/app/oracle/product/12.2.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.17 OUI version : 12.2.0.1.4 Log file location : /u02/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-07-23_20-48-53PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 29774415 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 = '/u02/app/oracle/product/12.2.0/dbhome_1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '29774415' to OH '/u02/app/oracle/product/12.2.0/dbhome_1' Patching component oracle.javavm.server, 12.2.0.1.0... Patching component oracle.javavm.server.core, 12.2.0.1.0... Patching component oracle.rdbms.dbscripts, 12.2.0.1.0... Patching component oracle.javavm.client, 12.2.0.1.0... Patching component oracle.rdbms, 12.2.0.1.0... Patch 29774415 successfully applied. Log file location: /u02/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-07-23_20-48-53PM_1.log OPatch succeeded.
Apply patch 29757449
[oracle@host02 29699168]$ cd 29757449/ [oracle@host02 29757449]$ $ORACLE_HOME/OPatch/opatch apply Oracle Interim Patch Installer version 12.2.0.1.17 Copyright (c) 2019, Oracle Corporation. All rights reserved. Oracle Home : /u02/app/oracle/product/12.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u02/app/oracle/product/12.2.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.17 OUI version : 12.2.0.1.4 Log file location : /u02/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-07-23_20-50-52PM_1.log Verifying environment and performing prerequisite checks... -------------------------------------------------------------------------------- Start OOP by Prereq process. Launch OOP... Oracle Interim Patch Installer version 12.2.0.1.17 Copyright (c) 2019, Oracle Corporation. All rights reserved. Oracle Home : /u02/app/oracle/product/12.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u02/app/oracle/product/12.2.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.17 OUI version : 12.2.0.1.4 Log file location : /u02/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-07-23_20-51-08PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 29757449 Do you want to proceed? [y|n] Y (auto-answered by -silent) User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u02/app/oracle/product/12.2.0/dbhome_1') Is the local system ready for patching? [y|n] Y (auto-answered by -silent) User Responded with: Y Backing up files... Applying interim patch '29757449' to OH '/u02/app/oracle/product/12.2.0/dbhome_1' ApplySession: Optional component(s) [ oracle.has.crs, 12.2.0.1.0 ] , [ oracle.ons.daemon, 12.2.0.1.0 ] , [ oracle.oid.client, 12.2.0.1.0 ] , [ oracle.network.cman, 12.2.0.1.0 ] , [ oracle.jdk, 1.8.0.211.12 ] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms.rsf, 12.2.0.1.0... Patching component oracle.rdbms, 12.2.0.1.0... Patching component oracle.network.rsf, 12.2.0.1.0... Patching component oracle.rdbms.util, 12.2.0.1.0... Patching component oracle.ctx, 12.2.0.1.0... Patching component oracle.ctx.rsf, 12.2.0.1.0... Patching component oracle.ldap.rsf, 12.2.0.1.0... Patching component oracle.rdbms.dbscripts, 12.2.0.1.0... Patching component oracle.rdbms.rsf.ic, 12.2.0.1.0... Patching component oracle.sdo, 12.2.0.1.0... Patching component oracle.sdo.locator, 12.2.0.1.0... Patching component oracle.tfa, 12.2.0.1.0... Patching component oracle.xdk.rsf, 12.2.0.1.0... Patching component oracle.rdbms.rman, 12.2.0.1.0... Patching component oracle.assistants.deconfig, 12.2.0.1.0... Patching component oracle.xdk, 12.2.0.1.0... Patching component oracle.precomp.rsf, 12.2.0.1.0... Patching component oracle.sqlplus, 12.2.0.1.0... Patching component oracle.assistants.acf, 12.2.0.1.0... Patching component oracle.ldap.rsf.ic, 12.2.0.1.0... Patching component oracle.rdbms.oci, 12.2.0.1.0... Patching component oracle.rdbms.dv, 12.2.0.1.0... Patching component oracle.rdbms.crs, 12.2.0.1.0... Patching component oracle.rdbms.install.plugins, 12.2.0.1.0... Patching component oracle.oraolap, 12.2.0.1.0... Patching component oracle.install.deinstalltool, 12.2.0.1.0... Patching component oracle.oracore.rsf, 12.2.0.1.0... Patching component oracle.xdk.parser.java, 12.2.0.1.0... Patching component oracle.sqlplus.ic, 12.2.0.1.0... Patching component oracle.ldap.client, 12.2.0.1.0... Patching component oracle.nlsrtl.rsf, 12.2.0.1.0... Patching component oracle.rdbms.lbac, 12.2.0.1.0... Patching component oracle.assistants.server, 12.2.0.1.0... Patching component oracle.ons, 12.2.0.1.0... Patching component oracle.rdbms.deconfig, 12.2.0.1.0... Patching component oracle.precomp.common, 12.2.0.1.0... Patching component oracle.precomp.lang, 12.2.0.1.0... Patching component oracle.ctx.atg, 12.2.0.1.0... OPatch found the word "error" in the stderr of the make command. Please look at this stderr. You can re-run this make command. Stderr output: chmod: changing permissions of ‘/u02/app/oracle/product/12.2.0/dbhome_1/bin/extjobO’: Operation not permitted make: [iextjob] Error 1 (ignored) Patch 29757449 successfully applied. OPatch Session completed with warnings. Log file location: /u02/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-07-23_20-51-08PM_1.log OPatch completed with warnings.
Verify patch application
[oracle@host02 29757449]$ $ORACLE_HOME/OPatch/opatch lspatches 29757449;Database Jul 2019 Release Update : 12.2.0.1.190716 (29757449) 29774415;OJVM RELEASE UPDATE: 12.2.0.1.190716 (29774415) OPatch succeeded.
Applying datapatch to CDB and PDB’s
[oracle@host02 dbhome_1]$ cd OPatch
[oracle@host02 OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.2.0.1.0 Production on Tue Jul 23 20:58:14 2019
Copyright (c) 2012, 2019, Oracle. All rights reserved.
Log file for this invocation: /u02/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_24799_2019_07_23_20_58_14/sqlpatch_invocation.log
Connecting to database...OK
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of SQL patches:
Patch 29774415 (OJVM RELEASE UPDATE: 12.2.0.1.190716 (29774415)):
Installed in the binary registry only
Bundle series DBRU:
ID 190716 in the binary registry and not installed in any PDB
Adding patches to installation queue and performing prereq checks...
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED PDB1
Nothing to roll back
The following patches will be applied:
29774415 (OJVM RELEASE UPDATE: 12.2.0.1.190716 (29774415))
29757449 (DATABASE JUL 2019 RELEASE UPDATE 12.2.0.1.190716)
Installing patches...
Patch installation complete. Total patches installed: 6
Validating logfiles...
Patch 29774415 apply (pdb CDB$ROOT): SUCCESS
logfile: /u02/app/oracle/cfgtoollogs/sqlpatch/29774415/22954229/29774415_apply_CDB1_CDBROOT_2019Jul23_20_58_47.log (no errors)
Patch 29757449 apply (pdb CDB$ROOT): SUCCESS
logfile: /u02/app/oracle/cfgtoollogs/sqlpatch/29757449/23009673/29757449_apply_CDB1_CDBROOT_2019Jul23_20_59_42.log (no errors)
Patch 29774415 apply (pdb PDB$SEED): SUCCESS
logfile: /u02/app/oracle/cfgtoollogs/sqlpatch/29774415/22954229/29774415_apply_CDB1_PDBSEED_2019Jul23_21_04_13.log (no errors)
Patch 29757449 apply (pdb PDB$SEED): SUCCESS
logfile: /u02/app/oracle/cfgtoollogs/sqlpatch/29757449/23009673/29757449_apply_CDB1_PDBSEED_2019Jul23_21_04_43.log (no errors)
Patch 29774415 apply (pdb PDB1): SUCCESS
logfile: /u02/app/oracle/cfgtoollogs/sqlpatch/29774415/22954229/29774415_apply_CDB1_PDB1_2019Jul23_21_04_13.log (no errors)
Patch 29757449 apply (pdb PDB1): SUCCESS
logfile: /u02/app/oracle/cfgtoollogs/sqlpatch/29757449/23009673/29757449_apply_CDB1_PDB1_2019Jul23_21_04_31.log (no errors)
SQL Patching tool complete on Tue Jul 23 21:08:07 2019
[oracle@host02 OPatch]$
SQL> select patch_id,version,status,description
from dba_registry_sqlpatch;
PATCH_ID VERSION STATUS
---------- -------------------- -------------------------
DESCRIPTION
--------------------------------------------------------------------------------
29774415 12.2.0.1 SUCCESS
OJVM RELEASE UPDATE: 12.2.0.1.190716 (29774415)
29757449 12.2.0.1 SUCCESS
DATABASE JUL 2019 RELEASE UPDATE 12.2.0.1.190716
