|
在oracle环境中,当RAC不同节点间的时间差超过30秒时,会导致oracle数据库反复重启或者状态异常,如下:
1.通过CRS_STAT查看RAC服务状态
[oracle@silinux2 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE UNKNOWN silinux2
ora....l1.inst application ONLINE ONLINE silinux1
ora....l2.inst application ONLINE ONLINE silinux2
ora....SM1.asm application ONLINE ONLINE silinux1
ora....X1.lsnr application ONLINE OFFLINE
ora....ux1.gsd application ONLINE UNKNOWN silinux1
ora....ux1.ons application ONLINE UNKNOWN silinux1
ora....ux1.vip application ONLINE ONLINE silinux1
ora....SM2.asm application ONLINE ONLINE silinux2
ora....X2.lsnr application ONLINE ONLINE silinux2
ora....ux2.gsd application ONLINE UNKNOWN silinux2
ora....ux2.ons application ONLINE UNKNOWN silinux2
ora....ux2.vip application ONLINE ONLINE silinux2
说明:通过crs_stat命令查看,其中多个服务状态显示为UNKNOWN,可通过配置NTP或者直接用date -s XX:XX:XX来修改两节点时间,以保持一致(其中XX:XX:XX为小时:分钟:秒)
2.通过CRS_STOP命令来停止RAC相应服务,并用CRS_STAT确认结果,可见仍有部分服务无法正常关闭
[oracle@silinux2 ~]$ crs_stop -all
Attempting to stop `ora.orcl.db` on member `silinux1`
Stop of `ora.orcl.db` on member `silinux1` succeeded.
Attempting to stop `ora.silinux2.LISTENER_SILINUX2.lsnr` on member `silinux2`
Attempting to stop `ora.silinux1.LISTENER_SILINUX1.lsnr` on member `silinux1`
阅读更多内容：1 · 2 · 3 · 4 · 5 · 6 · 下一页>>
|
