HOME / TROUBLESHOOTING / PREREQUISITE CHECK “CHECKACTIVEFILESANDEXECUTABLES” FAILED Prerequisite Check “CheckActiveFilesAndExecutables” Failed

CHECKACTIVEFILESANDEXECUTABLES” FAILED Prerequisite Check “CheckActiveFilesAndExecutables” Failed

[oracle@oracleagent:Database] opatch apply
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2022, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/12.1.0
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/oraInst.loc
OPatch version : 12.2.0.1.27
OUI version : 12.1.0.2.0
Logfile location: /u01/app/oracle/product/12.1.0/cfgtoollogs/opatch/opatch2022-01-21_08-04-36AM_1.log

Verifying environment and performing prerequisite checks…
Prerequisite check “CheckActiveFilesAndExecutables” failed.
The details are:

Following active executables are not used by opatch process :
/u01/app/oracle/product/12.1.0/lib/libclntsh.so.12.1

Following active executables are used by opatch process :

/u01/app/oracle/product/12.1.0/lib/libasmclntsh12.so
UtilSession failed: Prerequisite check “CheckActiveFilesAndExecutables” failed.
Logfile location: /u01/app/oracle/product/12.1.0/cfgtoollogs/opatch/opatch2022-01-21_08-04-36AM_1.log

OPatch failed with error code 73

Solution:

[oracle@oracleagent:Database] /sbin/fuser /u01/app/oracle/product/12.1.0/lib/libclntsh.so.12.1
/u01/app/oracle/product/12.1.0/lib/libclntsh.so.12.1: 22235m 24173m
[oracle@oracleagent:Database] kill -9 22235 24173
[oracle@oracleagent:Database] opatch apply
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2022, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/12.1.0
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/oraInst.loc
OPatch version : 12.2.0.1.27
OUI version : 12.1.0.2.0
Logfile location: /u01/app/oracle/product/12.1.0/cfgtoollogs/opatch/opatch2022-01-21_08-08-33AM_1.log

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

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.1.0’)

