Oracle 11g RAC INS-06006 Passwordless SSH connectivity not set up between the following node(s) 解决方法

 

1.Public-IP和VIP是否同在一个主网内。

2.grid用户的密码确保正确和存在。

3.添加节点时,严格区分大小写。

4.一般用grid用户安装grid软件。

5.可能是BUG,看后面内容。


一.问题描述

  在VBox 上安装Oracle 11.2.0.1 的RAC, 在SSH 配置时报错:

  INS-06006: Passwordless SSHconnectivity not set up between the following node(s)

  798x597

  注意:

  这里奇怪的表现是我们setup是成功,仅仅是Test 失败。

二.测试一

  尝试在2个节点手工的执行测试命令:

  [oracle@rac1 ~]$ ssh rac2 date

  Tue Jun 26 19:48:01 CST 2012

  [oracle@rac1 ~]$ ssh rac1 date

  Tue Jun 26 19:48:11 CST 2012

  [oracle@rac2 ~]$ ssh rac1 date

  Tue Jun 26 19:48:27 CST 2012

  [oracle@rac2 ~]$ ssh rac2 date

  Tue Jun 26 19:48:30 CST 2012

  SSH 是正常的,也就是说我们这里的配置是有效的,只是显示为失败,但是这里通不过,安装是继续不了的。

三.测试三

  SSH的配置,在Oracle 10g的RAC 里是需要手工配置的,在11g里可以在OUI中自动配置。

  手工配置参考:

  Redhat 5.4 +ASM + RAW+ Oracle 10g RAC 安装文档

  尝试手工移除SSH的相关配置文件:

  [oracle@rac1 ~]$ cd $HOME/.ssh

  [oracle@rac1 .ssh]$ pwd

  /home/oracle/.ssh

  [oracle@rac1 .ssh]$ ll

  total 100

  -rw-r--r--. 1 oracle oinstall  8542 Jun 26 19:46 authorized_keys

  -rw-------. 1 oracle oinstall   667 Nov 22 2011 authorized_keys2

  -rw-r--r-- 1 oracle oinstall  7879 Jun 2619:46 authorized_keys.ri.bak

  -rw-r--r-- 1 oracle oinstall    22 Jun 2619:46 config

  -rw-r--r-- 1 oracle oinstall    22 Jun 2619:33 config.ri.bak

  -rw-------. 1 oracle oinstall   887 Jun 26 19:46 identity

  -rw-r--r--. 1 oracle oinstall   221 Jun 26 19:46 identity.pub

  -rw------- 1 oracle oinstall   887 Jun 2619:46 id_rsa

  -rw-r--r-- 1 oracle oinstall   221 Jun 2619:46 id_rsa.pub

  -rw-r--r-- 1 oracle oinstall   221 Jun 2619:34 id_rsa.pub.ri.bak

  -rw------- 1 oracle oinstall   887 Jun 2619:34 id_rsa.ri.bak

  -rw-r--r--. 1 oracle oinstall 20981 Jun 2619:49 known_hosts

  -rw-r--r-- 1 oracle oinstall 14248 Jun 26 19:34 known_hosts.ri.bak

  [oracle@rac1 .ssh]$ rm -rf *

  [oracle@rac2 ~]$ cd $HOME/.ssh

  [oracle@rac2 .ssh]$ ll

  total 68

  -rw-r--r--. 1 oracle oinstall  8542 Jun 26 19:46 authorized_keys

  -rw-------. 1 oracle oinstall   667 Nov 22 2011 authorized_keys2

  -rw-r--r-- 1 oracle oinstall  7658 Jun 2619:42 authorized_keys.ri.bak

  -rw-------. 1 oracle oinstall   883 Jun 26 19:46 identity

  -rw-r--r--. 1 oracle oinstall   221 Jun 26 19:46 identity.pub

  -rw------- 1 oracle oinstall   883 Jun 2619:46 id_rsa

  -rw-r--r-- 1 oracle oinstall   221 Jun 2619:46 id_rsa.pub

  -rw-r--r--. 1 oracle oinstall 20981 Jun 2619:49 known_hosts

  [oracle@rac2 .ssh]$ rm -rf *

  再次SSH,还是同样的错误。

