如何解决11gR2网格架构升级失败问题
适用于:
Oracle Server - Enterprise Edition - Version: 11.2.0.1 to 11.2.0.1 - Release: 11.2 to 11.2
Generic UNIX
Generic Linux
目标
本说明的目的是提供升级失败11gR2(11.2)网格基础设施(CRS)的解决应用步骤,因此又可以继续尝试。
解决方案
rootupgrade.sh运行前发生的故障:
案例适用于这里是runInstaller无法执行,在执行rootupgrade.sh之前。
您将需要从屏幕输出和安装日志中找出失败的原因
$ORACLE_BASE/oraInventory/logs (three files .log, .err and .out will be generated each time you run runInstaller) before execute clean up steps.
A.:作为网格中用户,通过运行$ GRID_HOME/deinstall/deinstall来删除失败的安装
B:如果步骤A成功,请跳到步骤C,否则执行以下:
export ORACLE_HOME=$OLD_CRS_HOME
## To detach failed GRID_HOME:
$OLD_CRS_HOME/oui/bin/runInstaller -detachHome -silent ORACLE_HOME=$GRID_HOME
## To confirm $GRID_HOME is removed from central inventory:
$OLD_CRS_HOME/OPatch/opatch lsinventory -all
## To remove files in failed GRID_HOME on all nodes manually:
/bin/rm -rf $GRID_HOME
unset ORACLE_HOME
C. Detach and attach pre-11gR2 CRS home to set CRS flag to true on all nodes:
export ORACLE_HOME=$OLD_CRS_HOME
$OLD_CRS_HOME/oui/bin/runInstaller -detachHome -silent -local ORACLE_HOME=$OLD_CRS_HOME
$OLD_CRS_HOME/oui/bin/runInstaller -silent -local -ignoreSysPrereqs -attachHome ORACLE_HOME=$OLD_CRS_HOME ORACLE_HOME_NAME=$OLD_CRS_HOME_NAME LOCAL_NODE=local_nodename CLUSTER_NODES=local_nodename,remote_nodename CRS=true
d.重新启动runInstaller来升级到11.2网格基础架构
执行rootupgrade.sh产生的故障:
你要查看$GRID_HOME/cfgtoollogs/crsconfig,$GRID_HOME/log 和$ORACLE_BASE/
oraInventorv/logs 日志来确定故障产生的原因。一旦原因被确定,请执行以下步骤:
0、重新启动根的脚本- rootupgrade.sh
对于11.2.0.2或者以上的版本,rootupgrade.sh是可以重新启动的,一旦原因被确认并且修复,rootupgrade.sh是可以在失败节点上重新执行的,如果成功,你可以继续进行安装,否则请在节点上进行下一个步骤。
1、确认‘last node’
Mark the node as "last node" where you find pre-upgrade OCR backup in $GRID_HOME/cdata/ocr$OLD_CRS_VERSION (for example, /ocw/grid/cdata/ocr10.2.0.4.0); in most case it's first node where you execute rootupgrade.sh
2、2. As root, on all but "last node", execute:
$GRID_HOME/crs/install/rootcrs.pl -downgrade -force
在你从未执行过rootupgrade.sh的节点上,你可以跳过这一命令。
3、3. As root, on "last node", execute:
$GRID_HOME/crs/install/rootcrs.pl -downgrade -force -lastnode -oldcrshome $OLD_CRS_HOME -version $OLD_CRS_VERSION
Please note $OLD_CRS_VERSION need to be in format of n.n.n.n.n, for example, 10.2.0.4.0
如果OCR降级成功,跳到第5步,否则转到步骤4。
4.重配置11gR2
只有当第3步执行失败,执行这一步。
4A. As root, on all but last node, execute:
$GRID_HOME/crs/install/rootcrs.pl -verbose -deconfig -force
4B. As root, on last node, execute:
$GRID_HOME/crs/install/rootcrs.pl -verbose -deconfig -force -lastnode
* If rootcrs.pl fails with following error:
Using configuration parameter file: /ocw/grid/crs/install/crsconfig_params
Can't open /etc/oracle/scls_scr/node1/root/ohasdrun for write: No such file or directory at /ocw/grid/crs/install/s_crsconfig_lib.pm line 1021.
As root, please create a empty ohasdrun and try the same again:
mkdir -p /etc/oracle/scls_scr/$HOSTNAME/root
touch /etc/oracle/scls_scr/$HOSTNAME/root/ohasdrun
*如果rootcrs.pl一直挂起,请禁用自动启动11gR2,重新启动节点,并重新执行相同的命令。要禁用自动启动CRS的,以root身份执行:
$GRID_HOME/bin/crsctl disable crs
*一旦步骤4完成后,检查点文件不应该存在。为了验证:
ls -l $ORACLE_BASE/Clusterware/ckptGridHA_.xml
如果它仍然存在,请用“rm”命令手动删除.
5、执行$OLD_CRS_HOME/root.sh
如果新的节点加入或者任何在11.2CRS原始安装之后的改变,请从甲骨文支持获得关于如何手动修改pre-11.2 configuration的介绍
OCR or Voting disk location
Network information for public, VIP or private
- If OCR or Voting Disk are located on Cluster File System or Network File System, please make sure they exist before execution of root.sh. If they don't exist, please create dummy OCR/Voting Disk files with /bin/touch.
作为root用户,在每个节点上按顺序执行$OLD_CRS_HOME/root.sh,它将在脚本结束后开启旧的CRS
如果root.sh启动pre-11.2CRS失败,请转到步骤6,否则跳到步骤7.
6. 解除和重新配置pre-11.2 CRS
Execute this step only if step 5 failed.
6A。作为root用户,在所有节点上,执行$OLD_CRS_HOME/install/rootdelete.sh
6B。作为root用户,在第一个节点上,执行$OLD_CRS_HOME/install/rootdeinstall.sh
6C。作为root用户,在所有节点上按顺序执行$OLD_CRS_HOME/root.sh
7。还原的OCR
如果您执行步骤4或第6步,OCR备份需要恢复。
如果你在OCR升级前备份,你可以用它来恢复,否则,请确定
在所有节点上$OLD_CRS_HOME/cdata/{CLUSTERNAME}能很好的自动备份。
7A. As root, on all nodes, stop CRS:
$OLD_CRS_HOME/bin/crsctl stop crs
7B. As root, on node where identified OCR backup resides:
$OLD_CRS_HOME/bin/ocrconfig -restore name_of_ocr_backup
8.清理所有节点上的gpnp profile
执行此步骤:只有前11.2 CRS配置或OS环境发生了变化,例如,网络信息,OCR或表决磁盘位置等:
rm -rf $GRID_HOME/gpnp/*
该命令需要在所有节点上执行
9.验证pre-11.2CRS
在这点上,pre-11.2CRS应该运行了,作为CRS用户,在所有节点上执行如下操作来验证:
export ORACLE_HOME=$OLD_CRS_HOME
$OLD_CRS_HOME/bin/crsctl query crs activeversion
$OLD_CRS_HOME/bin/crsctl query crs softwareversion
$OLD_CRS_HOME/bin/crsctl check crs
$OLD_CRS_HOME/bin/crs_stat -t
$OLD_CRS_HOME/bin/crs_stat
$OLD_CRS_HOME/bin/oifcfg iflist -p -n
$OLD_CRS_HOME/bin/oifcfg getif
$OLD_CRS_HOME/bin/ocrcheck
cat /etc/oracle/ocr.loc /var/opt/oracle/ocr.loc
$OLD_CRS_HOME/bin/crsctl get css diagwait
$OLD_CRS_HOME/bin/srvctl config nodeapps -n `hostname | cut -d'.' -f1 | awk '{ print tolower($0); }'` -a
$OLD_CRS_HOME/OPatch/opatch lsinventory oh=$OLD_CRS_HOME
unset ORACLE_HOME
ifconfig ## location and exact syntax in note 1054902.1
10。执行rootupgrade.sh
取消设置ORACLE_HOME,ORACLE_BASE,ORACLE_SID,ORA_CRS_HOME,TNS_ADMIN 在root和oracle’s profile和当前的shell环境的;确保所有节点上的防火墙是关闭的,并在所有节点上依次执行$GRID_HOME/ rootupgrade.sh。
11。执行rootupgrade.sh步骤:
如果任何配置辅助已经成功完成以前,你想跳过它,请务必重新运行设置为false$ GRID_HOME/ cfgtoollogs/ configToolAllCommands,
for example:
$ cat $GRID_HOME/cfgtoollogs/configToolAllCommands
..
/ogrid/gbase/oui/bin/runConfig.sh ORACLE_HOME=/ogrid/gbase MODE=perform ACTION=configure RERUN=false $*
As GRID user, execute $GRID_HOME/cfgtoollogs/configToolAllCommands on first node.
Failure during plug-in:
请找出失败的插件的原因并跳到步骤11.
参考文献
BUG:9626103 - DOWNGRADE CORRUPTED VOTING DISK
NOTE:1050908.1 - How to Troubleshoot Grid Infrastructure Startup Issues
NOTE:1053147.1 - 11gR2 Clusterware and Grid Home - What You Need to Know
NOTE:1054902.1 - How to Validate Network and Name Resolution Setup for the Clusterware and RAC
NOTE:1056322.1 - How to Troubleshoot 11gR2 Installation Issue
NOTE:942166.1 - How to Proceed from Failed 11gR2 Grid Infrastructure (CRS) Installation
NOTE:948456.1 - Pre 11.2 Database Issues in 11gR2 Grid Infrastructure Environment
相关信息显示:
产品
* Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
关键词
UPGRADE FAILS; OCR; RUNINSTALLER; GRID; CRS; CRSCTL; PLUG-IN; ROOTUPGRADE