New kid on the block – let’s install “Database Release Update 12.2.0.1.170718”

At the DOAG database conference in May, Andrew Mendelsohn announced that Oracle will change the release schedule to annual releases and that patch naming will be changed to “Release Updates” (RU). The latter started – as announced – in July 2017 and now the first “Database Release Update” is available.
Let’s start patching.

We will install the following patches:

  • Patch 26123830 – Database Jul2017 Release Update 12.2.0.1.170718
  • Patch 25811364 – Oracle JavaVM Component Jul2017 Release Update 12.2.0.1.170718

Update 16-AUG-2017:

Please note that that the DB RU was replaced by a “Release Update 12.2.0.1.170814“.

 

The starting point:

oracle@nf12cdba:/u00/app/oracle/stage/ [rdbms12201] $ORACLE_HOME/OPatch/opatch lspatches
26187629;OCW Patch Set Update : 12.2.0.1.170620 (26187629)
25983138;DATABASE BUNDLE PATCH: 12.2.0.1.170620 (25983138)

OPatch succeeded.

So the DBBP which was release in June is installed on our system.

oracle@nf12cdba:~/ [rdbms12201] $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.9

OPatch succeeded.

That’s good, because the required version of OPatch for installing the Database RU is 12.2.0.1.6 (or higher).
The OJVM RU requires 12.2.0.1.7 (or higher). At the moment, version 12.2.0.1.9 ist the highest available version.

BTW, I think it’s a good idea to download not only the patches but the most current
version of OPatch (via https://updates.oracle.com/download/6880880.html), too,
and to store everything together.

Let’s transfer the files on the database server, unzip the files, stop all databases
and listeners in the Oracle home and let’s start patching.

oracle@nf12cdba:/u00/app/oracle/stage/ [TVDNCDB] ls -l
total 149460
-rw-r--r--. 1 oracle oinstall 111976263 Jul 18 20:14 p25811364_122010_Linux-x86-64.zip
-rw-r--r--. 1 oracle oinstall 41068221 Jul 18 20:14 p26123830_122010_Linux-x86-64.zip

oracle@nf12cdba:/u00/app/oracle/stage/ [TVDNCDB] unzip p25811364_122010_Linux-x86-64.zip
[..]

oracle@nf12cdba:/u00/app/oracle/stage/ [TVDNCDB] unzip p26123830_122010_Linux-x86-64.zip
[..]

The first patch to be installed is the database RU:

oracle@nf12cdba:/u00/app/oracle/stage/ [TVDNCDB] cd 26123830
/u00/app/oracle/stage/26123830

oracle@nf12cdba:/u00/app/oracle/stage/26123830/ [TVDNCDB] $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.9
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Oracle Home : /u00/app/oracle/product/12.2.0.1
Central Inventory : /u00/app/oraInventory
 from : /u00/app/oracle/product/12.2.0.1/oraInst.loc
OPatch version : 12.2.0.1.9
OUI version : 12.2.0.1.4
Log file location : /u00/app/oracle/product/12.2.0.1/cfgtoollogs/opatch/opatch2017-07-18_20-19-30PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 26123830

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 = '/u00/app/oracle/product/12.2.0.1')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '26123830' to OH '/u00/app/oracle/product/12.2.0.1'

Patching component oracle.oracore.rsf, 12.2.0.1.0...
Patching component oracle.ctx, 12.2.0.1.0...
Patching component oracle.rdbms.deconfig, 12.2.0.1.0...
Patching component oracle.rdbms.rsf, 12.2.0.1.0...
Patching component oracle.rdbms.rman, 12.2.0.1.0...
Patching component oracle.rdbms, 12.2.0.1.0...
Patching component oracle.rdbms.util, 12.2.0.1.0...
Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...
Patching component oracle.tfa, 12.2.0.1.0...
Patching component oracle.rdbms.rsf.ic, 12.2.0.1.0...
Patch 26123830 successfully applied.
Sub-set patch [25983138] has become inactive due to the application of a super-set patch [26123830].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u00/app/oracle/product/12.2.0.1/cfgtoollogs/opatch/opatch2017-07-18_20-19-30PM_1.log

OPatch succeeded.

Note 2161861.1 tells us something about the changes in OPatch.
OPatch does not de-install superseeded patches anymore, but deactivates them.

“opatch lsinventory” will show you the inactive patches when using the flag “-inactive”:

oracle@nf12cdba:/u00/app/oracle/stage/26123830/ [TVDNCDB] $ORACLE_HOME/OPatch/opatch lsinventory -inactive
Oracle Interim Patch Installer version 12.2.0.1.9
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Oracle Home : /u00/app/oracle/product/12.2.0.1
Central Inventory : /u00/app/oraInventory
 from : /u00/app/oracle/product/12.2.0.1/oraInst.loc
