Oracle 11.2.0.3
1、报错信息检查第1节点的CRS alert log,发现存在有下面异常信息
| 2013-0X-XX 19:27:17.609[ctssd(18809056)]CRS-2409:The clock on host XXXdb1 is not synchronous with the mean cluster time. No action has been taken as the Cluster Time Synchronization Service is running in observer mode.2013-0X-XX 19:59:42.312[ctssd(18809056)]CRS-2409:The clock on host XXXdb1 is not synchronous with the mean cluster time. No action has been taken as the Cluster Time Synchronization Service is running in observer mode. |
上面报错的意思是,ORACLE的CTSSD服务发现异常,不能处于观察模式
2、报错信息问题分析2.1、操作系统的NTPD服务处于启动状态,CTSSD就不会工作,但是只要CTSSD服务启动,正常情况下应该处于观察模式2.2、当前OS的NTPD服务正在运行,并且,CTSSD不能处于观察模式运行
3、排查过程3.1、检查两个节点的时间是否存在差异
| XXXdb1:/u01/app/11.2.0.3/grid/log/XXXdb1$ssh XXXdb2 dateMon Jul 15 20:30:17 GMT+08:00 2013 XXXdb1:/u01/app/11.2.0.3/grid/log/XXXdb1$dateMon Jul 15 20:30:18 GMT+08:00 2013 |
经检查,时间不存在差异 3.2、检查OS的NTPD服务
| XXXdb1:/# lssrc -ls xntpdProgram name: /usr/sbin/xntpdVersion: 3Leap indicator: 00 (No leap second today.)Sys peer: 10.XXX.XXX.71Sys stratum: 2Sys precision: -18Debug/Tracing: DISABLEDRoot distance: 0.000397Root dispersion: 0.013458Reference ID: 10.XXX.XXX.71Reference time: d58e6e41.d0fca000 Mon, Jul 15 2013 20:49:05.816Broadcast delay: 0.003906 (sec)Auth delay: 0.000122 (sec)System flags: bclient auth pll monitor filegenSystem uptime: 30149695 (sec)Clock stability: 0.047607 (sec)Clock frequency: 0.000000 (sec)Peer: 10.XXX.XXX.71flags: (configured)(sys peer)stratum: 1, version: 3our mode: client, his mode: serverSubsystem Group PID Statusxntpd tcpip 4128900 active |
经检查两个节点,OS层的NTPD都在运行,并且可以做时间同步 3.3、检查ctssd的运行情况
| XXXdb1:/#su - gridXXXdb1:/home/grid$ crsctl stat res ora.ctssd -initNAME=ora.ctssdTYPE=ora.ctss.typeTARGET=ONLINESTATE=ONLINE on XXXdb1 |
经检查两个节点,CTSSD服务都已经启动 3.4、借助CRS的cluvfy工具诊断CTSS错误的原因
| XXXdb1:/home/grid$cluvfy comp clocksync -n all -verboseVerifying Clock Synchronization across the cluster nodesChecking if Clusterware is installed on all nodes...Check of Clusterware install passedChecking if CTSS Resource is running on all nodes...Check: CTSS Resource running on all nodesNode Name Status------------------------------------ ------------------------XXXdb2 passedXXXdb1 passedResult: CTSS resource check passedQuerying CTSS for time offset on all nodes...Result: Query of CTSS for time offset passedCheck CTSS state started...Check: CTSS stateNode Name State------------------------------------ ------------------------XXXdb2 ObserverXXXdb1 ObserverCTSS is in Observer state. Switching over to clock synchronization checks using NTPStarting Clock synchronization checks using Network Time Protocol(NTP)...NTP Configuration file check started...The NTP configuration file "/etc/ntp.conf" is available on all nodesNTP Configuration file check passed……Checking NTP daemon command line for slewing option "-x"Check: NTP daemon command lineNode Name Slewing Option Set?------------------------------------ ------------------------XXXdb2 noXXXdb1 noResult:NTP daemon slewing option check failed on some nodesPRVF-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 |
见上面标红色字体部分,在做NTP slewingoption时,两个节点都不通过,原因为,NTP没有运行在“-X”模式 3.5、检查OS层NTPD的配置(1)检查/etc/ntpd.conf
| server 10.XXX.XXX.71broadcastclientdriftfile /etc/ntp.drifttracefile /etc/ntp.trace |
(2)检查/etc/rc.tcpip文件的配置
| 存在有下面信息:# Start up Network Time Protocol (NTP) daemonstart /usr/sbin/xntpd "$src_running" -a "-x" |
看来配置不存在问题,但当前运行却不处于”-x”模式,很有可能是NTPD被重启过,启动时没有加上个”-x”参数接下来请看第2页精彩内容: http://www.linuxidc.com/Linux/2013-08/88583p2.htm
推荐阅读:Oracle 12C R1 RAC安装CRS http://www.linuxidc.com/Linux/2013-07/87697.htmOracle 11g RAC 执行root.sh时遭遇 CRS-0184/PRCR-1070 http://www.linuxidc.com/Linux/2013-07/87534.htmOracle 10g R2 RAC CRS无法启动,CRS-1604:CSSD 表决文件脱机 http://www.linuxidc.com/Linux/2013-02/79308.htmVMware 下Oracle RAC搬家引起CRS-1006/CRS-0215/CRS-0233 http://www.linuxidc.com/Linux/2013-01/77308.htm
快速找到跟踪其他session产生的trc文件MongoDB简单调研相关资讯 CRS CRS-2409
- 更改服务器名后CRS无法启动 (02/12/2014 15:03:12)
本文评论 查看全部评论 (0)