December 24, 2010

Identifying the complete Oracle Database Software Release

Filed under: Uncategorized — srivenu @ 2:58 am

I recently found out that identifying the complete Oracle software release is not just as simple as querying V$VERSION or DBA_REGISTRY.

One of our databases was recently upgraded from to And our team has pointed that querying COMP_ID, COMP_NAME & VERSION from DBA_REGISTRY was showing for all components except OWM, Oracle Workspace Manager which was showing We raised an SR and was pointed to Metalink Note 861152.1. Looks like we need to query REGISTRY$HISTORY or use the opatch command “lsinv -bugs_fixed | grep PSU” to get the PLATFORM RELEASE NUMBER.

The following is an example from one of our 11g databases (on SunOS 5.10 Sun-Fire-15000) where we applied the Patch Set Update.

--> sqlplus / as sysdba

SQL*Plus: Release Production on Fri Dec 24 17:02:54 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from 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 product_component_version;

PRODUCT                                  VERSION    STATUS
---------------------------------------- ---------- --------------------
NLSRTL                          Production
Oracle Database 11g Enterprise Edition 64bit Production
PL/SQL                          Production
TNS for Solaris:                Production

SQL> select COMP_ID, COMP_NAME, VERSION, STATUS, MODIFIED from dba_registry;

COMP_ID    COMP_NAME                                VERSION    STATUS    
---------- ---------------------------------------- ---------- ----------
EM         Oracle Enterprise Manager       VALID     
AMD        OLAP Catalog                    VALID     
SDO        Spatial                         VALID     
ORDIM      Oracle Multimedia               VALID     
XDB        Oracle XML Database             VALID     
CONTEXT    Oracle Text                     VALID     
ODM        Oracle Data Mining              VALID     
EXF        Oracle Expression Filter        VALID     
RUL        Oracle Rules Manager            VALID     
OWM        Oracle Workspace Manager        VALID     
CATALOG    Oracle Database Catalog Views   VALID     
CATPROC    Oracle Database Packages and Types VALID     
JAVAVM     JServer JAVA Virtual Machine    VALID     
XML        Oracle XDK                      VALID     
CATJAVA    Oracle Database Java Packages   VALID     
APS        OLAP Analytic Workspace         VALID     
XOQ        Oracle OLAP API                 VALID     

17 rows selected.

SQL> Select ACTION_TIME, ACTION, VERSION, COMMENTS from registry$history;

ACTION_TIME                    ACTION           VERSION         COMMENTS                
------------------------------ ---------------  --------------- --------------------    
09-SEP-10 AM   VIEW RECOMPILE                   view recompilation
09-SEP-10 AM   UPGRADE      Upgraded from
09-SEP-10 AM   APPLY          PSU           

--> opatch lsinv -bugs_fixed | grep PSU|awk '{print $1,"",$2,"\t",$9,"\t",$10,"\t",$11}'
8974548  9654983         BACKOUT         BUG     7438445
9352237  9654983         DATABASE        PSU
9654983  9654983         DATABASE        PSU

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at

%d bloggers like this: