love wife & love life —Roger的Oracle&MySQL技术博客

Phone:18180207355 提供专业Oracle&MySQL数据恢复、性能优化、迁移升级、紧急救援等服务

2015年第一季度PSU更新(OJVM PSU更新)

本站文章除注明转载外,均为本站原创: 转载自love wife & love life —Roger的Oracle&MySQL技术博客

本文链接地址: 2015年第一季度PSU更新(OJVM PSU更新)

Oracle的Patch越来越复杂了,从2014年10月份发布的补丁集开始,引入了新的几个补丁集概念,即:

JDBC Patch,针对jdbc客户端(Instant Client, Database and Grid ORACLE_HOMES).
Oracle JavaVM Component Database PSU,简称OJVM PSU(仅仅是针对ORACLE_HOMEs).
Combo Patch:可以理解为是OJVM PSU(DB PSU/GI PSU)一样的东西,只不过其允许我们去进行选择安装其中
的部分Patch,而OJVM PSU是不行的,要么都安装,要么都不安装。Combo Patch更加灵活。

从2015年1月的补丁发布开始,OJVM PSU 就集成了JDBC Patch(2014年10月份的补丁并不包括)。
2015年第1季度的PSU更新主要是4个版本:12.1.0.2,12.1.0.1、11.2.0.4、11.2.0.3以及11.1.0.7

++++10.2.0.4
Oracle Database PSU   Unix             Comments                 Includes Cpu 

10.2.0.4.1           8576156          Bash 10.2.0.4.0          includes CPU Jul 2009
10.2.0.4.2           8833280          Bash 10.2.0.4.0          includes CPU Oct 2009
10.2.0.4.3           9119284          Bash 10.2.0.4.0          includes CPU Jan 2010
10.2.0.4.4           9352164          Bash 10.2.0.4.0          includes CPU Apr 2010
10.2.0.4.5           9654991          该psu必须基于10.2.0.4.4  includes CPU Jul 2010
10.2.0.4.6           9952234          该psu必须基于10.2.0.4.4  includes CPU Oct 2010
10.2.0.4.7           10248636         该psu必须基于10.2.0.4.4  includes CPU Jan 2011
10.2.0.4.8           11724977         该psu必须基于10.2.0.4.4  includes CPU Apr 2011
10.2.0.4.9           12419397         该psu必须基于10.2.0.4.4  includes CPU Jul 2011
10.2.0.4.10          12827778         该psu必须基于10.2.0.4.4  includes CPU Oct 2011
10.2.0.4.11          12879929         该psu必须基于10.2.0.4.4  includes CPU Jan 2012
10.2.0.4.12          12879933         该psu必须基于10.2.0.4.4  includes CPU Apr 2012
10.2.0.4.13          13923851         该psu必须基于10.2.0.4.4  includes CPU Jul 2012
10.2.0.4.14          14275630         该psu必须基于10.2.0.4.4  includes CPU Oct 2012
10.2.0.4.15          14736542         该psu必须基于10.2.0.4.4  includes CPU Jan 2013
10.2.0.4.16          16056269         该psu必须基于10.2.0.4.4  includes CPU Apr 2013
10.2.0.4.17          16619897         该psu必须基于10.2.0.4.4  includes CPU Jul 2013

+++++10.2.0.5
Oracle Database PSU   Unix             Comments                Includes Cpu 

10.2.0.5.1           9952230          Bash 10.2.0.5.0         includes CPU Oct 2010
10.2.0.5.2           10248542         Bash 10.2.0.5.0         includes CPU Jan 2011
10.2.0.5.3           11724962         Bash 10.2.0.5.0         includes CPU Apr 2011
10.2.0.5.4           12419392         Bash 10.2.0.5.0         includes CPU Jul 2011
10.2.0.5.5           12827745         Bash 10.2.0.5.0         Includes CPU Oct 2011
10.2.0.5.6           13343471         Bash 10.2.0.5.0         includes CPU Jan 2012
10.2.0.5.7           13632743         Bash 10.2.0.5.0         includes CPU Apr 2012
10.2.0.5.8           13923855         Bash 10.2.0.5.0         includes CPU Jul 2012
10.2.0.5.9           14275629         Bash 10.2.0.5.0         includes CPU Oct 2012
10.2.0.5.10          14727319         Bash 10.2.0.5.0         includes CPU Jan 2013
10.2.0.5.11          16056270         Bash 10.2.0.5.0         includes CPU Apr 2013
10.2.0.5.12          16619894         Bash 10.2.0.5.0         includes CPU Jul 2013

