Do Patchset Updates (PSU's) Change the Oracle Release Version/Fifth Digit? [ID 861152.1] |
|
| Modified08-SEP-2011TypeHOWTOStatusPUBLISHED | |
In this Document
Goal
Solution
References
Applies to:
OracleServer - Enterprise Edition - Version: 10.2.0.4 to 11.2.0.2 - Release: 10.2 to11.2
Information in this document applies to anyplatform.
Goal
Thisarticle helps to find whether PSU released for Oracle Database Server10gR2 ( 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 ReleaseVersion/Fifth Digit?
Answer: NO.
The PSU i.e 10.2.0.4.x/10.2.0.5.x , 11.1.0.7.x and11.2.0.1.x/11.2.0.2.x released for Oracle Database Server version10.2.0.4.0/10.2.0.5.x , 11.1..0.7.0 and 11.2.0.1.0/11.2.0.2.0respectively does NOT change the database version .ThatmeansPSU 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 OracleDatabase 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 theversion as 10.2.0.4.0/10.2.0.5.0 for Oracle 10g R2, 11.1.0.7 for Oracle 11gR1 and 11.2.0.1 /11.2.0.2 for Oracle 11g R2
PSU'salsowill notchange the version of oracle binaries (likesqlplus, exp/imp etc.)
Note : It is also applicable for the Oracle Enterprise ManagerGrid Control and EM Agent
Although Patch Set Updates are referenced by their 5-place version number, withthe 10.2 , 11.1 and 11.2 PSUs the product banners and Oracle UniversalInstaller (OUI) information are not updated with the new version number. Forthe 10.2 ,11.1 and 11.2 PSUs, use the OPatch inventory information to determinethe PSU version currently installed.
example:
> opatch lsinventory
And compare it to the version table listed in
Note 854428.1Patch Set Updates forOracle 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
InvokingOPatch 10.2.0.4.8
OPatchVersion: 10.2.0.4.8
2. Verify if PSU is installed in the ORACLE_HOME
$ opatch lsinv -bugs_fixed | grep PSU
85761568833280 Tue Feb 09 16:54:18 MST 2010 DATABASE PSU 10.2.0.4.3 (INCLUDESCPUJUL2009)
88332808833280 Tue Feb 09 16:54:18 MST 2010 DATABASE PSU 10.2.0.4.4 (INCLUDESCPUOCT2009)
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_TIMEID ACTION VERSION BUNDLE COMMENTS
---------------------------- -------- -------- ------ --------------
23-AUG-10 07.28.02.856762 AM 4APPLY 10.2.0.4 PSU PSU 10.2.0.4.3
23-AUG-10 07.31.48.001892 AM 1APPLY 10.2.0.4 PSU PSU 10.2.0.4.4
Note: The registry$history will not contain the row showingthe PSU Post Install step was executed unless catbundle.sql is executed.This means if the Post Install steps were skipped because the db was upgradedor created after installing the PSU, this row will not exist
-------------------------------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
Weibo: http://weibo.com/tianlesoftware
Email: dvd.dba@gmail.com
DBA1 群:62697716(满); DBA2 群:62697977(满)DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群:83829929(满) DBA5群: 142216823(满)
DBA6 群:158654907(满) DBA7 群:69087192(满)DBA8 群:172855474
DBA 超级群2:151508914 DBA9群:102954821 聊天 群:40132017(满)
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请
分享到:
相关推荐
2011年9月23日,Oracle 发布了11.2.0.3 的Patchset,完整安装版,不需要先安装11G的其它版本。 Oracle 10.2.0.5是Oracle官方宣布的10.2的最后一个版本,2010年4月30日发布。 以下版本包含所有平台,请使用使用迅雷...
Description TIMESTEN 11.2.1.9.9 RELEASE Product Oracle TimesTen In-Memory Database Release TimesTen 11.2.1.9.9
Oracle 11.2.0.3 Patchset. 下载链接
oracle 10g 10.2.0.4 升级提到的一个稳定,原文 If this reports a version lower or higher then 4, see OracleMetalink document 553812.1 "Actions for the DSTv4 update in the Release 10.2.0.4 patchset".
This SBP contains Patchset Update 10.2.0.5.11 (patch number 16056270) which in turn, comprises all fixes from Critical Patch Update CPU April 2013.
It is Oracle Database Patch 4 for 10.2.0.4 , It can be applied over Oracle Database 10g with Patchset 10.2.0.4 Linux 64 bit
TimesTen Patchset 17019459 -01 Description TIMESTEN 11.2.1.9.9 RELEASE Product Oracle TimesTen In-Memory Database Release TimesTen 11.2.1.9.9
一、硬件要求 二、软件 三、系统安装注意 四、安装Oracle前的系统准备工作 五、安装Oracle,并进行相关设置 六、升级Oracle到patchset 10.2.0.4 七、使用rlwrap调用sqlplus中历史命令
绝对可以用,下载可以用迅雷.目前仍然可以使用20120301
CAOS项目(基于Phh AOSP) 这是GSI专案,是根据Phh的作品打出的补丁 apply-patches.sh以应用所有补丁。 用法:cd / where / aosp / sources bash〜/ files / patches / aosp / v224 / apply-patches.sh〜/ files / ...
目 录 一、硬件要求 二、软件 三、系统安装注意 四、安装Oracle前的系统准备工作 五、安装Oracle,并进行相关设置 六、升级Oracle到patchset 10.2.0.4 七、使用rlwrap调用sqlplus中历史命令
>>> from unidiff import PatchSet >>> diff = urllib.request.urlopen('https://github.com/matiasb/python-unidiff/pull/3.diff') >>> encoding = diff.headers.get_charsets()[0] >>> patch = PatchSet(diff, ...
Shadow-sources是一个Linux内核补丁集,旨在稳定,包含修补程序和增强性能的补丁程序,并设计成模块化的,允许其他人轻松添加或删除补丁程序,同时重点关注服务器的稳定性。
Thinkpad Wifi Patchset Using this ISO you should be able to get rid of annoying bootmessages: "1802 Unauthorized network card is plugged in. Power off and remove the Mini PCI network card." "01C9...
patchset/<github>/BZ_<bz>/V<patch>/<title> 例如: patchset/mdkinney/BZ_1234/V1/Add_My_New_Feature patchset分支中的必需文件为: Readme.txt # Same as edk2-ci/master License.txt # Same as edk2-c...
博客:PostgreSQL的学习心得和知识总结(五十三)|语法级自上而下完美实现MySQL数据库的 insert set 的实现方案
gerrit-change-trigger:Gerrit 变更触发器插件 添加一名作者 存储库: : 发布: : 概要 这是一个 Gerrit 插件。 这可以在 gerrit 事件流的更改中触发最新补丁patchset-created事件。 Trigger按钮被添加到修订...
安装 npm install 假设存在 ENV.FIREWORK_URL ENV.JOB_NAME ENV.BUILD_NUMBER ENV.BUILD_URL ENV.GERRIT_PROJECT ENV.GERRIT_CHANGE_NUMBER ENV.GERRIT_PATCHSET_NUMBER ENV.GERRIT_CHANGE_URL
介绍 这是一个简单的钩子,用于使用有关Gerrit审查中发生的更改的信息来更新 。 它解析来自Gerrit的提交消息,并以“#1028”的样式查找Redmine问题。 然后,它向Redmine问题添加有关审阅URL和其他数据的信息性...
inox补丁集:Inox补丁集试图通过禁用向Google的数据传输来提供最小的基于Chromium的浏览器,并注重隐私