四.测试四

  在MOS上搜了一下,有一篇文章:

  TOP Note: Solutions for Typical 11gR2 GridInfrastructure/RAC Database runInstaller Issues [ID 1056713.1]

  里面对这个问题的说明:

  [INS-06006]Passwordless SSH connectivity not set up between the following node(s): [node1,node2]. CVU may reports "PRVF-4007 : User equivalence check failed foruser "user"" for same error

  可能的原因:

  (1)    Grid user does not havepassword on OS level, the fix is to set password with "passwd"command.

  (2)    If OUI is able to setuppasswordless SSH connectivity but still shows the error, likely"ping" command is inaccessible - grid user should be able to executeping command.

  (3)    OS command ssh or scp are notin expected location, the workaround is to either create symbolic link on allnodes or export the following environment variables before starting OUI

  ln -s /usr/local/bin/ssh /usr/bin/ssh
ln -s /usr/local/bin/scp /usr/bin/scp

OR

export ORACLE_SRVM_REMOTESHELL=/usr/local/bin/ssh
export ORACLE_SRVM_REMOTECOPY=/usr/local/bin/ssh

Note: /usr/local/bin is the location for ssh and scp, if ssh and scp arelocated in somewhere else, replace it accordingly

五.测试五

  我这里的问题和MOS上说的不一样,第一我们在新开的ssh窗口测试,是正常的,仅仅在安装窗口不能测试通过。

  我安装之前仅仅修改了一下环境变量,即修改了/home/oracle/.bash_profile文件,所以尝试source了一下,并重新登陆,来进行安装:

  [oracle@rac1 ~]$ source ~/.bash_profile

  796x596

这次验证通过,由此可见,环境变量的问题也会导致 INS-06006 的错误出现。

+=====================================================================+

升级Grid Infrastructure时遭遇[INS-06006] Passwordless SSH connectivity not set up between the following node(s)错误,如下图:

一、环境说明:
DB版本:Oracle 11.2.0.4 
OS版本:Redhat 6.4
二、处理方法
1、使用ssh验证等效性
[grid@jzh03 ~]$ date;ssh jzh03 date
Wed Dec 10 17:06:23 CST 2014
Wed Dec 10 17:06:24 CST 2014
 
[grid@jzh03 ~]$ date;ssh jzh04 date
Wed Dec 10 17:06:51 CST 2014
Wed Dec 10 17:06:51 CST 2014
结果依然报错。
2、修改grid用户密码
[root@jzh03 Desktop]# passwd grid
Changing password for user grid.
New password:
BAD PASSWORD: it is too short
BAD PASSWORD: is too simple
Retype new password:
passwd: all authentication tokens updated successfully.
结果依然报错。
3、修改.ssh目录
[root@jzh03 grid]# chmod 700 .ssh
[root@jzh03 grid]# ls -la
total 44
drwxr-xr-x  5 grid oinstall 4096 Dec 11 10:48 .
drwxr-xr-x. 4 root root     4096 Dec 11 10:21 ..
-rw-------  1 grid oinstall   66 Dec 11 10:59 .bash_history
-rw-r--r--  1 grid oinstall   18 Aug 29  2012 .bash_logout
-rw-r--r--  1 grid oinstall  472 Dec 11 10:37 .bash_profile
-rw-r--r--  1 grid oinstall  124 Aug 29  2012 .bashrc
drwxr-xr-x  2 grid oinstall 4096 Jul 14  2010 .gnome2
-rw-r--r--  1 grid oinstall  124 Jun 28  2011 .mkshrc
drwxr-xr-x  4 grid oinstall 4096 Nov 13 06:37 .mozilla
drwx------  2 grid oinstall 4096 Dec 11 10:55 .ssh
-rw-------  1 grid oinstall  646 Dec 11 10:37 .viminfo
结果依然报错。
4、删除手工配置的ssh,采用grid infrastructure配置--->依然报错。
5、上MOS查找相关文章,发现11.2.0.4 runInstaller: [INS-06006] Passwordless SSH connectivity not set up between the following nodes(s) (文档 ID 1597212.1),描述如下:
Installing 11.2.0.4 Grid Infrastructure patch set, runInstaller reports error: [INS-06006] Passwordless SSH connectivity not set up between the following nodes(s): [racnode1].

  • installActions.log 

