各位大牛，你們好：
環境如下：
作業系統 ： 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 mark = 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 = 170431
2019-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: 78G
trace日志
===================================================
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'
uj5u.com熱心網友回復：
打上最新的psu了嗎？轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/46451.html
標籤：基礎和管理
下一篇：SQL練習 分析函式 求答案