Sunday, December 6, 2009

Does PSU Released For Oracle Change The Database Version/Fifth Digit? (Answer is NO)

Intro to Patch Set Updates (PSU) [ID 854428.1] - Original

2.3 Baseline Version for Easier Tracking
Oracle associates a version number to the patch. The fifth number of the database version is incremented for each PSU. For example, the initial PSU is version, the next PSU for Release will be, and so on.

This enables customers and Oracle Support to refer to just one number, the version, rather than a list of one-off patches or sets of bundles that have been applied.

Any new one-off patches are requested on the five-number version number.

Does PSU Released For Oracle 10gR2 ( 11g R1 (11.10.7) Change The Database Version/Fifth Digit ? [ID 861152.1] - Updated through Metalink

Applies to:
Oracle Server - Enterprise Edition - Version: to
Information in this document applies to any platform.

This article helps to find whether PSU released for Oracle Database Server 10gR2 ( ) and 11gR2 ( change the database version.

Answer is NO.

The PSU i.e and released for Oracle Database Server version and 11.1..0.7.0 respectively does NOT change the database version . That means PSU and ( where x is the fifth digit ) does NOT change the 5th digit of the Oracle Database Server version.

After applying the PSU and "opatch lsinventory" still shows the version as for Oracle 10g R2 a nd for Oracle 11g R1.

PSU also does not change the version of oracle binaries (like sqlplus, exp/imp etc.)

It was suggested that starting in the October 2009 release of the PSU that the version number would be updated in the binaries and dba_registry. Development determined that would not be possible for current releases as it also would require a change the the OUI. Therefore, this will not occur on any PSU release prior to 11.2 and possibly not until the 1st patchset of 11.2

[oracle@vmxdb01 view_recompile]$ sqlplus '/ as sysdba'

SQL*Plus: Release - Production on Sun Dec 6 09:43:15 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

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

SQL> select * from registry$history;

------------------------------ ---------- ---------- ---------- --------- -------------------- ----------
06-DEC-09 AM CPU 6452863 view recompilation

SQL> select * from v$version;

Oracle Database 10g Enterprise Edition Release - Prod
PL/SQL Release - Production
CORE Production
TNS for Linux: Version - Production
NLSRTL Version - Production