【转Oracle补丁】老托的Oracle 数据库Patch概念性小常识

最新推荐文章于 2022-08-02 20:53:59 发布

guoliang

最新推荐文章于 2022-08-02 20:53:59 发布

阅读量2.1k

点赞数

分类专栏： oracle升级-补丁安装

oracle升级-补丁安装专栏收录该内容

9 篇文章 0 订阅

订阅专栏

【转Oracle补丁】老托的Oracle 数据库Patch概念性小常识

http://www.oracledatabase12g.com/archives/category/oracle/patch-oracle

名称	说明
Release	¤ 标准产品发布。如Oracle Database 10g Release 2的第一个发行版本为10.2.0.1,可以在OTN、edelivery等站点上公开下载
Patch Set Release	¤ 就是早期大家常说的PSR。这是在主版本号上发布的补丁集，修复了较多的Bug，可能会包含一些增强功能（Enhancement）。比如11.2.0.1是一个主版本，那么11.2.0.2、11.2.0.3就是2个不同的Patch set。这种补丁集经过了严格的集成测试，也是累积型的。所以推荐安装最新的Patch Set。
Patch Set Update	¤ 就是DBA&DMA们常论道的PSU。Oracle 选取在每个季度用户下载数量最多，并且得到验证具有较低风险的补丁放入到每个季度的PSU中，修复比较严重的一些问题，包含每个季度的CPU，是累积型的。虽然在描述PSU的时候会用到数据库版本第5位，比如Database PSU 11.2.0.3.5，但实际上打完PSU后并不会真正改变数据库的版本，从v$version中看到的版本还是4位的(11.2.0.3.0)，第5位仍然是0。 ¤ 注意 (1)Windows上没有CPU和PSU，对于Windows和Exadata，Oracle使用Bundle Patch代替PSU，Bundle Patch会包含PSU的内容 (2)从11.2.0.2版本开始，一个新的补丁策略被引入，11.2.0.1之后发布的Patch Set本身就是一个完整的安装包，不再需要基础的Release 版本安装。
Critical Patch Update	¤ 这个指的就是CPU补丁。每季度发布一次，用来修复安全方面的一些补丁，是累积型的。目前(2012年10月）已经更名为Security Patch Update (SPU) ¤ 这类问题本来不属于软件错误,在正常使用中不会出现任何问题。但是别有用心的人可以通过运行非常精巧设计的代码，绕过数据库系统的安全管理机制,达到非授权存取的目的。 ¤ 重要补丁公告参见这里.
Interim Patch/One-OffPatch	¤ 是我们常说的小补丁，为了修复某(几)个Bug而发布的补丁。这种补丁推荐在测试库上测试无误后再安装在生产库上。
Merged Patch	¤ 合并的补丁。当几个小补丁之间有冲突，不能同时安装的时候，需要提供这种Merged Patch。补丁冲突主要是由于2个或者多个补丁修改同一个文件，但是修改的内容是不同的。
Bundle Patch(BP)	¤ 补丁集，修复多个Bug。在Windows平台上的Oracle没有小补丁，只有这种Bundle Patch。这种累积型的补丁集会周期性的发布（至少每季一次）,也就是每个Bundle Patch会包含之前所有的Bundle Patch。比如Windows Bundle Patch 16，它会包含之前所有15个Bundle Patch，所以我们总是推荐安装最新的Bundle Patch。Oracle的集群软件和数据库软件的Window Bundle Patch是同一个，比如Windows Bundle Patch 16(补丁号16167942，既可以打在集群上，也可以打在数据库上) 。 ■要了解Windows Bundle Patch的补丁号，可以参考MOS文档： Note 161549.1 Oracle Database, Networking and Grid Agent Patches for Microsoft Platforms ■这部分有待补充
Diagnostic Patch	诊断补丁。顾名思义，这类补丁不是用来解决问题的，而是用来寻找问题的原因的。这类补丁只在Oracle技术支持部门要求安装时，才需要安装。在得到需要的诊断信息后，应立即卸载这一补丁。
Composite Patch	¤ 从2012年4月份的Database PSU 11.2.0.3.2和11.2.0.2.0.7开始，推出一种新的概念叫Composite Patches。这是一种新型的补丁包，它不同于其他的累积型补丁包。如果是第一次安装Composite Patches，那么该Composite Patches所包括的全部补丁都会被安装，后续安装的Composite Patches，只会安装对比前一次Composite Patches有变化的部分和新增加的补丁。 ¤ Composite Patche的改进包括减少补丁安装时间，减少回滚以前应用的overlay patches的需要。新的Composite Patches格式，使以前PSU应用的overlay patches和新安装的PSU并存成为可能。更多信息，请参考Document 1376691.1‘Composite Patches for Oracle Products’ 和Oracle Database Support NEWS April edition. ■ PSU就是一种Composite Patch ¤第一次安装的composite patch为PSU 11.2.0.3.5： 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 14727310: applied on Fri Dec 09 10:59:28 EST 2011 Patch Description: “Database Patch Set Update : 11.2.0.3.5 (14727310)” <==变化和新增的部分 Created on 14 Jan 2013, 07:56:00 hrs PST8PDT Sub-patch 14275605; “Database Patch Set Update : 11.2.0.3.4 (14275605)”<==Sub-patch Sub-patch 13923374; “Database Patch Set Update : 11.2.0.3.3 (13923374)”<==Sub-patch Sub-patch 13696216; “Database Patch Set Update : 11.2.0.3.2 (13696216)”<==Sub-patch Sub-patch 13343438; “Database Patch Set Update : 11.2.0.3.1 (13343438)”<==Sub-patch Bugs fixed: 13566938, 13593999, 10350832, 14138130 … ¤安装下一个composite patch PSU 11.2.0.3.6时，只需要安装有变化的部分和新增加的patches，不需要再安装之前已经安装的11.2.0.3.1 、11.2.0.3.2,11.2.0.3.4和11.2.0.3.5，之前已经安装的这部分就称为sub-patch： Patch 16056266: applied on Sun Apr 28 12:42:57 CST 2013 Patch Description: “Database Patch Set Update : 11.2.0.3.6 (16056266)” <==变化和新增的部分 Created on 12 Mar 2013, 02:14:47 hrs PST8PDT Sub-patch 14727310; “Database Patch Set Update : 11.2.0.3.5 (14727310)”<==Sub-patch Sub-patch 14275605; “Database Patch Set Update : 11.2.0.3.4 (14275605)”<==Sub-patch Sub-patch 13923374; “Database Patch Set Update : 11.2.0.3.3 (13923374)”<==Sub-patch Sub-patch 13696216; “Database Patch Set Update : 11.2.0.3.2 (13696216)”<==Sub-patch Sub-patch 13343438; “Database Patch Set Update : 11.2.0.3.1 (13343438)”<==Sub-patch Bugs fixed: 13616375, 14035825, 12861463, 12834027, 15862021, 13632809, 13377816 … ¤在MOS文档中有针对Composite Patches详细的说明：Note 1376691.1 Composite Patches for Oracle Products

参考知识：可以参考下面的MOS文档了解每个季度的CPU、PSU、Windows Bundle Patch的具体补丁号：

Note 1454618.1 Quick Reference to Patch Numbers for Database PSU, SPU(CPU), Bundle Patches and Patchsets

FILED UNDER: ORACLE, ORACLE补丁PATCH

RAC Grid Infrastructure安装11.2.0.3.5 14727347 PSU GI-RDBMS补丁

2013/02/13 BY MACLEAN LIU 4条评论

在《【视频教学】Maclean教你用Vbox在Linux 6.3上安装Oracle 11gR2 RAC》中我们介绍了在11.2.0.3 Grid Infrastructure GI环境下安装11.2.0.3.5 14727347 补丁的步骤；由于该11.2.0.3.5的opatch auto安装会有问题，所以我们使用手动的opatch apply安装该补丁，以下是检验步骤：

14727347解压后包含了2个补丁目录14727310和15876003 ，已包含11.2.0.3.5 DB的PSU，下载了该GI PSU后无需再去下载DB 的PSU了。

PSU 14727347的下载地址

1） rootcrs.pl 停止本节点的服务，若有RDBMS DB在运行则首先关闭该实例

su – oracle

$ <ORACLE_HOME>/bin/srvctl stop database –d <db-unique-name>

su – root

$GRID_HOME/crs/install/rootcrs.pl -unlock

2) 给GI HOME打补丁

