当前位置:  数据库>oracle

DB and RAC(11.2.0.3 ) Patch Set Update(11.2.0.3.6 )

    来源: 互联网  发布时间：2017-05-21

    本文导语: 现在是2013年05月29日，Oracle最新的PSU为11.2.0.3.6,本次升级为RAC和DB分别进行升级，为日后的RAC+DG环境做准备。     系统:linux 5.7 x86_64     数据库版本：11.2.0.3.0 单机升级ORACLE     首先升级单机的DB到11.2.0.3.6：     下载11.2.0.3.6...

现在是2013年05月29日，Oracle最新的PSU为11.2.0.3.6,本次升级为RAC和DB分别进行升级，为日后的RAC+DG环境做准备。
 
    系统:linux 5.7 x86_64
 
    数据库版本：11.2.0.3.0
 
单机升级ORACLE
 
    首先升级单机的DB到11.2.0.3.6：
 
    下载11.2.0.3.6的补丁包，补丁编号为16056266。
 
1.1  检查补丁冲突
 
用oracle用户unzip补丁包到ORACLE_HOME目录下。
 
[oracle@bogon db_1]$ cd 16056266/
 
[oracle@localhost 16056266]$ ../OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
 

Oracle Interim Patch Installer version 11.2.0.3.4
 Copyright (c) 2012, Oracle Corporation.  All rights reserved.
 
PREREQ session
 
Oracle Home      : /u01/app/oracle/product/11g/db_1
 Central Inventory : /u01/app/oraInventory
    from          : /u01/app/oracle/product/11g/db_1/oraInst.loc
 OPatch version    : 11.2.0.3.4
 OUI version      : 11.2.0.3.0
 Log file location : /u01/app/oracle/product/11g/db_1/cfgtoollogs/opatch/opatch2013-05-27_11-00-06AM_1.log
 
Invoking prereq "checkconflictagainstohwithdetail"
 
Prereq "checkConflictAgainstOHWithDetail" passed.
 
OPatch succeeded.
 

1.2  检查当前数据库补丁历史
 
SQL> select action,comments from registry$history;
 
ACTION
 ------------------------------
 COMMENTS
 --------------------------------------------------------------------------------
 APPLY
 Patchset 11.2.0.2.0
 
APPLY
 Patchset 11.2.0.2.0
 
 
 
1.3 应用补丁进行升级
 
--升级前将数据库，监听及sqlplus都退出，否则在前置检查的时候会报错。
 
[oracle@bogon 16056266]$ ../OPatch/opatch apply
 Oracle Interim Patch Installer version 11.2.0.3.4
 Copyright (c) 2012, Oracle Corporation.  All rights reserved.
 

Oracle Home      : /u01/app/oracle/product/11g/db_1
 Central Inventory : /u01/app/oraInventory
    from          : /u01/app/oracle/product/11g/db_1/oraInst.loc
 OPatch version    : 11.2.0.3.4
 OUI version      : 11.2.0.3.0
 Log file location : /u01/app/oracle/product/11g/db_1/cfgtoollogs/opatch/opatch2013-05-28_11-00-14AM_1.log
 
Verifying environment and performing prerequisite checks...
 OPatch continues with these patches:  13343438  13696216  13923374  14275605  14727310  16056266
 
Do you want to proceed? [y|n]
 Y
 
--单机PSU可以不需要MOS账号
 

  Composite patch 16056266 successfully applied.
  UtilSession: N-Apply done.
    --------------------------------------------------------------------------------
  The following warnings have occurred during OPatch execution:
    1) OUI-67215:
    OPatch found the word "warning" in the stderr of the make command.
    Please look at this stderr. You can re-run this make command.
    Stderr output:
    ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
    /u01/app/oracle/product/11g/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
    /u01/app/oracle/product/11g/db_1/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
    /u01/app/oracle/product/11g/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
    --------------------------------------------------------------------------------
    OUI-67008:OPatch Session completed with warnings.
    Finishing UtilSession at Tue May 28 11:10:43 CST 2013
    Log file location: /u01/app/oracle/product/11g/db_1/cfgtoollogs/opatch/opatch2013-05-28_11-00-14AM_1.log
 
--虽然有告警，但依然安装成功
 
1.4 检查升级（PSU)后的版本
 
--查看当前补丁版本
 [oracle@localhost OPatch]$ ./opatch lspatches
16056266;Database Patch Set Update : 11.2.0.3.6 (16056266)
 

--查看当前补丁详细信息
 [oracle@localhost OPatch]$ ./opatch lsinventory
 Oracle Interim Patch Installer version 11.2.0.3.4
 Copyright (c) 2012, Oracle Corporation.  All rights reserved.
 

Oracle Home      : /u01/app/oracle/product/11g/db_1
 Central Inventory : /u01/app/oraInventory
    from          : /u01/app/oracle/product/11g/db_1/oraInst.loc
 OPatch version    : 11.2.0.3.4
 OUI version      : 11.2.0.3.0
 Log file location : /u01/app/oracle/product/11g/db_1/cfgtoollogs/opatch/opatch2013-05-28_11-33-02AM_1.log
 
Lsinventory Output file location : /u01/app/oracle/product/11g/db_1/cfgtoollogs/opatch/lsinv/lsinventory2013-05-28_11-33-02AM.txt
 
