oracle12.2 RAC、Oracle Linux7.4
节点2自动重启,部分日志信息
2020-07-15 09:52:43.893 [OCTSSD(17627)]CRS-2411: The Cluster Time Synchronization Service will take a long time to perform time synchronization as local time is significantly different from mean cluster time. Details in /u01/app/grid/diag/crs/rac2/crs/trace/octssd.trc.
WARNING: ASMB(0) has not responded for 269 seconds
NOTE: ASM umbilicus running slower than expected, ASMB diagnostic requested after 269 seconds
NOTE: ASMB process state dumped to trace file /u01/app/oracle/diag/rdbms/orcl/ORCL2/trace/ORCL2_gen0_19201.trc
ERROR: terminating instance because ASMB is stuck for 269 seconds
GEN0 (ospid: 19201): terminating the instance due to error 15082
2020-07-15T09:57:17.130597+08:00
System state dump requested by (instance=2, osid=19201 (GEN0)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/orcl/ORCL2/trace/ORCL2_diag_19211_20200715095717.trc
2020-07-15T09:57:21.449565+08:00
License high water mark = 283
2020-07-15T09:57:24.060403+08:00
Instance terminated by GEN0, pid = 19201
2020-07-15T09:57:24.061199+08:00
Warning: 2 processes are still attach to shmid 262150:
(size: 36864 bytes, creator pid: 19102, last attach/detach pid: 19211)
2020-07-15T09:57:24.450259+08:00
USER (ospid: 43233): terminating the instance
2020-07-15T09:57:24.454862+08:00
Instance terminated by USER, pid = 43233
2020-07-15T09:57:35.679695+08:00
Starting ORACLE instance (normal) (OS id: 43515)
2020-07-15T09:57:35.704277+08:00
CLI notifier numLatches:89 maxDescs:7453
2020-07-15T09:57:35.738309+08:00
Trace文件内容
*** 2020-07-15T09:57:39.194570+08:00 (CDB$ROOT(1))
*** CLIENT ID:() 2020-07-15T09:57:39.194606+08:00
*** SERVICE NAME:() 2020-07-15T09:57:39.194611+08:00
*** MODULE NAME:() 2020-07-15T09:57:39.194615+08:00
*** ACTION NAME:() 2020-07-15T09:57:39.194619+08:00
*** CLIENT DRIVER:() 2020-07-15T09:57:39.194624+08:00
[kji_attach][LMON !running, !call kjual]
*** SESSION ID:(848.3861) 2020-07-15T09:57:39.406480+08:00
*** SERVICE NAME:() 2020-07-15T09:57:39.406498+08:00
*** CONTAINER ID:(1) 2020-07-15T09:57:39.406503+08:00
kjznppl0: database in migration or not writable
*** 2020-07-15T09:57:42.210217+08:00 (CDB$ROOT(1))
AUTO SGA: kmgs_parameter_update_timeout gen0 1 mmon alive 1
*** 2020-07-15T09:57:45.209906+08:00 (CDB$ROOT(1))
AUTO SGA: kmgs_parameter_update_timeout gen0 1 mmon alive 1
*** 2020-07-15T09:57:48.209879+08:00 (CDB$ROOT(1))
AUTO SGA: kmgs_parameter_update_timeout gen0 1 mmon alive 1
根据提示信息似乎与服务器时间不一致有关系