rac中 ora.bc2.srv offline 怎么办
答案:2 悬赏:50 手机版
解决时间 2021-02-09 20:40
- 提问者网友:浮克旳回音
- 2021-02-09 15:53
rac中 ora.bc2.srv offline 怎么办
最佳答案
- 五星知识达人网友:蓝房子
- 2021-02-09 16:53
关于RAC节点服务ora.rac2.gsd的offline问题解决方法
我没有时间去测试,先记录下来。当看到bolg时,会想起这回事。去测试一下
模拟节点故障时,rac2的vip顠到了rac1,CRS重构后,rac2重新启动.发现如下情况:
[oracle@rac2 bin]$ ./crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....C1.inst application 0/5 0/0 ONLINE ONLINE rac1
ora....C2.inst application 0/5 0/0 ONLINE ONLINE rac2
ora.RAC.db application 0/1 0/1 ONLINE ONLINE rac2
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac1
ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1
ora.rac1.vip application 0/0 0/0 ONLINE ONLINE rac1
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE rac2
ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2
ora.rac2.gsd application 0/5 0/0 ONLINE OFFLINE
ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2
ora.rac2.vip application 0/0 0/0 ONLINE ONLINE rac2
检查节点一:
[oracle@rac2 bin]$ ./srvctl status nodeapps -n rac1
VIP is running on node: rac1
GSD is running on node: rac1
Listener is running on node: rac1
ONS daemon is running on node: rac1
检查节点二:
[oracle@rac2 bin]$ ./srvctl status nodeapps -n rac2
VIP is running on node: rac2
GSD is not running on node: rac2
Listener is running on node: rac2
ONS daemon is running on node: rac2
手工重启服务:
[oracle@rac2 bin]$ ./srvctl start nodeapps -n rac2
再次检查如下:
[oracle@rac2 bin]$ ./srvctl status nodeapps -n rac2
VIP is running on node: rac2
GSD is running on node: rac2
Listener is running on node: rac2
ONS daemon is running on node: rac2
这时候,服务一切正常:
[oracle@rac2 bin]$ ./crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....C1.inst application 0/5 0/0 ONLINE ONLINE rac1
ora....C2.inst application 0/5 0/0 ONLINE ONLINE rac2
ora.RAC.db application 0/1 0/1 ONLINE ONLINE rac2
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac1
ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1
ora.rac1.vip application 0/0 0/0 ONLINE ONLINE rac1
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE rac2
ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2
ora.rac2.gsd application 0/5 0/0 ONLINE ONLINE rac2
ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2
ora.rac2.vip application 0/0 0/0 ONLINE ONLINE rac2
请采纳
如果你认可我的回答,敬请及时采纳,
~如果你认可我的回答,请及时点击【采纳为满意回答】按钮
~~手机提问的朋友在客户端右上角评价点【满意】即可。
~你的采纳是我前进的动力
~~O(∩_∩)O,记得好评和采纳,互相帮助
我没有时间去测试,先记录下来。当看到bolg时,会想起这回事。去测试一下
模拟节点故障时,rac2的vip顠到了rac1,CRS重构后,rac2重新启动.发现如下情况:
[oracle@rac2 bin]$ ./crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....C1.inst application 0/5 0/0 ONLINE ONLINE rac1
ora....C2.inst application 0/5 0/0 ONLINE ONLINE rac2
ora.RAC.db application 0/1 0/1 ONLINE ONLINE rac2
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac1
ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1
ora.rac1.vip application 0/0 0/0 ONLINE ONLINE rac1
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE rac2
ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2
ora.rac2.gsd application 0/5 0/0 ONLINE OFFLINE
ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2
ora.rac2.vip application 0/0 0/0 ONLINE ONLINE rac2
检查节点一:
[oracle@rac2 bin]$ ./srvctl status nodeapps -n rac1
VIP is running on node: rac1
GSD is running on node: rac1
Listener is running on node: rac1
ONS daemon is running on node: rac1
检查节点二:
[oracle@rac2 bin]$ ./srvctl status nodeapps -n rac2
VIP is running on node: rac2
GSD is not running on node: rac2
Listener is running on node: rac2
ONS daemon is running on node: rac2
手工重启服务:
[oracle@rac2 bin]$ ./srvctl start nodeapps -n rac2
再次检查如下:
[oracle@rac2 bin]$ ./srvctl status nodeapps -n rac2
VIP is running on node: rac2
GSD is running on node: rac2
Listener is running on node: rac2
ONS daemon is running on node: rac2
这时候,服务一切正常:
[oracle@rac2 bin]$ ./crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....C1.inst application 0/5 0/0 ONLINE ONLINE rac1
ora....C2.inst application 0/5 0/0 ONLINE ONLINE rac2
ora.RAC.db application 0/1 0/1 ONLINE ONLINE rac2
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac1
ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1
ora.rac1.vip application 0/0 0/0 ONLINE ONLINE rac1
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE rac2
ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2
ora.rac2.gsd application 0/5 0/0 ONLINE ONLINE rac2
ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2
ora.rac2.vip application 0/0 0/0 ONLINE ONLINE rac2
请采纳
如果你认可我的回答,敬请及时采纳,
~如果你认可我的回答,请及时点击【采纳为满意回答】按钮
~~手机提问的朋友在客户端右上角评价点【满意】即可。
~你的采纳是我前进的动力
~~O(∩_∩)O,记得好评和采纳,互相帮助
全部回答
- 1楼网友:西风乍起
- 2021-02-09 18:03
任务占坑
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