AIX上： su – root; slibclean

su – grid

opatch napply -oh $GRID_HOME -local /tmp/patch/14727310
opatch napply -oh $GRID_HOME -local /tmp/patch/15876003/

3) 给RDBMS DB HOME打补丁

su – oracle

[oracle@vmac1 scripts]$ /tmp/patch/15876003/custom/server/15876003/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
/tmp/patch/15876003/custom/server/15876003/custom/scripts/prepatch.sh completed successfully.

opatch napply -oh $ORACLE_HOME -local /tmp/patch/15876003/custom/server/15876003
opatch napply -oh $ORACLE_HOME -local /tmp/patch/14727310
/tmp/patch/15876003/custom/server/15876003/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME

4)执行rootcrs.pl -patch

su – root

[root@vmac1 ~]# /g01/11ggrid/app/11.2.0/grid/rdbms/install/rootadd_rdbms.sh
[root@vmac1 ~]# /g01/11ggrid/app/11.2.0/grid/crs/install/rootcrs.pl -patch

5) 在2节点上重复以上步骤

6)对于现有的DB 执行升级字典操作

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT

7)执行utlrp 脚本并重启DB

SQL> @?/rdbms/admin/utlrp
SQL> shutdown immediate;
SQL> startup;

8) 重启应用程序

FILED UNDER: ORACLE, ORACLE补丁PATCH TAGGED WITH: GI, PSU

甲骨文发布2012 7月数据库安全补丁Critical Patch Update July 2012

2012/07/20 BY MACLEAN LIU 1条评论

Oracle甲骨文公司在2012年7月17日发布了最新的数据库安全补丁Critical Patch Update July 2012:在OTN的CPU security专题页面上已经生成了《Oracle Critical Patch Update Advisory – July 2012》的页面；发布的安全补丁涵盖多个版本的Oracle数据库：
包括主流数据库版本上的以下补丁：

11.2.0.3:

Database 11.2.0.3 CPU Patch 14038787, or
Database 11.2.0.3.3 PSU Patch 13923374, or
GI 11.2.0.3.3 PSU Patch 13919095, or
Microsoft Windows (32-Bit) Bundle Patch 14095819, or
Microsoft Windows x64 (64-Bit) Bundle Patch 14095820

11.2.0.2:

Database 11.2.0.2 CPU Patch 14038791, or
Database 11.2.0.2.7 PSU Patch 13923804, or
GI 11.2.0.2.7 PSU Patch 14192201, or
Microsoft Windows (32-Bit) Bundle Patch 14134042, or
Microsoft Windows x64 (64-Bit) Bundle Patch 14134043

11.1.0.7:

Database 11.1.0.7 CPU Patch 14038803, or
Database 11.1.0.7.12 PSU Patch 13923474, or
Microsoft Windows (32-Bit) Bundle Patch 14109867, or
Microsoft Windows x64 (64-Bit) Bundle Patch 14109868

10.2.0.5:

Database 10.2.0.5 CPU Patch 14038805, or
Database 10.2.0.5.8 PSU Patch 13923855, or
Microsoft Windows (32-Bit) Bundle Patch 14134051, or
Microsoft Windows x64 (64-Bit) Bundle Patch 14134053, or
Microsoft Windows Itanium (64-Bit) Patch 14134052

10.2.0.4:

Database 10.2.0.4 CPU Patch 14038814, or
Database 10.2.0.4.13 PSU Patch 13923851

Exadata:

Quarterly Database patch for Exadata – July 2012 11.2.0.3.8 Patch 14103267, or
Quarterly Full Stack download for Exadata (July 2012) Patch 14207418, or
Exadata Database Recommended Patch 17 Patch 14084153, or