Is the local system ready for patching? [y|n]
y
User Responded with Y
Backing up files…
Applying sub-patch ‘32768233’ to OH ‘/u01/app/oracle/product/12.1.0’
ApplySession: Optional component(s) [ oracle.network.cman, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.

 

…..

….

…..

 

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 RELEASE PATCHING IN ORACLE 19C -Opatch update

patch

Description

In this article, we are going to see steps used to apply the latest Oracle 19c Database Release Update 19.9.0.0.201020 (Patch 31771877) The Environment is a single instance database.

Review readme file on Patch 31771877 – Database Release Update 19.9.0.0.201020

Download patch p31

771877_190000_Linux-x86-64.zip

Make sure the opatch version is minimum 12.2.0.1.19


Step:-1 Download the Patch from oracle support

p31771877_190000_Linux-x86-64.zip

p6880880_200000_Linux-x86-64.zip

Step:-2 Copied the patch to DB Server

[oratest@oracle ~]$ mkdir patch

[oratest@oracle ~]$ ls

[oratest@oracle ~]$ cd patch/

[oratest@oracle ~]$ ls -lrth
-rwxrwxr-x. 1 oratest oratest 116M Oct 21 10:55
-x86-64.zip
-rwxrwxr-x. 1 oratest oratest 1.6G Oct 21 11:23 p6880880_210000_Linux-x86-64.zip


Step:-3 Upgrade Opatch Tool from 12.2.0.1.17 to 12.2.0.1.

[oratest@oracle ~]$ cd $ORACLE_HOME
[oratest@oracle ~]$ ls
[oratest@oracle ~]$ ./opatch version
OPatch Version: 12.2.0.1.17

OPatch succeeded

[oratest@oracle ~]$ cd /home/oratest/patch 

[oratest@oracle ~]$  ls

[oratest@oracle ~]$cp p6880880_200000_Linux-x86-64.zip
/u01/app/oracle/product/19.0.0/dbhome_1

[oratest@oracle ~]$ cd /app/oracle/product/19.0.0/dbhome_1

[oratest@oracle ~]$pwd
/u01/app/oracle/product/19.0.0/dbhome_1
[oratest@oracle ~]$ mv OPatch/ OPatch_BKP

[oratest@oracle ~]$ unzip p6880880_200000_Linux-x86-64.zip
Archive: p6880880_200000_Linux-x86-64.zip
creating: OPatch/
inflating: OPatch/emdpatch.pl
creating: OPatch/oracle_common/
creating: OPatch/oracle_common/modules/
inflating: OPatch/oracle_common/modules/com.oracle.glcm.common-logging_1.6.5.0.jar
inflating: OPatch/oracle_common/modules/common-logging-config.jar
creating: OPatch/oplan/

[oratest@oracle]$ cd OPatch
[oratest@oracle OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.27
OPatch succeeded.

Step:-4 Check Patches status before applying using the below query

SET LINESIZE 500
SET PAGESIZE 1000
SET SERVEROUT ON
SET LONG 2000000
COLUMN action_time FORMAT A12
COLUMN action FORMAT A10
COLUMN comments FORMAT A30
COLUMN description FORMAT A60
COLUMN namespace FORMAT A20
COLUMN status FORMAT A10

SELECT TO_CHAR(action_time, ‘YYYY-MM-DD’) AS action_time,action,status,
description,patch_id FROM sys.dba_registry_sqlpatch ORDER by action_time;

Identifying Invalid Objects before patching

SQL> select owner,object_type,object_name,status from dba_objects 
where status='INVALID'; no row selected.

Step:-5  Apply RU patch on ORACLE_HOME 19c

[oracle@oraem01 soft]$ unzip p31771877_190000_Linux-x86-64.zip
[oracle@oraem01 soft]$ 31771877
[oratest@oracle 31771877]$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1

[oratest@oracle 31771877]$ 
export PATH=/u01/app/oracle/product/19.0.0/dbhome_1/OPatch:$PATH

Step – 6:- Apply opatch

[oratest@oracle 31771877]$  opatch apply
Oracle Interim Patch Installer version 12.2.0.1.27
Copyright (c) 2021, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.27
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/
opatch/opatch2021-10-21_12-48-42PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 31771877 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/19.0.0/dbhome_1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '31771877' to OH '/u01/app/oracle/product/19.0.0/dbhome_1' ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] ,
[ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] ,
[ oracle.tfa, 19.0.0.0.0 ] , [ oracle.options.olap.awm, 19.0.0.0.0 ] ,
[ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] ,
[ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] ,
[ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.assistants.usm, 19.0.0.0.0 ] ,
[ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.sqlj, 19.0.0.0.0 ] ,
[oracle.jdk, 1.8.0.191.0] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms.rsf, 19.0.0.0.0... Patching component oracle.rdbms, 19.0.0.0.0... Patching component oracle.rdbms.util, 19.0.0.0.0... Patching component oracle.assistants.acf, 19.0.0.0.0... Patching component oracle.assistants.deconfig, 19.0.0.0.0... Patching component oracle.assistants.server, 19.0.0.0.0... Patching component oracle.buildtools.rsf, 19.0.0.0.0... Patching component oracle.ctx, 19.0.0.0.0... Patching component oracle.dbjava.ic, 19.0.0.0.0... Patching component oracle.dbjava.jdbc, 19.0.0.0.0... Patching component oracle.dbjava.ucp, 19.0.0.0.0... Patching component oracle.dbtoolslistener, 19.0.0.0.0... Patching component oracle.ldap.rsf, 19.0.0.0.0... Patching component oracle.network.rsf, 19.0.0.0.0... Patching component oracle.oracore.rsf, 19.0.0.0.0... Patching component oracle.rdbms.dbscripts, 19.0.0.0.0... Patching component oracle.rdbms.deconfig, 19.0.0.0.0... Patching component oracle.sdo, 19.0.0.0.0... Patching component oracle.sdo.locator.jrf, 19.0.0.0.0... Patching component oracle.sqlplus, 19.0.0.0.0... Patching component oracle.usm.deconfig, 19.0.0.0.0... Patching component oracle.rdbms.crs, 19.0.0.0.0... Patching component oracle.oraolap, 19.0.0.0.0... Patching component oracle.precomp.rsf, 19.0.0.0.0... Patching component oracle.javavm.client, 19.0.0.0.0... Patching component oracle.precomp.common.core, 19.0.0.0.0... Patching component oracle.network.client, 19.0.0.0.0... Patching component oracle.rdbms.scheduler, 19.0.0.0.0... Patching component oracle.ctx.atg, 19.0.0.0.0... Patching component oracle.marvel, 19.0.0.0.0... Patching component oracle.oraolap.dbscripts, 19.0.0.0.0... Patching component oracle.ovm, 19.0.0.0.0... Patching component oracle.bali.ice, 11.1.1.7.0... Patching component oracle.ctx.rsf, 19.0.0.0.0... Patching component oracle.rdbms.lbac, 19.0.0.0.0... Patching component oracle.rdbms.oci, 19.0.0.0.0... Patching component oracle.odbc, 19.0.0.0.0... Patching component oracle.rdbms.rman, 19.0.0.0.0... Patching component oracle.nlsrtl.rsf, 19.0.0.0.0... Patching component oracle.rdbms.install.plugins, 19.0.0.0.0... Patching component oracle.rdbms.drdaas, 19.0.0.0.0... Patching component oracle.ldap.rsf.ic, 19.0.0.0.0... Patching component oracle.ldap.security.osdt, 19.0.0.0 Patching component oracle.dbdev, 19.0.0.0.0... Patching component oracle.rdbms.install.common, 19.0.0.0.0... Patching component oracle.sdo.locator, 19.0.0.0.0... Patching component oracle.duma, 19.0.0.0.0... Patching component oracle.sqlplus.ic, 19.0.0.0.0... Patching component oracle.xdk.rsf, 19.0.0.0.0... Patching component oracle.xdk.parser.java, 19.0.0.0.0... Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0... Patching component oracle.precomp.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... Patch 31771877 successfully applied. Sub-set patch [29517242] has become inactive due to the application of a super-set
patch [31771877]. Please refer to Doc ID 2161861.1 for any possible further required actions. Log file location: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/
opatch2021-10-21_12-48-42PM_1.log OPatch succeeded.

Step – 7 – Run the Below Commands

SQL> select owner from all_objects where status='INVALID';
no rows selected
SQL> @?/rdbms/admin/utlrp.sql
Session altered.
TIMESTAMP
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN              2021-10-21 13:20:37
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>
DOC>   Use the following queries to track recompilation progress:
DOC>
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);
DOC>
DOC>   2. Query returning the number of objects compiled so far. This number
DOC>      should increase with time.
DOC>         SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC>   This script automatically chooses serial or parallel recompilation
DOC>   based on the number of CPUs available (parameter cpu_count) multiplied
DOC>   by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC>   On RAC, this number is added across all RAC nodes.
DOC>
DOC>   UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC>   recompilation. Jobs are created without instance affinity so that they
DOC>   can migrate across RAC nodes. Use the following queries to verify
DOC>   whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC>   1. Query showing jobs created by UTL_RECOMP
DOC>         SELECT job_name FROM dba_scheduler_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC>   2. Query showing UTL_RECOMP jobs that are running
DOC>         SELECT job_name FROM dba_scheduler_running_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#
PL/SQL procedure successfully completed.
TIMESTAMP
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END              2021-10-21 13:20:41
DOC> The following query reports the number of invalid objects.
DOC>
DOC> If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#
OBJECTS WITH ERRORS
-------------------
                  0
