Determine the Oracle Database Platform Specific Release Number

If you ask your Oracle DBMS about its full Oracle Database Release Number, you get an answer like the following (recommended way to query this, compare Identifying Your Oracle Database Software Release):

SQL> COL PRODUCT FORMAT A40
SQL> COL VERSION FORMAT A15
SQL> COL STATUS FORMAT A15
SQL> SELECT * FROM PRODUCT_COMPONENT_VERSION;

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

But this is simply wrong, the last byte, the Platform specific release number is not 0 in my case, e.g. after you applied a patch cluster (CPU) to your installation!

Solution is to use the opatch utility, which resides in your ORACLE_HOME directory: Start it with the lsinventory parameter and the sky is clear. Have a look at the first line with Database Patch Set Update:

$ /opt/oracle/product/11.2.0.3/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.</code>

Oracle Home : /opt/oracle/product/11.2.0.3
Central Inventory : /opt/oracle/home/oraInventory
from : /opt/oracle/product/11.2.0.3/oraInst.loc
OPatch version : 11.2.0.3.0
OUI version : 11.2.0.3.0
Log file location : /opt/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch2012-11-14_15-46-23PM_1.log

Lsinventory Output file location : /opt/oracle/product/11.2.0.3/cfgtoollogs/opatch/lsinv/lsinventory2012-11-14_15-46-23PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch 14275605 : applied on Wed Oct 17 16:31:29 CEST 2012
Unique Patch ID: 15377775
Patch description: "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Created on 4 Oct 2012, 00:07:51 hrs PST8PDT
Sub-patch 13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch 13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
Bugs fixed:
14480676, 13566938, 13419660, 10350832, 13632717, 14063281, 12919564
13624984, 13430938, 13467683, 13588248, 13420224, 14548763, 13080778
...