FILED UNDER: ORACLE, ORACLE补丁PATCH TAGGED WITH: CRITICAL PATCH UPDATE

甲骨文发布2012 4月数据库安全补丁Critical Patch Update April 2012

2012/03/30 BY MACLEAN LIU 暂无评论

根据最新的Update to Oracle Security Alert January 2012，Oracle Database的最新Critical Patch Updates将会在17 April 2012发布，即下个月的中旬，包括针对版本11.2.0.3的 CPU、PSU补丁将 Release，因为版本10gR2已经实际进入Sustaining Support(Oracle Database 10.2 has now transitioned from Premier Support to Sustaining Support. Our records indicate the CSI used for this SR does not have Extended Support so you are only eligible to Sustaining Support. Sustaining Support includes assistance with service requests, on a commercially reasonable basis, 24 hours per day, 7 days a week. It does not include new program updates, fixes, security alerts and critical update. The support policy details can be accessed at “http://www.oracle.com/us/support/library/057419.pdf “. If you need Extended Support please contact your account team.)，

所以我们有理由相信这次的CPU更新将不会再针对10gR2的Last Patchset 10.2.0.5 ，让11gR2来得更激烈一些吧！

Critical Patch Updates

Critical Patch Updates are the primary means of releasing security fixes for Oracle products to customers with valid support contracts. They are released on the Tuesday closest to the 17th day of January, April, July and October. The next four dates are:

17 April 2012
17 July 2012
16 October 2012
15 January 2013

For Oracle Java SE Critical Patch Updates, the next three dates are:

12 June 2012
16 October 2012
19 February 2013

Patch Set Update and Critical Patch Update April 2012 Availability Document 介绍了 2012 April CPU 相关的Database 补丁：

Patch Availability for Oracle Database 11.2.0.3

Product Home	Patch	Advisory Number	Comments
Oracle Database home	Database 11.2.0.3 CPU Patch 13632717, orDatabase 11.2.0.3.2 PSU Patch 13696216, orGI 11.2.0.3.2 PSU Patch 13696251, orDatabase patch for Exadata (April 2012 – 11.2.0.3.5) Patch 13734832, or Quarterly Full Stack download for Exadata (April 2012) Patch 13839416, or Microsoft Windows (32-Bit) BundlePatch 13885388, or Microsoft Windows x64 (64-Bit) Bundle Patch 13885389	CVE-2012-0552, CVE-2012-0534, CVE-2012-0527, CVE-2012-0526, CVE-2012-0525
Oracle Database home	Patch 13705478	CVE-2011-5035	OC4J 10.1.3.4 one-off patch (Special OPatch needed, see README)

Product Home

Patch

Advisory Number

Comments

Oracle Database home

Database 11.2.0.3 CPU Patch 13632717, orDatabase 11.2.0.3.2 PSU Patch 13696216, orGI 11.2.0.3.2 PSU Patch 13696251, orDatabase patch for Exadata (April 2012 – 11.2.0.3.5) Patch 13734832, or

Quarterly Full Stack download for Exadata (April 2012) Patch 13839416, or

Microsoft Windows (32-Bit) BundlePatch 13885388, or

Microsoft Windows x64 (64-Bit) Bundle Patch 13885389

CVE-2012-0552, CVE-2012-0534, CVE-2012-0527, CVE-2012-0526, CVE-2012-0525

Oracle Database home

Patch 13705478

CVE-2011-5035

OC4J 10.1.3.4 one-off patch (Special OPatch needed, see README)

Patch Availability for Oracle Database 11.2.0.2

Product Home	Patch	Advisory Number	Comments
Oracle Database home	Database 11.2.0.2 CPU Patch 13632725, orDatabase 11.2.0.2.6 PSU Patch 13696224, orGI 11.2.0.2.6 PSU Patch 13696242, orExadata Database Recommended Patch 16 Patch 13837673, or Microsoft Windows (32-Bit) BundlePatch 13697073, or Microsoft Windows x64 (64-Bit) Bundle Patch 13697074	CVE-2012-0552, CVE-2012-0534, CVE-2012-0527, CVE-2012-0526, CVE-2012-0525, CVE-2012-0520, CVE-2012-0512, CVE-2012-0519 (Windows only)
Oracle Database home	Patch 13705478	CVE-2011-5035	OC4J 10.1.3.4 one-off patch (Special OPatch needed, see README)

Product Home

Patch

Advisory Number

Comments

Oracle Database home

Database 11.2.0.2 CPU Patch 13632725, orDatabase 11.2.0.2.6 PSU Patch 13696224, orGI 11.2.0.2.6 PSU Patch 13696242, orExadata Database Recommended Patch 16 Patch 13837673, or

Microsoft Windows (32-Bit) BundlePatch 13697073, or

Microsoft Windows x64 (64-Bit) Bundle Patch 13697074

CVE-2012-0552, CVE-2012-0534, CVE-2012-0527, CVE-2012-0526, CVE-2012-0525, CVE-2012-0520, CVE-2012-0512, CVE-2012-0519 (Windows only)

Oracle Database home

Patch 13705478

CVE-2011-5035

OC4J 10.1.3.4 one-off patch (Special OPatch needed, see README)

Patch Availability for Oracle Database 11.1.0.7

Product Home	Patch	Advisory Number	Comments
Oracle Database home	Database 11.1.0.7 CPU Patch 13632731, orDatabase 11.1.0.7.11 PSU Patch 13621679, orMicrosoft Windows (32-Bit) Bundle Patch 13715809, orMicrosoft Windows x64 (64-Bit) Bundle Patch 13715810	CVE-2012-0552, CVE-2012-0534, CVE-2012-0528, CVE-2012-0527, CVE-2012-0526, CVE-2012-0525, CVE-2012-0520, CVE-2012-0512, CVE-2012-0511, CVE-2012-0510
Oracle Database home	Patch 13705478	CVE-2011-5035	OC4J 10.1.3.3 one-off patch
Oracle CRS home	CRS 11.1.0.7.7 PSU Patch 11724953	Released April 2011	Non-security content only
Oracle Database home	Patch 9288120	Released April 2011	Database UIXFor Oracle Secure Enterprise Search 11.1.2.x installations, follow the instructions given in MOS note Note 1359600.1.
Oracle Database home	Patch 10073948	Released April 2011	Enterprise Manager Database Control UIXNot applicable to Oracle Secure Enterprise Search 11.1.2.x
Oracle Database home	Patch 11738232	Released April 2011	Warehouse BuilderNot applicable to Oracle Secure Enterprise Search 11.1.2.x

Patch Availability for Oracle Database 10.2.0.5

Product Home	Patch	Advisory Number	Comments
Oracle Database home	Database 10.2.0.5 CPU Patch 13632738, orDatabase 10.2.0.5.7 PSU Patch 13632743, orMicrosoft Windows (32-Bit) Bundle Patch 13654814, orMicrosoft Windows x64 (64-Bit) Bundle Patch 13654815, or Microsoft Windows Itanium (64-Bit)Patch 13870404	CVE-2012-0552, CVE-2012-0534, CVE-2012-0528, CVE-2012-0527, CVE-2012-0526, CVE-2012-0520
Oracle Database home	Patch 13705478	CVE-2011-5035	OC4J 10.1.3.4 one-off patch (Special OPatch needed, see README)
Oracle Database home	Patch 12536181	Released July 2011	Enterprise Manager Database ControlFor HP-UX PA-RISC and HP-UX Itanium platforms only
Oracle Warehouse Builder home	Patch 11738172	Released April 2011	Warehouse Builder
Oracle CRS home	CRS 10.2.0.5.2 PSU Patch 9952245	Released January 2011	Non-security content only

Patch Availability for Oracle Database 10.2.0.4

Product Home	Patch	Advisory Number	Comments
Oracle Database home	Database 10.2.0.4 CPU Patch 12879926, orDatabase 10.2.0.4.12 PSU Patch 12879933	CVE-2012-0552, CVE-2012-0534, CVE-2012-0528, CVE-2012-0527, CVE-2012-0526, CVE-2012-0520, CVE-2012-0511, CVE-2012-0510	10.2.0.4.4 PSU Patch 9352164 is base PSU for 10.2.0.4.12 Overlay PSU
Oracle Database home	Patch 13705478	CVE-2011-5035	OC4J 9.0.4.1 one-off patch
Oracle Database home	Patch 12536167	Released July 2011	Enterprise Manager Database ControlFor HP-UX PA-RISC and HP-UX Itanium platforms only
Oracle Database home	Patch 12758181	Released July 2011	Enterprise Manager Database Control UIX
Oracle Database home	Patch 9249369	Released April 2011	Database UIX
Oracle Database home	Patch 9273865	Released April 2011	iSqlPlus UIX
Oracle CRS home	CRS 10.2.0.4.4 PSU Patch 9294403	Released April 2010	Non-security content only

比较令人惊讶的是虽然版本10gR2已经实际进入Sustaining Support周期，但是这一次仍释出了 10.2.0.5上最新的 PSU 10.2.0.5.7 ，和10.2.0.4上的 10.2.0.4.12 PSU。

虽然10.2.0.5.7当前的状态要求有 Extended Support CSI 才能下载，但是实际在几个月前 10.2.0.5.5 release时也如现在一般，但是10.2.0.5.6 又变成了只要有一般的premier support账号即可下载，谁能摸得清Oracle Patch Support team的脾气呢？

PSU 10.2.0.5.7 修复的bug fix 包括：

PSU 10.2.0.5.7 contains all fixes previously released in PSU 10.2.0.5.6 and the following new fixes:

Buffer Cache Management

8822531 – TAKING AWR SNAP HANGS

12748240 – FIX FOR BUG 12748240

12780098 – FIX FOR BUG 12780098

13503598 – FIX FOR BUG 13503598

Generic

7115910 – ORA-7445 [KQLCHG] INTERMITTENTLY HIT DURING DBMS_REFRESH.REFRESH OF MV

9689310 – SPORADIC BUNCHES OF ORA-600 [17059]

9694101 – SHARED CURSOR TEST HANGS DUE TO ‘CURSOR: PIN S WAIT ON X’

11858315 – ORA-600 [17147] ORA-600 [KGHALO4] WITH PATCH 10277915 APPLIED

High Availability

9448311 – BOTH INSTANCE DOWN WITH ORA-00481.

11674645 – GCS DRM FREEZE IN ENTER SERVER MODE WAIT EVENT

13554409 – FIX FOR BUG 13554409

Oracle Space Management

6076890 – ORA-600[16622] WHEN SYNONYM IS SPECIFIED IN DBMS_SPACE.UNSUSED_SPACE

11790175 – SMON SPINS ON REDO APPLICATION ON BASICFILE LOBS

Oracle Virtual Operating System Services

10326338 – HIGH RESMGR:CPU QUANTUM WITH APPSQOS_PLAN IN PLACE

Server Manageability

13257247 – POPULATING WRH$_TEMPSTATXS MAY BE SLOW DUE TO INEFFICIENT QUERY EXECUTION PLAN

FILED UNDER: ORACLE, ORACLE补丁PATCH TAGGED WITH: CPU, PATCH

Oracle数据库升级与补丁

2012/01/21 BY MACLEAN LIU 暂无评论

以下是Maclean.Liu 编写或收集的数据库升级(Upgrade)与补丁(patch fix)方面的知识：

甲骨文发布2012 1月数据库安全补丁Critical Patch Update January 2012
Oracle数据库版本10.2实际进入扩展支持Extended Support周期
 Patch Set Update and Critical Patch Update October 2011补丁更新发布了
 11.2.0.3 Patch Set – List of Bug Fixes by Problem Type
快速升级Oracle 11.2.0.2 RAC到11.2.0.3
Upgrade GI/CRS 11.1.0.7 to 11.2.0.2. Rootupgrade.sh Hanging
Oracle补丁集的补丁号Patch ID/Number速查
 Oracle 11gR2发布11.2.0.3 Patchset补丁集-又一重量级更新
 Slide:11g新特性-在线实施补丁online patching
Slide:Oracle数据库升级前必要的准备工作
 深入了解Oracle数据字典升级脚本catupgrd.sql调用过程
 Slide:如何安装Oracle one-off 临时小补丁及注意事项 by Maclean.liu
Slide:了解Oracle critical patch update
Slide:Upgrade 11.2.0.1 GI/CRS to 11.2.0.2 in Linux
Slide:Upgrade 11.2.0.1 RAC DB/RDBMS to 11.2.0.2 in Linux By Maclean
Upgrade 11.2.0.1 DB/RDBMS to 11.2.0.2 in Linux
Upgrade 11.2.0.1 GI/CRS to 11.2.0.2 in Linux
Applying 11G R2 GI PSU 11.2.0.2.3
Critical Patch Update July 2011 Released
了解Oracle Critical Patch Update
了解Oracle数据库的版本号
 Pre-check while you are applying one-off patch
Advise on OS patch upgrade with RAC
Oracle Patch Set Update and Critical Patch Update April 2011 Released
11g新特性:Rolling Upgrade With Physical Standby
Patch your 10g Oracle database to PSU 10.2.0.4.5
7月最新发布10.2.0.4.5 Patch Set Update
Oracle Exadata Database Recommended Patch (BP3) for Bug 10387939
Startup Upgrade为我们做了什么？
深入理解Oracle Universal Installer (OUI)
Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql)
介绍dbms_registry PL/SQL程序包
 Applying online patch on 11gr2
