熟悉 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)