+++++11.1.0.7
Oracle Database PSU   Database        CRS                   Comments          Includes Cpu 

11.1.0.7.1            8833297         bug: 8287931          Bash 11.1.0.7.0   includes CPU Oct 2009
11.1.0.7.2            9209238         bug: 9207257          Bash 11.1.0.7.0   includes CPU Jan 2010
11.1.0.7.3            9352179                               Bash 11.1.0.7.0   includes CPU Apr 2010
11.1.0.7.4            9654987         bug: 9294495          Bash 11.1.0.7.0   includes CPU Jul 2010
11.1.0.7.5            9952228         bug: 9952240          Bash 11.1.0.7.0   includes CPU Oct 2010
11.1.0.7.6            10248531        bug: 10248535         Bash 11.1.0.7.0   includes CPU Jan 2011
11.1.0.7.7            11724936        11724953              Bash 11.1.0.7.0   includes CPU Apr 2011
11.1.0.7.8            12419384        11724953              Bash 11.1.0.7.0   includes CPU Jul 2011
11.1.0.7.9            12827740        11724953              Bash 11.1.0.7.0   includes CPU Oct 2011
11.1.0.7.10           13343461        11724953              Bash 11.1.0.7.0   includes CPU Jan 2012
11.1.0.7.11           13621679        11724953              Bash 11.1.0.7.0   includes CPU Apr 2012
11.1.0.7.12           13923474        11724953              Bash 11.1.0.7.0   includes CPU Jul 2012
11.1.0.7.13           14275623        11724953              Bash 11.1.0.7.0   includes CPU Oct 2012
11.1.0.7.14           14739378        11724953              Bash 11.1.0.7.0   includes CPU Jan 2013
11.1.0.7.15           16056268        11724953              Bash 11.1.0.7.0   includes CPU Apr 2013
11.1.0.7.16           16619896        11724953              Bash 11.1.0.7.0   includes CPU Jul 2013
11.1.0.7.17           17082366        11724953              Bash 11.1.0.7.0   includes CPU Oct 2013
11.1.0.7.18           17465583        11724953              Bash 11.1.0.7.0   includes CPU Jan 2014
11.1.0.7.19           18031726        11724953              Bash 11.1.0.7.0   includes CPU Apr 2014
11.1.0.7.20           18522513        11724953              Bash 11.1.0.7.0   includes CPU Jul 2014  
11.1.0.7.21           19152553        11724953              Bash 11.1.0.7.0   includes CPU Oct 2014
11.1.0.7.22           19769499        11724953              Bash 11.1.0.7.0   includes CPU Jan 2015

OJVM PSU:             Database              CRS        Comments                  Includes JDBC Patch
11.1.0.7.1            19282002(Unix)                   Bash 11.1.0.7.0
                      19806118(Win)  
                      19852363(JDBC Patch)
11.1.0.7.2            19877446                        Bash 11.1.0.7.21           Jan 2015
                                                     或SPU 11.1.0.7.0(CPUOct2014)

++++++11.2.0.1
Oracle Database PSU  Database   Grid Infrastructure   Comments          Includes Cpu 

11.2.0.1.1           9352237    9343627               Bash 11.2.0.1.0   includes CPU Apr 2010
11.2.0.1.2           9654983    9343627               Bash 11.2.0.1.0   includes CPU Jul 2010
11.2.0.1.3           9952216    9655006               Bash 11.2.0.1.0   includes CPU Oct 2010
11.2.0.1.4           10248516   9655006               Bash 11.2.0.1.0   includes CPU Jan 2011
11.2.0.1.5           11724930   9655006               Bash 11.2.0.1.0   includes CPU Apr 2011
11.2.0.1.6           12419378   9655006               Bash 11.2.0.1.0   includes CPU Apr 2011