January 2011 Patch set Update发布
 Advice on upgrading to 11.2.0.2 and converting to RAC
Oracle 9iR2 RAC to Oracle 10gR2 RAC Upgrade
Upgrading to Oracle Database 11g
如何确定所打Patch是否需要停机
 Database Upgrade using Transportable Tablespaces
Upgrading to 11g–Why,How and Best Practices
Upgrade from Oracle Database 10g to 11g:What to Expect From the Optimizer
Upgrade to Oracle Database 11g: Single Instance to RAC & ASM
Applying Database PSU 10.2.0.4.6
Oct 12: Patch Set Update Released
Oracle Critical Patch Updates Unwrapped
11.2.0.2补丁集安装体验
 Upgrading to RAC 11g R2 What you should know
Oracle 9i/10g/11g数据库升级路线图总览
 OPatch工具相关的环境变量
 使用OPATCH_DEBUG环境变量调试Opatch工具
 opatch java.lang.OutOfMemoryError:Java heap space错误一例

FILED UNDER: ORACLE, ORACLE升级UPGADE, ORACLE补丁PATCH TAGGED WITH: OPATCH, UPGRADE DATABASE RELEASE

甲骨文发布2012 1月数据库安全补丁Critical Patch Update January 2012

2012/01/17 BY MACLEAN LIU 暂无评论

