OracleDatabase 11g 11.2.0.1.0
Thereare 1 products installed in this Oracle Home.
Interimpatches (2) :
Patch 9654983 : applied on Tue Nov 05 12:00:22 CST 2013
UniquePatch ID: 12651759
Created on 17 Jun 2010, 03:31:21 hrs PST8PDT
Bugs fixed:
9068088, 9363384, 8865718, 8837736,8801119, 9054253, 8725286, 8974548
9093300, 8909984, 8755082, 8780372,8664189, 8769569, 7519406, 8822531
7705591, 8650719, 9637033, 8639114,8723477, 8729793, 8919682, 8856478
9001453, 8733749, 8565708, 8735201,8684517, 8870559, 8773383, 8981059
8812705, 9488887, 8813366, 9242411,8822832, 8897784, 8760714, 8775569
8671349, 8898589, 9714832, 8642202,9011088, 9170608, 9369797, 9165206
8834636, 8891037, 8431487, 8570322,8685253, 8872096, 8718952, 8799099
9032717, 9399090, 9546223, 9713537,8588519, 8783738, 8834425, 9454385
8856497, 8890026, 8721315, 8818175,8674263, 9145541, 8720447, 9272086
9467635, 9010222, 9197917, 8991997,8661168, 8803762, 8769239, 9654983
8706590, 8778277, 8815639, 9027691,9454036, 9454037, 9454038, 9255542
8761974, 9275072, 8496830, 8702892,8818983, 8475069, 8875671, 9328668
8798317, 8891929, 8774868, 8820324,8544696, 8702535, 8268775, 9036013
9363145, 8933870, 8405205, 9467727,8822365, 9676419, 8761260, 8790767
8795418, 8913269, 8717461, 8607693,8861700, 8330783, 8780281, 8780711
8784929, 9341448, 9015983, 9119194,8828328, 8665189, 8717031, 8832205
9676420, 8633358, 9321701, 9655013,8796511, 9167285, 8782971, 8756598
8703064, 9066116, 9007102, 9461782,9352237, 8505803, 8753903, 9216806
8918433, 9057443, 8790561, 8733225,9067282, 8928276, 9210925
Patch 9655006 : applied on Tue Nov 05 11:58:48 CST 2013
UniquePatch ID: 12651759
Created on 6 Jul 2010, 12:02:48 hrs PST8PDT
Bugs fixed:
9655006, 9778840, 9343627, 9783609,9262748
可以看到补丁的安装情况,PSU需要的几个补丁都已经安装上去,最后就是执行下数据字典更新脚本,RAC环境下只要保证一个实例启动状态,然后在oracle用户下执行下面的语句,执行脚本
cd$ORACLE_HOME/rdbms/admin
sqlplus/nolog
SQL>CONNECT / AS SYSDBA
SQL>@catbundle.sql psu apply
SQL>QUIT
这个脚本会更新数据字典表,如果不执行可能使用过程中会出现一些莫名的错误,因此千万不要忘记执行。
5.4. PSU补丁安装
接下来在完成了前提补丁的安装后,我们又再次回答PSU的说明文档,接着看还有那些先决条件需要准备,为了保障 make, ar, ld, 和nm命令能够直接被调用,需要提前设置环境变量路径,如下
exportPATH=$PATH:/usr/ccs/bin
在经过之前前提补丁的安装后,接下来再安装PSU补丁就应该轻车熟路,11.2.0.1.6PSU补丁的安装过程就如同一个‘个别补丁‘一样简单,先在节点1上进入解压的目录(一般为12419378),然后直接运行opatch apply如下,当然前提是数据库实例已经关闭,否则会在环境校验阶段出现错误提示,关闭实例的操作这里就不再演示,可以一个节点一个节点的操作,也可以所有节点一起操作,下面我们直接进行补丁的安装:
[oracle@rac1 12419378]$ opatch apply
OracleInterim Patch Installer version 11.2.0.3.5
Copyright(c) 2013, Oracle Corporation. All rightsreserved.
OracleHome :/u01/app/oracle/product/11.2.0/db_1
CentralInventory : /u01/app/oraInventory
from :/u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatchversion : 11.2.0.3.5
OUIversion : 11.2.0.1.0
Logfile location :/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/12419378_Nov_11_2013_16_17_40/apply2013-11-11_16-17-40PM_1.log
Applyinginterim patch '12419378' to OH '/u01/app/oracle/product/11.2.0/db_1'
Verifyingenvironment and performing prerequisite checks...
Patch12419378: Optional component(s) missing : [ oracle.client, 11.2.0.1.0 ]
Interimpatch 12419378 is a superset of the patch(es) [ 9654983 ,9655006] in the Oracle Home
OPatchwill roll back the subset patches and apply the given patch.
Allchecks passed.(环境检查成功)
Thisnode is part of an Oracle Real Application Cluster.
Remotenodes: 'demo-rac1'
Localnode: 'demo-rac2'
Pleaseshutdown Oracle instances running out of this ORACLE_HOME on the local system.
(OracleHome = '/u01/app/oracle/product/11.2.0/db_1')
……
Enter'yes' if this is not a shared home or if the prerequiste actions are performedto patch this shared home (yes/no):yes
patch/home/oracle/12419378 apply successfulfor home /u01/app/oracle/product/11.2.0/db_1