Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

1

好友

10

主题
1#
发表于 2013-5-9 10:28:14 | 查看: 4966| 回复: 13
安装grid出现这样的问题,ssh等价没问题,防火墙和selinux也关闭了,麻烦各位指教下!

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

报错信息.jpg

2#
发表于 2013-5-9 10:53:30
什么os 都不说, grid 什么版本都不说, 就贴个图

回复 只看该作者 道具 举报

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

回复 只看该作者 道具 举报

4#
发表于 2013-5-9 11:05:12
还是ip配置的问题, 自己用ssh node date +ifconfig 一步步查

回复 只看该作者 道具 举报

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等价性也没问题

回复 只看该作者 道具 举报

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

回复 只看该作者 道具 举报

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.

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

回复 只看该作者 道具 举报

8#
发表于 2013-5-9 20:33:50
/etc/hosts + ifconfig -a

2边的

回复 只看该作者 道具 举报

9#
发表于 2013-5-9 21:29:40
刘大,不好意思,这个环境现在连接不上,明天发给你,谢谢!

回复 只看该作者 道具 举报

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

回复 只看该作者 道具 举报

11#
发表于 2013-5-10 10:30:45
截图里说的是子网 10.0.0.0 , 而实际你没用到 这个网段

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

回复 只看该作者 道具 举报

12#
发表于 2013-5-10 10:55:24
一开始以为是网段的问题,后来我把10.0.0.0这个网段即PRIVIP改为172.30.100.0段的了

回复 只看该作者 道具 举报

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

回复 只看该作者 道具 举报

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



回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-29 00:52 , Processed in 0.055457 second(s), 23 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569