MSCS一个节点的Cluster Service无法启动

问题描述:

—————

MSCS一个节点的Cluster Service无法启动,这时在另一节点上的sql server的resource一直处于online pending状态,查看windows event发现event id 1145错误,该event id建议调整该resource的pend timeout时间,但调整后还是处于online pending…系统重起后状况依旧,但启动时提示:

At least one service or driver failed during system startup. Use Event
Viewer to examine the event log for details

解决过程:

————-

1.在网上查找关于event id 1145的解决方法,未果;

2.将其中一节点关掉,单节点进行测试,发现本节点上的service可以起来,原本属于另一节点的service无法起来;

3.查看 cluster.log,没发现异常状况;

4.最后该公司DBA(lm.lv)发现其中一节点上的event viewer上有如下错误:

Event ID 7022 Source: Service Control Manager
Description: The Messenger Service hung on startup

在微软网站上查找,提供如下解决方法:

CAUSE
This behavior can occur if a file that is associated with the NetBIOS interface is missing or has become corrupted.

RESOLUTION
To resolve this issue:

1. Click Start, point to Settings, click Control Panel, and then double-click Networking.
2. Click the Services tab.
3. Uninstall the NetBIOS interface.
4. Reboot your computer.
5. Click Start, point to Settings, click Control Panel, and then double-click Networking.
6. Install the NetBIOS interface.
7. Restart your computer.
8. Reapply your current service pack (if any).

重起后问题解决!

启示:

1.解决问题时多看看event viewer,从中可以发现很有用的线索;

2.该问题虽然是发生在sql server 2000的MSCS中,但对于居于MSCS的 oracle fail safe也有参考意义