INFO: Preparing to check passwordless SSH Connectivity between nodes: [RACNODE1, RACNODE2]                               ====>> "hostname" command returns upper case hostname
INFO: Testing passwordless SSH connectivity between the selected nodes. This may take several minutes, please wait...
INFO: OverallStatus of User Equivalence check using CVU is SUCCESSFUL
FINEST: oracle.install.driver.oui.OUISSHSupportManager:Checking whether RACNODE1 is a local node or not. 
FINEST: oracle.install.driver.oui.OUISSHSupportManager:Identified RACNODE1 as the local node.
INFO: Finding passwordless SSH connectivity setup on remote nodes
INFO: Preparing remote commands to check passwordless SSH connectivity setup on remote nodes
INFO: Total number of remote commands to be executed is 4
WARNING: Failed while executing remote commands to check SSH connectivity to other nodes..
Refer associated stacktrace #oracle.install.driver.oui.OUISSHSupportManager:964
INFO: Source Node: racnode1 Target Node: racnode1
INFO: Exception: null
INFO: Status log: oracle.install.driver.oui.OUISSHSupportManager$SSHSetupVerificationCommand: 0|ssh: Could not resolve hostname -o FallBackToRsh=no : Temporary failure in name resolution :failed

....

INFO: Remote node(s) not configured for passwordless SSH connectivity : [racnode1]
INFO: Details about the list of remote node(s), not configured for passwordless SSH connectivity
---------------------------------
NODE REMOTE NODES 
---------------------------------
racnode1 [racnode1, racnode2]                       ====>> converted to lower case in the code
---------------------------------

 

  • oraInstall.err 

---# Begin Stacktrace #---------------------------
ID: oracle.install.driver.oui.OUISSHSupportManager:569
oracle.ops.mgmt.cluster.ClusterException: ssh: -o FallBackToRsh=no : Name or service not known :failedssh: -o FallBackToRsh=no : Name or service not known :failed :successful :successful
at oracle.ops.mgmt.cluster.ClusterConfig.submit(ClusterConfig.java:578)
at oracle.ops.mgmt.cluster.ClusterCmd.submit(ClusterCmd.java:269)
at oracle.ops.mgmt.cluster.ClusterCmd.submit(ClusterCmd.java:294)
at oracle.install.driver.oui.OUISSHSupportManager.getUnconfiguredRemoteNodes(OUISSHSupportManager.java:428)
at oracle.install.driver.oui.OUISSHSupportManager.getSSHConnectivityDetails(OUISSHSupportManager.java:378)
at oracle.install.commons.net.support.SSHSupportManager.getSSHConnectivityDetails(SSHSupportManager.java:181)
at oracle.install.ivw.common.view.SSHSetupPane$8.perform(SSHSetupPane.java:305)
at oracle.install.ivw.common.view.SSHSetupPane$SSHOperation.run(SSHSetupPane.java:336)

---# End Stacktrace #-----------------------------

  • hostname is in mixed case (in this example upper case)

grep RACNODE /etc/hosts
10.0.0.101 RACNODE1.US.ORACLE.COM RACNODE1
10.0.0.102 RACNODE2.US.ORACLE.COM RACNODE2

The bug is fixed in 12.1.0.2

The workaround is to either allow OUI or manually (note 300548.1) setup ssh user equivalence for the installing user, then in command line window, ensure ssh doesn't prompt for password for both real hostname and lower case hostname. 

For example:

$ ssh RACNODE1 date                    ====>> real hostname for node1
Fri Nov 8 10:01:03 PST 2013      
$ ssh racnode1 date                    ====>> lower case hostname for node1
Fri Nov 8 10:01:04 PST 2013
$ ssh RACNODE2 date
Fri Nov 8 10:01:05 PST 2013
$ ssh racnode2 date
Fri Nov 8 10:01:06 PST 2013

 

In the case of upgrade, the alternate workaround is to update inventory to set to lower case nodename instead of real hostname:

$ /oui/bin/runInstaller -updateNodelist ORACLE_HOME= "CLUSTER_NODES={racnode1,racnode2}" CRS=true

Note in above command it's racnode1,racnode2 in lower case despite the hostname is upper case. 

原来是个bug,想不到第一次安装11.2.0.4就遇到bug,将主机名全部改为小写之后就顺利安装成功了。