PSU Jan 2017 integrado a la Base Image 17.2.1.0.0 para bases single-instance

Otra de las novedades presentadas en Abril para la Base Image 17.2.1.0.0,  es la integración del PSU de enero 2017 para despliegues en single-instance y configuraciones Dataguard (siempre de una única instancia). Con esto, los nuevos despliegues de "Oracle Database Cloud Services"  incorporarán todas las funcionalidades incluidas en el nuevo PSU.


Aqui los datos del nuevo PSU. Patch 25732082 PATH SET UPDATE 12.1.0.2.170117

Voy a comprobar la incorporación del nuevo PSU creando un nuevo despliegue:

Me conecto a la VM:

[oracle@TEST12cR1 ~]$ ps -ef|grep pmon

oracle    2862 24274  0 12:43 pts/0    00:00:00 grep pmon

oracle   20426     1  0 Apr13 ?        00:00:15 ora_pmon_DB12CR1

Voy a utilizar la forma para verificar parches que trata en su blog Mike Dietrich:

[oracle@TEST12cR1 ~]$ sqlplus / as sysdba

SQL> select xmltransform(dbms_qopatch.is_patch_installed('24732082'), dbms_qopatch.get_opatch_xslt) from dual;

XMLTRANSFORM(DBMS_QOPATCH.IS_PATCH_INSTALLED('24732082'),DBMS_QOPATCH.GET_OPATCH

--------------------------------------------------------------------------------

Patch Information:

         24732082:   applied on 2017-02-08T10:31:23Z

Ahora de la forma tradicional consultando al inventory:

[oracle@TEST12cR1 ~]$ opatch lsinventory

Oracle Interim Patch Installer version 12.2.0.1.8

Copyright (c) 2017, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc

OPatch version    : 12.2.0.1.8

OUI version       : 12.1.0.2.0

Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2017-04-16_12-37-27PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2017-04-16_12-37-27PM.txt

--------------------------------------------------------------------------------

Local Machine Information::

Hostname: TEST12cR1.compute-arprosegur.oraclecloud.internal

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c                                                  12.1.0.2.0

There are 1 products installed in this Oracle Home.

<<< Parte de la salida fué omitida >>>

Patch  24732082     : applied on Wed Feb 08 10:31:23 UTC 2017

Unique Patch ID:  20904347

Patch description:  "Database Patch Set Update : 12.1.0.2.170117 (24732082)"

   Created on 21 Dec 2016, 07:15:01 hrs PST8PDT

Sub-patch  24006101; "Database Patch Set Update : 12.1.0.2.161018 (24006101)"

Sub-patch  23054246; "Database Patch Set Update : 12.1.0.2.160719 (23054246)"

Sub-patch  22291127; "Database Patch Set Update : 12.1.0.2.160419 (22291127)"

Sub-patch  21948354; "Database Patch Set Update : 12.1.0.2.160119 (21948354)"

Sub-patch  21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"

Sub-patch  20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"

Sub-patch  20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"

Sub-patch  19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"

   Bugs fixed:

     21099555, 22175564, 19141838, 22083366, 20842388, 20117253, 19865345

     19791273, 21542577, 20951038, 19243521, 22165897, 19908836, 21281532

     19238590, 24577566, 21184223, 19134173, 20031873, 20387265, 21575362

     19149990, 21263635, 17551063, 18886413, 22160989, 22507210, 19366375

     19703301, 19001390, 24285405, 18202441, 20267166, 19358317, 19706965

     24739928, 19068970, 18549238, 18797519, 22148226, 20825533, 21196809

     19649152, 19670108, 18940497, 18948177, 22496904, 18964978, 19035573

     19176326, 20413820, 19176223, 21106027, 20904530, 20134339, 19074147

     20868862, 18411216, 21072646, 21322887, 22507234, 20425790, 18966843

     21329301, 20562898, 19333670, 20124446, 19468991, 19883092, 18510194

     19658708, 19591608, 19402853, 20618595, 21787056, 22380919, 19469538

     21266085, 17835294, 19721304, 19791377, 19068610, 22178855, 16777441