Keeping your Oracle 19c database up to date is vital for performance, stability and security. In this article we walk you through the full patching process for a single‐instance Oracle 19c database on Linux — from preparing backups and validating the environment to applying the patch with OPatch and verifying the outcome.
Required files:
Patch 19.28 - p37960098_190000_Linux-x86-64.zip
Latest OPatch - p6880880_190000_Linux-x86-64.zip
Location of Patch and OPatch:
[oracle@dba-simplified ~]$ cd /home/patch/
[oracle@dba-simplified patch]$ ls -ltr
total 2274844
-rwxrwxr-x 1 oracle oinstall 72884918 Nov 2 2025 p6880880_190000_Linux-x86-64.zip --> opatch
-rwxrwxr-x 1 oracle oinstall 2256549942 Nov 2 2025 p37960098_190000_Linux-x86-64.zip --> patch
Unzip the patch:
[oracle@dba-simplified patch]$ unzip -oq p37960098_190000_Linux-x86-64.zip
[oracle@dba-simplified patch]$ ls -ltr
total 2277172
drwxr-xr-x 5 oracle oinstall 81 Jul 15 17:15 37960098
-rw-rw-r-- 1 oracle oinstall 2382992 Jul 16 02:16 PatchSearch.xml
-rwxrwxr-x 1 oracle oinstall 72884918 Nov 2 2025 p6880880_190000_Linux-x86-64.zip
-rwxrwxr-x 1 oracle oinstall 2256549942 Nov 2 2025 p37960098_190000_Linux-x86-64.zip
Upgrade the OPatch utility:
[oracle@dba-simplified ~]$ cd $ORACLE_HOME
[oracle@dba-simplified db_1]$ mv OPatch OPatch_bkp
[oracle@dba-simplified db_1]$ unzip -oq /home/patch/p6880880_190000_Linux-x86-64.zip
[oracle@dba-simplified db_1]$
[oracle@dba-simplified db_1]$ cd OPatch
[oracle@dba-simplified OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.48
OPatch succeeded.
Prerequisites:
Step 1: Take full database backup – a safety net in case the patch causes issues.
(Use RMAN to perform the full database backup)
Step 2: Backup the Oracle Home – allows you to restore the home if the patch fails.
[oracle@dba-simplified ~]$ cd /home/patch
[oracle@dba-simplified patch]$ nohup tar -cvzf dbhome_bkp.tar.gz $ORACLE_HOME &
[1] 19187
[oracle@dba-simplified patch]$ nohup: ignoring input and appending output to ‘nohup.out’
[oracle@dba-simplified patch]$ jobs
[1]+ Running nohup tar -cvzf dbhome_bkp.tar.gz $ORACLE_HOME &
[oracle@dba-simplified patch]$ jobs
[1]+ Done nohup tar -cvzf dbhome_bkp.tar.gz $ORACLE_HOME
Step 3: Check for invalid objects
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
0
Step 4: Check DBA_REGISTRY – ensures compatibility and that no previous patching or component issues exist.
SQL> select comp_id, version, comp_name, status from dba_registry;
COMP_ID VERSION COMP_NAME STATUS
------- ----------- ----------------------------------- ----------
CATALOG 19.0.0.0.0 Oracle Database Catalog Views VALID
CATPROC 19.0.0.0.0 Oracle Database Packages and Types VALID
RAC 19.0.0.0.0 Oracle Real Application Clusters OPTION OFF
JAVAVM 19.0.0.0.0 JServer JAVA Virtual Machine VALID
XML 19.0.0.0.0 Oracle XDK VALID
CATJAVA 19.0.0.0.0 Oracle Database Java Packages VALID
APS 19.0.0.0.0 OLAP Analytic Workspace VALID
XDB 19.0.0.0.0 Oracle XML Database VALID
OWM 19.0.0.0.0 Oracle Workspace Manager VALID
CONTEXT 19.0.0.0.0 Oracle Text VALID
ORDIM 19.0.0.0.0 Oracle Multimedia VALID
SDO 19.0.0.0.0 Spatial VALID
XOQ 19.0.0.0.0 Oracle OLAP API VALID
OLS 19.0.0.0.0 Oracle Label Security VALID
DV 19.0.0.0.0 Oracle Database Vault VALID
15 rows selected.
Step 5: Check OPatch utility.
[oracle@dba-simplified ~]$ cd $ORACLE_HOME/OPatch
[oracle@dba-simplified OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.48
OPatch succeeded.
[oracle@dba-simplified OPatch]$ ./opatch lspatches
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)
OPatch succeeded.
Patching Steps
Step 1: Stop Database Services
[oracle@dba-simplified ~]$ lsnrctl stop
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 20-OCT-2025 18:21:07
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.150)(PORT=1521)))
The command completed successfully
[oracle@dba-simplified ~]$
[oracle@dba-simplified ~]$ sqlplus / as sysdba
sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Oct 20 18:21:13 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> SHUT IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
Step 2: Run OPatch pre-checks
[oracle@dba-simplified ~]$ cd $ORACLE_HOME/OPatch
[oracle@dba-simplified OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/patch/37960098
Oracle Interim Patch Installer version 12.2.0.1.48
Copyright (c) 2025, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /home/app/oracle/product/19.3.0/db_1
Central Inventory : /home/app/oraInventory
from : /home/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.48
OUI version : 12.2.0.7.0
Log file location : /home/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2025-10-20_18-26-36PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@dba-simplified OPatch]$ ./opatch prereq CheckSystemSpace -phBaseDir /home/patch/37960098
Oracle Interim Patch Installer version 12.2.0.1.48
Copyright (c) 2025, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /home/app/oracle/product/19.3.0/db_1
Central Inventory : /home/app/oraInventory
from : /home/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.48
OUI version : 12.2.0.7.0
Log file location : /home/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2025-10-20_18-28-37PM_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.
[oracle@dba-simplified OPatch]$ ./opatch prereq CheckActiveFilesAndExecutables -phBaseDir /home/patch/37960098
Oracle Interim Patch Installer version 12.2.0.1.48
Copyright (c) 2025, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /home/app/oracle/product/19.3.0/db_1
Central Inventory : /home/app/oraInventory
from : /home/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.48
OUI version : 12.2.0.7.0
Log file location : /home/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2025-10-20_18-32-41PM_1.log
Invoking prereq "checkactivefilesandexecutables"
Prereq "checkActiveFilesAndExecutables" for patch 37960098 passed.
OPatch succeeded.
Step 3: Apply the patch
[oracle@dba-simplified ~]$ cd /home/patch/37960098/
[oracle@dba-simplified 37960098]$ $ORACLE_HOME/OPatch/opatch apply -silent
Oracle Interim Patch Installer version 12.2.0.1.48
Copyright (c) 2025, Oracle Corporation. All rights reserved.
Oracle Home : /home/app/oracle/product/19.3.0/db_1
Central Inventory : /home/app/oraInventory
from : /home/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.48
OUI version : 12.2.0.7.0
Log file location : /home/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2025-10-20_18-40-14PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 37960098
Do you want to proceed? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/home/app/oracle/product/19.3.0/db_1')
Is the local system ready for patching? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
Backing up files...
Applying interim patch '37960098' to OH '/home/app/oracle/product/19.3.0/db_1'
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.precomp.companion, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.ldap.ztk, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.pg4mq, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.java.sqlj.sqljruntime, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] , [ oracle.jdk, 1.8.0.391.11 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.rsf, 19.0.0.0.0...
Patching component oracle.rdbms.util, 19.0.0.0.0...
Patching component oracle.rdbms, 19.0.0.0.0...
Patching component oracle.assistants.acf, 19.0.0.0.0...
Patching component oracle.assistants.deconfig, 19.0.0.0.0...
Patching component oracle.assistants.server, 19.0.0.0.0...
Patching component oracle.blaslapack, 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.dbdev, 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.duma, 19.0.0.0.0...
Patching component oracle.javavm.client, 19.0.0.0.0...
Patching component oracle.ldap.owm, 19.0.0.0.0...
Patching component oracle.ldap.rsf, 19.0.0.0.0...
Patching component oracle.ldap.security.osdt, 19.0.0.0.0...
Patching component oracle.marvel, 19.0.0.0.0...
Patching component oracle.network.rsf, 19.0.0.0.0...
Patching component oracle.odbc.ic, 19.0.0.0.0...
Patching component oracle.ons, 19.0.0.0.0...
Patching component oracle.ons.ic, 19.0.0.0.0...
Patching component oracle.oracore.rsf, 19.0.0.0.0...
Patching component oracle.perlint, 5.28.1.0.0...
Patching component oracle.precomp.common.core, 19.0.0.0.0...
Patching component oracle.precomp.rsf, 19.0.0.0.0...
Patching component oracle.rdbms.crs, 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.rdbms.oci, 19.0.0.0.0...
Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0...
Patching component oracle.rdbms.scheduler, 19.0.0.0.0...
Patching component oracle.rhp.db, 19.0.0.0.0...
Patching component oracle.rsf, 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.sqlplus.ic, 19.0.0.0.0...
Patching component oracle.tfa.db, 19.0.0.0.0...
Patching component oracle.wwg.plsql, 19.0.0.0.0...
Patching component oracle.xdk.rsf, 19.0.0.0.0...
Patching component oracle.oraolap.api, 19.0.0.0.0...
Patching component oracle.ldap.ssl, 19.0.0.0.0...
Patching component oracle.rdbms.locator, 19.0.0.0.0...
Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0...
Patching component oracle.rdbms.rman, 19.0.0.0.0...
Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...
Patching component oracle.mgw.common, 19.0.0.0.0...
Patching component oracle.rdbms.install.common, 19.0.0.0.0...
Patching component oracle.oraolap, 19.0.0.0.0...
Patching component oracle.network.aso, 19.0.0.0.0...
Patching component oracle.ctx.atg, 19.0.0.0.0...
Patching component oracle.nlsrtl.rsf.lbuilder, 19.0.0.0.0...
Patching component oracle.rdbms.rat, 19.0.0.0.0...
Patching component oracle.ctx.rsf, 19.0.0.0.0...
Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...
Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...
Patching component oracle.rdbms.dm, 19.0.0.0.0...
Patching component oracle.xdk.xquery, 19.0.0.0.0...
Patching component oracle.nlsrtl.rsf, 19.0.0.0.0...
Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0...
Patching component oracle.nlsrtl.rsf.ic, 19.0.0.0.0...
Patching component oracle.sqlj.sqljruntime, 19.0.0.0.0...
Patching component oracle.network.listener, 19.0.0.0.0...
Patching component oracle.javavm.server, 19.0.0.0.0...
Patching component oracle.ldap.client, 19.0.0.0.0...
Patching component oracle.install.deinstalltool, 19.0.0.0.0...
Patching component oracle.xdk, 19.0.0.0.0...
Patching component oracle.network.client, 19.0.0.0.0...
Patching component oracle.rdbms.hs_common, 19.0.0.0.0...
Patching component oracle.rdbms.drdaas, 19.0.0.0.0...
Patching component oracle.dbtoolslistener, 19.0.0.0.0...
Patching component oracle.sdo.locator, 19.0.0.0.0...
Patching component oracle.ovm, 19.0.0.0.0...
Patching component oracle.rdbms.lbac, 19.0.0.0.0...
Patching component oracle.odbc, 19.0.0.0.0...
Patching component oracle.rdbms.dv, 19.0.0.0.0...
Patching component oracle.rdbms.hsodbc, 19.0.0.0.0...
Patching component oracle.xdk.server, 19.0.0.0.0...
Patching component oracle.xdk.parser.java, 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 37960098 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [37960098].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /home/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2025-10-20_18-40-14PM_1.log
OPatch succeeded.
[oracle@dba-simplified 37960098]$
Step 4: Restart Database Services
[oracle@dba-simplified ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Oct 20 19:00:13 2025
Version 19.28.0.0.0
Copyright (c) 1982, 2025, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1543502248 bytes
Fixed Size 8939944 bytes
Variable Size 905969664 bytes
Database Buffers 620756992 bytes
Redo Buffers 7835648 bytes
Database mounted.
Database opened.
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.28.0.0.0
[oracle@dba-simplified ~]$
[oracle@dba-simplified ~]$ lsnrctl start
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 20-OCT-2025 19:00:58
Copyright (c) 1991, 2025, Oracle. All rights reserved.
Starting /home/app/oracle/product/19.3.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /home/app/oracle/product/19.3.0/db_1/network/admin/listener.ora
Log messages written to /home/app/oracle/diag/tnslsnr/dba-simplified/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.150)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.150)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 20-OCT-2025 19:01:03
Uptime 0 days 0 hr. 0 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/app/oracle/product/19.3.0/db_1/network/admin/listener.ora
Listener Log File /home/app/oracle/diag/tnslsnr/dba-simplified/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.150)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
[oracle@dba-simplified ~]$
[oracle@dba-simplified ~]$ lsnrctl status | grep orcl
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=dba-simplified)(PORT=5500))(Security=(my_wallet_directory=/home/app/oracle/admin/orcl/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
[oracle@dba-simplified ~]$
Post-Patching Steps
Step 1: Run DATAPATCH
[oracle@dba-simplified ~]$ cd $ORACLE_HOME/OPatch
[oracle@dba-simplified OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.28.0.0.0 Production on Mon Oct 20 19:11:00 2025
Copyright (c) 2012, 2025, Oracle. All rights reserved.
Log file for this invocation: /home/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_30451_2025_10_20_19_11_00/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.28.0.0.0 Release_Update 250705030417: Installed
SQL registry:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 14-JUL-25 12.22.53.007219 AM
Adding patches to installation queue and performing prereq checks...done
Installation queue:
No interim patches need to be rolled back
Patch 37960098 (Database Release Update : 19.28.0.0.250715 (37960098)):
Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.28.0.0.0 Release_Update 250705030417
No interim patches need to be applied
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...done
Patch 37960098 apply: SUCCESS
logfile: /home/app/oracle/cfgtoollogs/sqlpatch/37960098/27635722/37960098_apply_ORCL_2025Oct20_19_13_09.log (no errors)
SQL Patching tool complete on Mon Oct 20 19:30:04 2025
[oracle@dba-simplified OPatch]$
Step 2: Compile invalid objects
SQL> @?/rdbms/admin/utlrp.sql
Session altered.
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN 2025-10-20 19:32:43
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 2025-10-20 19:32:45
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.
Step 3: Check the invalid object count again and match it with the pre-check results
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
0
Step 4: Verify the patch version
SQL> select INSTALL_ID, PATCH_ID, PATCH_UID, ACTION, ACTION_TIME, DESCRIPTION from dba_registry_sqlpatch;
[oracle@dba-simplified ~]$ cd $ORACLE_HOME/OPatch
[oracle@dba-simplified OPatch]$ ./opatch lspatches
37960098;Database Release Update : 19.28.0.0.250715 (37960098)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
OPatch succeeded.
Step 5: Check DBA_REGISTRY again
SQL> select comp_id, version, comp_name, status from dba_registry;
COMP_ID VERSION COMP_NAME STATUS
------- ----------- ----------------------------------- ----------
CATALOG 19.0.0.0.0 Oracle Database Catalog Views VALID
CATPROC 19.0.0.0.0 Oracle Database Packages and Types VALID
RAC 19.0.0.0.0 Oracle Real Application Clusters OPTION OFF
JAVAVM 19.0.0.0.0 JServer JAVA Virtual Machine VALID
XML 19.0.0.0.0 Oracle XDK VALID
CATJAVA 19.0.0.0.0 Oracle Database Java Packages VALID
APS 19.0.0.0.0 OLAP Analytic Workspace VALID
XDB 19.0.0.0.0 Oracle XML Database VALID
OWM 19.0.0.0.0 Oracle Workspace Manager VALID
CONTEXT 19.0.0.0.0 Oracle Text VALID
ORDIM 19.0.0.0.0 Oracle Multimedia VALID
SDO 19.0.0.0.0 Spatial VALID
XOQ 19.0.0.0.0 Oracle OLAP API VALID
OLS 19.0.0.0.0 Oracle Label Security VALID
DV 19.0.0.0.0 Oracle Database Vault VALID
15 rows selected.
With this, we have successfully completed the Oracle Database 19c (19.28) patching on the Linux environment. Always ensure to perform post-patching validations and verify the patch details to maintain system integrity and database stability.