各位大牛,你们好: 环境如下:
操作系统 : red hat linux 7.6
数据库: 12C R2 RAC
操作系统内存:64G 最近3个发生过2次,某个节点在凌晨自动重启,第一次是A节点,第二次B节点,alter日志如下,trace太长,就只列一段,在网上搜了好久,也不知道是什么原因,麻烦大牛们帮忙看看是什么问题。
alter日志:
2019-04-09T04:12:30.756224+08:00
LMON (ospid: 35864): terminating the instance due to error 481
2019-04-09T04:12:30.824463+08:00
System state dump requested by (instance=2, osid=35864 (LMON)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/racywzc/racywzc2/trace/racywzc2_diag_35844_20190409041230.trc
2019-04-09T04:12:34.509002+08:00
License high water = 178
2019-04-09T04:12:37.316209+08:00
Instance terminated by LMON, pid = 35864
2019-04-09T04:12:37.321611+08:00
Warning: 2 processes are still attach to shmid 524294:
(size: 24576 bytes, creator pid: 35740, last attach/detach pid: 35844)
2019-04-09T04:12:38.519019+08:00
USER (ospid: 170431): terminating the instance
2019-04-09T04:12:38.535971+08:00
Instance terminated by USER, pid = 1704312019-04-09T04:12:55.229029+08:00
Starting ORACLE instance (normal) (OS id: 170554)
2019-04-09T04:12:55.251875+08:00
CLI notifier numLatches:97 maxDescs:8518
2019-04-09T04:12:55.260262+08:00
**********************************************************************
2019-04-09T04:12:55.260424+08:00
Dump of system resources acquired for SHARED GLOBAL AREA (SGA) 2019-04-09T04:12:55.260667+08:00
Per process system memlock (soft) limit = UNLIMITED
2019-04-09T04:12:55.260799+08:00
Expected per process system memlock (soft) limit to lock
SHARED GLOBAL AREA (SGA) into memory: 78Gtrace日志
===================================================
SYSTEM STATE (level=10)
------------
Dumping the Process Summary
1: PSEUDO process
2: PMON ospid 35812 sid 243 ser 538, waiting for 'pmon timer'
3: CLMN ospid 35814 sid 364 ser 65070, waiting for 'pmon timer'
4: PSP0 ospid 35816 sid 485 ser 18540, waiting for 'rdbms ipc message'
5: IPC0 ospid 35827 sid 606 ser 27510, waiting for 'rdbms ipc message'
6: VKTM ospid 35829 sid 727 ser 2783, waiting for 'VKTM Logical Idle Wait'
7: GEN0 ospid 35834 sid 848 ser 39150, waiting for 'rdbms ipc message'
8: MMAN ospid 35836 sid 969 ser 55194, waiting for 'rdbms ipc message'
9: LCK0 ospid 36956 sid 1090 ser 15242, waiting for 'rdbms ipc message'
10: GEN1 ospid 35840_35842 sid 1211 ser 57014, waiting for 'rdbms ipc message'
11: SCMN ospid 35840_35840 sid 1332 ser 18545, waiting for 'watchdog main loop'
12: DIAG ospid 35844 sid 1453 ser 2514,
13: OFSD ospid 35846_35848 sid 1574 ser 43454, waiting for 'OFS idle'
14: SCMN ospid 35846_35846 sid 1695 ser 3764, waiting for 'watchdog main loop'
15: DBRM ospid 35850 sid 1816 ser 18086, waiting for 'rdbms ipc message'
16: VKRM ospid 35852 sid 1937 ser 44844, waiting for 'VKRM Idle'
17: PING ospid 35854 sid 2058 ser 9123, waiting for 'PING'
18: SVCB ospid 35856 sid 2179 ser 24016, waiting for 'wait for unread message on broadcast channel'
19: ACMS ospid 35858 sid 2300 ser 6383, waiting for 'rdbms ipc message'
20: PMAN ospid 35860 sid 2421 ser 19685, waiting for 'pman timer'
21: DIA0 ospid 35862 sid 2542 ser 53755,
22: LMON ospid 35864 sid 2663 ser 14118, waiting for 'ges lms sync during dynamic remastering and reconfig'
操作系统 : red hat linux 7.6
数据库: 12C R2 RAC
操作系统内存:64G 最近3个发生过2次,某个节点在凌晨自动重启,第一次是A节点,第二次B节点,alter日志如下,trace太长,就只列一段,在网上搜了好久,也不知道是什么原因,麻烦大牛们帮忙看看是什么问题。
alter日志:
2019-04-09T04:12:30.756224+08:00
LMON (ospid: 35864): terminating the instance due to error 481
2019-04-09T04:12:30.824463+08:00
System state dump requested by (instance=2, osid=35864 (LMON)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/racywzc/racywzc2/trace/racywzc2_diag_35844_20190409041230.trc
2019-04-09T04:12:34.509002+08:00
License high water = 178
2019-04-09T04:12:37.316209+08:00
Instance terminated by LMON, pid = 35864
2019-04-09T04:12:37.321611+08:00
Warning: 2 processes are still attach to shmid 524294:
(size: 24576 bytes, creator pid: 35740, last attach/detach pid: 35844)
2019-04-09T04:12:38.519019+08:00
USER (ospid: 170431): terminating the instance
2019-04-09T04:12:38.535971+08:00
Instance terminated by USER, pid = 1704312019-04-09T04:12:55.229029+08:00
Starting ORACLE instance (normal) (OS id: 170554)
2019-04-09T04:12:55.251875+08:00
CLI notifier numLatches:97 maxDescs:8518
2019-04-09T04:12:55.260262+08:00
**********************************************************************
2019-04-09T04:12:55.260424+08:00
Dump of system resources acquired for SHARED GLOBAL AREA (SGA) 2019-04-09T04:12:55.260667+08:00
Per process system memlock (soft) limit = UNLIMITED
2019-04-09T04:12:55.260799+08:00
Expected per process system memlock (soft) limit to lock
SHARED GLOBAL AREA (SGA) into memory: 78Gtrace日志
===================================================
SYSTEM STATE (level=10)
------------
Dumping the Process Summary
1: PSEUDO process
2: PMON ospid 35812 sid 243 ser 538, waiting for 'pmon timer'
3: CLMN ospid 35814 sid 364 ser 65070, waiting for 'pmon timer'
4: PSP0 ospid 35816 sid 485 ser 18540, waiting for 'rdbms ipc message'
5: IPC0 ospid 35827 sid 606 ser 27510, waiting for 'rdbms ipc message'
6: VKTM ospid 35829 sid 727 ser 2783, waiting for 'VKTM Logical Idle Wait'
7: GEN0 ospid 35834 sid 848 ser 39150, waiting for 'rdbms ipc message'
8: MMAN ospid 35836 sid 969 ser 55194, waiting for 'rdbms ipc message'
9: LCK0 ospid 36956 sid 1090 ser 15242, waiting for 'rdbms ipc message'
10: GEN1 ospid 35840_35842 sid 1211 ser 57014, waiting for 'rdbms ipc message'
11: SCMN ospid 35840_35840 sid 1332 ser 18545, waiting for 'watchdog main loop'
12: DIAG ospid 35844 sid 1453 ser 2514,
13: OFSD ospid 35846_35848 sid 1574 ser 43454, waiting for 'OFS idle'
14: SCMN ospid 35846_35846 sid 1695 ser 3764, waiting for 'watchdog main loop'
15: DBRM ospid 35850 sid 1816 ser 18086, waiting for 'rdbms ipc message'
16: VKRM ospid 35852 sid 1937 ser 44844, waiting for 'VKRM Idle'
17: PING ospid 35854 sid 2058 ser 9123, waiting for 'PING'
18: SVCB ospid 35856 sid 2179 ser 24016, waiting for 'wait for unread message on broadcast channel'
19: ACMS ospid 35858 sid 2300 ser 6383, waiting for 'rdbms ipc message'
20: PMAN ospid 35860 sid 2421 ser 19685, waiting for 'pman timer'
21: DIA0 ospid 35862 sid 2542 ser 53755,
22: LMON ospid 35864 sid 2663 ser 14118, waiting for 'ges lms sync during dynamic remastering and reconfig'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货