ORACLE 11g RAC时钟同步问题

       近一段，客户数据库累积了一些问题，需要我集中处理，有些相对容易，有些 有一点棘手，可能需要通过SR提交服务。我陆续将所碰到问题及解决方案总结一下。
     首先是HP-UX和AIX平台上出现时间同步警告信息，具体日志如下：

2014-01-16 15:48:10.885 [ctssd(15073486)]CRS-2409:The clock on host node2 is not synchronous with the mean cluster time. No action has been taken as the Cluster Time Synchronization Service is running in observer mode.

原理描述：

      11g Clusterware引入一个新的进程CTSS，该进程主要负责集群的时间管理，确保每个节点的集群时间一致，如果系统的NTP进程运行，则CTSS进程处于observer模式， 否则，NTP进程没有运行，CTSS运行于ACTIVE模式。

问题分析及解决：

   运行cluvfy命令进行节点的时间同步，出现如下错误：

#su – grid $cluvfy comp clocksync –n all –verbose 执行失败，出现如以下错误： 执行失败，如：   Version of exectask could not be retrieved from node “node1”   Version of exectask could not be retrieved from node “node1” ERROR:    Framework setup check failed on all the nodes    Verification cannot processed

    命令cluvfy运行出现错误，主要从以下三个方面进行解决：
  1、检查两个节点直接的信任关系，否则执行sshUserSetup.sh脚本，该脚本可通过解压安装包获得。

# sshUserSetup.sh -user grid -hosts "oadb1 oadb2" -advanced –PromptPassphrase

2、清除临时文件系统中以CVU开头的文件目录。

# rm –rf /tmp/CVU*

3、因为数据库升级，会改变exectask*命令执行权限，需要更改该脚本执行权限

# su – grid $ cd $ORACLE_HOME/cv/remenv $chmod 755 ./*

重新执行cluvfy脚本，依然无法同步，具体信息如下：

$ cluvfy comp clocksync –n all –verbose 输出信息如下： Verifying Clock Synchronization across the cluster nodes Checking if Clusterware is installed on all nodes... Check of Clusterware install passed   Checking if CTSS Resource is running on all nodes... Check: CTSS Resource running on all nodes   Node Name                             Status                    ------------------------------------  ------------------------    node1                              passed                     node2                              passed                  Result: CTSS resource check passed   Querying CTSS for time offset on all nodes... Result: Query of CTSS for time offset passed   Check CTSS state started... Check: CTSS state   Node Name                             State                     ------------------------------------  ------------------------   node2                              Observer                  node1                              Observer                CTSS is in Observer state. Switching over to clock synchronization checks using NTP   Starting Clock synchronization checks using Network Time Protocol(NTP)...   NTP Configuration file check started... The NTP configuration file "/etc/ntp.conf" is available on all nodes NTP Configuration file check passed   Checking daemon liveness...   Check: Liveness for "xntpd"   Node Name                             Running?                  ------------------------------------  ------------------------   node2                              yes                       node1                              yes                     Result: Liveness check passed for "xntpd" Check for NTP daemon or service alive passed on all nodes   Checking NTP daemon command line for slewing option "-x" Check: NTP daemon command line   Node Name                             Slewing Option Set?       ------------------------------------  ------------------------   node2                              no                        node1                              no                      Result: NTP daemon slewing option check failed on some nodes PRVF-5436 : The NTP daemon running on one or more nodes lacks the slewing option "-x" Result: Clock synchronization check using Network Time Protocol(NTP) failed   PRVF-9652 : Cluster Time Synchronization Services check failed Verification of Clock Synchronization across the cluster nodes was unsuccessful on all the specified nodes.

以上可以看出xntpd进程运行未使用参数”-x”，在所有节点“系统启动配置文件”检查并添加该参数，然后各个节点重新启动时间同步：

1、AIX平台配置文件:

     #vi /etc/rc.tcpip

       start /usr/sbin/xntpd "$src_running" "-x"

2、HP-UX平台配置文件：

     #vi /etc/rc.config.d/netdaemons

        XNTPD_ARGS="-x"

3、AIX停止和启动XNTPD进程

     #stopsrc –s xntpd

     #startsrc –s xntpd –a “-x”

4、HP-UX停止和启动XNTPD进程

     #/sbin/init.d/xntpd stop

     #/sbin/init.d/xntpd start
完成以上命令后，各个节点重新执行cluvfy comp clocksysnc –n all –verbose，时间同步成功。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/354732/viewspace-1074324/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/354732/viewspace-1074324/