DOC> The following query reports the number of exceptions caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC> Note: Typical compilation errors (due to coding errors) are not
DOC>       logged into this table: they go into DBA_ERRORS instead.
DOC>#
ERRORS DURING RECOMPILATION
---------------------------
                          0
Function created.
PL/SQL procedure successfully completed.
Function dropped.
PL/SQL procedure successfully completed.


SQL> select owner from all_objects where status='INVALID';
no rows selected
                         

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

Apply Patching On Oracle 19c Database Release Update- January 2021

DESCRIPTION

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

Sep 1 : DOWNLOAD THE PATCH FROM ORACLE SUPPORT

Sep 2 : CHECK THE CURRENT OPTACH VERSION IN THE DATABASE

[oracle@localhost ~]$ export PATH=/u01/app/oracle/product/19.0.0/OPatch:$PATH
[oracle@localhost ~]$ opatch version
OPatch Version: 12.2.0.1.17

OPatch succeeded.
[oracle@localhost ~]$

Sep 3 : MOVE THE PATCH TO ORACLE HOME LOCATION

[oracle@localhost ~]$ cd Desktop/
[oracle@localhost Desktop]$ ls
LINUX.X64_193000_db_home.zip p32218454_190000_Linux-x86-64.zip VMwareTools-10.0.6-3595377.tar.gz
[oracle@localhost Desktop]$ mv p32218454_190000_Linux-x86-64.zip /u01/app/oracle/product/19.0.0/

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

