DESCRIPTION

This article we are going to see steps to apply the latest Oracle 19c Database Release Update Patch 32218454

DOWNLOAD THE PATCH FROM ORACLE SUPPORT

 CHECK THE CURRENT OPTACH VERSION IN THE DATABASE

 

oracle@oracle19c ~]$ export PATH=/u01/app/oracle/product/19.0.0/db_1/OPatch:$PATH

[oracle@oracle19c ~]$ opatch version

OPatch Version: 12.2.0.1.17

OPatch succeeded.

MOVE THE PATCH TO ORACLE HOME LOCATION

[oracle@oracle19c ~]$ cd Desktop/

[oracle@oracle19c Desktop]$ ls

p6880880_200000_LINUX.zip

[oracle@oracle19c Desktop]$ mv p6880880_190000_LINUX.zip $ORACLE_HOME

NOTE:We need to Upgrade Opatch from “12.2.0.1.17 to 12.2.0.1.23” for applying Patch “32218454”.

 

UNZIP THE DOWNLOADED OPATCH

 

[oracle@oracle19c db_1]$ unzip p6880880_190000_LINUX.zip

Archive:  p6880880_190000_LINUX.zip

replace OPatch/emdpatch.pl? [y]es, [n]o, [A]ll, [N]one, [r]ename: A

  inflating: OPatch/emdpatch.pl      

  inflating: OPatch/oracle_common/modules/com.oracle.glcm.common-logging_1.6.5.0.jar  

  inflating: OPatch/oracle_common/modules/common-logging-config.jar  

  inflating: OPatch/oplan/oplan      

  inflating: OPatch/datapatch        

                     :

                     :

                     :

Continues

  inflating: OPatch/modules/thirdparty/jackson-databind-2.10.2.jar  

  inflating: OPatch/modules/thirdparty/jackson-annotations-2.10.2.jar




[oracle@oracle19c db_1]$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_1

[oracle@oracle19c db_1]$ export PATH=/u01/app/oracle/product/19.0.0/db_1/OPatch:$PATH

 

BEFORE APPLYING THE PATCH CHECK THE STATUS

SQL> col comp_id for a10

col version for a11

col status for a10

col comp_name for a37

select comp_id,comp_name,version,status from dba_registry;




COMP_ID    COMP_NAME         VERSION    STATUS

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

CATALOG    Oracle Database Catalog Views           19.0.0.0.0   VALID

CATPROC    Oracle Database Packages and Types       19.0.0.0.0  VALID

RAC    Oracle Real Application Clusters               19.0.0.0.0  OPTION OFF

JAVAVM    JServer JAVA Virtual Machine               19.0.0.0.0  VALID

XML    Oracle XDK               19.0.0.0.0  VALID

CATJAVA    Oracle Database Java Packages           19.0.0.0.0  VALID

APS    OLAP Analytic Workspace                    19.0.0.0.0  VALID

XDB    Oracle XML Database                19.0.0.0.0  VALID

OWM    Oracle Workspace Manager            19.0.0.0.0  VALID

CONTEXT    Oracle Text                19.0.0.0.0  VALID

ORDIM    Oracle Multimedia                19.0.0.0.0  VALID

SDO    Spatial                        19.0.0.0.0  VALID

XOQ    Oracle OLAP API                19.0.0.0.0  VALID

OLS    Oracle Label Security                        19.0.0.0.0  VALID

DV    Oracle Database Vault                    19.0.0.0.0  VALID

15 rows selected.

 

SHUTDOWN DATABASE AND LISTENER

 

[oracle@oracle19c db_1]$ sqlplus / as sysdba

SQL> shut immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> Disconnected

[oracle@oracle19c db_1]$ lsnrctl stop

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 25-JAN-2021 16:23:50

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle19c.localdomain)(PORT=1521)))

The command completed successfully

 

MOVE THE PATCH TO ORACLE HOME LOCATION

oracle@oracle19c Desktop]$ mv p32218454_190000_Linux-x86-64.zip /u01/app/oracle/product/19.0.0/db_1/PATCH2021




[oracle@oracle19c Desktop]$ cd /u01/app/oracle/product/19.0.0/db_1/PATCH2021

 

UNZIP THE PATCH

 

[oracle@oracle19c PATCH2021]$ unzip p32218454_190000_Linux-x86-64.zip

Archive:  p32218454_190000_Linux-x86-64.zip

   creating: 32218454/

   creating: 32218454/etc/

   creating: 32218454/etc/config/

  inflating: 32218454/etc/config/inventory.xml  

  inflating: 32218454/etc/config/actions.xml  

   creating: 32218454/files/

   creating: 32218454/files/jlib/

   creating: 32218454/files/jlib/oraclepki.jar/

   creating: 32218454/files/jlib/oraclepki.jar/oracle/

   creating: 32218454/files/jlib/oraclepki.jar/oracle/security/

   creating: 32218454/files/jlib/oraclepki.jar/oracle/security/pki/

  inflating: 32218454/files/jlib/oraclepki.jar/oracle/security/pki/PKIConstants.class  

   creating: 32218454/files/jlib/oraclepki.jar/oracle/security/pki/textui/

  inflating:  

               :

               :

               :

