一步一脚印

最近做了一个rac数据库的迁移，中间涉及到很多部分内容，包括rac环境的搭建、ASM的设置、数据库的迁移、升级等。
本文是这次迁移工作的第八部分：迁移过程中遇到的错误。

8 遇到的错误

8.1 错误

Crs我安装了3遍，在其中一次重装crs时，在最后执行脚本时出错：

bash-3.00# /oracle/app/oraInventory/orainstRoot.sh

Changing permissions of /oracle/app/oraInventory to 770.

Changing groupname of /oracle/app/oraInventory to oinstall.

The execution of the script is complete

在执行第二个脚本时，停顿住了：

bash-3.00# /oracle/app/product/10.2/crs/root.sh

WARNING: directory '/oracle/app/product/10.2' is not owned by root

WARNING: directory '/oracle/app/product' is not owned by root

WARNING: directory '/oracle/app' is not owned by root

WARNING: directory '/oracle' is not owned by root

Checking to see if Oracle CRS stack is already configured

Setting the permissions on OCR backup directory

Setting up NS directories

Oracle Cluster Registry configuration upgraded successfully

WARNING: directory '/oracle/app/product/10.2' is not owned by root

WARNING: directory '/oracle/app/product' is not owned by root

WARNING: directory '/oracle/app' is not owned by root

WARNING: directory '/oracle' is not owned by root

Successfully accumulated necessary OCR keys.

Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.

node <nodenumber>: <nodename> <private interconnect name> <hostname>

node 1: pub-node1 priv-node1 pub-node1

node 2: pub-node2 priv-node2 pub-node2

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

Now formatting voting device: /dev/rdsk/c3t0d3s6

Format of 1 voting devices complete.

Startup will be queued to init within 30 seconds.

看了一下/tmp的信息，发现有如下错误：

Failure in CSS initialization opening OCR.

查了一会资料，发现可能是因为hostname引起的，因为我当前的hostname是pre1，而我在配置cluster nodes时，写的是pub-node1。解决方法是：

修改hostname为配置cluster nodes时的名称：

hostname pub-node1

重新运行刚才出错的脚本：

bash-3.00# hostname pub-node1

bash-3.00# /oracle/app/product/10.2/crs/root.sh

WARNING: directory '/oracle/app/product/10.2' is not owned by root

WARNING: directory '/oracle/app/product' is not owned by root

WARNING: directory '/oracle/app' is not owned by root

WARNING: directory '/oracle' is not owned by root

Checking to see if Oracle CRS stack is already configured

Setting the permissions on OCR backup directory

Setting up NS directories

Oracle Cluster Registry configuration upgraded successfully

WARNING: directory '/oracle/app/product/10.2' is not owned by root

WARNING: directory '/oracle/app/product' is not owned by root

WARNING: directory '/oracle/app' is not owned by root

WARNING: directory '/oracle' is not owned by root

clscfg: EXISTING configuration version 3 detected.

clscfg: version 3 is 10G Release 2.

Successfully accumulated necessary OCR keys.

Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.

node <nodenumber>: <nodename> <private interconnect name> <hostname>

node 1: pub-node1 priv-node1 pub-node1

node 2: pub-node2 priv-node2 pub-node2

clscfg: Arguments check out successfully.

NO KEYS WERE WRITTEN. Supply -force parameter to override.

-force is destructive and will destroy any previous cluster

configuration.

Oracle Cluster Registry for cluster has already been initialized

Startup will be queued to init within 30 seconds.

Adding daemons to inittab

Expecting the CRS daemons to be up within 600 seconds.

CSS is active on these nodes.

pub-node1

CSS is inactive on these nodes.

pub-node2

Local node checking complete.

Run root.sh on remaining nodes to start CRS daemons.

为了下次重启后仍然生效，修改文件:

/etc/hostname.ce0

/etc/nodename

/etc/inet/ipnodes

把这两个文件的内容中pre1都修改为pub-node1

在其他节点也做类似的操作。

8.2 安装crs时不能修改节点名称

在安装crs时，在节点选择时还是显示之前安装错误时的节点信息，且不能修改节点名称。这是因为没有把之前的crs信息删除干净，把安装crs时的inventory 目录删除就可以

8.3 网络验证不通过

$ ./runcluvfy.sh comp nodecon -n pre1,pre2 -verbose

Verifying node connectivity

ERROR:

User equivalence unavailable on all the nodes.

Verification cannot proceed.

Verification of node connectivity was unsuccessful on all the nodes.

在solaris下很容易遇到这个错误，这是因为Oracle在寻找ssh和scp命令时，去/usr/local/bin目录下寻找，而ssh命令在/usr/bin目录下。

相应的解决方法也很简单，在/usr/local/bin目录下建立一个指向/usr/bin/ssh的链接就可以了。

具体步骤是：

在需要执行cluvfy的节点上执行执行下面步骤：

用root创建链接：

bash-3.00# mkdir -p /usr/local/bin

bash-3.00# ln -s -f /usr/bin/ssh /usr/local/bin/ssh

bash-3.00# ln -s -f /usr/bin/scp /usr/local/bin/scp

在oracle用户下再次添加ssh验证：

$ exec /usr/bin/ssh-agent $SHELL

$ /usr/bin/ssh-add

Identity added: /export/home/oracle/.ssh/id_rsa (/export/home/oracle/.ssh/id_rsa)

Identity added: /export/home/oracle/.ssh/id_dsa (/export/home/oracle/.ssh/id_dsa)

再次执行验证就可以成功了：

bash-3.00$ ./runcluvfy.sh comp nodecon -n pre1,pre2