Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › ORACLE 11GR2 RAC

zyo_320

0 积分	1 好友	10 主题

发消息

[常规管理] ORACLE 11GR2 RAC

1^#

发表于 2013-5-9 10:28:14 | 查看: 4881| 回复: 13

安装grid出现这样的问题，ssh等价没问题，防火墙和selinux也关闭了，麻烦各位指教下！

报错信息.jpg (72.74 KB, 下载次数: 369)

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2013-5-9 10:53:30

什么os 都不说， grid 什么版本都不说，就贴个图

回复只看该作者道具举报

zyo_320

3^#

发表于 2013-5-9 11:02:21

Maclean Liu(刘相兵发表于 2013-5-9 10:53
什么os 都不说， grid 什么版本都不说，就贴个图

呵呵 sorry！ OS RHEL 6.3 grid 11.2.0.3

回复只看该作者道具举报

Maclean Liu(刘相兵

4^#

发表于 2013-5-9 11:05:12

还是ip配置的问题，自己用ssh node date +ifconfig 一步步查

回复只看该作者道具举报

zyo_320

5^#

发表于 2013-5-9 11:08:39

节点1上：
[grid@afis-svr03 grid]$ ssh afis-svr03 date
Thu May  9 11:06:36 CST 2013
[grid@afis-svr03 grid]$ ssh afis-svr04 date
Thu May  9 11:07:07 CST 2013
[grid@afis-svr03 grid]$ ssh afis-svr04-priv date
Thu May  9 11:07:11 CST 2013
[grid@afis-svr03 grid]$ ssh afis-svr03-priv date
Thu May  9 11:06:47 CST 2013

节点2上：
[grid@afis-svr04 grid]$ ssh afis-svr03 date
Thu May  9 11:07:13 CST 2013
[grid@afis-svr04 grid]$ ssh afis-svr04 date
Thu May  9 11:07:44 CST 2013
[grid@afis-svr04 grid]$ ssh afis-svr04-priv date
Thu May  9 11:07:54 CST 2013
[grid@afis-svr04 grid]$ ssh afis-svr03-priv date
Thu May  9 11:07:31 CST 2013
网络之间能ping通，ssh等价性也没问题

回复只看该作者道具举报

zyo_320

6^#

发表于 2013-5-9 11:10:55

eth0配置：public
DEVICE=em1
BOOTPROTO=none
NM_CONTROLLED=yes
ONBOOT=yes
TYPE=Ethernet
UUID="2770df7d-b8c7-4857-91ec-465cfc014a13"
IPADDR=192.168.1.8
PREFIX=24
GATEWAY=192.168.1.1
DEFROUTE=yes
IPV4_FAILURE_FATAL=yes
IPV6INIT=no
NAME="System em1"
DNS1=192.168.1.1
NETMASK=255.255.255.0
USERCTL=no
HWADDR=90:B1:1C:3E:19:7F
LAST_CONNECT=1363949298

eth2配置： private
DEVICE=em3
BOOTPROTO=none
HWADDR=90:B1:1C:3E:19:81
NM_CONTROLLED=yes
ONBOOT=yes
TYPE=Ethernet
UUID="dd6d9c6c-eace-4602-818c-9f582db73df8"
IPV6INIT=no
USERCTL=no
IPADDR=10.0.0.2
PREFIX=24
GATEWAY=10.0.0.254
DEFROUTE=yes
IPV4_FAILURE_FATAL=yes
NAME="System em3"
DNS1=10.0.0.254
NETMASK=255.255.255.0

回复只看该作者道具举报

zyo_320

7^#

发表于 2013-5-9 17:44:19

系统RHEL6.3  GRID 11.2.0.3  环境两台服务器，其中一台装有VBOX虚拟软件，软件中装有openfiler做共享存储，现在节点1执行CUV ，网络报错：

Interface information for node "afis-svr04"
Name IP Address    Subnet       Gateway       Def. Gateway HW Address       MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
em1 192.168.1.9    192.168.1.0    0.0.0.0       192.168.1.1    90:B1:1C:3D:C1:2B 1500
em3 172.30.100.4 172.30.100.0 0.0.0.0       192.168.1.1    90:B1:1C:3D:C1:2D 1500

Interface information for node "afis-svr03"
Name IP Address    Subnet       Gateway       Def. Gateway HW Address       MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
em1 192.168.1.8    192.168.1.0    0.0.0.0       192.168.1.1    90:B1:1C:3E:19:7F 1500
em3 172.30.100.2 172.30.100.0 0.0.0.0       192.168.1.1    90:B1:1C:3E:19:81 1500

Check: Node connectivity for interface "em1"

WARNING:
Make sure IP address "em1 : 192.168.1.9 [192.168.1.0] " is up and is a valid IP address on node "afis-svr04"

WARNING:
Make sure IP address "em1 : 192.168.1.8 [192.168.1.0] " is up and is a valid IP address on node "afis-svr03"
  Source                         Destination                   Connected?
  ------------------------------  ------------------------------  ----------------
  afis-svr04[192.168.1.9]       afis-svr03[192.168.1.8]       no

ERROR:
PRVF-7616 : Node connectivity failed for subnet "192.168.1.0" between "afis-svr04 - em1 : 192.168.1.9" and "afis-svr03 - em1 : 192.168.1.8"
Result: Node connectivity failed for interface "em1"

Check: TCP connectivity of subnet "192.168.1.0"
  Source                         Destination                   Connected?
  ------------------------------  ------------------------------  ----------------
  afis-svr03:192.168.1.8       afis-svr04:192.168.1.9       passed
Result: TCP connectivity check passed for subnet "192.168.1.0"

Check: Node connectivity for interface "em3"

WARNING:
Make sure IP address "em3 : 172.30.100.4 [172.30.100.0] " is up and is a valid IP address on node "afis-svr04"

WARNING:
Make sure IP address "em3 : 172.30.100.2 [172.30.100.0] " is up and is a valid IP address on node "afis-svr03"
  Source                         Destination                   Connected?
  ------------------------------  ------------------------------  ----------------
  afis-svr04[172.30.100.4]       afis-svr03[172.30.100.2]       no

ERROR:
PRVF-7616 : Node connectivity failed for subnet "172.30.100.0" between "afis-svr04 - em3 : 172.30.100.4" and "afis-svr03 - em3 : 172.30.100.2"
Result: Node connectivity failed for interface "em3"

Check: TCP connectivity of subnet "172.30.100.0"
  Source                         Destination                   Connected?
  ------------------------------  ------------------------------  ----------------
  afis-svr03:172.30.100.2       afis-svr04:172.30.100.4       passed
Result: TCP connectivity check passed for subnet "172.30.100.0"

Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "192.168.1.0".
Subnet mask consistency check passed for subnet "172.30.100.0".
Subnet mask consistency check passed.

Result: Node connectivity check failed

Checking multicast communication...

Checking subnet "192.168.1.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.1.0" for multicast communication with multicast group "230.0.1.0" passed.

Checking subnet "172.30.100.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "172.30.100.0" for multicast communication with multicast group "230.0.1.0" passed.

Check of multicast communication passed.

节点2执行：
[grid@afis-svr04 grid]$ ./runcluvfy.sh stage -pre crsinst -n afis-svr03,afis-svr04 -networks "em*" -verbose

Performing pre-checks for cluster services setup

Checking node reachability...
Unable to reach any of the nodes

ERROR:
Unable to reach any of the nodes
Verification cannot proceed

Pre-check for cluster services setup was unsuccessful on all the nodes.

还请刘大，指导下，上午建议的我都看了还是没能查出问题，网上也有查相关资料，能力有限还请刘大指教下再！

回复只看该作者道具举报

Maclean Liu(刘相兵

8^#

发表于 2013-5-9 20:33:50

/etc/hosts + ifconfig -a

2边的

回复只看该作者道具举报

zyo_320

9^#

发表于 2013-5-9 21:29:40

刘大，不好意思，这个环境现在连接不上，明天发给你，谢谢！

回复只看该作者道具举报

zyo_320

10^#

发表于 2013-5-10 09:02:31

节点1：
[root@afis-svr03 ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain

192.168.1.8 afis-svr03
172.30.100.2    afis-svr03-priv

192.168.1.9 afis-svr04
172.30.100.4    afis-svr04-priv

192.168.1.10 afis-svr03-vip
192.168.1.11 afis-svr04-vip

192.168.1.12 rac-cluster

[root@afis-svr03 ~]# ifconfig -a
em1    Link encap:Ethernet  HWaddr 90:B1:1C:3E:19:7F
      inet addr:192.168.1.8  Bcast:192.168.1.255  Mask:255.255.255.0
      inet6 addr: fe80::92b1:1cff:fe3e:197f/64 Scope:Link
      UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
      RX packets:906137 errors:0 dropped:0 overruns:0 frame:0
      TX packets:1033981 errors:0 dropped:0 overruns:0 carrier:0
      collisions:0 txqueuelen:1000
      RX bytes:311027447 (296.6 MiB)  TX bytes:414170142 (394.9 MiB)
      Interrupt:35

em2    Link encap:Ethernet  HWaddr 90:B1:1C:3E:19:80
      inet6 addr: fe80::92b1:1cff:fe3e:1980/64 Scope:Link
      UP BROADCAST MULTICAST  MTU:1500  Metric:1
      RX packets:485 errors:0 dropped:0 overruns:0 frame:0
      TX packets:19 errors:0 dropped:0 overruns:0 carrier:0
      collisions:0 txqueuelen:1000
      RX bytes:46908 (45.8 KiB)  TX bytes:4520 (4.4 KiB)
      Interrupt:38

em3    Link encap:Ethernet  HWaddr 90:B1:1C:3E:19:81
      inet addr:172.30.100.2  Bcast:172.30.100.255  Mask:255.255.255.0
      inet6 addr: fe80::92b1:1cff:fe3e:1981/64 Scope:Link
      UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
      RX packets:28823 errors:4 dropped:0 overruns:0 frame:0
      TX packets:8936 errors:0 dropped:0 overruns:0 carrier:0
      collisions:0 txqueuelen:1000
      RX bytes:2958915 (2.8 MiB)  TX bytes:866737 (846.4 KiB)
      Interrupt:34

em4    Link encap:Ethernet  HWaddr 90:B1:1C:3E:19:82
      UP BROADCAST MULTICAST  MTU:1500  Metric:1
      RX packets:0 errors:0 dropped:0 overruns:0 frame:0
      TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
      collisions:0 txqueuelen:1000
      RX bytes:0 (0.0 b)  TX bytes:0 (0.0 b)
      Interrupt:36

节点2：
[root@afis-svr04 ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain

192.168.1.8 afis-svr03
172.30.100.2    afis-svr03-priv

192.168.1.9 afis-svr04
172.30.100.4    afis-svr04-priv

192.168.1.10 afis-svr03-vip
192.168.1.11 afis-svr04-vip

192.168.1.12 rac-cluster

[root@afis-svr04 ~]# ifconfig -a
em1    Link encap:Ethernet  HWaddr 90:B1:1C:3D:C1:2B
      inet addr:192.168.1.9  Bcast:192.168.1.255  Mask:255.255.255.0
      inet6 addr: fe80::92b1:1cff:fe3d:c12b/64 Scope:Link
      UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
      RX packets:822314 errors:0 dropped:0 overruns:0 frame:0
      TX packets:535761 errors:0 dropped:0 overruns:0 carrier:0
      collisions:0 txqueuelen:1000
      RX bytes:86571361 (82.5 MiB)  TX bytes:324670571 (309.6 MiB)
      Interrupt:35

em2    Link encap:Ethernet  HWaddr 90:B1:1C:3D:C1:2C
      inet6 addr: fe80::92b1:1cff:fe3d:c12c/64 Scope:Link
      UP BROADCAST MULTICAST  MTU:1500  Metric:1
      RX packets:440 errors:0 dropped:0 overruns:0 frame:0
      TX packets:19 errors:0 dropped:0 overruns:0 carrier:0
      collisions:0 txqueuelen:1000
      RX bytes:38503 (37.6 KiB)  TX bytes:4520 (4.4 KiB)
      Interrupt:38

em3    Link encap:Ethernet  HWaddr 90:B1:1C:3D:C1:2D
      inet addr:172.30.100.4  Bcast:172.30.100.255  Mask:255.255.255.0
      inet6 addr: fe80::92b1:1cff:fe3d:c12d/64 Scope:Link
      UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
      RX packets:28578 errors:0 dropped:0 overruns:0 frame:0
      TX packets:13092 errors:0 dropped:0 overruns:0 carrier:0
      collisions:0 txqueuelen:1000
      RX bytes:2959668 (2.8 MiB)  TX bytes:1247205 (1.1 MiB)
      Interrupt:34

em4    Link encap:Ethernet  HWaddr 90:B1:1C:3D:C1:2E
      UP BROADCAST MULTICAST  MTU:1500  Metric:1
      RX packets:0 errors:0 dropped:0 overruns:0 frame:0
      TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
      collisions:0 txqueuelen:1000
      RX bytes:0 (0.0 b)  TX bytes:0 (0.0 b)
      Interrupt:36

回复只看该作者道具举报

Maclean Liu(刘相兵

11^#

发表于 2013-5-10 10:30:45

截图里说的是子网 10.0.0.0 ，而实际你没用到这个网段

说明是GRID 安装配置过程中可能你点错了东西。

回复只看该作者道具举报

zyo_320

12^#

发表于 2013-5-10 10:55:24

一开始以为是网段的问题，后来我把10.0.0.0这个网段即PRIVIP改为172.30.100.0段的了

回复只看该作者道具举报

zyo_320

13^#

发表于 2013-5-10 17:11:19

[root@rac02 ~]# /home/opt/oraInventory/orainstRoot.sh
Changing permissions of /home/opt/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /home/opt/oraInventory to oinstall.
The execution of the script is complete.
[root@rac02 ~]# /home/opt/11.2.0/grid/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /home/opt/11.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /home/opt/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
Failed to create keys in the OLR, rc = 127, Message:
/home/opt/11.2.0/grid/bin/clscfg.bin: error while loading shared libraries: libcap.so.1: cannot open shared object file: No such file or directory

Failed to create keys in the OLR at /home/opt/11.2.0/grid/crs/install/crsconfig_lib.pm line 7497.
/home/opt/11.2.0/grid/perl/bin/perl -I/home/opt/11.2.0/grid/perl/lib -I/home/opt/11.2.0/grid/crs/install /home/opt/11.2.0/grid/crs/install/rootcrs.pl execution failed

回复只看该作者道具举报

harryzhang

14^#

发表于 2013-5-12 20:09:23

既然是6.X的系统。那么

[root@db5 lib]# /u01/app/grid/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/grid/crs/install/crsconfig_params
User ignored Prerequisites during installation
Failed to create keys in the OLR, rc = 127, Message:
/u01/app/grid/bin/clscfg.bin: error while loading shared libraries: libcap.so.1: cannot open shared object file: No such file or directory

Failed to create keys in the OLR at /u01/app/grid/crs/install/crsconfig_lib.pm line 7497.
/u01/app/grid/perl/bin/perl -I/u01/app/grid/perl/lib -I/u01/app/grid/crs/install /u01/app/grid/crs/install/rootcrs.pl execution failed

解决方法：[root@db6 lib64]# ln -s libcap.so.2.16 libcap.so.1

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册