--------------------------------------------------------------------------------
 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  16056266    : applied on Tue May 28 11:09:50 CST 2013
 Unique Patch ID:  15962803
 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  14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"
 Sub-patch  13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
 Sub-patch  13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
 Sub-patch  13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
    Bugs fixed:
      13566938, 13593999, 10350832, 14138130, 12919564, 13561951, 13624984
      13588248, 13080778, 13914613, 13804294, 14258925, 12873183, 13645875
      14472647, 12880299, 14664355, 14409183, 12998795, 14469008, 13719081
      13492735, 13496884, 12857027, 14263036, 14263073, 13732226, 13742433
      16368108, 16314469, 12905058, 13742434, 12849688, 12950644, 13742435
      13464002, 13534412, 12879027, 13958038, 14613900, 12585543, 12535346
      12588744, 11877623, 13786142, 12847466, 13649031, 13981051, 12582664
      12797765, 14262913, 12923168, 13384182, 13612575, 13466801, 13484963
      14207163, 11063191, 13772618, 13070939, 12797420, 13041324, 16314467
      16314468, 12976376, 11708510, 13680405, 14589750, 13026410, 13742437
      13737746, 14644185, 13742438, 13326736, 13596521, 13001379, 16344871
      13099577, 9873405, 14275605, 13742436, 9858539, 14841812, 11715084
      16231699, 14040433, 12662040, 9703627, 12617123, 12845115, 12764337
      13354082, 14459552, 13397104, 13913630, 12964067, 12983611, 13550185
      13810393, 12780983, 12583611, 14546575, 13476583, 15862016, 11840910
      13903046, 15862017, 13572659, 16294378, 13718279, 14088346, 13657605
      13448206, 16314466, 14480676, 13419660, 13632717, 14063281, 14110275
      13430938, 13467683, 13420224, 13812031, 14548763, 16299830, 12646784
      13616375, 14035825, 12861463, 12834027, 15862021, 13632809, 13377816
      13036331, 14727310, 13685544, 15862018, 13499128, 16175381, 13584130
      12829021, 15862019, 12794305, 14546673, 12791981, 13787482, 13503598
      10133521, 12718090, 13399435, 14023636, 13860201, 12401111, 13257247
      13362079, 14176879, 12917230, 13923374, 14220725, 14480675, 13524899
      13559697, 9706792, 14480674, 13916709, 13098318, 13773133, 14076523
      13340388, 13366202, 13528551, 12894807, 13454210, 13343438, 12748240
      14205448, 13385346, 15853081, 14273397, 12971775, 13582702, 10242202
      13035804, 13544396, 16382353, 8547978, 14226599, 14062795, 13035360
      12693626, 13332439, 14038787, 14062796, 12913474, 14841409, 14390252
      16314470, 13370330, 13059165, 14062797, 14062794, 12959852, 13358781
      12345082, 12960925, 9659614, 13699124, 14546638, 13936424, 13338048
      12938841, 12658411, 12620823, 12656535, 14062793, 12678920, 13038684
      14062792, 13807411, 13250244, 12594032, 15862022, 9761357, 12612118
      13742464, 14052474, 13911821, 13457582, 13527323, 15862020, 13910420
      13502183, 12780098, 13705338, 13696216, 14841558, 10263668, 15862023
      16056266, 15862024, 13554409, 13645917, 13103913, 13011409, 14063280
 
 
 
--------------------------------------------------------------------------------
 
OPatch succeeded.
 
./opatch lsinventory -detail  --补丁详细信息查看
 
1.5 将升级信息载入数据库
 
cd $ORACLE_HOME/rdbms/admin
 sqlplus /nolog
 SQL> CONNECT / AS SYSDBA
 SQL> STARTUP
 SQL> @catbundle.sql psu apply
 SQL> QUIT


    
 
 

您可能感兴趣的文章:

 
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术，将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。












  • 相关文章推荐
  • 请问在B Shell中如何表示以下关系：a=0 or 0<a<7啊？a=0 and a=11?哪里有Shell编程的详细资料下载啊？
  • java命名空间java.math类biginteger的类成员方法: and定义及介绍
  • 系统参数？？？and后台管理实例？？？and JSP???
  • C++ Double Ended Queues 成员 Operators:compare and assign dequeues
  • 博客 iis7站长之家
  • java命名空间java.lang类character.unicodeblock的类成员方法: superscripts_and_subscripts定义及介绍
  • jQuery 图像脚本 Before and After
  • java命名空间javax.swing类jfilechooser的类成员方法: files_and_directories定义及介绍
  • 3D游戏：搜救行动 Search and Rescue
  • java命名空间java.lang类character.unicodeblock的类成员方法: miscellaneous_symbols_and_arrows定义及介绍
  • jQuery Resize And Crop
  • java命名空间java.lang类character.unicodeblock的类成员方法: halfwidth_and_fullwidth_forms定义及介绍
  • Tymeac-and
  • java命名空间java.lang类character.unicodeblock的类成员方法: cjk_symbols_and_punctuation定义及介绍
  • Mobile Freecell and Sudoku
  • java命名空间java.util类bitset的类成员方法: and定义及介绍
  • 3D冒险游戏 Humm and Strumm
  • java命名空间java.lang类character.unicodeblock的类成员方法: enclosed_cjk_letters_and_months定义及介绍
  • Linux and Android for T-Mobile Wing
  • 广告系统中weak-and算法原理及编码验证
  • HTML Forms generation and validation
  • Jquery Upload and Crop Image


    • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除！

    ©2012-2021,