手机版
你好,游客 登录 注册 搜索
背景:
阅读新闻

升级Oracle RAC 11.2.0.3.0到 11.2.0.3.9

[日期:2016-11-23] 来源:Linux社区  作者:angelwing1984 [字体: ]

重装了Oracle RAC 11.2.0.3,顺便打补丁到11.2.0.3.9,这里记下步骤。

1.将补丁上传到服务器上

mkdir /patches
chown -R grid:oinstall /patches
chmod 775  /patches

2.给OPath打补丁

用root用户执行下面的命令

cd /patches
cp p6880880_112000_Linux-x86-64.zip /u01/app/11.2.0.3/grid/
cd /u01/app/11.2.0.3/grid/
mv OPatch OPatch1
unzip p6880880_112000_Linux-x86-64.zip
chown -R grid:oinstall OPatch

cd /patches
cp p6880880_112000_Linux-x86-64.zip /u01/app/oracle/product/11.2.0.3/dbhome_1
cd /u01/app/oracle/product/11.2.0.3/dbhome_1
mv OPatch OPatch1
unzip p6880880_112000_Linux-x86-64.zip
chown -R oracle:oinstall OPatch

用grid和oracle分别执行下面的命令生成响应文件

$ORACLE_HOME/OPatch/ocm/bin/emocmrsp 

3.给grid软件打补丁

将opatch加到PATH里

export PATH=$PATH:/u01/app/11.2.0.3/grid/OPatch

用root用户给grid打补丁

[root@db01 ~]# opatch auto /patches/ -ocmrf /home/grid/ocm.rsp  -oh /u01/app/11.2.0.3/grid/
Executing /u01/app/11.2.0.3/grid/perl/bin/perl /u01/app/oracle/product/11.2.0.3/dbhome_1/OPatch/crs/patch11203.pl -patchdir / -patchn patches -ocmrf /home/grid/ocm.rsp -oh /u01/app/11.2.0.3/grid/ -paramfile /u01/app/11.2.0.3/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatchauto2015-03-02_14-44-08.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatchauto2015-03-02_14-44-08.report.log

2015-03-02 14:44:08: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0.3/grid/crs/install/crsconfig_params

Stopping CRS...
Stopped CRS successfully

patch //patches/17592127  apply successful for home  /u01/app/11.2.0.3/grid 
patch //patches/17540582  apply successful for home  /u01/app/11.2.0.3/grid 

Starting CRS...
CRS-4123: Oracle High Availability Services has been started.

opatch auto succeeded.

4.给oracle软件打补丁

同样用root执行下面的命令。

[root@db01 ~]# opatch auto /patches/ -ocmrf /home/grid/ocm.rsp  -oh /u01/app/oracle/product/11.2.0.3/dbhome_1/
Executing /u01/app/11.2.0.3/grid/perl/bin/perl /u01/app/oracle/product/11.2.0.3/dbhome_1/OPatch/crs/patch11203.pl -patchdir / -patchn patches -ocmrf /home/grid/ocm.rsp -oh /u01/app/oracle/product/11.2.0.3/dbhome_1/ -paramfile /u01/app/11.2.0.3/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatchauto2015-03-02_15-49-09.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatchauto2015-03-02_15-49-09.report.log

2015-03-02 15:49:09: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0.3/grid/crs/install/crsconfig_params

Stopping RAC /u01/app/oracle/product/11.2.0.3/dbhome_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0.3/dbhome_1 successfully

patch //patches/17592127/custom/server/17592127  apply failed  for home  /u01/app/oracle/product/11.2.0.3/dbhome_1

Starting RAC /u01/app/oracle/product/11.2.0.3/dbhome_1 ...
Started RAC /u01/app/oracle/product/11.2.0.3/dbhome_1 successfully

opatch auto succeeded.

到这一步节点1的补丁已经打完了,在节点2上同样执行1-4的步骤。
节点2的补丁打完之后,下面就是给数据库打补丁。

5.给数据库打补丁

启动数据库
srvctl start database -d pord

用oracle用户登录数据库,执行下面的脚本

[oracle@db01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on 星期一 32 16:11:13 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


连接到: 
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> @?/rdbms/admin/catbundle.sql psu apply

日志比较长,这里就不贴了。

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

本文永久更新链接地址http://www.linuxidc.com/Linux/2016-11/137441.htm

linux
相关资讯       Oracle RAC  Oracle RAC升级 
本文评论   查看全部评论 (0)
表情: 表情 姓名: 字数

       

评论声明
  • 尊重网上道德,遵守中华人民共和国的各项有关法律法规
  • 承担一切因您的行为而直接或间接导致的民事或刑事法律责任
  • 本站管理人员有权保留或删除其管辖留言中的任意内容
  • 本站有权在网站内转载或引用您的评论
  • 参与本评论即表明您已经阅读并接受上述条款