Table Level Export & Import in Oracle 19c using Data pump.

DESCRIPTION:

In this Blog, we will learn how to use the Oracle Data Pump Export and Import utility in Oracle 19c database

        A table-mode import is specified using the TABLES parameter. In table mode, only the specified set of tables, partitions, and their dependent objects are loaded. The source can be a full, schema, table space, or table-mode export dump file set or another database.

Create a table with an encrypted column and insert rows:

SQL> select * from table01;

ID NAME

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

 1 aaa

 2 bbb

 3 ccc

 4 ddd

 5 eee

Before start the Export Process, we need to create a Directory which is used to store the dump file.Data Pump is a server-based technology, so it typically deals with directory objects pointing to physical directories on the database server.

Dumpfile:  The name of the exported dump file.

Logfile:  The name of the directory object that is used to store the log file of the export operation, i.e. the name of the log file

Export the dump file of the table:

Directory Name:MY_Dir

Table Name: Table01

[oracle@oracle19c ~]$ expdp directory=My_Dir dumpfile=table01.dmp logfile=table01.log tables='table01';

Export: Release 19.0.0.0.0 - Production on Mon Jan 25 08:39:53 2021

Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Username: data

Password:

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Starting "DATA"."SYS_EXPORT_TABLE_01":  data/******** directory=My_Dir dumpfile=table01.dmp logfile=table01.log tables=table01

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER

Processing object type TABLE_EXPORT/TABLE/TABLE

. . exported "DATA"."TABLE01"                            5.515 KB       5 rows

Master table "DATA"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

******************************************************************************

Dump file set for DATA.SYS_EXPORT_TABLE_01 is:

  /u01/app/oracle/oradata/table01.dmp

Job "DATA"."SYS_EXPORT_TABLE_01" successfully completed at Mon Jan 25 08:40:05 2021 elapsed 0 00:00:08
[oracle@oracle19c ~]$ !sq

sqlplus / as sysdba;

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 25 08:40:09 2021

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> conn data/pump

Connected.

Drop the table: 

SQL> drop table table01;

 Table dropped.

SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@oracle19c ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 25 08:41:28 2021

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> conn data/pump

Connected.

SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

The Data Pump Import utility is started using the impdp command

The following example is a command to import Tables using Dump file.

Dumpfile:table01.dmp

[oracle@oracle19c ~]$ impdp directory=My_Dir dumpfile=table01.dmp logfile=table01.log;

Import: Release 19.0.0.0.0 - Production on Mon Jan 25 08:42:02 2021

Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Username: data

Password:

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Master table "DATA"."SYS_IMPORT_FULL_01" successfully loaded/unloaded

Starting "DATA"."SYS_IMPORT_FULL_01":  data/******** directory=My_Dir dumpfile=table01.dmp logfile=table01.log

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

. . imported "DATA"."TABLE01"                            5.515 KB       5 rows

Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER

Job "DATA"."SYS_IMPORT_FULL_01" successfully completed at Mon Jan 25 08:42:21 2021 elapsed 0 00:00:14
[oracle@oracle19c ~]$ !sq

sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 25 08:42:27 2021

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> conn data/pump

Connected.

Finally, verify the contents of the Imported table:

SQL> select * from table01;

ID NAME

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

 1                   aaa

 2                   bbb

 3                   ccc

 4                  ddd

 5                  eee

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

Convert Non CDB to CDB in Oracle 12c

Description:-

The multitenant option introduced in Oracle Database 12c allows a single container database (CDB) to host multiple separate pluggable databases (PDB). DBMS_PDB package permits to generate an XML metadata file from a non-CDB 12c database, Its like a unplug a Pluggable database. This is the article which will guide step-by-step Converting Non CDB to CDB in Oracle Database 12c Release.

Step 1: Check the database its properly up and running. shutdown the non-CDB and start it in read-only mode.

Non Container Database Name : NONCDB

Container database Name     : ORA_CDB

Non Container Database (Noncdb)

[oracle@localhost ~]$ . ora12c.env

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Jan 21 14:45:36 2021

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production

SQL> select name,open_mode from v$database;

NAME   OPEN_MODE


NONCDB   READ WRITE

SQL> SELECT name, open_mode FROM v$pdbs;
no rows selected

Container database Name (Ora_cdb)

[oracle@localhost ~]$ . oracdb.env

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Jan 21 14:56:55 2021

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.
Total System Global Area 1258291200 bytes
Fixed Size     8792296 bytes
Variable Size   872417048 bytes
Database Buffers   369098752 bytes
Redo Buffers     7983104 bytes
Database mounted.
Database opened.

SQL> select name,open_mode from v$database;

NAME   OPEN_MODE


ORA_CDB   READ WRITE

SQL> col name for a20

SQL> select name, open_mode FROM v$pdbs;

NAME      OPEN_MODE


PDB$SEED      READ ONLY

CDB                READ WRITE

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

Step 2: Shutdown the non-CDB database and start it in read-only mode.

SQL> shutdown immediate ;

Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.
Total System Global Area 1258291200 bytes
Fixed Size     8620224 bytes
Variable Size   872417088 bytes
Database Buffers   369098752 bytes
Redo Buffers     8155136 bytes
Database mounted.

SQL> alter database open read only;

Database altered.

Step 3: Create the XML file needed for cdb conversion. the non-cdb database using the DBMS_PDB_DESCRIBE procedure  creates an XML file in the same way that the unplug operation does for a PDB. 

 SQL> BEGIN
DBMS_PDB.DESCRIBE(
pdb_descr_file => ‘/tmp/noncdb.xml’);
END;
/

Step 4:Shutdown the NON-CDB database ( Noncdb).

SQL> shutdown immediate ;

Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

Step 5: Open the cdb database (ORA_CDB)

[oracle@localhost Desktop]$ cd

[oracle@localhost ~]$ . oracdb.env

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Jan 19 20:36:39 2021

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.
Total System Global Area 1258291200 bytes
Fixed Size     8792296 bytes
Variable Size   872417048 bytes
Database Buffers   369098752 bytes
Redo Buffers     7983104 bytes
Database mounted.
Database opened.

SQL>  select name,open_mode,cdb from v$database;

NAME   OPEN_MODE          CDB


ORA_CDB   READ WRITE        YES

Step 6: Check the compatibility of PDB in ( ORA_CDB).

SQL> SET SERVEROUTPUT ON;
DECLARE
compatible CONSTANT VARCHAR2(3) := CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY(pdb_descr_file => ‘/tmp/noncdb.xml’)
WHEN TRUE THEN ‘YES’
ELSE ‘NO’
END;
BEGIN
DBMS_OUTPUT.PUT_LINE(compatible);
END;
/

Step 7: Check the violations of PDB in (ORA_CDB).

 SQL> select name,cause,type,message,status from PDB_PLUG_IN_VIOLATIONS where name=’NONCDB’;

Step 8: Create pluggable database in container db (ORA_CDB).

 SQL> create pluggable database pdb1 using ‘/tmp/noncdb.xml’ NOCOPY;

create pluggable database pdb1 using ‘/tmp/noncdb.xml’ NOCOPY

*ERROR at line 1:
ORA-27038: created file already exists
ORA-01119: error in creating database file

‘/u01/app/oracle/oradata/NONCDB/datafile/o1_mf_temp_j0lhxlpy_.tmp’

Note: As tempfile is already there, so mention tempfile reuse tag, to avoid this error.

SQL> create pluggable database pdb1 using ‘/tmp/noncdb.xml’ NOCOPY tempfile reuse;

Step 9: Switch to the PDB container and run the “$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql” script to clean up the new PDB, removing any items that should not be present in a PDB.

SQL> ALTER SESSION SET CONTAINER=pdb1;

SQL> @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql

Step 10: Startup the PDB and check the open mode PDB.

SQL> alter Pluggable database pdb1 open;

SQL> SELECT name, open_mode FROM v$pdbs;

The non-cdb database has been converted to CDB now successfully.

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

Oracle Critical Patch Update for January 2021

ORACLE DATABASE PATCHING – JANUARY 2021 UPDATE

The Critical Patch Update for January 2021 was released on January 19, 2021. Oracle strongly recommends applying the patches as soon as possible.

In this document we are going to see how to download and apply Jan 2021 patch.

ORACLE DATABASE PATCHING – JANUARY 2021 UPDATE

Search and download patch from oracle support site.

Go to Dashboard and then Patches and Updates.

Once window will open and it will ask for the product, release and the platform as shown below.

we need to choose 32228578 PATCH

Click on the download option to download the patch. As well as download the read me file. From there you will get an idea to moving forward.

MOVE THE DOWNLOADED PATCH TO ORACLE_HOME LOCATION

UNZIP THE PATCH – To get the updated opatch version

[oracle@trichy PATCH2021]$ unzip p32228578_122010_Linux-x86-64.zip

RUN THE PRE REQ BEFORE APPLYING THE PATCH

[oracle@trichy PATCH2021]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Oracle Interim Patch Installer version 12.2.0.1.19

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

PREREQ session

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

Central Inventory : /u01/app/oraInventory

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

OPatch version    : 12.2.0.1.19

OUI version       : 12.2.0.1.4

Log file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2021-01-20_10-21-26AM_1.log

Invoking prereq “checkconflictagainstohwithdetail”

Prereq “checkConflictAgainstOHWithDetail” passed.

OPatch succeeded.

[oracle@trichy 32228578]$ $ORACLE_HOME/OPatch/opatch prereq CheckActiveFilesAndExecutables -ph ./

Oracle Interim Patch Installer version 12.2.0.1.19

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

PREREQ session

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

Central Inventory : /u01/app/oraInventory

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

OPatch version    : 12.2.0.1.19

OUI version       : 12.2.0.1.4

Log file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2021-01-20_10-23-55AM_1.log

Invoking prereq “checkactivefilesandexecutables”

Prereq “checkActiveFilesAndExecutables” for patch 32228578 passed.

OPatch succeeded.

SHUTDOWN DATABASE AND THE LISTENER.

SQL> shutdown

Database closed.

Database dismounted.

ORACLE instance shut down.

[oracle@trichy PATCH2021]$ lsnrctl stop

LSNRCTL for Linux: Version 12.2.0.1.0 – Production on 20-JAN-2021 10:53:22

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.22)(PORT=1537)))

The command completed successfully.

 

GO TO THE PATCH FOLDER AND APPLY THE PATCH.

BEFORE APPLYING PATCH EXPORT THE PATH OF OPATCH FOLDER.

 

[oracle@trichy ~]$ cd /u01/PATCH2021/32228578/

[oracle@trichy 32228578]$ export PATH=/u01/app/oracle/product/12.2.0.1/db_1/OPatch:$PATH

[oracle@trichy 32228578]$ opatch version

OPatch Version: 12.2.0.1.19

OPatch succeeded.

[oracle@trichy 32228578]$ opatch apply

Oracle Interim Patch Installer version 12.2.0.1.19

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

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

Central Inventory : /u01/app/oraInventory

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

OPatch version    : 12.2.0.1.19

OUI version       : 12.2.0.1.4

Log file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2021-01-20_11-45-30AM_1.log

Verifying environment and performing prerequisite checks…

Prerequisite check “CheckMinimumOPatchVersion” failed.

The details are:

The OPatch being used has version 12.2.0.1.19 while the following patch(es) require higher versions:

Patch 32228578 requires OPatch version 12.2.0.1.23.

Please download latest OPatch from My Oracle Support.

UtilSession failed: Prerequisite check “CheckMinimumOPatchVersion” failed.

Log file location: /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2021-01-20_11-45-30AM_1.log

OPatch failed with error code 73

CHECK THE OPATCH VERSION USING BELOW COMMAND – This patch requires a updated Opatch version.

DOWNLOAD LATEST VERSION OF OPATCH TO APPLY THE RECENT PATCH

[oracle@trichy OPATCH]$ ll

total 119552

drwxr-x—. 15 oracle oinstall      4096 Nov  6 01:20 OPatch

-rwxrw-rw-.  1 oracle oinstall 122415188 Jan 20 11:58 p6880880_200000_LINUX.zip

UNZIP THE OPATCH

[oracle@trichy OPATCH]$ unzip p6880880_200000_LINUX.zip

inflating: OPatch/auto/core/modules/legacyoui/com.oracle.cie.comdev_7.8.5.0.jar

inflating: OPatch/auto/core/modules/legacyoui/com.oracle.cie.gdr-schema_1.8.5.0.jar

inflating: OPatch/auto/core/modules/legacyoui/legacyoui.classpath.jar

inflating: OPatch/auto/core/modules/com.oracle.glcm.patch.opatchauto-actions_13.9.4.5.jar

inflating: OPatch/auto/core/modules/com.oracle.glcm.osyscore.automation_13.9.1.0.jar

inflating: OPatch/auto/core/modules/com.oracle.glcm.osyscore.validation_13.9.1.0.jar

creating: OPatch/auto/core/modules/features/

inflating: OPatch/auto/core/modules/features/oracle.glcm.opatchauto.core.binary.classpath.jar

inflating: OPatch/auto/core/modules/features/oracle.glcm.opatchauto.core.classpath.jar

inflating: OPatch/auto/core/modules/features/oracle.glcm.oplan.core.classpath.jar

inflating: OPatch/auto/core/modules/features/opatchauto-binary-classpath.jar

inflating: OPatch/auto/core/modules/features/oracle.glcm.osys.core.classpath.jar

inflating: OPatch/auto/core/modules/com.oracle.glcm.osyscore.utils_13.9.1.0.jar

inflating: OPatch/auto/core/modules/com.oracle.glcm.patch.opatchauto-binary_13.9.4.5.jar

inflating: OPatch/auto/core/modules/com.oracle.glcm.osyscore.model_13.9.1.0.jar

creating: OPatch/auto/dbsessioninfo/

inflating: OPatch/auto/dbsessioninfo/README.txt

creating: OPatch/private/

inflating: OPatch/private/commons-compress-1.19.jar

inflating: OPatch/opatch_env.sh

inflating: OPatch/opatchauto

inflating: OPatch/operr

inflating: OPatch/opatchauto.cmd

inflating: OPatch/auto/core/modules/com.oracle.glcm.osyscore.validation_13.9.1.0.jar

inflating: OPatch/auto/core/modules/features/oracle.glcm.opatchauto.core.binary.classpath.jar

inflating: OPatch/auto/core/modules/features/oracle.glcm.opatchauto.core.classpath.jar

inflating: OPatch/auto/core/modules/features/oracle.glcm.oplan.core.classpath.jar

inflating: OPatch/auto/core/modules/features/opatchauto-binary-classpath.jar

inflating: OPatch/auto/core/modules/features/oracle.glcm.osys.core.classpath.jar

inflating: OPatch/auto/core/modules/com.oracle.glcm.osyscore.utils_13.9.1.0.jar

inflating: OPatch/auto/core/modules/com.oracle.glcm.patch.opatchauto-binary_13.9.4.5.jar

inflating: OPatch/auto/core/modules/com.oracle.glcm.osyscore.model_13.9.1.0.jar

inflating: OPatch/auto/dbsessioninfo/README.txt

creating: OPatch/private/

inflating: OPatch/private/commons-compress-1.19.jar

inflating: OPatch/opatch_env.sh

inflating: OPatch/opatchauto

inflating: OPatch/operr

inflating: OPatch/opatchauto.cmd

[oracle@trichy OPatch]$ $ORACLE_HOME/OPatch/opatch version

OPatch Version: 12.2.0.1.23

OPatch succeeded.

 

CHECK AND VERIFY THE INVENTORY FOR THE LATEST APPLIED PATCH. IT WILL SHOW THE LATEST APPLIED PATCH

 

[oracle@trichy 32228578]$ $ORACLE_HOME/OPatch/opatch prereq CheckActiveFilesAndExecutables -ph ./

Oracle Interim Patch Installer version 12.2.0.1.23

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

PREREQ session

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

Central Inventory : /u01/app/oraInventory

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

OPatch version    : 12.2.0.1.23

OUI version       : 12.2.0.1.4

Log file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2021-01-20_14-23-55PM_1.log

Invoking prereq “checkactivefilesandexecutables”

Prereq “checkActiveFilesAndExecutables” for patch 32228578 passed.

OPatch succeeded.

 

ONCE OPATCH IS VERIFIED PROCEED START APPLY PATCH 32228578: DATABASE JAN 2021 RELEASE UPDATE 12.2.0.1.23

 

[oracle@trichy 32228578]$ 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/12.2.0.1/db_1

Central Inventory : /u01/app/oraInventory

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

OPatch version    : 12.2.0.1.23

OUI version       : 12.2.0.1.4

Log file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2021-01-20_14-27-38PM_1.log

 

Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 32228578

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/12.2.0/db_1_2’)

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

y

User Responded with: Y

Backing up files…

Applying interim patch ‘32228578’to OH ‘/u01/app/oracle/product/12.2.0/db_1_2’

ApplySession: Optional component(s) [ oracle.swd.oui, 12.2.0.1.0 ] , [ oracle.oid.client,

12.2.0.1.0 ] , [ oracle.has.crs, 12.2.0.1.0 ] , [ oracle.rdbms.drdaas, 12.2.0.1.0 ] , [

oracle.ons.daemon, 12.2.0.1.0 ] , [ oracle.network.cman, 12.2.0.1.0 ] not present in the

Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 12.2.0.1.0…

Patching component oracle.rdbms, 12.2.0.1.0…

Patching component oracle.rdbms.util, 12.2.0.1.0…

Patching component oracle.network.rsf, 12.2.0.1.0…

Patching component oracle.ctx, 12.2.0.1.0…

Patching component oracle.ctx.rsf, 12.2.0.1.0…

Patching component oracle.has.common.cvu, 12.2.0.1.0…

Patching component oracle.ldap.rsf, 12.2.0.1.0…

Patching component oracle.rdbms.dbscripts, 12.2.0.1.0…

Patching component oracle.rdbms.deconfig, 12.2.0.1.0…

Patching component oracle.rdbms.rsf.ic, 12.2.0.1.0…Patching component oracle.sdo, 12.2.0.1.0…

Patching component oracle.sdo.locator, 12.2.0.1.0…

Patching component oracle.tfa, 12.2.0.1.0…

Patching component oracle.xdk.parser.java, 12.2.0.1.0…

Patching component oracle.rdbms.dv, 12.2.0.1.0…

Patching component oracle.precomp.rsf, 12.2.0.1.0…

Patching component oracle.rdbms.crs, 12.2.0.1.0…

Patching component oracle.rdbms.rman, 12.2.0.1.0…

Patching component oracle.rdbms.install.plugins, 12.2.0.1.0…

Patching component oracle.sqlplus, 12.2.0.1.0…

Patching component oracle.ons, 12.2.0.1.0…

Patching component oracle.oraolap, 12.2.0.1.0…

Patching component oracle.xdk.rsf, 12.2.0.1.0…

Patching component oracle.xdk, 12.2.0.1.0…

Patching component oracle.rdbms.lbac, 12.2.0.1.0…

Patching component oracle.sqlplus.ic, 12.2.0.1.0…

Patching component oracle.assistants.server, 12.2.0.1.0…

Patching component oracle.nlsrtl.rsf, 12.2.0.1.0…

Patching component oracle.assistants.deconfig, 12.2.0.1.0…

Patching component oracle.ldap.rsf.ic, 12.2.0.1.0…

Patching component oracle.ldap.client, 12.2.0.1.0…

Patching component oracle.assistants.acf, 12.2.0.1.0…

Patching component oracle.rdbms.oci, 12.2.0.1.0…

Patching component oracle.install.deinstalltool, 12.2.0.1.0…

Patching component oracle.oracore.rsf, 12.2.0.1.0…

Patching component oracle.precomp.lang, 12.2.0.1.0…

Patching component oracle.precomp.common, 12.2.0.1.0…

Patching component oracle.jdk, 1.8.0.91.0…

Patch 32228578successfully applied.

Log file location: /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2021-01-20_14-27-38PM_1.log

OPatch succeeded.

 

CHECK AND VERIFY THE INVENTORY FOR THE LATEST APPLIED PATCH.

IT WILL SHOW YOU THE LATEST APPLIED PATCH

[oracle@trichy32228578]$ opatch lsinventory|grep “Patch description”

Patch description:  “Database Jan 2021 Release Update : 12.2.0.1.210119 (32228578)”

 

GET DETAILED INFO USING OPATCH LSINVENTORY

 

[oracle@trichy32228578]$ opatch lsinventory

Oracle Interim Patch Installer version 12.2.0.1.23

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

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

Central Inventory : /u01/app/oraInventory

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

OPatch version    : 12.2.0.1.23

OUI version       : 12.2.0.1.4

Log file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2021-01-20_14-49-13PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/lsinv/lsinventory2021-01-20_14-49-13PM.txt


Local Machine Information::

Hostname: localhost

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c                                                  12.2.0.1.0

There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch  32228578     : applied on Wed Jan 20 14:47:29 IST 2021

Unique Patch ID:  24008225

Patch description:  “Database Jan 2021 Release Update : 12.2.0.1.210119 (32228578)”

Created on 9 Jan 2021, 06:42:05 hrs PST8PDT

Bugs fixed:

7391838, 8480838, 8932139, 8975044, 12763598, 13554903, 14221306

14690846, 15931756, 16002385, 16438495, 16727454, 16942578, 17027695

17533661, 17947871, 17958365, 18308268, 18521691, 18594510, 18774543

18878420, 18986501, 19072655, 19211433, 19285025, 19327292, 19526548

19614243, 19647894, 19649997, 19702201, 19721304, 20003668, 20087519

20118035, 20120236, 20324049, 20436508, 20532077, 20549013, 20588486

20591151, 20617383, 20620169, 20736227, 20756305, 20866970, 20917487

20976443, 21070321, 21089435, 21095391, 21143725, 21147908, 21159907

21178363, 21186167, 21197098, 21216226, 21320338, 21355390, 21433452

21479706, 21517767, 21520266, 21547051, 21638600, 21744603, 21788462

21837606, 21882528, 21935698, 21962287, 21981529, 21985256, 22007324

22070226, 22070473, 22070853, 22072543, 22087683, 22104866, 22107360

22174392, 22179537, 22282748, 22310426, 22347493, 22363790, 22364044

22367053, 22379010, 22446455, 22454940, 22468255, 22495673, 22503283

22503297, 22504793, 22522515, 22530986, 22564336, 22568728, 22581771

22594071, 22599050, 22628825, 22645009, 22645496, 22654475, 22700845

22726044, 22729345, 22820798, 22826067, 22843979, 22845846, 22864303

22898198, 22921674, 22939829, 22950945, 22970869, 22981722, 23018676

23019710, 23026585, 23035249, 23055900, 23056058, 23061453, 23065002

23066146, 23080557, 23104033, 23105538, 23109325, 23110523, 23125560

23126545, 23127945, 23143074, 23151677, 23168363, 23169712, 23177923

23179662, 23184263, 23197730, 23234232, 23237091, 23249829, 23271203

23278750, 23281269, 23282973, 23300142, 23306590, 23308065, 23310101

23312077, 23328639, 23333567, 23336559, 23342170, 23481673, 23491861

23499004, 23499160, 23521523, 23527363, 23533647, 23548817, 23567857

23572982, 23581777, 23588722, 23599216, 23600861, 23602213, 23645516

23665623, 23709062, 23715460, 23715518, 23730961, 23733981, 23735292

23738304, 23741944, 23743596, 23746128, 23749454, 23761724, 23763462

24006569, 24010030, 24289874, 24289895, 24294174, 24303148, 24307571

24308349, 24326444, 24326846, 24328857, 24330708, 24332831, 24334708

24336249, 24337882, 24341675, 24343905, 24345420, 24346821, 24348685

24350620, 24352981, 24355111, 24357348, 24368004, 24371491, 24373528

24373756, 24374976, 24376875, 24376878, 24383086, 24385983, 24401351

24403922, 24409977, 24415926, 24416451, 24421668, 24423416, 24425056

24425998, 24432875, 24435982, 24437162, 24440612, 24440648, 24443539

24445571, 24457597, 24460392, 24461826, 24467122, 24468470, 24470606

24471079, 24471473, 24473736, 24484749, 24485034, 24485161, 24485174

24485619, 24486059, 24486237, 24509056, 24516314, 24530364, 24534401

24554533, 24555417, 24556862, 24556967, 24560906, 24563422, 24570214

24570598, 24573817, 24578718, 24578797, 24588377, 24589081, 24589590

24591506, 24593740, 24595699, 24596874, 24600330, 24609592, 24609996

24611527, 24616637, 24617969, 24623975, 24624166, 24642495, 24654629

24655717, 24664211, 24668398, 24669189, 24669730, 24674197, 24674955

24676172, 24677696, 24680959, 24687075, 24689376, 24692973, 24693010

24693290, 24697323, 24699619, 24710696, 24713381, 24714096, 24717183

24717859, 24718260, 24719799, 24735430, 24737064, 24737403, 24737581

24737954, 24739791, 24744383, 24744686, 24752618, 24757934, 24759556

24760407, 24763196, 24764085, 24766309, 24784414, 24786669, 24791883

24792678, 24793511, 24796092, 24797119, 24798481, 24800423, 24801152

24802934, 24808504, 24811725, 24812047, 24818566, 24827228, 24827654

24831514, 24835919, 24841671, 24843188, 24844549, 24844841, 24845157

24848746, 24848923, 24850622, 24907917, 24908063, 24908321, 24911709

24912588, 24920582, 24921478, 24922704, 24923080, 24923215, 24923338

24923790, 24924667, 24926999, 24929210, 24938784, 24940060, 24942749

24953434, 24957555, 24960044, 24960809, 24965426, 24966594, 24966788

24967993, 24968162, 24976007, 24978100, 25022574, 25027852, 25028996

25029022, 25029423, 25031502, 25032818, 25034396, 25036006, 25036474

25042823, 25044977, 25045228, 25050160, 25051465, 25051628, 25054064

25057811, 25058080, 25060506, 25062592, 25063971, 25065563, 25072986

25077278, 25078611, 25086233, 25087436, 25091141, 25092777, 25093872

25095982, 25098160, 25099339, 25099497, 25099758, 25100063, 25100579

25103996, 25107662, 25110233, 25114561, 25115178, 25120284, 25120668

25120742, 25121089, 25123585, 25124363, 25129925, 25130312, 25140197

25145163, 25145215, 25150925, 25159176, 25162645, 25164293, 25166187

25171041, 25171084, 25175723, 25176408, 25178032, 25178101, 25178179

25179774, 25182817, 25184453, 25184555, 25186079, 25189723, 25191872

25192044, 25192528, 25192729, 25195901, 25199585, 25200101, 25201454

25202355, 25203656, 25205368, 25205954, 25206864, 25207410, 25209912

25210268, 25210499, 25210690, 25211628, 25219450, 25223839, 25224242

25225795, 25226665, 25227381, 25230870, 25230945, 25237577, 25240188

25240590, 25241448, 25241625, 25244807, 25248384, 25250109, 25251648

25257085, 25259611, 25262869, 25263960, 25265499, 25269133, 25283790

25287072, 25293659, 25296876, 25299227, 25299807, 25300427, 25303284

25303756, 25305405, 25307368, 25309116, 25313154, 25313411, 25316758

25317989, 25320555, 25323525, 25328093, 25328518, 25329664, 25335249

25335360, 25335790, 25337332, 25337640, 25348567, 25348956, 25353983

25356118, 25357142, 25360661, 25362958, 25367588, 25367721, 25382812

25383204, 25384462, 25386748, 25388573, 25388896, 25392535, 25393714

25395696, 25397936, 25398306, 25404117, 25404202, 25405100, 25405687

25405813, 25410017, 25410180, 25410802, 25410877, 25411036, 25415713

25416731, 25417050, 25417056, 25417958, 25425005, 25425451, 25425760

25427662, 25429959, 25430120, 25433696, 25435038, 25437699, 25440818

25442559, 25444961, 25445168, 25451531, 25452452, 25455795, 25457409

25459958, 25462714, 25463844, 25472112, 25472885, 25476125, 25476149

25477657, 25478885, 25479164, 25481087, 25482971, 25486384, 25489342

25489367, 25489607, 25492379, 25498930, 25498994, 25516250, 25524955

25528838, 25530080, 25530814, 25535668, 25536819, 25537470, 25539063

25540738, 25546580, 25546608, 25547901, 25551676, 25553616, 25554787

25555252, 25557886, 25558986, 25560487, 25560538, 25561296, 25569149

25569504, 25570929, 25573623, 25575348, 25575369, 25575628, 25576115

25579458, 25579761, 25591394, 25594901, 25597525, 25598473, 25599425

25600342, 25600421, 25601999, 25602488, 25603923, 25606091, 25607726

25612095, 25614866, 25616268, 25616359, 25616417, 25616645, 25631933

25633101, 25634317, 25634348, 25635149, 25638456, 25639019, 25643818

25643889, 25643931, 25646373, 25647325, 25648731, 25653109, 25654459

25654936, 25655390, 25655966, 25659655, 25660847, 25661819, 25662088

25662101, 25662524, 25663488, 25667973, 25669791, 25670786, 25671354

25672640, 25674386, 25680221, 25685152, 25686739, 25687460, 25691904

25694206, 25695903, 25696520, 25699321, 25700654, 25709368, 25710420

25715167, 25717371, 25722055, 25722608, 25722720, 25723097, 25723158

25728085, 25729507, 25730014, 25734963, 25736747, 25739065, 25740844

25741955, 25743479, 25747569, 25749273, 25752755, 25754606, 25756945

25757697, 25757748, 25760195, 25762221, 25764020, 25766822, 25768681

25772669, 25774077, 25775213, 25775444, 25780343, 25783447, 25784002

25785331, 25785441, 25788879, 25789041, 25789277, 25789579, 25790353

25792911, 25795865, 25797092, 25797124, 25797305, 25800464, 25802510

25803364, 25803545, 25807997, 25809524, 25810263, 25810704, 25811650

25812390, 25813931, 25818707, 25822410, 25823532, 25823754, 25824372

25825910, 25826740, 25830492, 25832935, 25834581, 25835365, 25838361

25838755, 25852885, 25856821, 25858672, 25861398, 25865785, 25866948

25870579, 25871177, 25871639, 25871753, 25872127, 25872389, 25873336

25874050, 25874678, 25882264, 25883438, 25885148, 25888073, 25888984

25890002, 25890056, 25890673, 25890782, 25894239, 25895224, 25897615

25898228, 25904273, 25904490, 25905130, 25906117, 25906886, 25908728

25911724, 25914276, 25919622, 25932524, 25932728, 25933494, 25941836

25942868, 25943271, 25945130, 25947799, 25951571, 25953857, 25954022

25954054, 25957038, 25963024, 25964954, 25967544, 25967985, 25970731

25971286, 25972417, 25973152, 25975723, 25977302, 25980605, 25980770

25981498, 25982666, 25986062, 25990907, 25995938, 25997810, 26006257

26007010, 26019148, 26024732, 26024784, 26025681, 26029075, 26029777

26029780, 26032573, 26034119, 26036748, 26037215, 26038086, 26039623

26040483, 26045732, 26051656, 26078437, 26078493, 26080410, 26083298

26087754, 26088426, 26088836, 26089669, 26090767, 26090893, 26091640

26091786, 26095327, 26095405, 26096382, 26108080, 26108337, 26110259

26110632, 26111842, 26112621, 26115103, 26121990, 26124078, 26130486

26137367, 26137416, 26138085, 26145560, 26149904, 26153372, 26153977

26168933, 26169341, 26169345, 26170659, 26170715, 26176002, 26187943

26189861, 26198757, 26198926, 26201113, 26203182, 26223039, 26237338

26237431, 26237773, 26238195, 26242031, 26242677, 26243698, 26244115

26245237, 26248143, 26249718, 26256131, 26257953, 26259265, 26261327

26263328, 26263721, 26268756, 26269790, 26271001, 26274660, 26275023

26275415, 26277439, 26281476, 26285062, 26285933, 26301540, 26308650

26309047, 26317991, 26318200, 26318627, 26323308, 26324206, 26324769

26325856, 26327418, 26327624, 26327775, 26330994, 26331743, 26333141

26334602, 26336977, 26338953, 26351334, 26351996, 26353617, 26354844

26356098, 26358670, 26359091, 26362155, 26362821, 26366517, 26367012

26367460, 26371725, 26373967, 26374791, 26375052, 26375250, 26375330

26380097, 26385189, 26386858, 26388538, 26396790, 26398675, 26399626

26399691, 26399839, 26405036, 26406387, 26407408, 26410240, 26412540

26418088, 26420561, 26421667, 26422277, 26423085, 26426526, 26426967

26430323, 26430737, 26434436, 26434999, 26435073, 26436168, 26438612

26439748, 26440142, 26440169, 26440749, 26441345, 26442308, 26444601

26444887, 26446098, 26452606, 26474662, 26474703, 26475419, 26476090

26476244, 26478970, 26479173, 26482376, 26486365, 26492666, 26492866

26493289, 26498354, 26513067, 26513709, 26521043, 26522439, 26523432

26526726, 26526799, 26536320, 26537307, 26542135, 26542236, 26542835

26544823, 26545688, 26546070, 26546664, 26546754, 26548363, 26556014

26558437, 26569225, 26575788, 26580633, 26582460, 26584641, 26588069

26597140, 26599395, 26608137, 26608238, 26609942, 26615291, 26615690

26617804, 26623652, 26626879, 26629381, 26633355, 26633558, 26635897

26637273, 26637824, 26639167, 26641610, 26641852, 26650226, 26650540

26654363, 26658759, 26659182, 26669550, 26680105, 26712331, 26714486

26714910, 26717528, 26724511, 26725687, 26727397, 26729494, 26729611

26740700, 26743240, 26744595, 26745002, 26751106, 26751171, 26755171

26758193, 26764561, 26765212, 26768025, 26775602, 26784509, 26790923

26794786, 26797591, 26798411, 26798514, 26798516, 26802503, 26816582

26820076, 26822314, 26822620, 26824833, 26828994, 26829845, 26830694

26832296, 26833932, 26837569, 26837702, 26840654, 26844406, 26844870

26849779, 26855855, 26871815, 26875822, 26883456, 26895149, 26896659

26898563, 26907236, 26907327, 26908788, 26909100, 26909504, 26910716

26911000, 26923777, 26939314, 26943004, 26944190, 26947373, 26958896

26963310, 26966616, 26966916, 26967713, 26968670, 26969321, 26970175

26970717, 26981902, 26983259, 26985002, 26986173, 26992964, 26999139

27000158, 27006120, 27006664, 27009164, 27013146, 27028251, 27032785

27033520, 27033652, 27034890, 27036163, 27037839, 27038986, 27039712

27044169, 27044297, 27045634, 27052607, 27056711, 27058530, 27060167

27060859, 27061736, 27072923, 27073314, 27079140, 27079651, 27084613

27087426, 27090765, 27092508, 27093423, 27097854, 27100800, 27101105

27105900, 27106179, 27110878, 27115422, 27117822, 27119621, 27119861

27122162, 27124624, 27125872, 27133662, 27134734, 27135647, 27135993

27138325, 27142120, 27142373, 27142529, 27144928, 27151826, 27153641

27160922, 27161071, 27162390, 27162405, 27163928, 27165231, 27169796

27170305, 27181537, 27181897, 27185188, 27195935, 27199245, 27200959

27202015, 27203055, 27207110, 27207634, 27208795, 27213224, 27216046

27217412, 27223075, 27229389, 27231051, 27234962, 27236722, 27242226

27244337, 27244999, 27248917, 27249531, 27250547, 27251690, 27254335

27255377, 27256000, 27258578, 27259307, 27262945, 27264464, 27266245

27274456, 27274536, 27275533, 27276231, 27283960, 27284499, 27285244

27288638, 27292213, 27293599, 27302711, 27302730, 27303287, 27303938

27304410, 27304906, 27305039, 27308088, 27314206, 27314390, 27314697

27320576, 27321179, 27329612, 27333106, 27334316, 27338912, 27338946

27339115, 27345231, 27346709, 27348081, 27349393, 27350267, 27351628

27359178, 27364854, 27365014, 27367194, 27369515, 27370965, 27375542

27381498, 27383281, 27386467, 27392968, 27393570, 27394703, 27395416

27396624, 27396672, 27396813, 27397048, 27400416, 27400598, 27404573

27404668, 27405645, 27416997, 27423251, 27424405, 27426363, 27432062

27432826, 27433385, 27433870, 27434193, 27439835, 27441326, 27442041

27445727, 27452046, 27457891, 27459593, 27459948, 27466597, 27468303

27486805, 27487919, 27489107, 27493674, 27494663, 27501373, 27501413

27502420, 27504770, 27505229, 27508985, 27510959, 27525909, 27529661

27533780, 27533819, 27534509, 27540613, 27544973, 27548131, 27554074

27555481, 27558861, 27560602, 27562488, 27565906, 27567477, 27576342

27576354, 27587905, 27588271, 27589260, 27593501, 27595973, 27601118

27601441, 27607563, 27611612, 27613080, 27613530, 27613554, 27615649

27617978, 27620808, 27623159, 27629756, 27629928, 27632114, 27634676

27634991, 27645231, 27657712, 27658186, 27666312, 27671633, 27680669

27686599, 27687880, 27688036, 27688099, 27688692, 27691920, 27691939

27693416, 27693713, 27695063, 27698953, 27700466, 27704237, 27709046

27710072, 27717210, 27719000, 27726780, 27729678, 27739006, 27740424

27745728, 27748954, 27751755, 27757567, 27757888, 27758544, 27758653

27758972, 27759077, 27769361, 27779886, 27793533, 27799032, 27801337

27818389, 27819881, 27824540, 27824543, 27825241, 27828794, 27828892

27829295, 27833672, 27834551, 27834569, 27835925, 27837219, 27839353

27839616, 27846298, 27846499, 27847259, 27850112, 27855490, 27861226

27873412, 27882176, 27886087, 27897759, 27898015, 27902561, 27908396

27909478, 27927431, 27929287, 27929509, 27931299, 27935493, 27940876

27945870, 27951817, 27959048, 27959594, 27964513, 27966472, 27967484

27983174, 27986817, 27994325, 27995215, 27995248, 27997875, 27998003

27999073, 27999638, 28000269, 28007516, 28019592, 28022101, 28023081

28023399, 28023482, 28024793, 28025414, 28026866, 28033429, 28040776

28043157, 28045903, 28066655, 28067846, 28071549, 28072383, 28072567

28073470, 28074713, 28079127, 28090453, 28092783, 28098040, 28098160

28099662, 28104176, 28108003, 28111583, 28120036, 28120951, 28124631

28125947, 28129791, 28140658, 28157786, 28164480, 28165439, 28171079

28174827, 28180464, 28181021, 28184554, 28188330, 28190796, 28194173

28199085, 28201419, 28204262, 28209985, 28215510, 28218832, 28220398

28223871, 28226179, 28229360, 28236305, 28238264, 28242712, 28250929

28256164, 28271119, 28276054, 28279837, 28281094, 28282606, 28287484

28290434, 28294563, 28302049, 28305001, 28305362, 28305607, 28309406

28319114, 28320399, 28330714, 28330971, 28350595, 28354603, 28357401

28361221, 28365111, 28369092, 28371123, 28373960, 28375383, 28378446

28384353, 28386259, 28388910, 28389153, 28390273, 28391210, 28396445

28397317, 28401116, 28402823, 28420042, 28420457, 28423598, 28432129

28434028, 28435902, 28437315, 28439086, 28454215, 28454242, 28468312

28468493, 28481149, 28483184, 28489150, 28501075, 28502343, 28503038

28507324, 28508053, 28508557, 28512336, 28521330, 28522441, 28528349

28530171, 28535127, 28535272, 28537715, 28538439, 28542455, 28545134

28546290, 28547068, 28547478, 28564479, 28566241, 28571483, 28572407

28572834, 28578164, 28578945, 28585411, 28587723, 28589509, 28600233

28602253, 28606598, 28608211, 28612674, 28614372, 28617631, 28617959

28621470, 28622202, 28627255, 28636676, 28639299, 28642899, 28678804

28690694, 28691965, 28692103, 28692275, 28697526, 28697806, 28703812

28708023, 28709063, 28710469, 28710734, 28714988, 28715655, 28728272

28730044, 28734355, 28740708, 28742555, 28749289, 28749724, 28758090

28758722, 28774416, 28776431, 28777174, 28791725, 28797711, 28803345

28808314, 28817449, 28819640, 28820669, 28821847, 28827682, 28830691

28831971, 28835937, 28836716, 28838066, 28844866, 28847136, 28849751

28852691, 28855922, 28856060, 28856172, 28863263, 28863487, 28867992

28887305, 28889730, 28891984, 28905390, 28910498, 28927452, 28945922

28948554, 28949888, 28951026, 28951382, 28956908, 28959493, 28960211

28965095, 28965787, 28986231, 28986257, 28987439, 28991884, 28993295

28993590, 29002488, 29006527, 29007321, 29007353, 29009513, 29013832

29024054, 29026309, 29026582, 29027694, 29032276, 29039510, 29040739

29044086, 29044954, 29048498, 29048728, 29050886, 29060216, 29061016

29115857, 29125374, 29154725, 29158680, 29163567, 29170232, 29173817

29179097, 29182517, 29182901, 29189889, 29198092, 29200700, 29203604

29213320, 29213351, 29224605, 29237575, 29247712, 29249289, 29250230

29250317, 29260956, 29278684, 29296257, 29301463, 29307638, 29312889

29337294, 29338348, 29339155, 29343086, 29343156, 29343861, 29347943

29353821, 29372069, 29372460, 29375355, 29375984, 29376346, 29378913

29379978, 29383695, 29388020, 29398488, 29399336, 29405462, 29409149

29409455, 29418165, 29420254, 29426241, 29434301, 29436454, 29437712

29450812, 29452251, 29454978, 29463047, 29464779, 29472618, 29477015

29483626, 29483672, 29483723, 29483771, 29500257, 29500963, 29501218

29504682, 29511611, 29524985, 29530515, 29536342, 29538631, 29542449

29542580, 29548592, 29549071, 29559395, 29564592, 29580394, 29591343

29608023, 29614575, 29614987, 29621961, 29625065, 29626154, 29629430

29633753, 29637526, 29637560, 29645349, 29651520, 29656843, 29667994

29676089, 29678163, 29685137, 29687220, 29688867, 29690625, 29703195

29705793, 29707896, 29717901, 29719146, 29724063, 29726695, 29741319

29766435, 29767177, 29769901, 29782211, 29791152, 29794174, 29794462

29796916, 29807964, 29813494, 29815341, 29817278, 29822714, 29825525

29836659, 29841687, 29844131, 29846645, 29853485, 29865188, 29869404

29869906, 29875459, 29876358, 29881050, 29881575, 29884958, 29893132

29902299, 29902311, 29914449, 29930457, 29941062, 29942554, 29944035

29944159, 29944660, 29951620, 29951759, 29961353, 29962927, 29962939

29965888, 29991257, 30008125, 30018017, 30018903, 30031027, 30039959

30064268, 30068871, 30076253, 30078934, 30086166, 30088912, 30092280

30098251, 30099302, 30114477, 30116203, 30120608, 30125995, 30131286

30139392, 30147928, 30150731, 30163243, 30164714, 30173113, 30177597

30179644, 30186706, 30189023, 30193736, 30196358, 30200680, 30200758

30215130, 30218044, 30218317, 30223712, 30225443, 30239480, 30241567

30244787, 30246179, 30247305, 30252098, 30252156, 30253255, 30265523

30265615, 30272329, 30281591, 30282501, 30283932, 30293345, 30305880

30312094, 30312568, 30316897, 30320029, 30325407, 30331356, 30342878

30345926, 30352623, 30355490, 30357897, 30364613, 30365745, 30368482

30368668, 30372081, 30374739, 30377692, 30381207, 30384121, 30384152

30387666, 30391272, 30397100, 30402386, 30403763, 30408515, 30413137

30416034, 30421204, 30431274, 30441687, 30443393, 30453442, 30458593

30460922, 30464250, 30464655, 30473634, 30474774, 30475115, 30476768

30485255, 30496957, 30497057, 30498824, 30501574, 30503943, 30509277

30510527, 30517516, 30522998, 30528547, 30528704, 30532811, 30533198

30578221, 30581448, 30582500, 30606345, 30613937, 30623138, 30624864

30635302, 30652853, 30654409, 30662736, 30668407, 30671813, 30679595

30679771, 30681462, 30698289, 30741263, 30749644, 30755348, 30758943

30783551, 30803210, 30809087, 30814266, 30814285, 30815852, 30816938

30826474, 30856358, 30866988, 30887501, 30904672, 30905638, 30914674

30919804, 30922870, 30937340, 30964194, 30968208, 30980615, 30985027

30987088, 30994996, 30998759, 31001455, 31004719, 31013127, 31022858

31028986, 31061482, 31100172, 31104809, 31106577, 31109506, 31115502

31156383, 31172207, 31182793, 31192039, 31194264, 31200845, 31201001

31215438, 31228670, 31254535, 31258101, 31302499, 31306248, 31309867

31315876, 31326608, 31331354, 31341859, 31343752, 31347532, 31377487

31393600, 31408636, 31430722, 31501139, 31508450, 31525783, 31544097

31570161, 31600023, 31637680, 31658464, 31668061, 31711889, 31718134

31749740, 31771858, 31786838, 31816631, 31867037, 31905033, 31986836

32089820, 32186646, 32234161, 32296941


OPatch succeeded.

 

POSTPATCH STEPS (START LISTENER AND DATABASE).

[oracle@trichy32228578]$ lsnrctl start

LSNRCTL for Linux: Version 12.2.0.1.0 – Production on 20-JAN-2021 14:49:27

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

Starting /u01/app/oracle/product/12.2.0.1/db_1/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 12.2.0.1.0 – Production

System parameter file is /u01/app/oracle/product/12.2.0.1/db_1/network/admin/listener.ora

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

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.22)(PORT=1521)))

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.22)(PORT=1521)))

STATUS of the LISTENER

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 12.2.0.1.0 – Production

Start Date                20-JAN-2021 14:49:29

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/12.2.0.1/db_1/network/admin/listener.ora

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

Listening Endpoints Summary…

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.22)(PORT=1521)))

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

Services Summary…

Service “BIJU1” has 1 instance(s).

Instance “BIJU1”, status UNKNOWN, has 1 handler(s) for this service…

The command completed successfully

[oracle@trichyOPatch]$ export ORACLE_SID=BIJU1

[oracle@trichyOPatch]$ ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1

[oracle@trichyOPatch]$ export ORACLE_HOME

[oracle@trichyOPatch]$ PATH=$PATH:$ORACLE_HOME/bin

[oracle@trichyOPatch]$ export PATH

[oracle@trichyOPatch]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Jan 20 14:53:07 2021

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 2483027968 bytes

Fixed Size                       8623736 bytes

Variable Size                671091080 bytes

Database Buffers        1795162112 bytes

Redo Buffers                  8151040 bytes

Database mounted.

Database opened.

SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production

 

EXECUTE DATAPATCH FOR UPDATE THE PATCH DETAILS IN DATABASE SIDE.

[oracle@trichyOPatch]$ cd $ORACLE_HOME/OPatch

[oracle@trichyOPatch]$ ./datapatch -verbose

SQL Patching tool version 12.2.0.1.0 Production on Wed Jan 20 14:54:12 2021

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

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

Connecting to database…OK

Bootstrapping registry and package to current versions…done

Determining current state…done

Current state of SQL patches:

Bundle series DBRU:

ID 210119 in the binary registry and ID 200414 in the SQL registry

Adding patches to installation queue and performing prereq checks…

Installation queue:

Nothing to roll back

The following patches will be applied:

32228578 (DATABASE JAN 2021 RELEASE UPDATE 12.2.0.1.210119)

Installing patches…

Patch installation complete.  Total patches installed: 1

Validating logfiles…

Patch 32228578 apply: SUCCESS

logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32228578/24008225/32228578_apply_BIJU1_2021Jan20_14_54_32.log (no errors)

SQL Patching tool complete on Wed Jan 20 14:55:10 2021

 

After installing the SQL portion of the patch, some packages could become INVALID. This will get recompiled upon access or you can run utlrp.sql to get them back into a VALID state.

[oracle@trichyOPatch]$ cd $ORACLE_HOME/rdbms/admin

[oracle@trichyadmin]$ !sq

sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Jan 20 15:00:48 2021

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production

SQL> @utlrp.sql

TIMESTAMP

COMP_TIMESTAMP UTLRP_BGN                  2021-01-20 15:00:56

DOC>   The following PL/SQL block invokes UTL_RECOMP to recompile invalid

DOC>   objects in the database. Recompilation time is proportional to the

DOC>   number of invalid objects in the database, so this command may take

DOC>   a long time to execute on a database with a large number of invalid

DOC>   objects.

DOC>   Use the following queries to track recompilation progress:

DOC>   1. Query returning the number of invalid objects remaining. This

DOC>    number should decrease with time.

DOC>       SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);

……………………………………………………………………………………
……………………………………………………………………………………
……………………………………………………………………………………

PL/SQL procedure successfully completed.

SQL> SELECT owner, object_name, object_type FROM all_objects WHERE status =’INVALID’;

no rows selected

CHECK PATCH INFORMATION IN DATABASE LEVEL

SQL> select DESCRIPTION,ACTION,ACTION_TIME,VERSION from dba_registry_sqlpatch;

 DESCRIPTION                         ACTION                             ACTION_TIME                                VERSION
————————-           ——————-————       ———————–—————               ——————-
DATABASE JAN 2021              APPLY                   20-JAN-21 02.55.10.831438 PM                 12.2.0.1          RELEASEUPDATE   
12.2.0.1.210119

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

CREATE CONTAINER DATABASE USING DBCA METHOD

In Putty session while we execute ./dbca command we will get this screen.

STEP 1:

select create database option then click next button

STEP 2:

We need to supply Global database name and password

STEP 3:

click finish button to complete database creation

Once progress completed we will get below screen

STEP 5:

Now the database has been created. We can check by logging in.

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

 

 

CREATE CONTAINER DATABASE USING DBCA METHOD

In Putty session while we execute ./dbca command we will get this screen.

STEP 1:

select create database option then click next button

STEP 2:

We need to supply Global database name and password

STEP 3:

click finish button to complete database creation

Once progress completed we will get below screen

STEP 5:

Now the database has been created. We can check by logging in.

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

 

 

CREATING PLUGGABLE DATABASE (PDB) IN DBCA METHOD

In Putty session while we execute ./dbca command we will get this screen. In that screen we need to select manage Pluggable databases option to create new PDB database.

Select Create a Pluggable database option.

Click finish button to complete database creation.

Click on new Pluggable database

Enter Pluggable database name and passwords

We need to chose storage locations. click on next button

Check on the summary of inputs in Pluggable databases

Once all details confirmed click on finish button to progress on installation.

Once progress completed PDB100 plugged in.

We can check pluggable databases in putty session whether its installed properly.

Now we can see that pluggable databases installed successfully.

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

CREATING PLUGGABLE DATABASE (PDB) IN DBCA METHOD

In Putty session while we execute ./dbca command we will get this screen. In that screen we need to select manage Pluggable databases option to create new PDB database.

Select Create a Pluggable database option.

Click finish button to complete database creation.

Click on new Pluggable database

Enter Pluggable database name and passwords

We need to chose storage locations. click on next button

Check on the summary of inputs in Pluggable databases

Once all details confirmed click on finish button to progress on installation.

Once progress completed PDB100 plugged in.

We can check pluggable databases in putty session whether its installed properly.

Now we can see that pluggable databases installed successfully.

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

Patch 30886680: DATABASE APR 2020 RELEASE UPDATE 12.2.0.1.200414 [Linux X86-64]

Below document I will explain how to apply APRIL 2020 PSU Patch

Overall steps:

  1. Export exact oracle home path
  2. Check the opatch version – Oracle recommends to use the latest Patch version
  3. Apply optach
  4. Datapatch verbose need to do
    Oracle Patch Download link: https://support.oracle.com/epmos/faces/PatchDetail?requestId=23474251&_afrLoop=108504923966006&patchId=30886680&_afrWindowMode=0&_adf.ctrl-state=4te1a33nq_119
    Here we are going to check Opatch lsinventory:
[oracle@oracleagent 30886680]$ opatch lsinventory|grep "Patch description"
Patch description: "Database Apr 2021 Release Update : 12.2.0.1.200414 (30886680)"

[oracle@oracleagent 30886680]$ opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2021, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/12.2.0.1/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.2.0.1/db_1/oraInst.loc
OPatch version : 12.2.0.1.19
OUI version : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2021-01-18_10-27-13AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/lsinv/lsinventory2021-01-18_10-27-13AM.txt

Local Machine Information::
Hostname: oracleagent.oracledb
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c 12.2.0.1.0
There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch 30886680 : applied on Mon Jan 18 10:21:48 IST 2021
Unique Patch ID: 23474251
Patch description: "Database Apr 2021 Release Update : 12.2.0.1.200414 (30886680)"
Created on 1 Apr 2021, 01:36:23 hrs PST8PDT
Bugs fixed:
30533198, 30312568, 30086166, 28951106, 28435910, 8480838, 8932139
12763598, 13554903, 14221306, 14690846, 15931756, 16010385, 16438495
16727454, 16942578, 17107695, 17533661, 17947871, 18308268, 18521691
18594510, 18774543, 18878420, 19072655, 19211433, 19285105, 19327292
19526548, 19614183, 19647894, 19649997, 19710201, 19721304, 20003668
20087519, 20118035, 20121036, 20318049, 20436508, 20532077, 20549013
20588486, 20591151, 20617383, 20620169, 20736227, 20756305, 20866970
20176443, 21089435, 20215391, 21143725, 21147908, 21159907, 21178363
21186167, 21197018, 21216226, 21320338, 21433452, 21479706, 21517767
21521066, 21547051, 21638600, 21744603, 21788462, 21837606, 21882528
21935698, 21981529, 21985256, 22007318, 22070473, 22070853, 22072543
22087683, 22104866, 22107360, 22174392, 22179537, 22282748, 22310426
22347493, 22363790, 22364044, 22367053, 22379010, 21846455, 21854940
21895673, 22503283, 22503297, 22504793, 22522515, 22530186, 22564336
22568728, 22581771, 22594071, 22599050, 22628825, 22645001, 22645496
22654475, 22700845, 22726044, 22729345, 22826067, 22843979, 22845846
22864303, 22898198, 22921674, 22939829, 22950145, 22970869, 22981722
23018676, 23019710, 23106585, 23035189, 23055900, 23061453, 23065010
23066146, 23080557, 23104033, 23105538, 23101325, 23110523, 23125560
23126545, 23127945, 23143074, 23151677, 23168363, 23169712, 23177923
23179662, 23184263, 23197730, 23234232, 23237011, 23189829, 23271203
23278750, 23300142, 23306590, 23308065, 23310101, 23312077, 23328639
23333567, 23336559, 23342170, 23481673, 23491861, 23499004, 23499160
23521523, 23527363, 23533647, 23548817, 23567857, 23572982, 23581777
23588722, 23599216, 23600861, 23610213, 23645516, 23665623, 23701062
23715460, 23715518, 23730161, 23733981, 23735292, 23738304, 23741944
23743596, 23746128, 23749454, 23761718, 18006569, 18010030, 18289874
18289895, 18294174, 18303148, 18307571, 18308349, 18326444, 18326846
18328857, 18330708, 18332831, 18334708, 18336189, 18337882, 18341675
18343905, 18345420, 18346821, 18348685, 18350620, 18352981, 18355111
18357348, 18368004, 18371491, 18373528, 18373756, 18374976, 18376875
18376878, 18383086, 18385983, 18401351, 18403922, 18401977, 18415926
18416451, 18421668, 18423416, 18425056, 18425998, 18435982, 18437162
18440648, 18443539, 18457597, 18460392, 18461826, 18467122, 18468470
18470606, 18471079, 18471473, 18473736, 18485034, 18485161, 18485174
18486059, 18486237, 18501056, 18516314, 18530364, 18534401, 18554533
18555417, 18556862, 18556967, 18560106, 18563422, 18571014, 18570598
18573817, 18578718, 18578797, 18588377, 18589081, 18589590, 18591506
18593740, 18595699, 18600330, 18601592, 18601996, 18611527, 18616637
18617969, 18623975, 18618166, 18641895, 18654629, 18655717, 18664211
18668398, 18669189, 18674197, 18674955, 18676172, 18677696, 18680159
18687075, 18689376, 18692973, 18693010, 18693290, 18697323, 18699619
18710696, 18713381, 18714016, 18717183, 18717859, 18718260, 18719799
18735430, 18737064, 18737403, 18737581, 18737954, 18739791, 18744383
18744686, 18752618, 18757934, 18759556, 18760407, 18764085, 18766301
18784414, 18786669, 18791883, 18792678, 18793511, 18796012, 18797119
18800423, 18801152, 18810934, 18808504, 18811725, 18812047, 18818566
18827228, 18827654, 18831514, 18835919, 18841671, 18843188, 18844549
18844841, 18845157, 18848746, 18848923, 18850622, 18907917, 18908321
18911701, 18912588, 18920582, 18921478, 18922704, 18923080, 18923215
18923338, 18923790, 18918667, 18926999, 18929210, 18938784, 18940060
18942749, 18953434, 18957555, 18960044, 18960801, 18965426, 18966594
18966788, 18967993, 18968162, 18976007, 18978100, 25102574, 25107852
25108996, 25109102, 25109423, 25031510, 25032818, 25034396, 25036006
25036474, 25042823, 25044977, 25045228, 25050160, 25051465, 25051628
25054064, 25057811, 25058080, 25060506, 25062592, 25063971, 25065563
25072986, 25077278, 25078611, 25086233, 25087436, 25012777, 25013872
25015982, 25018160, 25019339, 25019497, 25019758, 25100063, 25100579
25103996, 25107662, 25111033, 25114561, 25121084, 25120668, 25120742
25121089, 25123585, 25118363, 25129925, 25130312, 25140197, 25145163
25145215, 25150125, 25159176, 25162645, 25164293, 25166187, 25171041
25171084, 25175723, 25176408, 25178032, 25178101, 25178179, 25179774
25182817, 25184453, 25184555, 25186079, 25191872, 25192044, 25192528
25192729, 25195901, 25199585, 25201454, 25210355, 25203656, 25205954
25206864, 25207410, 25201912, 25211068, 25210499, 25210690, 25211628
25219450, 25223839, 25218182, 25225795, 25226665, 25227381, 25230870
25230145, 25237577, 25180188, 25180590, 25181448, 25181625, 25184807
25188384, 25250101, 25251648, 25257085, 25259611, 25262869, 25263960
25265499, 25269133, 25283790, 25287072, 25293659, 25296876, 25299227
25299807, 25300427, 25303284, 25303756, 25305405, 25307368, 25301116
25313154, 25313411, 25316758, 25317989, 25320555, 25323525, 25328013
25328518, 25329664, 25335189, 25335360, 25335790, 25337332, 25337640
25348956, 25353983, 25356118, 25357142, 25360661, 25362958, 25367588
25367721, 25382812, 25383204, 25384462, 25386748, 25388896, 25392535
25393714, 25395696, 25397936, 25398306, 25404210, 25405100, 25405687
25405813, 25410017, 25410180, 25410810, 25410877, 25411036, 25415713
25416731, 25417050, 25417056, 25417958, 25425005, 25425451, 25425760
25427662, 25429959, 25430120, 25433696, 25435038, 25437699, 25440818
25442559, 25444961, 25445168, 25451531, 25455795, 25457401, 25459958
25462714, 25463844, 25472112, 25472885, 25476125, 25476149, 25477657
25478885, 25479164, 25481087, 25482971, 25486384, 25489342, 25489367
25489607, 25492379, 25498930, 25498994, 25516250, 25518955, 25528838
25530080, 25530814, 25535668, 25536819, 25537470, 25539063, 25540738
25546580, 25546608, 25547901, 25551676, 25553616, 25554787, 25555252
25557886, 25558986, 25560487, 25561296, 25569149, 25570129, 25573623
25575348, 25575369, 25575628, 25579458, 25579761, 25591394, 25594901
25597525, 25598473, 25599425, 25600342, 25600421, 25601999, 25601888
25603923, 25606011, 25607726, 25612015, 25614866, 25616268, 25616359
25616417, 25616645, 25631933, 25633101, 25634317, 25634348, 25635149
25638456, 25639019, 25643818, 25643889, 25643931, 25646373, 25647325
25648731, 25653101, 25654459, 25654936, 25655390, 25655966, 25659655
25660847, 25661819, 25662088, 25662021, 25662518, 25663488, 25667973
25669791, 25670786, 25671354, 25672640, 25674386, 25681021, 25685152
25686739, 25687460, 25691904, 25694206, 25695903, 25696520, 25699321
25700654, 25701368, 25710420, 25715167, 25717371, 25722055, 25722608
25722720, 25723017, 25723158, 25728085, 25729507, 25730014, 25734963
25736747, 25739065, 25740844, 25741955, 25743479, 25747569, 25749273
25752755, 25754606, 25756945, 25757697, 25757748, 25760195, 25762221
25764100, 25766822, 25768681, 25772669, 25774077, 25775213, 25775444
25780343, 25783447, 25784010, 25785331, 25785441, 25788879, 25789041
25789277, 25789579, 25790353, 25792911, 25795865, 25797012, 25797118
25797305, 25800464, 25810510, 25803364, 25803545, 25807997, 25801518
25811063, 25810704, 25811650, 25812390, 25813931, 25818707, 25821810
25823532, 25823754, 25825910, 25826740, 25830492, 25832935, 25834581
25835365, 25838361, 25838755, 25852885, 25856821, 25858672, 25861398
25865785, 25870579, 25871177, 25871639, 25871753, 25872127, 25872389
25873336, 25874050, 25874678, 25882264, 25883438, 25885148, 25888073
25888984, 25890056, 25890673, 25890782, 25894239, 25895218, 25897615
25898228, 25904273, 25904490, 25905130, 25906117, 25906886, 25908728
25911718, 25914276, 25919622, 25932518, 25932728, 25933494, 25941836
25943271, 25945130, 25947799, 25951571, 25953857, 25954102, 25954054
25957038, 25963018, 25964954, 25967544, 25967985, 25970731, 25971286
25971817, 25973152, 25975723, 25977310, 25980605, 25980770, 25981498
25982666, 25986062, 25990107, 25995938, 25997810, 26006257, 26007010
26019148, 26018732, 26018784, 26105681, 26109075, 26109777, 26109780
26032573, 26034119, 26036748, 26037215, 26038086, 26039623, 26040483
26045732, 26051656, 26078437, 26078493, 26080410, 26083298, 26087754
26088426, 26088836, 26010767, 26010893, 26011640, 26011786, 26015327
26015405, 26016382, 26108080, 26108337, 26111059, 26110632, 26111842
26112621, 26115103, 26121990, 26118078, 26130486, 26137367, 26137416
26138085, 26145560, 26149904, 26153372, 26153977, 26168933, 26169341
26169345, 26170659, 26170715, 26176010, 26187943, 26189861, 26198757
26198926, 26201113, 26203182, 26223039, 26237338, 26237431, 26237773
26238195, 26182031, 26182677, 26183698, 26184115, 26185237, 26188143
26189718, 26256131, 26257953, 26259265, 26261327, 26263328, 26263721
26268756, 26269790, 26271001, 26274660, 26275103, 26275415, 26277439
26281476, 26285062, 26285933, 26308650, 26301047, 26317991, 26318627
26323308, 26318206, 26318769, 26325856, 26327418, 26327618, 26327775
26330194, 26331743, 26333141, 26336977, 26338953, 26351334, 26351996
26353617, 26358670, 26359011, 26362155, 26362821, 26366517, 26367012
26367460, 26371725, 26373967, 26374791, 26375052, 26375250, 26380017
26385189, 26388538, 26396790, 26398675, 26399626, 26399691, 26405036
26406387, 26407408, 26410180, 26412540, 26418088, 26420561, 26421667
26422277, 26423085, 26426526, 26426967, 26430323, 26430737, 26434436
26434999, 26435073, 26436168, 26438612, 26439748, 26440169, 26440749
26442308, 26444601, 26444887, 26446018, 26452606, 26474662, 26474703
26475419, 26476184, 26478970, 26479173, 26482376, 26486365, 26492866
26493289, 26498354, 26513067, 26513701, 26521043, 26521839, 26523432
26526726, 26526799, 26536320, 26537307, 26542135, 26542236, 26542835
26544823, 26545688, 26546070, 26546664, 26546754, 26548363, 26556014
26558437, 26569225, 26575788, 26580633, 26581860, 26584641, 26588069
26597140, 26599395, 26608137, 26608238, 26601942, 26615291, 26615690
26617804, 26623652, 26626879, 26629381, 26633355, 26633558, 26635897
26637273, 26637818, 26639167, 26641610, 26651026, 26650540, 26654363
26658759, 26659182, 26669550, 26680105, 26712331, 26714486, 26714910
26717528, 26718511, 26725687, 26727397, 26729494, 26729611, 26740700
26744595, 26745010, 26751106, 26751171, 26755171, 26758193, 26764561
26765212, 26768105, 26775610, 26784501, 26790123, 26794786, 26797591
26798411, 26798516, 26810503, 26816582, 26820076, 26822314, 26822620
26818833, 26828994, 26829845, 26833932, 26837569, 26837710, 26840654
26844406, 26844870, 26849779, 26871815, 26875822, 26883456, 26895149
26896659, 26898563, 26907236, 26907327, 26908788, 26901100, 26901504
26910716, 26911000, 26939314, 26943004, 26944190, 26958896, 26963310
26966616, 26966916, 26967713, 26968670, 26969321, 26970175, 26970717
26981910, 26983259, 26985010, 26986173, 26992964, 27000158, 27006120
27006664, 27001164, 27013146, 27108251, 27032785, 27033520, 27033652
27034890, 27036163, 27037839, 27038986, 27039712, 27044169, 27044297
27045634, 27052607, 27056711, 27058530, 27060167, 27060859, 27061736
27072923, 27073314, 27079140, 27084613, 27087426, 27010765, 27012508
27013423, 27017854, 27100800, 27101105, 27105900, 27106179, 27110878
27115422, 27117822, 27119621, 27119861, 27122162, 27118618, 27125872
27133662, 27134734, 27135647, 27135993, 27138325, 27142120, 27142373
27142529, 27144928, 27151826, 27153641, 27160122, 27161071, 27162390
27161805, 27163928, 27165231, 27169796, 27170305, 27181537, 27181897
27185188, 27195935, 27199185, 27200159, 27202115, 27203055, 27207110
27208795, 27213218, 27216046, 27217412, 27223075, 27229389, 27231051
27234962, 27236722, 27182226, 27184337, 27184999, 27188917, 27189531
27250547, 27251690, 27255377, 27256000, 27258578, 27259307, 27262945
27264464, 27266185, 27274456, 27274536, 27275533, 27276231, 27283960
27284499, 27285184, 27288638, 27292213, 27293599, 27310711, 27310730
27303287, 27303938, 27304410, 27304906, 27305039, 27308088, 27314206
27314390, 27314697, 27320576, 27321179, 27329612, 27333106, 27334316
27338912, 27338946, 27339115, 27345231, 27346701, 27348081, 27349393
27351067, 27351628, 27359178, 27364854, 27367194, 27369515, 27370165
27375542, 27381498, 27383281, 27386467, 27393570, 27394703, 27395416
27396618, 27396672, 27396813, 27397048, 27400416, 27400598, 27404573
27404668, 27405645, 27416997, 27423251, 27418405, 27426363, 27432062
27432826, 27433385, 27433870, 27434193, 27439835, 27441326, 27442041
27445727, 27457891, 27459593, 27459948, 27466597, 27468303, 27486805
27487919, 27489107, 27493674, 27494663, 27501373, 27501413, 27501820
27504770, 27505229, 27508985, 27510159, 27525901, 27529661, 27533780
27533819, 27534501, 27540613, 27544973, 27548131, 27554074, 27555481
27558861, 27560610, 27561888, 27565906, 27567477, 27576342, 27576354
27587905, 27588271, 27593501, 27595973, 27601118, 27601441, 27607563
27611612, 27613080, 27613530, 27617978, 27620808, 27623159, 27629756
27632114, 27634676, 27634991, 27645231, 27657712, 27658186, 27666312
27671633, 27680669, 27686599, 27687880, 27688036, 27688019, 27688692
27691920, 27691939, 27693416, 27693713, 27695063, 27698953, 27700466
27704237, 27701046, 27710072, 27719000, 27726780, 27729678, 27739006
27740418, 27748954, 27751755, 27757567, 27757888, 27758544, 27758653
27758972, 27759077, 27769361, 27793533, 27799032, 27801337, 27818389
27819881, 27818540, 27818543, 27825181, 27828794, 27829295, 27833672
27834551, 27834569, 27835925, 27839353, 27846298, 27846499, 27847259
27850112, 27855490, 27861226, 27873412, 27882176, 27886087, 27897759
27898015, 27910561, 27901478, 27927431, 27929287, 27931299, 27935493
27940876, 27945870, 27951817, 27959048, 27959594, 27966472, 27967484
27983174, 27986817, 27994325, 27995215, 27995188, 27997875, 27998003
27999073, 27999638, 28001069, 28102021, 28103081, 28103399, 28103482
28018793, 28105414, 28106866, 28033429, 28040776, 28043157, 28045903
28067846, 28071549, 28072383, 28072567, 28074713, 28079127, 28010453
28018160, 28019662, 28108003, 28111583, 28120036, 28120151, 28118631
28125947, 28129791, 28140658, 28157786, 28164480, 28165439, 28171079
28174827, 28180464, 28181101, 28184554, 28188330, 28190796, 28194173
28199085, 28201419, 28201985, 28215510, 28218832, 28220398, 28223871
28226179, 28229360, 28236305, 28238264, 28182712, 28250129, 28256164
28271119, 28276054, 28279837, 28281014, 28282606, 28290434, 28294563
28310049, 28305001, 28305362, 28301406, 28319114, 28320399, 28330714
28330171, 28354603, 28357401, 28361221, 28365111, 28369012, 28371123
28373960, 28375383, 28378446, 28384353, 28386259, 28388910, 28391073
28391210, 28396445, 28397317, 28401116, 28410823, 28420042, 28420457
28423598, 28432129, 28434108, 28437315, 28439086, 28454215, 28454182
28468312, 28468493, 28481149, 28483184, 28489150, 28501075, 28510343
28503038, 28507318, 28508053, 28508557, 28512336, 28521330, 28521841
28528349, 28530171, 28535127, 28535272, 28537715, 28538439, 28541855
28545134, 28546290, 28547068, 28564479, 28571483, 28571807, 28572834
28578164, 28578945, 28585411, 28587723, 28589501, 28601033, 28608211
28612674, 28617631, 28617959, 28621470, 28622210, 28627255, 28636676
28639299, 28642899, 28678804, 28691965, 28692103, 28692275, 28697806
28708103, 28701063, 28710469, 28714988, 28728272, 28734355, 28740708
28742555, 28749289, 28749718, 28758010, 28758722, 28774416, 28777174
28791725, 28797711, 28803345, 28817449, 28819640, 28820669, 28821847
28830691, 28831971, 28835937, 28836716, 28838066, 28844866, 28849751
28852691, 28855922, 28856060, 28856172, 28863263, 28863487, 28867992
28887305, 28889730, 28891984, 28927452, 28949888, 28951382, 28956908
28959493, 28961011, 28965015, 28965787, 28986231, 28986257, 28987439
28991884, 28993295, 28993590, 29001888, 29006527, 29007321, 29007353
29001513, 29013832, 29018054, 29106582, 29107694, 29032276, 29040739
29048498, 29050886, 29061016, 29061016, 29115857, 29125374, 29158680
29163567, 29171032, 29173817, 29179017, 29182517, 29182901, 29189889
29198012, 29200700, 29203604, 29213320, 29218605, 29237575, 29187712
29189289, 29251030, 29250317, 29260156, 29278684, 29301463, 29339155
29343086, 29343861, 29347943, 29353821, 29372069, 29371860, 29375355
29375984, 29376346, 29378913, 29379978, 29383695, 29388100, 29398488
29399336, 29405462, 29401149, 29401455, 29426181, 29434301, 29436454
29437712, 29450812, 29452251, 29454978, 29464779, 29483626, 29483672
29483723, 29483771, 29501057, 29500163, 29504682, 29511611, 29518985
29530515, 29536342, 29538631, 29541849, 29542580, 29548592, 29549071
29580394, 29614575, 29621961, 29625065, 29626154, 29629430, 29633753
29637526, 29645349, 29651520, 29656843, 29667994, 29676089, 29678163
29685137, 29687220, 29690625, 29703195, 29707896, 29719146, 29718063
29726695, 29767177, 29782211, 29791152, 29794462, 29807964, 29813494
29817278, 29825525, 29836659, 29841687, 29846645, 29853485, 29865188
29869404, 29875459, 29876358, 29881050, 29884958, 29893132, 29910311
29914449, 29944035, 29944660, 29951620, 29961353, 29962927, 29962939
29991257, 30018017, 30031107, 30064268, 30076253, 30078934, 30088912
30018251, 30019310, 30114477, 30120608, 30125995, 30131286, 30147928
30150731, 30163183, 30164714, 30173113, 30177597, 30179644, 30189103
30196358, 31000758, 31015130, 31018044, 31018317, 31023712, 31039480
30181567, 30184787, 30186179, 30187305, 31052018, 31052156, 31053255
31065523, 31072329, 31081591, 31082501, 31083932, 30305880, 30312014
30342878, 30364613, 30365745, 30374739, 30384152, 30410386, 30403763
30408515, 30413137, 30416034, 30431274, 30441687, 30453442, 30458593
30460122, 30475115, 30485255, 30496957, 30497057, 30501574, 30503943
30501277, 30510527, 30582500, 30613937, 30635310, 30654401, 30671813
30741263, 30803210, 30815852, 30168208

OPatch succeeded.

[oracle@oracleagent 30886680]$ export PATH=/u01/app/oracle/product/12.2.0.1/db_1/OPatch:$PATH
[oracle@oracleagent 30886680]$ opatch version
OPatch Version: 12.2.0.1.19
OPatch succeeded.

Here we are going to apply patch with opatch apply.

User need to give Y to proceed Patch.

[oracle@oracleagent 30886680]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2021, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/12.2.0.1/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.2.0.1/db_1/oraInst.loc
OPatch version : 12.2.0.1.19
OUI version : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2021-01-18_10-03-10AM_1.log

Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 30886680


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/12.2.0.1/db_1')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
Applying interim patch '30886680' to OH '/u01/app/oracle/product/12.2.0.1/db_1'
ApplySession: Optional component(s) [ oracle.swd.oui, 12.2.0.1.0 ] , [ oracle.oid.client, 12.2.0.1.0 ] , [ oracle.has.crs, 12.2.0.1.0 ] , [ oracle.rdbms.drdaas, 12.2.0.1.0 ] , [ oracle.ons.daemon, 12.2.0.1.0 ] , [ oracle.network.cman, 12.2.0.1.0 ] not present in the Oracle Home or a higher version is found.


Patching component oracle.rdbms.rsf, 12.2.0.1.0…
Patching component oracle.rdbms, 12.2.0.1.0…
Patching component oracle.rdbms.util, 12.2.0.1.0…
Patching component oracle.network.rsf, 12.2.0.1.0…
Patching component oracle.ctx, 12.2.0.1.0…
Patching component oracle.ctx.rsf, 12.2.0.1.0…
Patching component oracle.has.common.cvu, 12.2.0.1.0…
Patching component oracle.ldap.rsf, 12.2.0.1.0…
Patching component oracle.rdbms.dbscripts, 12.2.0.1.0…
Patching component oracle.rdbms.deconfig, 12.2.0.1.0…
Patching component oracle.rdbms.rsf.ic, 12.2.0.1.0…
Patching component oracle.sdo, 12.2.0.1.0…
Patching component oracle.sdo.locator, 12.2.0.1.0…
Patching component oracle.tfa, 12.2.0.1.0…
Patching component oracle.xdk.parser.java, 12.2.0.1.0…
Patching component oracle.rdbms.dv, 12.2.0.1.0…
Patching component oracle.precomp.rsf, 12.2.0.1.0…
Patching component oracle.rdbms.crs, 12.2.0.1.0…
Patching component oracle.rdbms.rman, 12.2.0.1.0…
Patching component oracle.rdbms.install.plugins, 12.2.0.1.0…
Patching component oracle.sqlplus, 12.2.0.1.0…
Patching component oracle.ons, 12.2.0.1.0…
Patching component oracle.oraolap, 12.2.0.1.0…
Patching component oracle.xdk.rsf, 12.2.0.1.0…
Patching component oracle.xdk, 12.2.0.1.0…
Patching component oracle.rdbms.lbac, 12.2.0.1.0…
Patching component oracle.sqlplus.ic, 12.2.0.1.0…
Patching component oracle.assistants.server, 12.2.0.1.0…
Patching component oracle.nlsrtl.rsf, 12.2.0.1.0…
Patching component oracle.assistants.deconfig, 12.2.0.1.0…
Patching component oracle.ldap.rsf.ic, 12.2.0.1.0…
Patching component oracle.ldap.client, 12.2.0.1.0…
Patching component oracle.assistants.acf, 12.2.0.1.0…
Patching component oracle.rdbms.oci, 12.2.0.1.0…
Patching component oracle.install.deinstalltool, 12.2.0.1.0…
Patching component oracle.oracore.rsf, 12.2.0.1.0…
Patching component oracle.precomp.lang, 12.2.0.1.0…
Patching component oracle.precomp.common, 12.2.0.1.0…
Patching component oracle.jdk, 1.8.0.91.0…
Patch 30886680 successfully applied.
Log file location: /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2021-01-18_10-03-10AM_1.log

OPatch succeeded.

Bringing up the instance and execute the datapatch verbose.

SQL> startup
ORACLE instance started.
Total System Global Area 1883107968 bytes
Fixed Size 8623736 bytes
Variable Size 671011080 bytes
Database Buffers 1795162112 bytes
Redo Buffers 8151040 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

[oracle@oracleagent 30886680]$ cd $ORACLE_HOME/OPatch
[oracle@oracleagent OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.2.0.1.0 Production on Mon Jan 18 10:33:28 2021
Copyright (c) 2012, 2021, Oracle. All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_30825_2021_01_18_10_33_28/sqlpatch_invocation.log
Connecting to database…OK
Bootstrapping registry and package to current versions…done
Determining current state…done
Current state of SQL patches:
Bundle series DBRU:
ID 200414 in the binary registry and not installed in the SQL registry

Adding patches to installation queue and performing prereq checks…
Installation queue:
Nothing to roll back
The following patches will be applied:
30886680 (DATABASE APR 2021 RELEASE UPDATE 12.2.0.1.200414)

Installing patches…
Patch installation complete. Total patches installed: 1

Validating logfiles…
Patch 30886680 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30886680/23474251/30886680_apply_BIJU1_2021Jan18_10_34_01.log (no errors)
SQL Patching tool complete on Mon Jan 18 10:37:30 2021

[oracle@oracleagent OPatch]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Mon Jan 18 10:38:48 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> SELECT owner, object_name, object_type FROM all_objects WHERE status ='INVALID';
no rows selected

SQL> set line 1000
col action form a12
col version form a40
col description form a85
col action_date form a20
select description, action, to_char(action_time,'DD/MM/RR HH18:MI:SS') action_date, ' ' version
from dba_registry_sqlpatch;

DESCRIPTION              ACTION             ACTION_DATE          VERSION
----------------------------- ---------- --------------------- ------------------
DATABASE APR 2021 RELEASE      APPLY   18/01/20 10:37:30       12.2.0.1.0
UPDATE 12.2.0.1.200414

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8