continues  

   creating: 32218454/custom/

   creating: 32218454/custom/scripts/

  inflating: 32218454/custom/scripts/prepatch.sh  

  inflating: 32218454/custom/scripts/init  

  inflating: 32218454/README.html    

 extracting: 32218454/README.txt     

  inflating: PatchSearch.xml

 

APPLY RU PATCH ON ORACLE_HOME 19C

[oracle@oracle19c 32218454]$ opatch apply

Oracle Interim Patch Installer version 12.2.0.1.23

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

Oracle Home       : /u01/app/oracle/product/19.0.0/db_1

Central Inventory : /u01/app/oraInventory

from           : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc

OPatch version    : 12.2.0.1.23

OUI version       : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2021-01-26_11-01-55AM_1.log

 

Verifying environment and performing prerequisite checks…

 

——————————————————————————–

Start OOP by Prereq process.

Launch OOP…

 

Oracle Interim Patch Installer version 12.2.0.1.23

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

Oracle Home       : /u01/app/oracle/product/19.0.0/db_1

Central Inventory : /u01/app/oraInventory

from           : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc

OPatch version    : 12.2.0.1.23

OUI version       : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2021-01-26_11-07-27AM_1.log

 

Verifying environment and performing prerequisite checks…

OPatch continues with these patches:   32218454

 

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/db_1’)

 

 

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files…

Applying interim patch ‘32218454’ to OH ‘/u01/app/oracle/product/19.0.0/db_1’

ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.xdk.companion, 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…

 

CONTINUES….

 

Patching component oracle.network.client, 19.0.0.0.0…

 

Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0…

 

Patching component oracle.precomp.common, 19.0.0.0.0…

 

Patching component oracle.precomp.lang, 19.0.0.0.0…

 

Patching component oracle.jdk, 1.8.0.201.0…

STARTUP THE DATABASE AND LISTENER

 

[oracle@oracle19c 32218454]$ lsnrctl start




LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 26-JAN-2021 11:31:09




Copyright (c) 1991, 2020, Oracle.  All rights reserved.




Starting /u01/app/oracle/product/19.0.0/db_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/db_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/diag/tnslsnr/oracle19c/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle19c.localdomain)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))




Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle19c.localdomain)(PORT=1521)))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production

Start Date                26-JAN-2021 11:31:10

Uptime                    0 days 0 hr. 0 min. 21 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/product/19.0.0/db_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/diag/tnslsnr/oracle19c/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle19c.localdomain)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

The listener supports no services

The command completed successfully




SQL> startup

ORACLE instance started.




Total System Global Area 3992976600 bytes

Fixed Size     8903896 bytes

Variable Size   922746880 bytes

Database Buffers  3053453312 bytes

Redo Buffers     7872512 bytes

Database mounted.

Database opened.

[oracle@oracle19c ~]$ cd /u01/app/oracle/product/19.0.0/db_1

[oracle@oracle19c db_1]$ cd PATCH2021/

[oracle@oracle19c PATCH2021]$ cd 32218454/

[oracle@oracle19c 32218454]$ cd $ORACLE_HOME/OPatch

EXECUTE POST PATCH STEPS AND RUN DATAPATCH COMMAND

 

[oracle@oracle19c OPatch]$ ./datapatch -verbose

SQL Patching tool version 19.10.0.0.0 Production on Tue Jan 26 11:34:14 2021

Copyright (c) 2012, 2020, Oracle.  All rights reserved.




Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_15885_2021_01_26_11_34_14/sqlpatch_invocation.log




Connecting to database...OK

Gathering database info...done

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.10.0.0.0 Release_Update 210108185017: Installed

  SQL registry:

    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 22-JAN-21 12.46.45.828002 PM




Adding patches to installation queue and performing prereq checks...done

Installation queue:

  No interim patches need to be rolled back

  Patch 32218454 (Database Release Update : 19.10.0.0.210119 (32218454)):

    Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.10.0.0.0 Release_Update 210108185017

  No interim patches need to be applied

AFTER APPLYING RU PATCH,CHECK THE DBA_REGISTRY_SQLPATCH

col comp_id for a10

col version for a11

col status for a10

col comp_name for a37

select comp_id,comp_name,version,status from dba_registry;

OUTPUT FOR THE ABOVE COMMAND SHOWN BELOW SCREEN SHOT

 

 

USING BELOW QUERY, WE CAN VERIFY DESCRIPTION,STATUS OF APPLIED PATCH

 

COLUMN action FORMAT A10

COLUMN status FORMAT A30

COLUMN description FORMAT A30

SELECT action_time,action,status,description,patch_id dba_registry_sqlpatch;

CHECK OPATCH LSINVENTORY AND LIST OF PATCHES APPLIED.

 

[oracle@oracle19c ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_1

[oracle@oracle19c ~]$ export PATH=/u01/app/oracle/product/19.0.0/db_1/OPatch:$PATH

[oracle@oracle19c ~]$ opatch lspatches

32218454;Database Release Update : 19.10.0.0.210119 (32218454)

29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)

 

OPatch succeeded.

 AFTER THE EXECUTION OF DATAPATCH SHOULD RUN UTLRP.SQL TO CLEAR INVALID OBJECT.

 SQL>  @?/rdbms/admin/utlrp.sql




Session altered.

CHECK THE ACTION & PATCHID IN DBA_REGISTRY_SQLPATCH

 

 

 

 

Recent Posts

Start typing and press Enter to search