Interface eth0 checked failed
VMware GSX Server 做RAC实验。
[oracle@rac1 racg]$ cat /etc/redhat-release
Red Hat Enterprise Linux AS release 4 (Nahant Update 6)
[root@rac1 ~]# uname -a
Linux rac1 2.6.9-67.ELsmp #1 SMP Wed Nov 7 13:58:04 EST 2007 i686 i686 i386 GNU/Linux
clusterware 10.2.0.1
oracle 10.2.0.1
[oracle@rac1 ~]$
[oracle@rac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application OFFLINE OFFLINE
ora....C1.lsnr application OFFLINE OFFLINE
ora.rac1.gsd application OFFLINE OFFLINE
ora.rac1.ons application OFFLINE OFFLINE
ora.rac1.vip application OFFLINE OFFLINE
ora....SM2.asm application OFFLINE OFFLINE
ora....C2.lsnr application OFFLINE OFFLINE
ora.rac2.gsd application OFFLINE OFFLINE
ora.rac2.ons application OFFLINE OFFLINE
ora.rac2.vip application OFFLINE OFFLINE
[oracle@rac1 ~]$
[oracle@rac1 ~]$ srvctl start nodeapps -n rac1
rac1:ora.rac1.vip:Interface eth0 checked failed (host=rac1)
rac1:ora.rac1.vip:Invalid parameters, or failed to bring up VIP (host=rac1)
rac1:ora.rac1.vip:Interface eth0 checked failed (host=rac1)
rac1:ora.rac1.vip:Invalid parameters, or failed to bring up VIP (host=rac1)
CRS-0215: Could not start resource 'ora.rac1.LISTENER_RAC1.lsnr'.
[oracle@rac1 ~]$
[oracle@rac1 ~]$
[oracle@rac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application OFFLINE OFFLINE
ora....C1.lsnr application ONLINE OFFLINE
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac2
ora....SM2.asm application OFFLINE OFFLINE
ora....C2.lsnr application OFFLINE OFFLINE
ora.rac2.gsd application OFFLINE OFFLINE
ora.rac2.ons application OFFLINE OFFLINE
ora.rac2.vip application OFFLINE OFFLINE
[oracle@rac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application OFFLINE OFFLINE
ora....C1.lsnr application ONLINE OFFLINE
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE OFFLINE
ora....SM2.asm application OFFLINE OFFLINE
ora....C2.lsnr application OFFLINE OFFLINE
ora.rac2.gsd application OFFLINE OFFLINE
ora.rac2.ons application OFFLINE OFFLINE
ora.rac2.vip application OFFLINE OFFLINE
[oracle@rac1 ~]$
[oracle@rac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application OFFLINE OFFLINE
ora....C1.lsnr application ONLINE OFFLINE
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application OFFLINE OFFLINE
ora....C2.lsnr application OFFLINE OFFLINE
ora.rac2.gsd application OFFLINE OFFLINE
ora.rac2.ons application OFFLINE OFFLINE
ora.rac2.vip application OFFLINE OFFLINE
[oracle@rac1 ~]$ crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
[oracle@rac1 ~]$
不稳定。公网的默认路由一定要加上。如果eth0是公网ip,就将GATEWAY写到eth0里。
加上之后还是不稳定。一会儿就OFFLINE。
[oracle@rac1 ~]$ cd /u01/app/crs102/log/rac1/racg/
[oracle@rac1 racg]$ ll
total 64
-rw-r--r-- 1 oracle oinstall 503 Aug 13 13:30 evtf.log
-rw-r--r-- 1 oracle oinstall 6383 Aug 13 14:11 ora.rac1.ons.log
-rw-r--r-- 1 root root 29628 Aug 13 14:01 ora.rac1.vip.log
-rw-r--r-- 1 root root 5540 Aug 13 13:22 ora.rac2.vip.log
drwxrwxrwt 2 oracle oinstall 4096 Aug 13 11:54 racgeut
drwxrwxrwt 2 oracle oinstall 4096 Aug 13 11:54 racgevtf
drwxrwxrwt 2 oracle oinstall 4096 Aug 13 11:54 racgmain
[oracle@rac1 racg]$ more ora.rac1.vip.log
2012-08-13 13:51:49.767: [ RACG][3086903520] [17640][3086903520][ora.rac1.vip]: clsrcexecut: cmd = /u01/app/crs102/bin/racgeut -e _USR_ORA
_DEBUG=0 54 /u01/app/crs102/bin/racgvip start rac1
2012-08-13 13:51:49.767: [ RACG][3086903520] [17640][3086903520][ora.rac1.vip]: clsrcexecut: rc = 1, time = 9.710s
2012-08-13 13:51:59.431: [ RACG][3086903520] [17640][3086903520][ora.rac1.vip]: Interface eth0 checked failed (host=rac1)
Invalid parameters, or failed to bring up VIP (host=rac1)
2012-08-13 13:51:59.432: [ RACG][3086903520] [17640][3086903520][ora.rac1.vip]: clsrcexecut: env ORACLE_CONFIG_HOME=/u01/app/crs102
2012-08-13 13:51:59.432: [ RACG][3086903520] [17640][3086903520][ora.rac1.vip]: clsrcexecut: cmd = /u01/app/crs102/bin/racgeut -e _USR_ORA
_DEBUG=0 54 /u01/app/crs102/bin/racgvip check rac1
2012-08-13 13:51:59.433: [ RACG][3086903520] [17640][3086903520][ora.rac1.vip]: clsrcexecut: rc = 1, time = 9.660s
2012-08-13 13:51:59.433: [ RACG][3086903520] [17640][3086903520][ora.rac1.vip]: end for resource = ora.rac1.vip, action = start, status =
1, time = 19.490s
2012-08-13 13:52:31.118: [ RACG][3086903520] [18590][3086903520][ora.rac1.vip]: Interface eth0 checked failed (host=rac1)
Invalid parameters, or failed to bring up VIP (host=rac1)
2012-08-13 13:52:31.120: [ RACG][3086903520] [18590][3086903520][ora.rac1.vip]: clsrcexecut: env ORACLE_CONFIG_HOME=/u01/app/crs102
2012-08-13 13:52:31.120: [ RACG][3086903520] [18590][3086903520][ora.rac1.vip]: clsrcexecut: cmd = /u01/app/crs102/bin/racgeut -e _USR_ORA
_DEBUG=0 54 /u01/app/crs102/bin/racgvip start rac1
2012-08-13 13:52:31.120: [ RACG][3086903520] [18590][3086903520][ora.rac1.vip]: clsrcexecut: rc = 1, time = 9.570s
2012-08-13 13:52:40.800: [ RACG][3086903520] [18590][3086903520][ora.rac1.vip]: Interface eth0 checked failed (host=rac1)
Invalid parameters, or failed to bring up VIP (host=rac1)
2012-08-13 13:52:40.903: [ RACG][3086903520] [18590][3086903520][ora.rac1.vip]: clsrcexecut: env ORACLE_CONFIG_HOME=/u01/app/crs102
2012-08-13 13:52:40.904: [ RACG][3086903520] [18590][3086903520][ora.rac1.vip]: clsrcexecut: cmd = /u01/app/crs102/bin/racgeut -e _USR_ORA
_DEBUG=0 54 /u01/app/crs102/bin/racgvip check rac1
2012-08-13 13:52:40.904: [ RACG][3086903520] [18590][3086903520][ora.rac1.vip]: clsrcexecut: rc = 1, time = 9.780s
2012-08-13 13:52:40.905: [ RACG][3086903520] [18590][3086903520][ora.rac1.vip]: end for resource = ora.rac1.vip, action = start, status =
1, time = 19.510s
2012-08-13 13:54:36.511: [ RACG][3086903520] [20974][3086903520][ora.rac1.vip]: Interface eth0 checked failed (host=rac1)
Invalid parameters, or failed to bring up VIP (host=rac1)
2012-08-13 13:54:36.513: [ RACG][3086903520] [20974][3086903520][ora.rac1.vip]: clsrcexecut: env ORACLE_CONFIG_HOME=/u01/app/crs102
2012-08-13 13:54:36.513: [ RACG][3086903520] [20974][3086903520][ora.rac1.vip]: clsrcexecut: cmd = /u01/app/crs102/bin/racgeut -e _USR_ORA
_DEBUG=0 54 /u01/app/crs102/bin/racgvip start rac1
2012-08-13 13:54:36.513: [ RACG][3086903520] [20974][3086903520][ora.rac1.vip]: clsrcexecut: rc = 1, time = 9.530s
2012-08-13 14:01:30.198: [ RACG][3086903520] [28657][3086903520][ora.rac1.vip]: Interface eth0 checked failed (host=rac1)
Invalid parameters, or failed to bring up VIP (host=rac1)
在公网eth0里配置了默认网关,但是没有在实际环境中在网卡上配置这个网关ip,所以ping网关的话ping不通。
[root@rac1 ~]# route
Kernel IP routing table
Destination Gateway Genmask Flags Metric Ref Use Iface
192.168.11.0 * 255.255.255.0 U 0 0 0 eth0
10.1.1.0 * 255.255.255.0 U 0 0 0 eth1
169.254.0.0 * 255.255.0.0 U 0 0 0 eth1
default 192.168.11.254 0.0.0.0 UG 0 0 0 eth0
[root@rac1 ~]#
[root@rac2 ~]# route
Kernel IP routing table
Destination Gateway Genmask Flags Metric Ref Use Iface
192.168.11.0 * 255.255.255.0 U 0 0 0 eth0
10.1.1.0 * 255.255.255.0 U 0 0 0 eth1
169.254.0.0 * 255.255.0.0 U 0 0 0 eth1
default 192.168.11.254 0.0.0.0 UG 0 0 0 eth0
[root@rac2 ~]#
那么给虚拟机的VMware Network Adapter VMnet1 设置ip为192.168.11.254,即网关。
这时在两个节点ping 网关都通,再启动rac,稳定。
此时 [oracle@rac1 racg]$ more ora.rac1.vip.log 如下:
2012-08-13 13:54:36.513: [ RACG][3086903520] [20974][3086903520][ora.rac1.vip]: clsrcexecut: env ORACLE_CONFIG_HOME=/u01/app/crs102
2012-08-13 13:54:36.513: [ RACG][3086903520] [20974][3086903520][ora.rac1.vip]: clsrcexecut: cmd = /u01/app/crs102/bin/racgeut -e _USR_ORA
_DEBUG=0 54 /u01/app/crs102/bin/racgvip start rac1
2012-08-13 13:54:36.513: [ RACG][3086903520] [20974][3086903520][ora.rac1.vip]: clsrcexecut: rc = 1, time = 9.530s
2012-08-13 14:01:30.198: [ RACG][3086903520] [28657][3086903520][ora.rac1.vip]: Interface eth0 checked failed (host=rac1)
Invalid parameters, or failed to bring up VIP (host=rac1)
2012-08-13 14:01:30.216: [ RACG][3086903520] [28657][3086903520][ora.rac1.vip]: clsrcexecut: env ORACLE_CONFIG_HOME=/u01/app/crs102
2012-08-13 14:01:30.216: [ RACG][3086903520] [28657][3086903520][ora.rac1.vip]: clsrcexecut: cmd = /u01/app/crs102/bin/racgeut -e _USR_ORA
_DEBUG=0 54 /u01/app/crs102/bin/racgvip check rac1
2012-08-13 14:01:30.216: [ RACG][3086903520] [28657][3086903520][ora.rac1.vip]: clsrcexecut: rc = 1, time = 6.830s
2012-08-13 14:01:30.216: [ RACG][3086903520] [28657][3086903520][ora.rac1.vip]: end for resource = ora.rac1.vip, action = check, status =
1, time = 7.040s
更多参考:
the specified nodes are not clusterable
根据rowid删除表中重复的行
Agent process exited abnormally during initialization
一次字符乱码的解决过程
rman实验(一)
rman实验(二)
ORA-00600: internal error code, arguments: [keltnf
ORA-00600: ORA-12012 ORA-08102解决
linux下完全删除oracle
INFO: /usr/bin/ld: crt1.o: No such file: No such file or directory
centos4.8_64上安装oracle10201建库报ORA-12547
EM乱码解决
ORA-31613 Master process DM00 failed during startup
ORA-00600: internal error code, arguments: [4194], [29], [27], [], [], [], [], []
ORA-24324 ORA-01041 ORA-03113
centos5.3升级oracle
pdksh-5.2.14-36.el5.i386.rpm
使用rman进行数据库迁移
oracle10.2.0.1升级到10.2.0.4报错
Upgrade Oracle 10g from 10.2.0.1 to 10.2.0.4 (Single Instance)
改oracle的name和dbid
修改oracle实例名
Solaris8上迁移oracle8i---上
Solaris8上迁移oracle8i---下
未备份归档日志导致数据丢失的实验
使用NBU进行数据库迁移
catalog备份数据库
RMAN FORMAT字符串格式化
Error: can not register my instance state - -1
not all alterations performed
The ASM instance configured on the local node is a single-instance ASM
/u01/crs102/bin/crsctl.bin: error while loading shared libraries: libstdc++.so.5: cannot open shared
Initializing the Oracle ASMLib driver: [FAILED]
ORA-00245: control file backup operation failed
WARNING: failed to read mirror side 1 of virtual extent 229 logical extent
模拟恢复参数文件
Interface eth0 checked failed
import server uses ZHS16GBK character set (possible charset conversion)