在安装psu补丁之后，登陆数据库发现sqlplus、数据库版本号没有发生变更。查看MOS官方给出如下解释。同时做了一个测试，将打psu补丁后的数据库冷备份到打补丁之前的数据库仍然可以
启动数据库，同时没有任何报错。
APPLIES TO:
Oracle Database - Enterprise Edition - Version 10.2.0.4 to 12.1.0.1 [Release 10.2 to 12.1]
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) ,11g R2 (11.2.0.x ) and 12c R1 (12.1.0.1) 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 or higher , 11.1.0.7.x and 11.2.0.1.x or higher and 12.10.1 released for Oracle Database Server version 10.2.0.4.x or higher , 11.1..0.7.0 ,11.2.0.1 or higher and 12.1.0.1 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/11.2.0.3.x/11.2.0.4.x and 12.1.0.1. x ( where x is the fifth digit ) does NOT change the 5th digit of the Oracle Database Server version.After applying the PSU "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 , 11.2.0.1 /11.2.0.2/11.2.0.3/11.2.0.4 for Oracle 11g R2 and 12.1.0.1 for Oracle 12c R1 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 ,11.2 and 12.1 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
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.2 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
For Windows : You get the output as mentioned below
Example output :
ACTION_TIME ID ACTION VERSION BUNDLE COMMENTS ---------------------------- -- ------ -------- ------ --------------
30-JUL-12 10.28.44.656000 PM 20 APPLY 11.2.0.2 WINBUN Patch 20
Note: The registry$history will not contain the row showing the PSU Post Install step was executed unless catbundle.sql is executed. This means if the Post Install steps were skipped because the db was upgraded or created after installing the PSU, this row will not exist
备注：MOS通过查看registry$history视图，查看DB是否更新psu,同时也可以通过dba_registry_history视图进行查看。