由于网络管理员把所有网络设备做了重启造成rac的虚拟IP发生漂移造成监听程序失效应用连接数据库
从下面的信息可以看到两个节点的vip漂移到另一个节点上使监听offline了
[root@hnzdb2 bin]# ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE hnzdb1
ora....ER.lsnr application ONLINE OFFLINE
ora....B1.lsnr application ONLINE OFFLINE
ora.hnzdb1.gsd application ONLINE ONLINE hnzdb1
ora.hnzdb1.ons application ONLINE ONLINE hnzdb1
ora.hnzdb1.vip application ONLINE ONLINE hnzdb2
ora....SM2.asm application ONLINE ONLINE hnzdb2
ora....ER.lsnr application ONLINE OFFLINE
ora....B2.lsnr application ONLINE OFFLINE
ora.hnzdb2.gsd application ONLINE ONLINE hnzdb2
ora.hnzdb2.ons application ONLINE ONLINE hnzdb2
ora.hnzdb2.vip application ONLINE ONLINE hnzdb1
ora.orcl.db application ONLINE ONLINE hnzdb1
ora....l1.inst application ONLINE ONLINE hnzdb1
ora....l2.inst application ONLINE ONLINE hnzdb2
[root@hnzdb2 bin]# ./crs_start -all
hnzdb1 : CRS-1019: Resource ora.hnzdb2.LISTENER.lsnr (application) cannot run on
hnzdb2 : CRS-1018: Resource ora.hnzdb2.vip (application) is already running on h
hnzdb1 : CRS-1018: Resource ora.hnzdb1.vip (application) is already running on h
hnzdb2 : CRS-1019: Resource ora.hnzdb1.LISTENER.lsnr (application) cannot run on
hnzdb1 : CRS-1019: Resource ora.hnzdb2.LISTENER_HNZDB2.lsnr (application) cannot
hnzdb2 : CRS-1018: Resource ora.hnzdb2.vip (application) is already running on h
hnzdb1 : CRS-1018: Resource ora.hnzdb1.vip (application) is already running on h
hnzdb2 : CRS-1019: Resource ora.hnzdb1.LISTENER_HNZDB1.lsnr (application) cannot
CRS-0223: Resource 'ora.hnzdb1.LISTENER.lsnr' has placement error.
CRS-0223: Resource 'ora.hnzdb1.LISTENER_HNZDB1.lsnr' has placement error.
CRS-0223: Resource 'ora.hnzdb2.LISTENER.lsnr' has placement error.
CRS-0223: Resource 'ora.hnzdb2.LISTENER_HNZDB2.lsnr' has placement error.
[root@hnzdb2 bin]# ./crs_stop -all
Attempting to stop `ora.hnzdb2.gsd` on member `hnzdb2`
Attempting to stop `ora.hnzdb2.ons` on member `hnzdb2`
Stop of `ora.hnzdb2.gsd` on member `hnzdb2` succeeded.
Attempting to stop `ora.hnzdb1.gsd` on member `hnzdb1`
Attempting to stop `ora.orcl.db` on member `hnzdb1`
Attempting to stop `ora.hnzdb1.ons` on member `hnzdb1`
Stop of `ora.hnzdb2.ons` on member `hnzdb2` succeeded.
Stop of `ora.hnzdb1.gsd` on member `hnzdb1` succeeded.
Stop of `ora.hnzdb1.ons` on member `hnzdb1` succeeded.
^[Stop of `ora.orcl.db` on member `hnzdb1` succeeded.
`ora.orcl.orcl1.inst` is already OFFLINE.
`ora.orcl.orcl2.inst` is already OFFLINE.
Attempting to stop `ora.hnzdb2.ASM2.asm` on member `hnzdb2`
Target set to OFFLINE for `ora.hnzdb2.LISTENER_HNZDB2.lsnr`
Target set to OFFLINE for `ora.hnzdb1.LISTENER_HNZDB1.lsnr`
Attempting to stop `ora.hnzdb1.ASM1.asm` on member `hnzdb1`
Target set to OFFLINE for `ora.hnzdb2.LISTENER.lsnr`
Attempting to stop `ora.hnzdb2.vip` on member `hnzdb1`
Target set to OFFLINE for `ora.hnzdb1.LISTENER.lsnr`
Attempting to stop `ora.hnzdb1.vip` on member `hnzdb2`
Stop of `ora.hnzdb2.vip` on member `hnzdb1` succeeded.
Stop of `ora.hnzdb1.vip` on member `hnzdb2` succeeded.
[root@hnzdb2 bin]# ./crs_start -all
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26015009/viewspace-766961/，如需转载，请注明出处，否则将追究法律责任。