Oracle

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 10.2.0.4.0 to 10.2.0.4.3. And our team has pointed that querying COMP_ID, COMP_NAME & VERSION from DBA_REGISTRY was showing 10.2.0.4.0 for all components except OWM, Oracle Workspace Manager which was showing 10.2.0.4.3. 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 11.2.0.1.2 Patch Set Update.

--> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 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 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options



SQL> select * from v$version;

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

SQL> select * from product_component_version;


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


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


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

17 rows selected.


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


ACTION_TIME                    ACTION           VERSION         COMMENTS                
------------------------------ ---------------  --------------- --------------------    
09-SEP-10 04.07.34.774652 AM   VIEW RECOMPILE                   view recompilation
09-SEP-10 04.07.34.886572 AM   UPGRADE          11.2.0.1.0      Upgraded from 10.2.0.3.0
09-SEP-10 04.18.11.450891 AM   APPLY            11.2.0.1        PSU 11.2.0.1.2           


--> 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     11.2.0.1.1
9654983  9654983         DATABASE        PSU     11.2.0.1.2
Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 WordPress.com.

%d bloggers like this: