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]$