oracle rac 节点时间差_oracle rac时间不一致-CSDN博客

本文链接：https://blog.csdn.net/jnrjian/article/details/129045406

文章描述了一个Oracle19cRAC集群在CentOS7.4上遇到的问题，其中节点间时间差异过大，导致CRS-4535错误，无法与ClusterReadyServices通信。crsd.bin服务状态异常。解决方法包括调整系统时间，确保时间同步，并尝试手动启动ora.crsd资源。

摘要由CSDN通过智能技术生成

1、关闭数据库和集群

2、修改系统时间（应避免向后调时间，你当前情况我觉得节点2关闭20分钟，然后再向前微调时间和节点1保持一致）---20分钟不存在，看下面日志应该最多10分钟

3、将系统时间同步至硬件时间

4、启动数据库和集群

1. 如果时间慢了，关闭数据库和集群直接把时间向前调整，启动集群和数据库
2. 如果时间快了，关闭数据库和集群，等实际时间过了关闭集群和库的时间之后，再往前调整时间，启动集群和数据库

oracle rac 节点时间相差太大导致

CRS-4535: Cannot communicate with Cluster Ready Services

--------------
os: centos 7.4
db: oracle 19c rac (19.3)

rac 一个节点重启后检查集群状态时报错
CRS-4535: Cannot communicate with Cluster Ready Services

# /u01/app/grid/product/19.0.0/grid_1/bin/crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

检查发现 crsd.bin 不存在

# ps -ef | grep crsd.bin

root 12232 4773 0 10:07 pts/1 00:00:00 grep --color=auto crsd.bin

查看ora.crsd的状态,有问题

# /u01/app/grid/product/19.0.0/grid_1/bin/crsctl stat res -t -init

--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
1 ONLINE OFFLINE STABLE
ora.cluster_interconnect.haip
1 ONLINE ONLINE node2 STABLE
ora.crf
1 ONLINE ONLINE node2 STABLE
ora.crsd
1 ONLINE OFFLINE STABLE
ora.cssd
1 ONLINE ONLINE node2 STABLE
ora.cssdmonitor
1 ONLINE ONLINE node2 STABLE
ora.ctssd
1 ONLINE OFFLINE STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE node2 STABLE
ora.gipcd
1 ONLINE ONLINE node2 STABLE
ora.gpnpd
1 ONLINE ONLINE node2 STABLE
ora.mdnsd
1 ONLINE ONLINE node2 STABLE
ora.storage
1 ONLINE ONLINE node2 STABLE
--------------------------------------------------------------------------------

检查asm磁盘

# ls -l /dev/sd*
brw-rw---- 1 root disk 8, 0 Feb 16 09:57 /dev/sda
brw-rw---- 1 root disk 8, 1 Feb 16 09:57 /dev/sda1
brw-rw---- 1 root disk 8, 2 Feb 16 09:57 /dev/sda2
brw-rw---- 1 grid asmadmin 8, 16 Feb 16 10:12 /dev/sdb
brw-rw---- 1 grid asmadmin 8, 32 Feb 16 09:58 /dev/sdc
brw-rw---- 1 grid asmadmin 8, 48 Feb 16 09:58 /dev/sdd
brw-rw---- 1 grid asmadmin 8, 64 Feb 16 09:58 /dev/sde

# ls -l /dev/asm*
lrwxrwxrwx 1 root root 3 Feb 16 09:58 /dev/asm-diskb -> sdb
lrwxrwxrwx 1 root root 3 Feb 16 09:58 /dev/asm-diskc -> sdc
lrwxrwxrwx 1 root root 3 Feb 16 09:58 /dev/asm-diskd -> sdd
lrwxrwxrwx 1 root root 3 Feb 16 09:58 /dev/asm-diske -> sde

查看日志 $ORACLE_BASE/diag/crs/$HOSTNAME/crs/alert/log.xml

<msg time='2021-02-16T09:58:20.860+08:00' org_id='oracle' comp_id='crs'
msg_id='clsdadr_process_queue:4927:2974305713' type='UNKNOWN' group='CLSDADR'
level='16' host_id='node2' host_addr='192.168.56.12'
pid='6543'>
<txt>2021-02-16 09:58:20.843 [OCTSSD(6543)]CRS-2407: The new Cluster Time Synchronization Service reference node is host node1.
</txt>
</msg>
<msg time='2021-02-16T09:58:21.016+08:00' org_id='oracle' comp_id='crs'
msg_id='clsdadr_process_queue:4927:2974305713' type='UNKNOWN' group='CLSDADR'
level='16' host_id='node2' host_addr='192.168.56.12'
pid='6543'>
<txt>2021-02-16 09:58:21.008 [OCTSSD(6543)]CRS-2419: The clock on host node2 differs from mean cluster time by 3066359431 microseconds. The Cluster Time Synchronization Service will not perform time synchronization because the time difference is beyond the permissible offset of 600 seconds. Details in /u01/app/gridbase/19.0.0/grid_1/diag/crs/node2/crs/trace/octssd.trc.
</txt>
</msg>
<msg time='2021-02-16T09:58:21.110+08:00' org_id='oracle' comp_id='crs'
msg_id='clsdadr_process_queue:4927:2974305713' type='UNKNOWN' group='CLSDADR'
level='16' host_id='node2' host_addr='192.168.56.12'
pid='6543'>
<txt>2021-02-16 09:58:21.110 [OCTSSD(6543)]CRS-2402: The Cluster Time Synchronization Service aborted on host node2. Details at (:ctsselect_mstm4:) in /u01/app/gridbase/19.0.0/grid_1/diag/crs/node2/crs/trace/octssd.trc.
</txt>
</msg>