11G RAC11.2.0.1 升级11.2.0.3.docx

11G RAC 双节点升级到GI 升级升级前准备需要软件112030_Linux-x86-64_3of7.zip解压[grid@test01 temp]$ unzip 112030_Linux-x86-64_3of7.zip[grid@test01 temp]$ cd grid/[grid@test01 grid]$ pwd/temp/grid/[grid@test01 grid]$ ./runcluvfy.shstage -pre crsinst -upgrade -n test01,test02-rolling -src_crshome $ORACLE_HOME -dest_crshome $ORACLE_HOME -dest_version .0 -fixup -fixupdir /tmp -verbose常见问题及解决办法问题1：/u01/app/11.2.0/grid test01 /u01 3.8643GB 5.5GB failed解决方法：整理磁盘问题2：Checking for Oracle patch 9413827 in home /u01/app/grid/11.2.Node Name Applied Required Comment ---------------------------------------------------------------------------------------------------------------------------------test02 missing 9413827 failed test01 missing 9413827 failed 解决方法：打补丁9413827如果集群的管理用户和数据库管理用户是在同一个用户下，那么需要改变一下环境变量，使用命令. oraenv授权（双节点）[root@test01 ~]# chown -R grid:oinstall /u01/app/grid/11.2/备份一下（双节点）[grid@test01 ~]$cp -rf $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_bk解压（双节点）[grid@test01 tmp]$ unzip p9413827_112010_Linux-x86-64.zip -d $ORACLE_HOME看一下版本（双节点）[grid@test01 11.2]$ $ORACLE_HOME/OPatch/opatch versionOPatch Version: .0OPatch succeeded.集群1节点操作[grid@test01 11.2]$ srvctl stop home -o $ORACLE_HOME -s /tmp/dex -n test01解锁[root@test01 ~]# /u01/app/grid/11.2/crs/install/rootcrs.pl -unlock Successfully unlock /u01/app/grid/11.2备份[grid@test01 ~]$ /u01/app/grid/11.2/9413827/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME/u01/app/grid/11.2/9413827/custom/scripts/prepatch.sh completed successfully.打补丁[grid@test01 ~]$ cd /u01/app/grid/11.2/9413827/[grid@test01 9413827]$ /u01/app/grid/11.2/OPatch/opatch napply -local -oh $ORACLE_HOME -id 9413827[grid@test01 9413827]$ custom/server/9413827/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME[root@test01 ~]# /u01/app/grid/11.2/crs/install/rootcrs.pl -patch---------------------------------------