甲骨文公司(Oracle Corp)会在今天的(2012-01-17 Tuesday)的晚些时候发布最新的数据库安全补丁Critical Patch Update January 2012；

在OTN的CPU security专题页面上已经生成了《Oracle Critical Patch Update Pre-Release Announcement – January 2012》的页面；将要发布的安全补丁涵盖多个版本的Oracle数据库：

Affected Products and Components

Security vulnerabilities addressed by this Critical Patch Update affect the following products:

Oracle Database 11g Release 2, versions 11.2.0.2, 11.2.0.3
Oracle Database 11g Release 1, version 11.1.0.7
Oracle Database 10g Release 2, versions 10.2.0.3, 10.2.0.4, 10.2.0.5
Oracle Database 10g Release 1, version 10.1.0.5

实际因为版本10gR2已经正式进入Extended Support扩展支持阶段，所以下载10.2.0.4、10.2.0.5今后的CPU、PSU将(10.2.0.4.10、10.2.0.5.5 以后)需要用户已购买甲骨文公司的扩展支持服务包。

“甲骨文称，有27个补丁是修复MySQL数据库中的安全漏洞。其中一个安全漏洞不需要登录证书就可以在网络上利用。按照通用安全漏洞评分系统(CVSS)数据库的平分，MySQL数据库安全漏洞的最高等级是5.5，属于中等风险等级。

另外两个补丁修复甲骨文数据中的安全漏洞。甲骨文还计划为Fusion中间件软件发布11个补丁。其中修复的5个安全漏洞能够远程利用，不需要用户身份识别。

在应用程序方面，甲骨文电子商务套装软件将得到3个安全补丁。供应链应用套装软件将得到1个安全补丁。仁科软件得到6个补丁。JD Edwards软件得到8个补丁。

大约17个安全补丁与Sun的产品有关，其中包括6个不需要证书就可以远程利用的安全漏洞。受影响的产品包括GlassFish企业服务器和和Solaris OS。

另外3个补丁用于甲骨文包括VirtualBox在内的虚拟化技术。”

在My Oracle Support (MOS)服务站点上已经生成了<Oracle Critical Patch Update January 2012 Documentation Map [ID 1368685.1]>这个补丁文档patch note:

“Oracle provides Critical Patch Updates to its customers to fix security vulnerabilities. This document defines the Documentation Map to documents identifying patches and minimum releases that are required for the Oracle products to address the security vulnerabilities that are announced in the Advisory for January 2012 (the updates will be entered here when CPU is released). ”

补丁列表已发布：

Patch Availability for Oracle Database 11.2.0.3

Oracle Database 11.2.0.3	UNIX	Microsoft Windows (32-Bit)	Microsoft Windows x64 (64-bit)	Advisory Number	Comments
Oracle Database home	CPU Patch 13466801, or DB PSU Patch 13343438, or GI PSUPatch 13348650, or Database patch for Exadata Patch 13513783, or Quarterly Full Stack download for Exadata Patch 13551280	Bundle Patch 13413167	Bundle Patch 13413168

Patch Availability for Oracle Database 11.2.0.2

