给Oracle RAC 11gR2 11.2.0.1.0 打补丁到 11.2.0.1.2  打好以后 发现EM里面显示还是11.2.0.1.0

sqlplus连接的时候也显示 11.2.0.1.0 没有任何变化 难道是补丁打得有问题？

经过查询确认 原来PSU升级后 版本显示是不变的 如果想知道 只能通过

1. Opatch查询

[oracle@taoelrac1 ~]$ /oracle/app/oracle/product/11.2.0/OPatch/opatch lsinventory -bugs_fixed | egrep 'PSU|PATCH SET UPDATE'
9655006    9655006   Tue Jul 31 15:27:47 CST 2012   GI PSU 11.2.0.1.2 (INCLUDES DATABASE PSU 11.2.0.1.
9778840    9655006   Tue Jul 31 15:27:47 CST 2012   TRACKING BUG FOR GI PSU( THIS IS REPLACEMENT FOR
                                                    APRIL GI PSU 9343627)
8974548    9654983   Tue Jul 31 15:25:24 CST 2012   BACKOUT BUG 7438445 FROM PSU 11.1.0.7.1 RELEASE LA
9352237    9654983   Tue Jul 31 15:25:24 CST 2012   DATABASE PSU 11.2.0.1.1
9654983    9654983   Tue Jul 31 15:25:24 CST 2012   DATABASE PSU 11.2.0.1.2 (INCLUDES CPUJUL2010)

2. db中查询 dba_registry_history 表中的记录

SQL> desc dba_registry_history
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ACTION_TIME                                        TIMESTAMP(6)
 ACTION                                             VARCHAR2(30)
 NAMESPACE                                          VARCHAR2(30)
 VERSION                                            VARCHAR2(30)
 ID                                                 NUMBER
 BUNDLE_SERIES                                      VARCHAR2(30)
 COMMENTS                                           VARCHAR2(255)

SQL> select * from dba_registry_history;

ACTION_TIME
---------------------------------------------------------------------------
ACTION                         NAMESPACE
------------------------------ ------------------------------
VERSION                                ID BUNDLE_SERIES
------------------------------ ---------- ------------------------------
COMMENTS
--------------------------------------------------------------------------------
03-AUG-12 09.44.40.144885 AM
APPLY                          SERVER
11.2.0.1                                2 PSU
PSU 11.2.0.1.2

SQL>

=======转=================================

Do Patchset Updates (PSU's) Change the Oracle Release Version/Fifth Digit? (Doc ID 861152.1)

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.2.0.2 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Goal

This article helps to find whether  PSU released for Oracle Database Server 10gR2  ( 10.2.0.x  ) and 11gR1 (11.1.0.x) and 11g R2  (11.2.0.x )  change the database version.
Solution

Do Patchset Updates (PSU's) Change the Oracle Release Version/Fifth Digit?

Answer: NO.

The PSU  i.e 10.2.0.4.x/10.2.0.5.x  , 11.1.0.7.x  and 11.2.0.1.x/11.2.0.2.x released for Oracle Database Server version 10.2.0.4.0/10.2.0.5.x , 11.1..0.7.0 and 11.2.0.1.0/11.2.0.2.0  respectively does NOT change the database version . That means PSU  10.2.0.4.x /10.2.0.5.x, 11.1.0.7.x, 11.2.0.1.x /11.2.0.2.x ( where x is the fifth digit ) does NOT change the 5th digit of the Oracle Database Server version.

After applying the PSU 10.2.0.4.x/10.2.0.5.x  ,11.1.0.7.x ,11.2.0.1.x/11.2.0.2.x "opatch lsinventory" still shows the version as 10.2.0.4.0/10.2.0.5.0 for Oracle 10g R2, 11.1.0.7 for Oracle 11g R1  and 11.2.0.1 /11.2.0.2 for Oracle 11g R2

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

Note : It is also applicable for the Oracle Enterprise Manager Grid Control and EM Agent

Although Patch Set Updates are referenced by their 5-place version number, with the 10.2 , 11.1 and 11.2  PSUs the product banners and Oracle Universal Installer (OUI) information are not updated with the new version number. For the 10.2 ,11.1 and 11.2 PSUs, use the OPatch inventory information to determine the PSU version currently installed.

example:

> opatch lsinventory

And compare it to the version table listed in

Note 854428.1 Patch Set Updates for Oracle Products

Section 7, "Determining the Patch Set Update Version"

or

1. Make sure your opatch version is at or above

10.2.0.4.5 for version 10.2 ORACLE_HOMEs
11.1.0.6.5 for version 11.1 ORACLE_HOMEs
11.2.0.1.0 for version 11.1 ORACLE_HOMEs
$ opatch version
Invoking OPatch 10.2.0.4.8

OPatch Version: 10.2.0.4.8
2. Verify if PSU is installed in the ORACLE_HOME

$ opatch lsinventory -bugs_fixed | egrep 'PSU|PATCH SET UPDATE'

...
12827740 13343461 Wed Feb 22 07:11:36 GMT 2012 DATABASE PSU 11.1.0.7.9 (INCLUDES CPUOCT2011)
13343461 13343461 Wed Feb 22 07:11:36 GMT 2012 DATABASE PATCH SET UPDATE 11.1.0.7.10 (INCLUDES

3. Verify the PSU Post Install steps were run in the DB

select substr(action_time,1,30) action_time,
substr(id,1,10) id,
substr(action,1,10) action,
substr(version,1,8) version,
substr(BUNDLE_SERIES,1,6) bundle,
substr(comments,1,20) comments
from registry$history;

ACTION_TIME                  ID ACTION VERSION  BUNDLE COMMENTS
---------------------------- -- ------ -------- ------ --------------
23-AUG-10 07.28.02.856762 AM 4  APPLY  10.2.0.4 PSU    PSU 10.2.0.4.3
23-AUG-10 07.31.48.001892 AM 1  APPLY  10.2.0.4 PSU    PSU 10.2.0.4.4

1943972671  2097332981