Parcheo Oracle Restart 19c (GI Realease update revision 19.5.1.0.0 JAN2020)

En la siguiente entrada se explican los pasos a seguir a la hora de realizar un parcheo de una infraestructura de Grid versión 19c en un servidor standalone, también conocido como Oracle Restart 19c.

En este procedimiento parcheamos la infraestructura a la versión GI RELEASE UPDATE REVISION 19.5.1.0.0 JAN2020

Descargar parche y Opatch

Lo primero que tenemos que hacer es descargar de la página de Oracle el parche que vamos aplicar. Para ello, seguiremos la nota de My Oracle Support 2118136.2 : Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases

Para descargar la versión necesaria del Opatch vamos a la pagina https://updates.oracle.com/download/6880880.html. La versión que necesitamos en nuestro caso es 12.2.0.1.17 o superior. En el fichero “Readme.html” del parche viene indicada la versión necesaria para el parcheo.

Actualizar versión OPatch

Nuestra versión del OPatch es 12.2.0.11 y la que nos pide el parche a aplicar es 12.2.0.1.17 o superior, por lo que tenemos que actualizar el OPatch tanto del RDBMS home como del GI home siguiendo los pasos que se muestran a continuación.

———————————————————
–Comprobar versión actual OPatch:
———————————————————

[oracle@pruovmoracle19 ~]$ opatch version
OPatch Version: 12.2.0.1.11
OPatch succeeded.
[oracle@pruovmoracle19 ~]$

—————————————
— Backup OPatch actual:
———————————–
—-

[oracle@pruovmoracle19 ~]$
mv /u01/app/19.3.0/grid/OPatch /u01/app/19.3.0/grid/OPatch_OLD
[oracle@pruovmoracle19 ~]$

———————————————————————–
Descomprimir OPatch en el ORACLE_HOME:
———————————————————————–

[oracle@pruovmoracle19 ~]$
cd /tmp/SW/OPatch/
unzip -q -d /u01/app/19.3.0/grid/ p6880880_122010_Linux-x86-64.zip
chown -R oracle:oinstall /u01/app/19.3.0/grid/OPatch

————————————————————
— Comprobar nueva versión OPatch:
————————————————————

[oracle@pruovmoracle19 ~]$ opatch version
OPatch Version: 12.2.0.1.17
OPatch succeeded.
[oracle@pruovmoracle19 ~]$

Comprobar nivel de parcheo actual

Comprobamos el nivel de parcheo actual tanto en el RDBMS home como en el GI home.

[oracle@pruovmoracle19 ~]$ . ./profile_GI19
———————————————–
— Entorno Oracle Restart 19c
———————————————–
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$ opatch lsinventory | grep description
ARU platform description:: Linux x86-64
Patch description: “OCW RELEASE UPDATE 19.3.0.0.0 (29585399)”
Patch description: “ACFS RELEASE UPDATE 19.3.0.0.0 (29517247)”
Patch description: “Database Release Update : 19.3.0.0.190416 (29517242)”
Patch description: “TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763)”
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$ . ./profile_RDBMS19
—————————————————————–
Entorno RDBMS genérico 19c con GI 19c
—————————————————————–
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$ opatch lsinventory | grep description
ARU platform description:: Linux x86-64
Patch description: “OCW RELEASE UPDATE 19.3.0.0.0 (29585399)”
Patch description: “Database Release Update : 19.3.0.0.190416 (29517242)”
[oracle@pruovmoracle19 ~]$

Descomprimir el parche en el sistema operativo.

Para comenzar con los chequeos previos y la posterior instalación, debemos descomprimir el parche en un directorio del sistema operativo que tengamos suficiente espacio. En nuestro caso lo hemos descomprimido en la ruta: /u01/SW/Oracle19.3/PSU_JAN2020/