Oracle Database 11.2.0.2	UNIX	Microsoft Windows (32-Bit)	Microsoft Windows x64 (64-bit)	Advisory Number	Comments
Oracle Database home	CPU Patch 13343244, or DB PSU Patch 13343424, or GI PSUPatch 13343447, or Exadata Database Recommended Patch 14Patch 13556724	Bundle Patch 13413154	Bundle Patch 13413155	CVE-2012-0072, CVE-2012-0082

Patch Availability for Oracle Database 11.1.0.7

Oracle Database 11.1.0.7	UNIX	Microsoft Windows (32-Bit)	Microsoft Windows x64 (64-Bit)	Advisory Number	Comments
Oracle Database home	CPU Patch 13343453, or PSU Patch 13343461	Bundle Patch 13460955	Bundle Patch 13460956	CVE-2012-0072, CVE-2012-0082
Oracle Database home	Patch 9288120	Patch 9288120	Patch 9288120	Released April 2011	Database UIX For Oracle Secure Enterprise Search 11.1.2.x installations, follow the instructions given in MOS note Note 1359600.1.
Oracle Database home	Patch 10073948	Patch 10073948	Patch 10073948	Released April 2011	Enterprise Manager Database Control UIX Not applicable to Oracle Secure Enterprise Search 11.1.2.x
Oracle Database home	Patch 11738232	Patch 11738232	Patch 11738232	Released April 2011	Warehouse Builder Not applicable to Oracle Secure Enterprise Search 11.1.2.x

Patch Availability for Oracle Database 10.2.0.5

Oracle Database 10.2.0.5	UNIX	Microsoft Windows (32-Bit)	Microsoft Windows Itanium (64-Bit)	Microsoft Windows x64 (64-Bit)	Advisory Number	Comments
Oracle Database home	CPU Patch 13343467, or PSUPatch 13343471	Bundle Patch 13460967	NA	Bundle Patch 13460968	CVE-2012-0072, CVE-2012-0082
Oracle Database home	Patch 12536181	NA	NA	NA	Released July 2011	Enterprise Manager Database Control For HP-UX PA-RISC and HP-UX Itanium platforms only
Oracle Database home	Patch 11738172	Patch 11738172	Patch 11738172	Patch 11738172	Released April 2011	Warehouse Builder

Oracle Database 10.2.0.5

UNIX

Microsoft Windows (32-Bit)

Microsoft Windows Itanium (64-Bit)

Microsoft Windows x64 (64-Bit)

Advisory Number

Comments

Oracle Database home

CPU Patch 13343467, or PSUPatch 13343471

Bundle Patch 13460967

Bundle Patch 13460968

CVE-2012-0072, CVE-2012-0082

Oracle Database home

Patch 12536181

Released July 2011

Enterprise Manager Database Control

For HP-UX PA-RISC and HP-UX Itanium platforms only

Oracle Database home

Patch 11738172

Released April 2011

Warehouse Builder

Patch Availability for Oracle Database 10.2.0.4

Oracle Database 10.2.0.4	UNIX	Advisory Number	Comments
Oracle Database home	CPU Patch 12879912, or PSU Patch 12879929	CVE-2012-0072, CVE-2012-0082
Oracle Database home	Patch 12536167	Released July 2011	Enterprise Manager Database Control For HP-UX PA-RISC and HP-UX Itanium platforms only
Oracle Database home	Patch 9249369	Released April 2011	Database UIX
Oracle Database home	Patch 12758181	Released July 2011	Enterprise Manager Database Control UIX
Oracle Database home	Patch 9273865	Released April 2011	iSqlPlus UIX

Component	IBM zSeries (z/OS)	Advisory Number	Comments
Oracle Database home	CPU Patch 13343479	CVE-2012-0072, CVE-2012-0082

Patch Availability for Oracle Database 10.1.0.5

Oracle Database 10.1.0.5	UNIX	Microsoft Windows (32-Bit)	Microsoft Windows Itanium (64-Bit)	Advisory Number	Comments
Oracle Database home	Patch 6640838	Patch 6640838	Patch 6640838	Released October 2010	Oracle Universal Installer
Oracle Database home	Patch 11842285	NA	NA	Released July 2011	Oracle Universal Installer
Oracle Database home	CPU Patch 13343482	Bundle Patch 13413002	Bundle Patch 13413003	CVE-2012-0072, CVE-2012-0082
Oracle Database home	Patch 12535977	NA	NA	Released July 2011	Enterprise Manager Database Control For HP-UX PA-RISC and HP-UX Itanium platforms only
Oracle Workspace Manager home	Patch 7341989	Patch 7341989	Patch 7341989	Released April 2009
Oracle Database home	Patch 9249369	Patch 9249369	Patch 9249369	Released April 2011	Database UIX
Oracle Database home	Patch 10036362	Patch 10036362	Patch 10036362	Released April 2011	Enterprise Manager Database Control UIX
Oracle Database home	Patch 9273888	Patch 9273888	Patch 9273888	Released April 2011	iSqlPlus UIX

Patch Set Update Availability for Oracle Database

Oracle Database	UNIX	Advisory Number	Comments
11.2.0.2.4 Database PSU	Patch 13343424	See Section 3.1.3.3, “Oracle Database 11.2.0.2″
11.2.0.2.4 Grid Infrastructure PSU	Patch 13343447	See Section 3.1.3.3, “Oracle Database 11.2.0.2″	Includes CPUJan2012 and 11.2.0.2.4 Database PSU IBM: Linux on System Z and HP-UX PA-RISC are On-Request Platforms for GI PSU 11.2.0.2.4
11.2.0.2 BP12 for Exadata	Patch 13556724	See Section 3.1.3.3, “Oracle Database 11.2.0.2″	Includes CPUJan2012 and 11.2.0.2.4 Database and Grid Infrastructure PSU fixes for Exadata
11.1.0.7.9 Database PSU	Patch 13343461	See Section 3.1.3.4, “Oracle Database 11.1.0.7″
11.1.0.7.7 CRS PSU	Patch 11724953	Released April 2011
10.2.0.5.5 Database PSU	Patch 13343471	See Section 3.1.3.5, “Oracle Database 10.2.0.5″
10.2.0.5.2 CRS PSU	Patch 9952245	Released January 2011	IBM: Linux on System Z, Solaris x86-64 and HP-UX PA-RISC are On-Request Platforms for CRS PSU 10.2.0.5.2
10.2.0.4.10 Database PSU	Patch 12879929	See Section 3.1.3.6, “Oracle Database 10.2.0.4″	Overlay PSU
10.2.0.4.4 Database PSU	Patch 9352164	Released April 2010	Base PSU for 10.2.0.4.10
10.2.0.4.4 CRS PSU	Patch 9294403	Released April 2010

