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;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE    11.1.0.7.0      Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - 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 11.1.0.8.3
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    : 11.1.0.8.3
OUI version       : 11.1.0.7.0
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                                                  11.1.0.6.0
Oracle Database 11g Examples                                         11.1.0.6.0
Oracle Database 11g Patch Set 1                                      11.1.0.7.0
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:
     7295298
   This patch overlays patches:
     13923474
   This patch needs patches:
     13923474
   as prerequisites

.........


 



Main menu 2

Story | by Dr. Radut