Sep 4 : UNZIP THE DOWNLOADED OPATCH

oracle@localhost Desktop]$ mv p6880880_190000_Linux-x86-64.zip /u01/app/oracle/product/19.0.0/
[oracle@localhost Desktop]$ cd
[oracle@localhost ~]$ cd /u01/app/oracle/product/19.0.0/
[oracle@localhost 19.0.0]$ unzip p6880880_190000_Linux-x86-64.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@localhost 19.0.0]$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/
[oracle@localhost 19.0.0]$ export PATH=/u01/app/oracle/product/19.0.0/OPatch:$PATH
[oracle@localhost 19.0.0]$ opatch version
OPatch Version: 12.2.0.1.23

OPatch succeeded.
[oracle@localhost 19.0.0]$

Sep 5 : 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;

Sep 6 : SHUTDOWN DATABASE AND LISTENER

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0
[oracle@localhost scripts]$ cd
[oracle@localhost ~]$ cd /u01/app/oracle/product/19.0.0
[oracle@localhost 19.0.0]$ lsnrctl stop

LSNRCTL for Linux: Version 19.0.0.0.0 – Production on 27-JAN-2021 18:14:07

Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1522)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@localhost 19.0.0]$
The command completed successfully

Sep 7 : APPLY RU PATCH ON ORACLE_HOME 19C

[oracle@localhost 19.0.0]$ cd 32218454/
[oracle@localhost 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
Central Inventory : /u01/app/oracle/product/19.0.0/oraInventory
from : /u01/app/oracle/product/19.0.0//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/cfgtoollogs/opatch/opatch2021-01-27_18-46-39PM_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’)
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
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…
Patch 32218454 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [32218454].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.0.0/cfgtoollogs/opatch/opatch2021-01-27_18-46-39PM_1.log
OPatch succeeded.

Sep 8 : STARTUP THE DATABASE AND LISTENER

[oracle@localhost ~]$ cd scripts/
[oracle@localhost scripts]$ . ora19c.env
[oracle@localhost scripts]$ lsnrctl start

LSNRCTL for Linux: Version 19.0.0.0.0 – Production on 27-JAN-2021 19:12:28
Copyright (c) 1991, 2020, Oracle. All rights reserved.
Starting /u01/app/oracle/product/19.0.0/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/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1522)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1522)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 – Production
Start Date 27-JAN-2021 19:12:30
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19.0.0/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1522)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
The listener supports no services
The command completed successfully

SQL> startup
ORACLE instance started.

Total System Global Area 3019895280 bytes
Fixed Size 8901104 bytes
Variable Size 620756992 bytes
Database Buffers 2382364672 bytes
Redo Buffers 7872512 bytes
Database mounted.
Database opened.
SQL>

[oracle@localhost OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.10.0.0.0 Production on Wed Jan 27 19:47:50 2021
Copyright (c) 2012, 2020, Oracle. All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_18910_2021_01_27_19_47_50/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 27-JAN-21 05.00.33.668766 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
Installing patches…

Sep 9 : AFTER APPLYING RU PATCH,CHECK THE DBA_REGISTRY_SQLPATCH

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;

Sep 9 : USING BELOW QUERY, WE CAN VERIFY DESCRIPTION,STATUS OF APPLIED PATCH
COLUMN action_time FORMAT A10
COLUMN status FORMAT A30
COLUMN description FORMAT A30
SELECT action_time,action,status,description,patch_id from dba_registry_sqlpatch;

Sep 10 : CHECK OPATCH LSINVENTORY AND LIST OF PATCHES APPLIED.

[oracle@localhost ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/
[oracle@localhost ~]$ export PATH=/u01/app/oracle/product/19.0.0/OPatch:$PATH
[oracle@localhost ~]$ opatch lspatches
32218454;Database Release Update : 19.10.0.0.210119 (32218454)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)

OPatch succeeded.
[oracle@localhost ~]$

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

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

CHECK THE ACTION & PATCHID IN DBA_REGISTRY_SQLPATCH

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