ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 网络设备重启造成rac监听故障连接数据库报ora-12170:TNS:连接超时的错误

网络设备重启造成rac监听故障连接数据库报ora-12170:TNS:连接超时的错误

原创 Linux操作系统 作者:eric0435 时间:2013-07-24 09:06:07 0 删除 编辑
由于网络管理员把所有网络设备做了重启造成rac的虚拟IP发生漂移造成监听程序失效应用连接数据库
时报ora-12170:TNS:连接超时的错误
从下面的信息可以看到两个节点的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


尝试重启所有服务报虚拟ip漂移的错误信息

[root@hnzdb2 bin]# ./crs_start -all
hnzdb1 : CRS-1019: Resource ora.hnzdb2.LISTENER.lsnr (application) cannot run on
 hnzdb1
hnzdb2 : CRS-1018: Resource ora.hnzdb2.vip (application) is already running on h
nzdb1

hnzdb1 : CRS-1018: Resource ora.hnzdb1.vip (application) is already running on h
nzdb2
hnzdb2 : CRS-1019: Resource ora.hnzdb1.LISTENER.lsnr (application) cannot run on
 hnzdb2

hnzdb1 : CRS-1019: Resource ora.hnzdb2.LISTENER_HNZDB2.lsnr (application) cannot
 run on hnzdb1
hnzdb2 : CRS-1018: Resource ora.hnzdb2.vip (application) is already running on h
nzdb1

hnzdb1 : CRS-1018: Resource ora.hnzdb1.vip (application) is already running on h
nzdb2
hnzdb2 : CRS-1019: Resource ora.hnzdb1.LISTENER_HNZDB1.lsnr (application) cannot
 run on hnzdb2

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
系统架构师,ACOUG MEMBER,Oracle ACE,Mail:yongjing.star@gmail.com Mobile:13875984558 QQ:409898894 Blog:www.jydba.net

注册时间:2011-10-12

  • 博文量
    538
  • 访问量
    6187025