Jump to Navigation

286 - How to know Oracle Version and Patches

Version information is stored in a table called v$version. In this table you can find version information on Oracle, PL/SQL, etc.
To retrieve the version information for Oracle, you execute the following
SQL statement:

SQL> select * from v$version;

Oracle Database 11g Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
CORE      Production
TNS for Linux: Version - Production
NLSRTL Version - Production

The above versions are not PSU. If you want to know PSU version :

SQL> select * from registry$history;

If you want to know all patches applied to Oracle Database :

# cd $ORACLE_HOME/OPatch

# opatch lsinventory

Oracle Interim Patch Installer version
Copyright (c) 2010, Oracle Corporation.  All rights reserved.

Oracle Home       : /d01/oracle/QA/db/tech_st/11.1.0
Central Inventory : /d01/oracle/QA/oraInventory
   from           : /etc/oraInst.loc
OPatch version    :
OUI version       :
OUI location      : /d01/oracle/QA/db/tech_st/11.1.0/oui
Log file location : /d01/oracle/QA/db/tech_st/11.1.0/cfgtoollogs/opatch/opatch2013-02-20_10-33-31AM.log

Patch history file: /d01/oracle/QA/db/tech_st/11.1.0/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /d01/oracle/QA/db/tech_st/11.1.0/cfgtoollogs/opatch/lsinv/lsinventory2013-02-20_10-33-31AM.txt

Installed Top-level Products (3):

Oracle Database 11g                                        
Oracle Database 11g Examples                               
Oracle Database 11g Patch Set 1                            
There are 3 products installed in this Oracle Home.

Interim patches (17) :

Patch  7295298      : applied on Tue Feb 19 16:45:24 PST 2013
Unique Patch ID:  15173637
   Created on 1 Jul 2012, 14:05:31 hrs PST8PDT
   Bugs fixed:
   This patch overlays patches:
   This patch needs patches:
   as prerequisites



Main menu 2

Story | by Dr. Radut