Find oracle patch version

Easy way to find patch version is use opatch application


$ORACLE_HOME/OPatch/opatch lsinventory

example of output

[oracle@atlantisoracle ~]$ opatch lsinventory
Oracle Interim Patch Installer version
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Oracle Home : /export/home/oracle/app/11gr2
Central Inventory : /export/home/oracle/oraInventory
 from : /export/home/oracle/app/11gr2/oraInst.loc
OPatch version :
OUI version :
Log file location : /export/home/oracle/app/11gr2/cfgtoollogs/opatch/opatch2017-07-18_13-46-41PM_1.log

Lsinventory Output file location : /export/home/oracle/app/11gr2/cfgtoollogs/opatch/lsinv/lsinventory2017-07-18_13-46-41PM.txt

Below will be a list of current patches

To find this same information from inside the database, there are a two views that can be used.


SQL> select * from sys.v$version ;

Oracle Database 11g Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
CORE Production
TNS for Solaris: Version - Production
NLSRTL Version - Production
SQL>select * from sys.registry$history;

This view will display you a history of patches.

Leave a Reply

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