Oracle Critical Patch Update Advisory - January 2020
Use the following link that contains the links to download the patch bundles MOS Note: 2602410.1 – Critical Patch Update (CPU) Program Jan 2020 Patch Availability Document.
Section 3.1.4 is the overview about Database Patch Bundles for each release.
I download the following patch bundles:
Database Release Update 19.6.0.0.200114 Patch 30557433 for UNIXDo I need to refresh my OPatch Version?
19.6.0 requires opatch 12.2.0.1.17 or later
[code] [oracle@orcl19c OPatch]$ ./opatch version OPatch Version: 12.2.0.1.17 OPatch succeeded. [/code]
Applying RU 19.6.0 to my 19c home
Applying 19.6.0 to my existing Oracle 19c home (Currently at 19.3.0)
Unzip downloaded patch ZIP file
After I unzipped the patch into a separate directory, I run:
1. opatch conflict check
[code] [oracle@orcl19c patch]$ cd 30557433 [oracle@orcl19c 30557433]$ /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ 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.0.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.0.0/dbhome_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.0.0/dbhome_1/cfgtoollogs/opatch/opatch2020-05-02_10-49-53AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [/code]
2. If this is not a RAC environment, shut down all instances and listeners associated with the Oracle home that you are updating.
[code] [oracle@orcl19c 30557433]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sat May 2 10:54:07 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> shut immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> SQL> SQL> quit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 [oracle@orcl19c 30557433]$ lsnrctl stop LISTENER LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 02-MAY-2020 10:54:46 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl19c.oracledbashop.com)(PORT=1521))) The command completed successfully [oracle@orcl19c 30557433]$ [/code]
3. Opatch apply
[code] [oracle@orcl19c 30557433]$ pwd /u01/patch/30557433 [oracle@orcl19c 30557433]$ /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/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.0.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.0.0/dbhome_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.0.0/dbhome_1/cfgtoollogs/opatch/opatch2020-05-02_10-56-10AM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 30557433 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.0.0/dbhome_1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '30557433' to OH '/u01/app/oracle/product/19.0.0/dbhome_1' ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.xdk.parser.java.jaxb2, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.network.cman, 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.options.olap.awm, 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.rsf, 19.0.0.0.0... Patching component oracle.rdbms.util, 19.0.0.0.0... Patching component oracle.rdbms, 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.xdk.rsf, 19.0.0.0.0... Patching component oracle.rdbms.install.plugins, 19.0.0.0.0... Patching component oracle.rdbms.install.common, 19.0.0.0.0... Patching component oracle.odbc, 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.dv, 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.oci, 19.0.0.0.0... Patching component oracle.oracore.rsf, 19.0.0.0.0... Patching component oracle.sdo.locator.jrf, 19.0.0.0.0... Patching component oracle.network.listener, 19.0.0.0.0... Patching component oracle.ldap.owm, 19.0.0.0.0... Patching component oracle.nlsrtl.rsf, 19.0.0.0.0... Patching component oracle.oraolap.dbscripts, 19.0.0.0.0... Patching component oracle.rdbms.scheduler, 19.0.0.0.0... Patching component oracle.install.deinstalltool, 19.0.0.0.0... Patching component oracle.dbjava.ucp, 19.0.0.0.0... Patching component oracle.sdo.locator, 19.0.0.0.0... Patching component oracle.network.client, 19.0.0.0.0... Patching component oracle.rdbms.rman, 19.0.0.0.0... Patching component oracle.rdbms.drdaas, 19.0.0.0.0... Patching component oracle.rdbms.crs, 19.0.0.0.0... Patching component oracle.duma, 19.0.0.0.0... Patching component oracle.precomp.rsf, 19.0.0.0.0... Patching component oracle.javavm.client, 19.0.0.0.0... Patching component oracle.precomp.common.core, 19.0.0.0.0... Patching component oracle.dbjava.jdbc, 19.0.0.0.0... Patching component oracle.dbjava.ic, 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.dbdev, 19.0.0.0.0... Patching component oracle.ctx.rsf, 19.0.0.0.0... Patching component oracle.bali.ice, 11.1.1.7.0... Patching component oracle.xdk, 19.0.0.0.0... Patching component oracle.xdk.parser.java, 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 30557433 successfully applied. Sub-set patch [29517242] has become inactive due to the application of a super-set patch [30557433]. Please refer to Doc ID 2161861.1 for any possible further required actions. Log file location: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2020-05-02_10-56-10AM_1.log OPatch succeeded. [oracle@orcl19c 30557433]$ [/code]
4. As final action, I will start my database and all pluggable databases again.
[code] [oracle@orcl19c 30557433]$ lsnrctl start LISTENER LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 02-MAY-2020 11:02:14 Copyright (c) 1991, 2019, Oracle. All rights reserved. Starting /u01/app/oracle/product/19.0.0/dbhome_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 19.0.0.0.0 - Production System parameter file is /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/orcl19c/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl19c.oracledbashop.com)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl19c.oracledbashop.com)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 02-MAY-2020 11:02:14 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/orcl19c/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl19c.oracledbashop.com)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) The listener supports no services The command completed successfully [oracle@orcl19c 30557433]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sat May 2 11:02:19 2020 Version 19.6.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 893385440 bytes Fixed Size 9140960 bytes Variable Size 318767104 bytes Database Buffers 557842432 bytes Redo Buffers 7634944 bytes Database mounted. Database opened. SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> column name format a30 SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE ------------------------------ ---------- PDB$SEED READ ONLY ORCL1PDB MOUNTED PDB1 MOUNTED RCAT MOUNTED SQL> alter pluggable database all open; Pluggable database altered. SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE ------------------------------ ---------- PDB$SEED READ ONLY ORCL1PDB READ WRITE PDB1 READ WRITE RCAT READ WRITE SQL> [/code]
5.The next step, "datapatch", requires my databases and PDBs to be open
[code] [oracle@orcl19c 30557433]$ pwd /u01/patch/30557433 [oracle@orcl19c 30557433]$ /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/datapatch -verbose SQL Patching tool version 19.6.0.0.0 Production on Sat May 2 11:05:17 2020 Copyright (c) 2012, 2019, Oracle. All rights reserved. Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_22254_2020_05_02_11_05_17/sqlpatch_invocation.log Connecting to database...OK Gathering database info...done 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 interim SQL patches: No interim patches found Current state of release update SQL patches: Binary registry: 19.6.0.0.0 Release_Update 191217155004: Installed PDB CDB$ROOT: Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 20-JAN-20 11.16.12.311115 PM PDB ORCL1PDB: Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 20-JAN-20 11.24.50.669547 PM PDB PDB$SEED: Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 20-JAN-20 11.24.50.669547 PM PDB PDB1: Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 20-JAN-20 11.24.50.669547 PM PDB RCAT: Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 20-JAN-20 11.24.50.669547 PM Adding patches to installation queue and performing prereq checks...done Installation queue: For the following PDBs: CDB$ROOT PDB$SEED ORCL1PDB PDB1 RCAT No interim patches need to be rolled back Patch 30557433 (Database Release Update : 19.6.0.0.200114 (30557433)): Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.6.0.0.0 Release_Update 191217155004 No interim patches need to be applied Installing patches... Patch installation complete. Total patches installed: 5 Validating logfiles...done Patch 30557433 apply (pdb CDB$ROOT): SUCCESS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30557433/23305305/30557433_apply_ORCL1_CDBROOT_2020May02_11_06_37.log (no errors) Patch 30557433 apply (pdb PDB$SEED): SUCCESS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30557433/23305305/30557433_apply_ORCL1_PDBSEED_2020May02_11_10_32.log (no errors) Patch 30557433 apply (pdb ORCL1PDB): SUCCESS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30557433/23305305/30557433_apply_ORCL1_ORCL1PDB_2020May02_11_10_32.log (no errors) Patch 30557433 apply (pdb PDB1): SUCCESS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30557433/23305305/30557433_apply_ORCL1_PDB1_2020May02_11_10_32.log (no errors) Patch 30557433 apply (pdb RCAT): SUCCESS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30557433/23305305/30557433_apply_ORCL1_RCAT_2020May02_11_10_32.log (no errors) SQL Patching tool complete on Sat May 2 11:21:15 2020 [oracle@orcl19c 30557433]$ [/code]
No comments:
Post a Comment