Check the Patch Applied to the Oracle Database

check applied patch

In Oracle Database we have multiple ways to find Patch is Applied or not in the Database. Here i give all the ways to get the details about the same. how to check patch is applied or not in oracle, sql query to find patches applied in oracle 11g, How do I know if a patch is applied in Oracle 19c?

Check applied patch list

Here we have two ways to find the patch list and patch list with inventory, check the below commands.


$ ./opatch lspatches

Check applied patch list with lsinventory

For Linux environment:

$cd /u01/app/oracle/product/

$ ./opatch lsinventory


check applied patch

For Windows environment:

>cd %ORACLE_HOME%\OPatch
>opatch lsinventory

Check patches with more details

$./opatch lsinventory -details

Output Like:

[oracle@ocptechnology OPatch]$ ./opatch lsinventory -details
Oracle Interim Patch Installer version
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/
OPatch version    :
OUI version       :
Log file location : /u01/app/oracle/product/

Lsinventory Output file location : /u01/app/oracle/product/

Installed Top-level Products (1):

Oracle Database 11g                                        
There are 1 products installed in this Oracle Home.

Installed Products (136):

Agent Required Support Files                               
Assistant Common Files                                     
Bali Share                                                 
Buildtools Common Files                                    
Character Set Migration Utility                            
Cluster Verification Utility Common Files                  
Database Configuration and Upgrade Assistants              
Database SQL Scripts                                       
Database Workspace Manager                                 
Deinstallation Tool                                        
Enterprise Edition Options                                 
Enterprise Manager Agent                                   
Enterprise Manager Agent Core Files                        
Enterprise Manager Common Core Files                       
Enterprise Manager Common Files                            
Enterprise Manager Database Plugin -- Agent Support        
Enterprise Manager Database Plugin -- Repository Support   
Enterprise Manager Grid Control Core Files                 
Enterprise Manager plugin Common Files                     
Enterprise Manager Repository Core Files                   
Exadata Storage Server                                     
Expat libraries                                             
Generic Connectivity Common Files                          
HAS Common Files                                           
HAS Files for DB                                           
Installation Common Files                                  
Installation Plugin Files                                  
Installer SDK Component                                    
JAccelerator (COMPANION)                                   
Java Development Kit                                      
LDAP Required Support Files                                
OLAP SQL Scripts                                           
Oracle 11g Warehouse Builder Required Files                
Oracle Advanced Security                                   
Oracle Application Express                                 
Oracle Call Interface (OCI)                                
Oracle Clusterware RDBMS Files                             
Oracle Code Editor                                         
Oracle Configuration Manager                               
Oracle Configuration Manager Client                        
Oracle Configuration Manager Deconfiguration               
Oracle Containers for Java                                 
Oracle Core Required Support Files                         
Oracle Data Mining RDBMS Files                             
Oracle Database 11g                                        
Oracle Database 11g                                        
Oracle Database 11g Multimedia Files                       
Oracle Database Deconfiguration                            
Oracle Database Gateway for ODBC                           
Oracle Database User Interface                             
Oracle Database Utilities                                  
Oracle Database Vault J2EE Application                     
Oracle Database Vault option                               
Oracle DBCA Deconfiguration                                
Oracle Display Fonts                                        
Oracle Enterprise Manager Console DB                       
Oracle Extended Windowing Toolkit                          
Oracle Globalization Support                               
Oracle Globalization Support                               
Oracle Help For Java                                        
Oracle Help for the  Web                                   
Oracle Ice Browser                                          
Oracle Internet Directory Client                           
Oracle Java Client                                         
Oracle JDBC Server Support Package                         
Oracle JDBC/OCI Instant Client                             
Oracle JDBC/THIN Interfaces                                
Oracle JFC Extended Windowing Toolkit                      
Oracle JVM                                                 
Oracle Label Security                                      
Oracle LDAP administration                                 
Oracle Locale Builder                                      
Oracle Message Gateway Common Files                        
Oracle Multimedia                                          
Oracle Multimedia Annotator                                
Oracle Multimedia Client Option                            
Oracle Multimedia Java Advanced Imaging                    
Oracle Multimedia Locator                                  
Oracle Multimedia Locator RDBMS Files                      
Oracle Net                                                 
Oracle Net Listener                                        
Oracle Net Required Support Files                          
Oracle Net Services                                        
Oracle Netca Client                                        
Oracle Notification Service                                
Oracle Notification Service (eONS)                         
Oracle ODBC Driver                                         
Oracle ODBC Driverfor Instant Client                       
Oracle OLAP                                                
Oracle OLAP API                                            
Oracle OLAP RDBMS Files                                    
Oracle One-Off Patch Installer                             
Oracle Partitioning                                        
Oracle Programmer                                          
Oracle Quality of Service Management (Client)              
Oracle RAC Deconfiguration                                 
Oracle RAC Required Support Files-HAS                      
Oracle Real Application Testing                            
Oracle Recovery Manager                                    
Oracle Security Developer Tools                            
Oracle Spatial                                             
Oracle SQL Developer                                       
Oracle Starter Database                                    
Oracle Text                                                
Oracle Text Required Support Files                         
Oracle UIX                                                 
Oracle Universal Connection Pool                           
Oracle Universal Installer                                 
Oracle USM Deconfiguration                                 
Oracle Wallet Manager                                      
Oracle XML Development Kit                                 
Oracle XML Query                                           
Parser Generator Required Support Files                    
Perl Interpreter                                           
Perl Modules                                               
PL/SQL Embedded Gateway                                    
Platform Required Support Files                            
Precompiler Common Files                                   
Precompiler Required Support Files                         
Provisioning Advisor Framework                             
RDBMS Required Support Files                               
RDBMS Required Support Files for Instant Client            
RDBMS Required Support Files Runtime                       
Required Support Files                                     
Sample Schema Data                                         
Secure Socket Layer                                        
SQL*Plus Files for Instant Client                          
SQL*Plus Required Support Files                            
SQLJ Runtime                                               
SSL Required Support Files for InstantClient               
XDK Required Support Files                                 
XML Parser for Java                                        
XML Parser for Oracle JVM                                  
There are 136 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.


OPatch succeeded.

SQL command to check Applied patches

We have two different query to check applied pathces details in oracle database.

Command for Oracle 11G

Use the below command to for oracle 11g Database version, login with sys user in database and run the below command.

COLUMN action_time FORMAT A20
COLUMN comments FORMAT A30
COLUMN bundle_series FORMAT A10
set lin 300 pagesize 200

SELECT TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time,
action, version, id, comments, bundle_series
FROM   sys.registry$history
ORDER by action_time;

Command for Oracle 12C

In oracle 12c litle change in query, login as sys user and run the below query.

col action_time for a28
col action for a8
col version for a8
col comments for a30
col status for a10
set line 999 pages 999

select patch_id,  version, status, Action,Action_time from dba_registry_sqlpatch order by action_time;

Connect with us on Social Network 👇

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to Top