在11gR2 当前最新版本11.2.0.3的第一个psu 11.2.0.3.1中修复了几十个bug:

CPU molecules in PSU 11.2.0.3.1:

PSU 11.2.0.3.1 contains the following new PSU 11.2.0.3.1 molecules:

13499128 – DB-11.2.0.3-MOLECULE-001-CPUJAN2012

13528551 – DB-11.2.0.3-MOLECULE-002-CPUJAN2012

Bug Fixes

See My Oracle Support Note 1340011.1 that documents all the non-security bugs fixed in each 11.2.0.2 Patch Set Update (PSU).

PSU 11.2.0.3.1 contains the following new fixes:

Automatic Storage Management

9703627 – 11.2.0.2: ROOT USE OF ASMCMD PLACES ALERT.LOG IN USER DIRECTORY

12620823 – SOL-SP64-11203:ASM INSTANCE HANG DURING CRS STACK STARTING ON THE SECOND NODE

12797765 – SOL_SP64: AFTER ALL DISKS FAILURE, DG CAN’T BE DISMOUNTED ON T2000-3

12905058 – REBOOT 2 CELL NODES, CHECKFILE FOUND CORRUPTION BLOCK IN 3 UNDO DATAFILES

12938841 – 11203_ASM_SOL_SP64:RACE BETWEEN ADD DISK AND DISMOUNT MAY CAUSE KFGUSENUM01

12950644 – RBAL HIT ORA-07445:[KFDGLOBALOPEN()+738], ASM INST ABORT

Generic

9873405 – ORA-600 DURING FAST REFRESH AFTER 11.2.0.1.0 TO 11.2.0.2.0 UPDATE.

High Availability

12718090 – LNX64-11203-RAC:DB FG RROC HIT ORA-00600[KCLCHKBLK_3]

12834027 – ORA-00600 [KJBMPRLST:SHADOW] & [KJBRASR:PKEY] IN A READ MOSTLY & SKIP LOCK ENV

12847466 – AROLTP-C: HANG SIGNATURE: ‘GC CURRENT REQUEST’<=’GC BUFFER BUSY ACQUIRE’

12861463 – RAC PERF: DEFAULT VALUE FOR _LM_SINGLE_INST_AFFINITY_LOCK SHOULD BE FALSE

12917230 – QUERY WITH TEMP TABLE TRANSFORMATION RUNS 5X SLOWER WAITING FOR REMASTERING

12998795 – AROLTP-C: HANG SIGNATURE: ‘GC CURRENT REQUEST’<=’GC BUFFER BUSY ACQUIRE’

13035804 – LACK OF DLM PSEUDO RECONFIGURATION TEXTUAL REASON

Oracle Space Management

13041324 – HCC ON ZFS AND PILLAR STORAGE

13492735 – DISALLOW ADDING NON-HCC DATAFILE TO HCC TABLESPACE

Oracle Virtual Operating System Services

13362079 – HCC SHOULD NOT BE ENABLED FOR NON ZFS/ PILLAR STORAGE ARRAY

FILED UNDER: ORACLE, ORACLE补丁PATCH TAGGED WITH: CRITICAL PATCH UPDATE, SECURITY FIX

UtilSession failed: Prerequisite check “CheckSystemSpace” space(22288172004) is not available

2011/12/21 BY MACLEAN LIU 暂无评论

如果你在使用OPatch打11.2 GI/CRS上的PSU时遇到了如上错误信息”UtilSession failed: Prerequisite check “CheckSystemSpace” space”则说明你的CRS_HOME所在文件系统的空闲空间不足22g，这会导致OPatch预检测无法通过。

 UTIL session
 .
 Oracle Home       : /oracle/crshome
 Central Inventory : /oracle/oraInventory
    from           : /etc/oraInst.loc
 OPatch version    : 11.2.0.1.3
 OUI version       : 11.2.0.1.0
 OUI location      : /oracle/crshome/oui
 Log file location : 
 /ee/oracle/crshome/cfgtoollogs/opatch/opatch2010-06-04_00-15-12AM.log
 .
 Patch history file: /oracle/crshome/cfgtoollogs/opatch/opatch_history.txt
 .
 Invoking utility "napply"
 Checking conflict among patches...
 Checking if Oracle Home has components required by patches...
 Checking conflicts against Oracle Home...
 OPatch continues with these patches:   9655006  
 .
 Do you want to proceed? [y|n]
 y
 User Responded with: Y
 Running prerequisite checks...
 Prerequisite check "CheckSystemSpace" failed.
 The details are:
 Required amount of space(22288172004) is not available.     
 UtilSession failed: Prerequisite check "CheckSystemSpace" failed.

为什么打一个GI PSU要22g的空间？这是由于GI本身的特殊性造成的。

实际是不似乎必须要22g的free space?

回答是，至少需要20g的空闲空间。对于上述CheckSystemSpace错误可以通过加入OPatch.SKIP_VERIFY_SPACE=true参数来绕过检测：

opatch napply OPatch.SKIP_VERIFY_SPACE=true

但是即便使用了如上SKIP_VERIFY_SPACE=true参数实际在APPLY过程中仍会遇到由于缺少空闲空间导致的copy文件错误，所以实际的解决方案仍是扩文件系统或者清理空间。

但是一旦该PSU打完后，CRS_HOME不会真的多占用22g的空间，大约可能多出1-2G空间的使用量。

FILED UNDER: ORACLE, ORACLE补丁PATCH

Script:10g中不用EM显示Active Session Count by Wait Class

2011/10/27 BY MACLEAN LIU 暂无评论

