暂无图片
Oracle12.2 RAC其中一个节点重启
我来答
分享
Donnieyen
2020-08-17
Oracle12.2 RAC其中一个节点重启

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

根据提示信息似乎与服务器时间不一致有关系

我来答
添加附件
收藏
分享
问题补充
2条回答
默认
最新
Donnieyen

2020-07-15T09:57:18.465261+08:00
NOTE: umbilicus traces dumped to /u01/app/grid/diag/asm/+asm/+ASM2/trace/+ASM2_gen0_18931.trc
WARNING: client [ORCL2:RCL:rac-scan] not responsive for 270s; state=0x1. killing pid 19344
NOTE: umbilicus traces dumped to /u01/app/grid/diag/asm/+asm/+ASM2/trace/+ASM2_gen0_18931.trc
2020-07-15T09:57:18.723640+08:00
NOTE: cleaned up ASM client ORCL2:ORCL:rac-scan connection state (reg:2439686649)
2020-07-15T09:57:21.624048+08:00
NOTE: detected orphaned client id 0x10002.
2020-07-15T09:57:52.818742+08:00
NOTE: Flex client id 0x0 [ORCL2:ORCL:rac-scan] attempting to connect
NOTE: will remove stale ownerid 0x10002 for client ORCL2:ORCL:rac-scan (reconnected as ownerid 0x10003)
NOTE: registered owner id 0x10003 for ORCL2:ORCL:rac-scan
NOTE: Flex client ORCL2:ORCL:rac-scan registered, osid 43772, mbr 0x0, asmb 43672 (reg:1363029626)
2020-07-15T09:57:54.627036+08:00
NOTE: found stale ownerid 0x10002 for client ORCL2:ORCL:rac-scan
WARNING: giving up on client id 0x10002 [ORCL2:ORCL:rac-scan] which has not reconnected for 0 seconds (originally from ASM inst +ASM2, reg:2439686649) [stale]
NOTE: removing stale ownerid 0x10002 for client ORCL2:ORCL:rac-scan (reg:2439686649)
NOTE: released resources held for client id 0x10002 (reg:2439686649)
2020-07-15T09:57:57.789663+08:00
NOTE: client ORCL2:ORCL:rac-scan mounted group 1 (DATA)
NOTE: client ORCL2:ORCL:rac-scan mounted group 2 (FIR)
2020-07-15T10:03:04.096978+08:00
NOTE: [ocrcheck.bin@rac2 (TNS V1-V3) 49202] opening OCR file +OCR.255.4294967295, osid 49211
NOTE: [ocrcheck.bin@rac2 (TNS V1-V3) 49202] opened OCR file +OCR.255.4294967295, osid 49211

暂无图片 评论
暂无图片 有用 0
一念之间

 那就看ntp或者ctss两节点是不是一致

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