News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Applying the July 2019 Database Release Update Patch

  • Posted by Gavin Soorma
  • On July 24, 2019
  • 0 Comments
  • july 2019, opatch, opatchauto, patch, PSU, release update, ru

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


 1

0 Comments

Leave Reply

Your email address will not be published. Required fields are marked *