[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$cd /u01/SW/Oracle19.3/PSU_JAN2020/
[oracle@pruovmoracle19 ~]$unzip p30464035_190000_Linux-x86-64.zip
[oracle@pruovmoracle19 ~]$

Chequear conflictos con parches anteriores

Ahora comprobamos tanto desde el GI home como desde el RDBMS home si tenemos conflictos con parches instalados anteriormente.

——————————————————————–
–Cargamos el perfil de variables GI Home:
——————————————————————–


$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30446054

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30554387

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30689680

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30655595
—————————————————————————-
–Cargamos el perfil de variables RDBMS Home:
—————————————————————————-


$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30446054

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30554387

Ejemplo de ejecución:

[oracle@pruovmoracle19 ~]$ . ./profile_GI19
———————————————–
–Entorno Oracle Restart 19c:
————————————————
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30446054
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/19.3.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.3.0/grid/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2020-03-04_17-22-45PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30554387
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/19.3.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.3.0/grid/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2020-03-04_17-23-04PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30689680
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/19.3.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.3.0/grid/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2020-03-04_17-23-16PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30655595
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/19.3.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.3.0/grid/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2020-03-04_17-24-13PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$

[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$ . ./profile_RDBMS19
——————————————————————-
–Entorno RDBMS genérico 19c con GI 19c
——————————————————————-
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30446054
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-03-04_17-24-58PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$
[oracle@pruovmoracle19 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30554387
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-03-04_17-25-10PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
[oracle@pruovmoracle19 ~]$

Comprobar espacio

Comprobamos si hay espacio suficiente en el FS donde están los ORACLE_HOME tanto de GI como del RDBMS. Si el resultado del chequeo es satisfactorio se muestra el siguiente mensaje “Prereq “checkSystemSpace” passed.” y si no hay espacio muestra el siguiente mensaje “Prereq “checkSystemSpace” failed.”

—————————————————————-
–Cargamos el perfil de variables de GI
—————————————————————-


[oracle@pruovmoracle19 ~]$ . ./profile_GI19
———————————————–
–Entorno Oracle Restart 19c:
————————————————
[oracle@pruovmoracle19 ~]$


———————————————————————————————————-
–Creamos el fichero patch_list_gihome.txt con la ruta de los parches:
———————————————————————————————————-


[oracle@pruovmoracle19 ~]$ cat /tmp/patch_list_gihome.txt
/u01/SW/Oracle19.3/PSU_JAN2020/30464035/30446054
/u01/SW/Oracle19.3/PSU_JAN2020/30464035/30554387
/u01/SW/Oracle19.3/PSU_JAN2020/30464035/30689680
/u01/SW/Oracle19.3/PSU_JAN2020/30464035/30655595
[oracle@pruovmoracle19 ~]$


———————————————————————————————————
— Lanzamos la comprobación de espacio
———————————————————————————————————


[oracle@pruovmoracle19 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/19.3.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.3.0/grid/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2020-03-04_17-40-43PM_1.log
Invoking prereq “checksystemspace”
Prereq “checkSystemSpace” passed.
OPatch succeeded.
[oracle@pruovmoracle19 ~]$
————————————————————————
–Cargamos el perfil de variables de RDBMS
—————————————————————-——–

[oracle@pruovmoracle19 ~]$ . ./profile_RDBMS19
——————————————————————-
–Entorno RDBMS genérico 19c con GI 19c
——————————————————————-
[oracle@pruovmoracle19 ~]$


———————————————————————————————————-
–Creamos el fichero patch_list_dbhome.txt con la ruta de los parches:
———————————————————————————————————-


[oracle@pruovmoracle19 ~]$ cat /tmp/patch_list_dbhome.txt
/u01/SW/Oracle19.3/PSU_JAN2020/30464035/30446054
/u01/SW/Oracle19.3/PSU_JAN2020/30464035/30554387
[oracle@pruovmoracle19 ~]$


———————————————————————————————————
— Lanzamos la comprobación de espacio
———————————————————————————————————


[oracle@pruovmoracle19 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-03-04_17-49-43PM_1.log
Invoking prereq “checksystemspace”
Prereq “checkSystemSpace” passed.
OPatch succeeded.
[oracle@pruovmoracle19 ~]$

Aplicar parche GI con opatchauto

Una vez realizados todos los chequeos, ya tendremos el sistemas disponible para realizar el parcheo. En este caso vamos a realizar el parcheo con la utilidad opatchauto, por lo que se realizara una comprobación adicional.

Los comandos de opatchauto se deben ejecutar como “root” y con el perfil de variables de GI.

Lanzamos los siguientes comandos:

$ORACLE_HOME/OPatch/opatchauto apply /u01/SW/Oracle19.3/PSU_JAN2020/30464035/ -analyze

$ORACLE_HOME/OPatch/opatchauto apply /u01/SW/Oracle19.3/PSU_JAN2020/30464035/

———————————————————————————————————–
— Lanzamos la comprobación de conflictos con parches ya instalados
———————————————————————————————————–


root@pruovmoracle19 oracle]# $ORACLE_HOME/OPatch/opatchauto apply /u01/SW/Oracle19.3/PSU_JAN2020/30464035/ -analyze
OPatchauto session is initiated at Wed Mar 4 17:55:21 2020
System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2020-03-04_05-55-23PM.log.
Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2020-03-04_05-55-26PM.log
The id for this session is HH5E
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid
Patch applicability verified successfully on home /u01/app/19.3.0/grid
OPatchAuto successful.
——————————–Summary——————————–
Analysis for applying patches has completed successfully:
Host:pruovmoracle19
SIHA Home:/u01/app/19.3.0/grid
Version:19.0.0.0.0
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30554387
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-04_17-55-34PM_1.log
Patch: /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30689680
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-04_17-55-34PM_1.log
Patch: /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30655595
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-04_17-55-34PM_1.log
Patch: /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30446054
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-04_17-55-34PM_1.log
OPatchauto session completed at Wed Mar 4 17:55:45 2020
Time taken to complete the session 0 minute, 24 seconds
[root@pruovmoracle19 oracle]#
——————————————————————————————-
— Aplicamos parche
——————————————————————————————-

[root@pruovmoracle19 oracle]# $ORACLE_HOME/OPatch/opatchauto apply /u01/SW/Oracle19.3/PSU_JAN2020/30464035/
OPatchauto session is initiated at Wed Mar 4 18:13:49 2020
System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2020-03-04_06-13-51PM.log.
Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2020-03-04_06-13-54PM.log
The id for this session is YKNW
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid
Patch applicability verified successfully on home /u01/app/19.3.0/grid
Bringing down CRS service on home /u01/app/19.3.0/grid
Prepatch operation log file location: /u01/app/oracle/crsdata/pruovmoracle19/crsconfig/hapatch_2020-03-04_06-14-14PM.log
CRS service brought down successfully on home /u01/app/19.3.0/grid
Start applying binary patch on home /u01/app/19.3.0/grid
Binary patch applied successfully on home /u01/app/19.3.0/grid
Starting CRS service on home /u01/app/19.3.0/grid
Postpatch operation log file location: /u01/app/oracle/crsdata/pruovmoracle19/crsconfig/hapatch_2020-03-04_06-19-38PM.log
CRS service started successfully on home /u01/app/19.3.0/grid
OPatchAuto successful.
——————————–Summary——————————–
Patching is completed successfully. Please find the summary as follows:
Host:pruovmoracle19
SIHA Home:/u01/app/19.3.0/grid
Version:19.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30446054
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-04_18-14-39PM_1.log
Patch: /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30554387
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-04_18-14-39PM_1.log
Patch: /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30655595
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-04_18-14-39PM_1.log
Patch: /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30689680
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-04_18-14-39PM_1.log
OPatchauto session completed at Wed Mar 4 18:21:53 2020
Time taken to complete the session 8 minutes, 4 seconds

Aplicar parche RDBMS

Como en nuestra instalación no tenemos creada ninguna base de datos, el opatchauto no parchea el RDBMS home, por lo que tendremos que aplicar los parches de forma manual.

En el caso de que si tener creada una base de datos, el opatchauto se encarga de forma automática de aplicar parche en el GI home, parar la base de datos, aplicar el parche en RDBMS home y levantar la base de datos.

Los comandos que ejecutaremos son los siguientes:

cd /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30446054
opatch apply
cd /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30554387
opatch apply
[oracle@pruovmoracle19 30446054]$cd /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30446054
[oracle@pruovmoracle19 30446054]$
[oracle@pruovmoracle19 30446054]$
[oracle@pruovmoracle19 30446054]$
[oracle@pruovmoracle19 30446054]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-03-05_11-04-17AM_1.log
Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 30446054
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/19.3.0/db_1’)
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
Applying interim patch ‘30446054’ to OH ‘/u01/app/oracle/product/19.3.0/db_1’
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.assistants.usm, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.options.olap.awm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms, 19.0.0.0.0…
Patching component oracle.rdbms.rsf, 19.0.0.0.0…
Patching component oracle.rdbms.util, 19.0.0.0.0…
Patching component oracle.assistants.acf, 19.0.0.0.0…
Patching component oracle.assistants.deconfig, 19.0.0.0.0…
Patching component oracle.assistants.server, 19.0.0.0.0…
Patching component oracle.buildtools.rsf, 19.0.0.0.0…
Patching component oracle.ctx, 19.0.0.0.0…
Patching component oracle.ldap.rsf, 19.0.0.0.0…
Patching component oracle.network.rsf, 19.0.0.0.0…
Patching component oracle.rdbms.dbscripts, 19.0.0.0.0…
Patching component oracle.sdo, 19.0.0.0.0…
Patching component oracle.sqlplus, 19.0.0.0.0…
Patching component oracle.network.client, 19.0.0.0.0…
Patching component oracle.sdo.locator, 19.0.0.0.0…
Patching component oracle.duma, 19.0.0.0.0…
Patching component oracle.rdbms.crs, 19.0.0.0.0…
Patching component oracle.rdbms.drdaas, 19.0.0.0.0…
Patching component oracle.rdbms.rman, 19.0.0.0.0…
Patching component oracle.ctx.atg, 19.0.0.0.0…
Patching component oracle.install.deinstalltool, 19.0.0.0.0…
Patching component oracle.rdbms.scheduler, 19.0.0.0.0…
Patching component oracle.oraolap.dbscripts, 19.0.0.0.0…
Patching component oracle.dbjava.ucp, 19.0.0.0.0…
Patching component oracle.ctx.rsf, 19.0.0.0.0…
Patching component oracle.dbdev, 19.0.0.0.0…
Patching component oracle.xdk.parser.java, 19.0.0.0.0…
Patching component oracle.xdk, 19.0.0.0.0…
Patching component oracle.ons, 19.0.0.0.0…
Patching component oracle.ldap.rsf.ic, 19.0.0.0.0…
Patching component oracle.dbjava.ic, 19.0.0.0.0…
Patching component oracle.dbjava.jdbc, 19.0.0.0.0…
Patching component oracle.ovm, 19.0.0.0.0…
Patching component oracle.rdbms.deconfig, 19.0.0.0.0…
Patching component oracle.rdbms.install.plugins, 19.0.0.0.0…
Patching component oracle.xdk.rsf, 19.0.0.0.0…
Patching component oracle.odbc, 19.0.0.0.0…
Patching component oracle.network.listener, 19.0.0.0.0…
Patching component oracle.sdo.locator.jrf, 19.0.0.0.0…
Patching component oracle.oracore.rsf, 19.0.0.0.0…
Patching component oracle.nlsrtl.rsf, 19.0.0.0.0…
Patching component oracle.rdbms.install.seeddb, 19.0.0.0.0…
Patching component oracle.ldap.owm, 19.0.0.0.0…
Patching component oracle.rdbms.dv, 19.0.0.0.0…
Patching component oracle.rdbms.oci, 19.0.0.0.0…
Patching component oracle.sqlplus.ic, 19.0.0.0.0…
Patching component oracle.ldap.security.osdt, 19.0.0.0.0…
Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0…
Patching component oracle.precomp.lang, 19.0.0.0.0…
Patching component oracle.precomp.common, 19.0.0.0.0…
Patching component oracle.jdk, 1.8.0.201.0…
Patch 30446054 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [30446054].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-03-05_11-04-17AM_1.log
OPatch succeeded.
[oracle@pruovmoracle19 30446054]$
[oracle@pruovmoracle19 30554387]$cd /u01/SW/Oracle19.3/PSU_JAN2020/30464035/30554387
[oracle@pruovmoracle19 30554387]$
[oracle@pruovmoracle19 30554387]$
[oracle@pruovmoracle19 30554387]$
[oracle@pruovmoracle19 30554387]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-03-05_11-07-03AM_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) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-03-05_11-07-14AM_1.log
Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 30554387
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 = ‘/u01/app/oracle/product/19.3.0/db_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 ‘30554387’ to OH ‘/u01/app/oracle/product/19.3.0/db_1’
ApplySession: Optional component(s) [ oracle.has.crs.cvu, 19.0.0.0.0 ] , [ oracle.has.crs, 19.0.0.0.0 ] , [ oracle.has.cvu, 19.0.0.0.0 ] , [ oracle.xag, 19.0.0.0.0 ] , [ oracle.rhp.crs, 19.0.0.0.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms, 19.0.0.0.0…
Patching component oracle.has.db, 19.0.0.0.0…
Patching component oracle.has.db.cvu, 19.0.0.0.0…
Patching component oracle.rhp.common, 19.0.0.0.0…
Patching component oracle.has.rsf, 19.0.0.0.0…
Patching component oracle.has.common, 19.0.0.0.0…
Patching component oracle.has.common.cvu, 19.0.0.0.0…
Patching component oracle.rhp.db, 19.0.0.0.0…
Patch 30554387 successfully applied.
Sub-set patch [29585399] has become inactive due to the application of a super-set patch [30554387].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-03-05_11-07-14AM_1.log
OPatch succeeded.
[oracle@pruovmoracle19 30554387]

Comprobar el nuevo nivel de parcheo

Una vez aplicados los parches del GI home y del RDBMS home, comprobamos el nivel de parcheo par ver que ya tenemos nuestros binarios en la nueva versión.

————————
— GI HOME:
————————
[oracle@pruovmoracle19 ~]$ opatch lsinventory | grep description
ARU platform description:: Linux x86-64
Patch description: “OCW RELEASE UPDATE 19.5.1.0.0 (30446054)”
Patch description: “ACFS RELEASE UPDATE 19.5.1.0.0 (30554387)”
Patch description: “Database Release Update : 19.5.1.0.200114 (30689680)”
Patch description: “TOMCAT RELEASE UPDATE 19.0.0.0.0 (30655595)”
[oracle@pruovmoracle19 ~]$

——————————
— RDBMS HOME:
——————————
[oracle@pruovmoracle19 ~]$ opatch lsinventory | grep description
ARU platform description:: Linux x86-64
Patch description: “OCW RELEASE UPDATE REVISION 19.5.1.0.0 (30554387)”
Patch description: “Database Release Update Revision : 19.5.1.0.200114 (30446054)”
[oracle@pruovmoracle19 30554387]$

Responder

Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de WordPress.com

Estás comentando usando tu cuenta de WordPress.com. Cerrar sesión /  Cambiar )

Google photo

Estás comentando usando tu cuenta de Google. Cerrar sesión /  Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión /  Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión /  Cambiar )

Conectando a %s