The environment is as follows:
Operating system: red hat Linux 7.6
12 c R2 RAC database:
The operating system memory: 64 g
In recent three happened 2 times, automatic restart A node in the morning, the first is A node, A second node B, alter logging as follows, the trace is too long, just A, search on the Internet for A long time, also don't know is what reason, the trouble and help to see what the problem is,
alter logging:
The 2019-04-09 T04:12:30. 756224 + 08:00
LMON ospid: (35864) : terminating the instance due to error 481
The 2019-04-09 T04:12:30. 824463 + 08:00
The System state dump requested by (the instance=2, osid=35864 (LMON)), the summary=[abnormal instance termination].
System State dumped to trace the file/u01/app/oracle/diag/RDBMS/racywzc racywzc2/trace/racywzc2_diag_35844_20190409041230 TRC
The 2019-04-09 T04: o) 509002 + 08:00
License high water mark=178
The 2019-04-09 T04: children of. 316209 + 08:00
The Instance terminated by LMON, pid=35864
The 2019-04-09 T04: children of. 321611 + 08:00
Warning: 2 the processes are still attach to shmid 524294:
(size: 24576 bytes, the creator pid: 35740, the last attach/detach pid: 35844)
The 2019-04-09 T04: he. 519019 + 08:00
The USER (ospid: 170431) : terminating the instance
The 2019-04-09 T04: he. 535971 + 08:00
The Instance terminated by the USER, the pid=170431
The 2019-04-09 T04:12:55. 229029 + 08:00
Starting ORACLE instance (normal) (OS id: 170554)
The 2019-04-09 T04:12:55. 251875 + 08:00
CLI notifier numLatches: 97 maxDescs: 8518
The 2019-04-09 T04:12:55. 260262 + 08:00
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
The 2019-04-09 T04:12:55. 260424 + 08:00
The Dump of system resources acquired for SHARED GLOBAL AREA (SGA)
The 2019-04-09 T04:12:55. 260667 + 08:00
Per the process system memlock (soft) limit=UNLIMITED
The 2019-04-09 T04:12:55. 260799 + 08:00
Expected per process system memlock (soft) limit to lock
SHARED GLOBAL AREA (SGA) into the memory: 78 g
trace log
===================================================
The SYSTEM STATE (level=10)
-- -- -- -- -- -- -- -- -- -- -- --
Dumping the Process Summary
1: the PSEUDO process
2: PMON ospid sid ser 538 243 35812, waiting for 'PMON timer'
3: CLMN ospid sid ser 65070 364 35814, waiting for 'pmon timer'
4: PSP0 ospid sid ser 18540 485 35816, waiting for 'RDBMS ipc message'
5: IPC0 ospid sid ser 27510 606 35827, waiting for 'RDBMS ipc message'
6: VKTM ospid sid ser 2783 727 35829, waiting for 'VKTM Logical Idle Wait'
7: get ospid sid ser 39150 848 35834, waiting for 'RDBMS ipc message'
8: MMAN ospid sid ser 55194 969 35836, waiting for 'RDBMS ipc message'
9: LCK0 ospid sid ser 15242 1090 36956, 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 sid ser 1453 2514 35844,
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: DBRMS ospid sid ser 18086 1816 35850, waiting for 'RDBMS ipc message'
16: VKRM ospid sid ser 44844 1937 35852, waiting for 'VKRM Idle'
17: PING ospid sid ser 9123 2058 35854, waiting for a 'PING'
18: SVCB ospid sid ser 24016 2179 35856, waiting for 'wait for unread message on broadcast channel'
19: the ACMS ospid sid ser 6383 2300 35858, waiting for 'RDBMS ipc message'
20: PMAN ospid sid ser 19685 2421 35860, waiting for 'PMAN timer'
21: DIA0 ospid sid ser 2542 53755 35862,
22: LMON ospid sid ser 14118 2663 35864, waiting for 'the ges LMS sync during the dynamic remastering and reconfig'
CodePudding user response:
In the latest psu?