升级Oracle RAC 11.2.0.3.0到 11.2.0.3.9

153次阅读

共计 3484 个字符，预计需要花费 9 分钟才能阅读完成。

重装了 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 星期一 3 月 2 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