+++++++11.2.0.2
OracleDatabase PSU   Database   Grid Infrastructure   Comments          Includes  Cpu
11.2.0.2.1           10248523   Bundle1 10157506      Bash 11.2.0.2.0   no CPU fixes
11.2.0.2.2           11724916   Bundle2 10425672      Bash 11.2.0.2.0   includes CPU Apr 2011
                                PSU2 12311357
11.2.0.2.3           12419331   12419353              Bash 11.2.0.2.0   includes CPU Jul 2011
11.2.0.2.4           12827726   12827731              Bash 11.2.0.2.0   includes CPU Oct 2011
11.2.0.2.5           13343424   13343447              Bash 11.2.0.2.0   includes CPU Jan 2012
11.2.0.2.6           13696224   1396242               Bash 11.2.0.2.0   includes CPU Apr 2012
11.2.0.2.7           13923804   14192201              Bash 11.2.0.2.0   includes CPU Jul 2012
11.2.0.2.8           14275621   14390437              Bash 11.2.0.2.0   includes CPU Oct 2012
11.2.0.2.9           14727315   14390437              Bash 11.2.0.2.0   includes CPU Jan 2013
11.2.0.2.10          16056267   16166868              Bash 11.2.0.2.0   includes CPU Apr 2013
11.2.0.2.11          16619893   16742320              Bash 11.2.0.2.0   includes CPU Jul 2013
11.2.0.2.12          17082367   17272753              Bash 11.2.0.2.0   includes CPU Oct 2013

+++++++11.2.0.3
OracleDatabase PSU   Database               Grid Infrastructure       Comments           Includes  Cpu
11.2.0.3.0           10404530               (包含在10404530中)        
11.2.0.3.1           13343438               13348650                  Bash 11.2.0.3.0     includes CPU Jan 2012
11.2.0.3.2           13696216               13696251                  Bash 11.2.0.3.0     includes CPU Apr 2012
11.2.0.3.3           13923374               13919095                  Bash 11.2.0.3.0     includes CPU Jul 2012
11.2.0.3.4           14275605               14275572                  Bash 11.2.0.3.0     includes CPU Oct 2012
11.2.0.3.5           14727310               14727347                  Bash 11.2.0.3.0     includes CPU Jan 2013
11.2.0.3.6           16056266               16083653                  Bash 11.2.0.3.0     includes CPU Apr 2013
11.2.0.3.7           16619892               16742216                  Bash 11.2.0.3.0     includes CPU Jul 2013
11.2.0.3.8           16902043               17272731                  Bash 11.2.0.3.0     includes CPU Oct 2013
11.2.0.3.9           17540582               17735354                  Bash 11.2.0.3.0     includes CPU Jan 2014
11.2.0.3.10          18031683               18139678                  Bash 11.2.0.3.0     includes CPU Apr 2014
11.2.0.3.11          18522512               18706488                  Bash 11.2.0.3.0     includes CPU Jul 2014
11.2.0.3.12          19121548               19440385                  Bash 11.2.0.3.0     includes CPU Oct 2014
11.2.0.3.13          19769496               19971343                  Bash 11.2.0.3.0     includes CPU Jan 2015

OJVM PSU:            Database               Grid Infrastructure       Comments            Includes JDBC Patch

11.2.0.3.1           19282015(Unix)                                   PSU 11.2.0.3.12
                     19806120(Win)                                 或 SPU 11.2.0.3(CPUOct2014)
                     19852361(JDBC Patch)
11.2.0.3.2           19877443   19852361                              Bash 11.2.0.3.11     Jan 2015

+++++++11.2.0.4
OracleDatabase PSU   Database               Grid Infrastructure       Comments               Includes  Cpu
11.2.0.4.0           13390677               13390677
11.2.0.4.1           17478514                                          Bash 11.2.0.4.0         includes CPU Jan 2014
11.2.0.4.2           18031668               18139609                   Bash 11.2.0.4.0         includes CPU Apr 2014
11.2.0.4.3           18522509               18706472                   Bash 11.2.0.4.0         includes CPU Jul 2014
11.2.0.4.4           19121551               19380115                   Bash 11.2.0.4.0         includes CPU Oct 2014
11.2.0.4.5           19769489               19955028                   Bash 11.2.0.4.0         includes CPU Jan 2015

OJVM PSU:            Database               Grid Infrastructure        Comments               Includes JDBC Patch

