升级oracle spu,关于Oracle数据库PSU/SPU/BundlePatch的补丁号变化

思庄中心OCP脱产班1月15日开班，周末班于1月12日开班！

熟悉 Oracle

Database PSU、Bundle Patch 的DBA一定知道，一般来讲，这些 patch

的命名规则一般是按照推出的先后顺序，比如在 2015年7月 推出的对 11.2.0.4 的第7个 DB PSU就命名为：DB

PSU

11.2.0.4.7。正是基于这个知识,有用户现在要让我去打最得psu

11.2.0.4.9,我在metalink上找了半天,没有找到11.2.0.4.9,倒是找到了推荐的11.2.0.4.160119,这是什么玩艺,难道搞错了,

经查看Oracle

最新补丁号码名称参考文档：Quick Reference to Patch Numbers for Database

PSU, SPU(CPU), Bundle Patches and Patchsets (Doc ID

1454618.1),有一句话:

2.1 Change to Bundle Patch NumberingAs of November 2015,

the version numbering for new Bundle Patches, Patch Set Updates,

and Security Patch Updates for Oracle Database, Enterprise Manager

and Middleware products have a new format. This new format replaces

the numeric 5th digit of the bundle version with a release date in

the form YYMMDD:

YY is the last 2 digits of the year

MM is the numeric month (2 digits)

DD is the numeric day of the month (2 digits)

Note that the release date is the release date of the main

bundle, PSU, or SPU.

Some bundles may continue to use a numeric 5th digit in the

short term, but they will transition to the new format over

time.

This new version format makes it easier to see which bundle

patches are

from which time frame, and in particular, which patches are from

the

same Critical Patch Update release. For examples and more

information,

see My Oracle Support Note 2061926.1, Oracle Database,

Enterprise

Manager and Middleware - Change to Patch Numbering from Nov

2015

onwards.

其实就是从2016年1月份开始,oracle推出了对 PSU、SPU、Bundle Patch

新的命名规则。新的命名规则为(以11.2.0.4为例)：11.2.0.4.YYMMDD。 此处的 YYMMDD

为patch

(PSU、SPU、Bundle)发布的具体日期，格式为两位年份+两位月份+两位日期。

比如对 11.2.0.4 推出的第 9 个

DB PSU

(本来应该命名为：11.2.0.4.9),在新的命名规则下,这个patch被命名为：11.2.0.4.160119，这也表示这

11.2.0.4的 PSU 是在1 6年1月19日 推出的patch。

Oracle

最新补丁号码名称请参考文档：Oracle

Database, Enterprise Manager and Middleware - Change to Patch

Numbering

from Nov 2015 onwards (文档 ID 2061926.1)