ITPub博客

首页 > 数据库 > Oracle > ORACLE 11g RAC时钟同步问题

ORACLE 11g RAC时钟同步问题

原创 Oracle 作者:yezhibin 时间:2014-01-23 00:20:48 4 删除 编辑
      近一段,客户数据库累积了一些问题,需要我集中处理,有些相对容易,有些有一点棘手,可能需要通过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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-12-18

  • 博文量
    159
  • 访问量
    514994