OPatch version : 12.2.0.1.9
OUI version : 12.2.0.1.4
Log file location : /u00/app/oracle/product/12.2.0.1/cfgtoollogs/opatch/opatch2017-07-18_20-24-39PM_1.log

Lsinventory Output file location : /u00/app/oracle/product/12.2.0.1/cfgtoollogs/opatch/lsinv/lsinventory2017-07-18_20-24-39PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: nf12cdba.trivadistraining.com
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (2):

Oracle Database 12c 12.2.0.1.0
Oracle Database 12c Examples 12.2.0.1.0
There are 2 products installed in this Oracle Home.

Inactive patches (1) :

Patch 25983138 : applied on Thu Jun 22 13:10:40 CEST 2017
Unique Patch ID: 21358214
Patch description: "DATABASE BUNDLE PATCH: 12.2.0.1.170620 (25983138)"
 Created on 18 Jun 2017, 23:01:52 hrs PST8PDT
 Bugs fixed:
 23026585, 24336249, 24929210, 24942749, 25036474, 25110233, 25410877
 25417050, 25427662, 25459958, 25547901, 25569149, 25600342, 25600421
 25606091, 25655390, 25662088, 24385983, 24923215, 25099758, 25429959
 25662101, 25728085, 25823754, 22594071, 23665623, 23749454, 24326846
 24334708, 24560906, 24573817, 24578797, 24609996, 24624166, 24668398
 24674955, 24744686, 24811725, 24827228, 24831514, 24908321, 24976007
 25184555, 25210499, 25211628, 25223839, 25262869, 25316758, 25337332
 25455795, 25457409, 25539063, 25546608, 25612095, 25643931, 25410017
--------------------------------------------------------------------------------
OPatch succeeded.

Let’s continue with the OJVM patch:

oracle@nf12cdba:/u00/app/oracle/stage/ [TVDNCDB] cd 25811364
/u00/app/oracle/stage/25811364


oracle@nf12cdba:/u00/app/oracle/stage/25811364/ [TVDNCDB] $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.9
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Oracle Home : /u00/app/oracle/product/12.2.0.1
Central Inventory : /u00/app/oraInventory
 from : /u00/app/oracle/product/12.2.0.1/oraInst.loc
OPatch version : 12.2.0.1.9
OUI version : 12.2.0.1.4
Log file location : /u00/app/oracle/product/12.2.0.1/cfgtoollogs/opatch/opatch2017-07-18_20-26-50PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 25811364

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 = '/u00/app/oracle/product/12.2.0.1')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '25811364' to OH '/u00/app/oracle/product/12.2.0.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.rdbms, 12.2.0.1.0...
Patch 25811364 successfully applied.
Log file location: /u00/app/oracle/product/12.2.0.1/cfgtoollogs/opatch/opatch2017-07-18_20-26-50PM_1.log

OPatch succeeded.

Let’s verify:

oracle@nf12cdba:/u00/app/oracle/stage/ [TVDNCDB] $ORACLE_HOME/OPatch/opatch lspatches
25811364;OJVM RELEASE UPDATE: 12.2.0.1.170718 (25811364)
26123830;DATABASE RELEASE UPDATE: 12.2.0.1.170718 (26123830)
26187629;OCW Patch Set Update : 12.2.0.1.170620 (26187629)

OPatch succeeded.

Next step is to apply the changes to the database using the tool datapatch:

oracle@nf12cdba:/u00/app/oracle/stage/ [TVDNCDB] sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Tue Jul 18 20:29:54 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup upgrade;
ORACLE instance started.
Total System Global Area 2097152000 bytes
Fixed Size    8622624 bytes
Variable Size  603983328 bytes
Database Buffers 1476395008 bytes
Redo Buffers    8151040 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

And after that we have to restart the database in “normal mode”:

oracle@nf12cdba:/u00/app/oracle/stage/ [TVDNCDB] sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Tue Jul 18 20:33:05 2017
Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.
Total System Global Area 2097152000 bytes
Fixed Size    8622624 bytes
Variable Size  603983328 bytes
Database Buffers 1476395008 bytes
Redo Buffers    8151040 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

That’s it. Patching and applying the changes to the database went fine on my small test system. No big thing, no changes in the procedure – from my point of the “Release Updates” are just  a new name, for DBBP, SPU, PSU, CPU (fill in whichever acronym for Oracle patches you like).

 

MOS-Notes:

  • OPatch: Behavior Changes starting in OPatch 12.2.0.1.5 and 11.2.0.3.14 releases (Doc ID 2161861.1)

 

This entry was posted in Common, Oracle 12c and tagged , , . Bookmark the permalink.