11.2.0.4.1           19282021(Unix)                                    Bash 11.2.0.4.4
                     19799291(WIN)                                   或SPU 11.2.0.4(CPUOct2014)
                     19852360(JDBC Patch)
11.2.0.4.2           19877440   19852360                               Bash 11.2.0.4.4        Jan 2015

+++++++12.1.0.1
OracleDatabase PSU   Database           Grid Infrastructure       Comments           Includes  Cpu

12.1.0.1.1           17027533           17272829                  Bash 12.1.0.1.0
12.1.0.1.2           17552800           17735306                  Bash 12.1.0.1.0    includes CPU Jan 2014
12.1.0.1.3           18031528           18139660(AIX/HP/zLinux)   Bash 12.1.0.1.0    includes CPU Apr 2014
                                        18413105(Linux/Solaris)
12.1.0.1.4           18522516           18705972(AIX/HP/zLinux)   Bash 12.1.0.1.0    includes CPU Jul 2014
                                        18705901(Linux/Solaris)

12.1.0.1.5           19121550           19392451(AIX/HP/zLinux)   Bash 12.1.0.1.0    includes CPU Oct 2014
                                        19392372(Linux/Solaris)  

12.1.0.1.6           19769486           19971331(AIX/HP/zLinux)   Bash 12.1.0.1.0    includes CPU Jan 2015
                                        19971324(Linux/Solaris)      

OJVM PSU:            Database              Grid Infrastructure       Comments           Includes JDBC Patch

12.1.0.1.1           19282024(Unix)                                  Bash 12.1.0.1.5
                     19801531(WIN) 
                     19852357(JDBC Patch)
12.1.0.1.2           19877342             19852357                   Bash 12.1.0.1.5    Jan 2015

++++++ 12.1.0.2   
OracleDatabase PSU   Database         Grid Infrastructure       Comments           Includes  Cpu

12.1.0.2.1           19303936          19392646                  Bash 12.1.0.2.0    includes CPU Oct 2014
12.1.0.2.2           19769480          19954978                  Bash 12.1.0.2.0    includes CPU Jan 2015

OJVM PSU:            Database         Grid Infrastructure       Comments           Includes JDBC Patch

12.1.2.0.1           19282028                                    Bash 12.1.0.2.1
12.1.2.0.2           19877336          20132450                  Bash 12.1.0.2.1    Jan 2015

备注:

1) 关于JDBC Patch和OJVM PSU的信息,请参考MOS doc:

Oracle Recommended Patches — “Oracle JavaVM Component Database PSU” (OJVM PSU) Patches (1929745.1)
2) 要安装OJVM PSU,那么数据库环境版本也是有要求的,不能低于2014年10月发布的补丁号,及:
require the database home to be patched to at least October 2014 DB PSU

换句话讲,11.1.0.7如果要安装OJVM PSU,那么版本不能低于11.1.0.7.20。请参考上面的Comments说明。

3) 之前CPU(Critical Patch Update)安装补丁,现在改名被称为SPU Security Patch Update。

One Response to “2015年第一季度PSU更新(OJVM PSU更新)”

  1. zergduan Says:

    再来Combo Patch~
    所以对于Oracle Database产品的PSU来说,目前出现了3种补丁
    1. RDBMS 的PSU — DB PSU (使用opatch apply安装,可以对rdbms,client安装patch)
    2. GI的PSU — GI PSU (这种PSU是GI+DB PSU的组合里面有两个目录一个是gi的patch,一个是db patch,使用opatch auto自动安装,会将GI和及下注册的RDBMS一起安装patch;也可以使用db patch目录中的文件对client进行升级)
    3. OJVM的PSU — 包含gi,rdbms,client中所有针对java组件的patch

    将以上3种不同的PSU打包在一起就形成了Combo Patch,这种PSU目录结构很简单,一共三个目录:
    1. GI PSU(如上面所说,这个目录下又有两个子目录,一个值GI的patch,一个就是DB patch)
    2. 最新版OJVM PSU
    3. 第一版OJVM PSU — JDBC patch

    所以,其实你仅仅需要下载Combo Patch就可以了,因为里面已经包含了所有PSU~

Leave a Reply

You must be logged in to post a comment.