在<11g中AWR新快照视图>一文中我介绍了作为新特性加入11g的一些动态性能视图，另外也提及了通过一个SQL脚本就可以不打开EM界面而显示ASH的按等待类型(Wait Class)累计的Active Session Count，实际在EM中图形化的效果是这样的：

在11g 中可以使用如下SQL从命令行获得实例每分钟的AAS信息(注意没有对后台进程做过滤，所以是Foreground + Background 的模式)：

set echo off;
set verify off;
alter session set nls_date_format='HH24:MI';
select *
  from (select nvl(wait_class, 'CPU') activity,
               trunc(sample_time, 'MI') time
          from v$active_session_history) v pivot(count(*) for activity in('CPU' as
                                                                          "CPU",
                                                                          'Concurrency' as
                                                                          "Concurrency",
                                                                          'System I/O' as
                                                                          "System I/O",
                                                                          'User I/O' as
                                                                          "User I/O",
                                                                          'Administrative' as
                                                                          "Administrative",
                                                                          'Configuration' as
                                                                          "Configuration",
                                                                          'Application' as
                                                                          "Application",
                                                                          'Network' as
                                                                          "Network",
                                                                          'Commit' as
                                                                          "Commit",
                                                                          'Scheduler' as
                                                                          "Scheduler",
                                                                          'Cluster' as
                                                                          "Cluster",
                                                                          'Queueing' as
                                                                          "Queueing",
                                                                          'Other' as
                                                                          "Other"))
 where time > sysdate - interval '&last_min' minute
 order by time;

因为以上这段SQL脚本使用了11g 才引入的pivot函数，所以在10g 中是无法运行的。Google 了以下似乎没有可用的10g版本(大约化了一个小时)，寻思着还是自己给改以下吧，结果5分钟搞定。。

现在共享出来给经常不能使用EM的乙方同学(Foreground only 和 Foreground + background 2种模式都有):

REM created by Maclean Liu
REM www.oracledatabase12g.com & www.askmaclean.com
REM released 2011-10-27 Version 1.0

REM Foreground + Background mode

set echo off;
set verify off;
alter session set nls_date_format='HH24:MI';

select time,
       sum(case activity
             when 'CPU' then
              1
             else
              0
           end) CPU,
       sum(case activity
             when 'Concurrency' then
              1
             else
              0
           end) Concurrency,
       sum(case activity
             when 'System I/O' then
              1
             else
              0
           end) "System I/O",
       sum(case activity
             when 'User I/O' then
              1
             else
              0
           end) "User I/O",
       sum(case activity
             when 'Administrative' then
              1
             else
              0
           end) "Administrative",
       sum(case activity
             when 'Configuration' then
              1
             else
              0
           end) "Configuration",
       sum(case activity
             when 'Application' then
              1
             else
              0
           end) "Application",
       sum(case activity
             when 'Network' then
              1
             else
              0
           end) "Network",
       sum(case activity
             when 'Commit' then
              1
             else
              0
           end) "Commit",
       sum(case activity
             when 'Scheduler' then
              1
             else
              0
           end) "Scheduler",
       sum(case activity
             when 'Cluster' then
              1
             else
              0
           end) "Cluster",
       sum(case activity
             when 'Queueing' then
              1
             else
              0
           end) "Queueing",
       sum(case activity
             when 'Other' then
              1
             else
              0
           end) "Other"
  from (select trunc(sample_time, 'MI') time,
               nvl(wait_class, 'CPU') activity
          from v$active_session_history)
 where time > sysdate - interval '&last_min' minute
 group by time
 order by time;

REM Foreground  mode

set echo off;
set verify off;
alter session set nls_date_format='HH24:MI';
select time,
       sum(case activity
             when 'CPU' then
              1
             else
              0
           end) CPU,
       sum(case activity
             when 'Concurrency' then
              1
             else
              0
           end) Concurrency,
       sum(case activity
             when 'System I/O' then
              1
             else
              0
           end) "System I/O",
       sum(case activity
             when 'User I/O' then
              1
             else
              0
           end) "User I/O",
       sum(case activity
             when 'Administrative' then
              1
             else
              0
           end) "Administrative",
       sum(case activity
             when 'Configuration' then
              1
             else
              0
           end) "Configuration",
       sum(case activity
             when 'Application' then
              1
             else
              0
           end) "Application",
       sum(case activity
             when 'Network' then
              1
             else
              0
           end) "Network",
       sum(case activity
             when 'Commit' then
              1
             else
              0
           end) "Commit",
       sum(case activity
             when 'Scheduler' then
              1
             else
              0
           end) "Scheduler",
       sum(case activity
             when 'Cluster' then
              1
             else
              0
           end) "Cluster",
       sum(case activity
             when 'Queueing' then
              1
             else
              0
           end) "Queueing",
       sum(case activity
             when 'Other' then
              1
             else
              0
           end) "Other"
  from (select trunc(sample_time, 'MI') time,
               nvl(wait_class, 'CPU') activity
          from v$active_session_history
         where session_type = 'FOREGROUND')
 where time > sysdate - interval '&last_min' minute
 group by time
 order by time;

使用方法如下：

SQL> @ashwc

Session altered.

Enter value for last_min: 10

TIME         CPU CONCURRENCY System I/O   User I/O Administrative Configuration
----- ---------- ----------- ---------- ---------- -------------- -------------
Application    Network     Commit  Scheduler    Cluster   Queueing      Other
----------- ---------- ---------- ---------- ---------- ---------- ----------
20:40          1           0          0          0              0             0
          0          0          0          0          0          0          0

FILED UNDER: ORACLE, ORACLE补丁PATCH TAGGED WITH: ASH, ORACLE脚本SCRIPT, PIVOT, WAIT CLASS

guoliang

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
【转Oracle补丁】老托的Oracle 数据库Patch概念性小常识

【转Oracle补丁】老托的Oracle 数据库Patch概念性小常识http://www.oracledatabase12g.com/archives/category/oracle/patch-oracle 名称说明Release¤ 标准产品发布。如Oracle Data
复制链接

扫一扫