Chinese

在alert_sid.log里面有这些错误日志：

287 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_ora_22393.trc:
291 SVR4 Error: 2: No such file or directory
293 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_ora_22393.trc:
297 SVR4 Error: 2: No such file or directory
299 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_ora_22393.trc:
303 SVR4 Error: 2: No such file or directory
305 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_ora_22393.trc:
309 SVR4 Error: 2: No such file or directory
313 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_ora_22393.trc:
317 SVR4 Error: 2: No such file or directory
319 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_ora_22393.trc:
323 SVR4 Error: 2: No such file or directory
1195 Fatal NI connect error 12170.
1203 Tns error struct:
3155 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_smco_22227.trc (incident=7425):
4049 Fatal NI connect error 12170.
4057 Tns error struct:
11189 USER (ospid: 13563): terminating the instance due to error 472
13033 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_cjq0_5688.trc (incident=268769):
13037 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_cjq0_5688.trc:
19297 Fatal NI connect error 12537, connecting to:
19306 Tns error struct:
19425 Fatal NI connect error 12537, connecting to:
19434 Tns error struct:
19448 Fatal NI connect error 12537, connecting to:
19457 Tns error struct:
19489 Fatal NI connect error 12537, connecting to:
19498 Tns error struct:
19506 Fatal NI connect error 12537, connecting to:
19515 Tns error struct:
20874 Fatal NI connect error 12537, connecting to:
20883 Tns error struct:
20891 Fatal NI connect error 12537, connecting to:
20900 Tns error struct:
20919 Fatal NI connect error 12537, connecting to:
20928 Tns error struct:
20943 Fatal NI connect error 12537, connecting to:
20952 Tns error struct:
20962 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_qmnc_5539.trc (incident=268617):
21535 Fatal NI connect error 12537, connecting to:
21544 Tns error struct:
21552 Fatal NI connect error 12537, connecting to:
21561 Tns error struct:
22617 Fatal NI connect error 12537, connecting to:
22626 Tns error struct:
22658 Fatal NI connect error 12537, connecting to:
22667 Tns error struct:
22681 Fatal NI connect error 12537, connecting to:
22690 Tns error struct:
25625 Fatal NI connect error 12537, connecting to:
25634 Tns error struct:
26099 Error occured while spawning process m000; error = 12751
26754 Fatal NI connect error 12537, connecting to:
26763 Tns error struct:
26944 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_qmnc_5539.trc (incident=268618):
28030 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_cjq0_5688.trc (incident=268770):
28034 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_cjq0_5688.trc:
28227 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_qmnc_5539.trc (incident=268619):
28377 Error occured while spawning process m000; error = 12751
29126 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_qmnc_5539.trc (incident=268620):
32745 Fatal NI connect error 12537, connecting to:
32754 Tns error struct:
33252 Fatal NI connect error 12537, connecting to:
33261 Tns error struct:
33269 Fatal NI connect error 12537, connecting to:
33278 Tns error struct:
34298 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_cjq0_5688.trc:
34870 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_cjq0_5688.trc:
36044 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_cjq0_5688.trc:
37341 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_qmnc_5539.trc (incident=268621):
37760 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_cjq0_5688.trc:
37854 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_cjq0_5688.trc:
38204 Error occured while spawning process m000; error = 12751
38533 Fatal NI connect error 12537, connecting to:
38542 Tns error struct:
39535 Error occured while spawning process m000; error = 12751
40689 Fatal NI connect error 12537, connecting to:
40698 Tns error struct:
40712 Fatal NI connect error 12537, connecting to:
40721 Tns error struct:
41289 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_cjq0_5688.trc (incident=268771):
41295 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_cjq0_5688.trc:
41611 Fatal NI connect error 12537, connecting to:
41620 Tns error struct:
42176 Fatal NI connect error 12537, connecting to:
42185 Tns error struct:
42199 Fatal NI connect error 12537, connecting to:
42208 Tns error struct:
43552 Fatal NI connect error 12537, connecting to:
43560 Tns error struct:
43573 Fatal NI connect error 12537, connecting to:
43582 Tns error struct:
44752 Error occured while spawning process m000; error = 12751
44841 Error occured while spawning process m000; error = 12751
46011 Error occured while spawning process m000; error = 12751
46502 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_cjq0_5688.trc (incident=268772):
46506 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_cjq0_5688.trc:
48574 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_qmnc_11135.trc (incident=288617):
48604 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_cjq0_11259.trc (incident=288945):
48610 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_cjq0_11259.trc:
49056 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_cjq0_11259.trc (incident=288946):
49060 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_cjq0_11259.trc:
49193 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_smco_12433.trc (incident=289313):
50121 Fatal NI connect error 12537, connecting to:
50130 Tns error struct:
50183 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_mmon_9996.trc (incident=288569):
50300 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_mmon_9996.trc (incident=288570):
50381 Error occured while spawning process m000; error = 12751
50847 Errors in file /data3/oracle/diag/rdbms/aiobs/aiobs/trace/aiobs_smco_12433.trc (incident=289314):


主要有：
Fatal NI connect error 12170.
Fatal NI connect error 12537, connecting to:
Tns error struct:
Error occured while spawning process m000; error = 12751

Error occured while spawning process m000; error = 12751
Error occured while spawning process m000; error = 12751
Error occured while spawning process m000; error = 12751

142 ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
288 ORA-00313: open failed for members of log group 1 of thread 1
289 ORA-00312: online log 1 thread 1: '/data3/oracle/oradata/aiobs/redo01.log'
290 ORA-27037: unable to obtain file status
294 ORA-00313: open failed for members of log group 1 of thread 1
295 ORA-00312: online log 1 thread 1: '/data3/oracle/oradata/aiobs/redo01.log'
296 ORA-27037: unable to obtain file status
300 ORA-00313: open failed for members of log group 2 of thread 1
301 ORA-00312: online log 2 thread 1: '/data3/oracle/oradata/aiobs/redo02.log'
302 ORA-27037: unable to obtain file status
306 ORA-00313: open failed for members of log group 2 of thread 1
307 ORA-00312: online log 2 thread 1: '/data3/oracle/oradata/aiobs/redo02.log'
308 ORA-27037: unable to obtain file status
314 ORA-00313: open failed for members of log group 3 of thread 1
315 ORA-00312: online log 3 thread 1: '/data3/oracle/oradata/aiobs/redo03.log'
316 ORA-27037: unable to obtain file status
320 ORA-00313: open failed for members of log group 3 of thread 1
321 ORA-00312: online log 3 thread 1: '/data3/oracle/oradata/aiobs/redo03.log'
322 ORA-27037: unable to obtain file status
1212 WARNING: inbound connection timed out (ORA-3136)
1392 ORA-1144 signalled during: create tablespace obs_data
1436 ORA-12913 signalled during: create tablespace obs_temp
1565 ORA-1144 signalled during: create tablespace obs_data
1590 ORA-12913 signalled during: create tablespace obs_temp
1601 ORA-12913 signalled during: create tablespace obs_temp
1612 ORA-12913 signalled during: create tablespace obs_temp
1623 ORA-12913 signalled during: create tablespace obs_temp
1633 ORA-12913 signalled during: create tablespace obs_temp
1644 ORA-12913 signalled during: create tablespace obs_temp
1656 ORA-12913 signalled during: create tablespace obs_temp
1668 ORA-12913 signalled during: create tablespace obs_temp
1679 ORA-12913 signalled during: create tablespace obs_temp
3156 ORA-00445: background process "W000" did not start after 120 seconds
11226 ksuapc : ORA-1033 foreground process starts before PMON
13034 ORA-00445: background process "J000" did not start after 120 seconds
19314 opiodr aborting process unknown ospid (27176) as a result of ORA-609
19442 opiodr aborting process unknown ospid (11389) as a result of ORA-609
19465 opiodr aborting process unknown ospid (11178) as a result of ORA-609
19523 opiodr aborting process unknown ospid (21443) as a result of ORA-609
19529 opiodr aborting process unknown ospid (21732) as a result of ORA-609
20913 opiodr aborting process unknown ospid (20937) as a result of ORA-609
20936 opiodr aborting process unknown ospid (22466) as a result of ORA-609
20937 opiodr aborting process unknown ospid (21451) as a result of ORA-609
20960 opiodr aborting process unknown ospid (23100) as a result of ORA-609
20963 ORA-00445: background process "q000" did not start after 120 seconds
21574 opiodr aborting process unknown ospid (19936) as a result of ORA-609
21575 opiodr aborting process unknown ospid (19139) as a result of ORA-609
22634 opiodr aborting process unknown ospid (28687) as a result of ORA-609
22679 opiodr aborting process unknown ospid (4346) as a result of ORA-609
22698 opiodr aborting process unknown ospid (4410) as a result of ORA-609
25642 opiodr aborting process unknown ospid (15895) as a result of ORA-609
26771 opiodr aborting process unknown ospid (26238) as a result of ORA-609
26945 ORA-00445: background process "q003" did not start after 120 seconds
28031 ORA-00445: background process "J001" did not start after 120 seconds
28228 ORA-00445: background process "q002" did not start after 120 seconds
29127 ORA-00445: background process "q003" did not start after 120 seconds
32762 opiodr aborting process unknown ospid (5719) as a result of ORA-609
33286 opiodr aborting process unknown ospid (17120) as a result of ORA-609
33292 opiodr aborting process unknown ospid (17203) as a result of ORA-609
37342 ORA-00445: background process "q003" did not start after 120 seconds
38550 opiodr aborting process unknown ospid (24929) as a result of ORA-609
40706 opiodr aborting process unknown ospid (18372) as a result of ORA-609
40729 opiodr aborting process unknown ospid (17856) as a result of ORA-609
41290 ORA-00445: background process "J001" did not start after 120 seconds
41628 opiodr aborting process unknown ospid (653) as a result of ORA-609
42193 opiodr aborting process unknown ospid (20038) as a result of ORA-609
42216 opiodr aborting process unknown ospid (19243) as a result of ORA-609
43590 opiodr aborting process unknown ospid (4934) as a result of ORA-609
46503 ORA-00445: background process "J001" did not start after 120 seconds
48575 ORA-00445: background process "q000" did not start after 120 seconds
48605 ORA-00445: background process "J000" did not start after 120 seconds
49057 ORA-00445: background process "J001" did not start after 120 seconds
49194 ORA-00445: background process "W000" did not start after 120 seconds
50138 opiodr aborting process unknown ospid (27455) as a result of ORA-609
50184 ORA-00445: background process "m000" did not start after 120 seconds
50301 ORA-00445: background process "m000" did not start after 120 seconds
50848 ORA-00445: background process "W000" did not start after 120 seconds
50901 ORA-1624 signalled during: alter database drop logfile group 3...
50904 ORA-1624 signalled during: alter database drop logfile group 3...
50906 ORA-1624 signalled during: alter database drop logfile group 2...
50909 ORA-1624 signalled during: alter database drop logfile group 1 ...
50920 ORA-1624 signalled during: alter database drop logfile group 2...
50926 ORA-1623 signalled during: alter database drop logfile group 2...
50928 ORA-1624 signalled during: alter database drop logfile group 3...
50937 ORA-1623 signalled during: alter database drop logfile group 3...
50939 ORA-1624 signalled during: alter database drop logfile group 2...
50952 ORA-1624 signalled during: alter database drop logfile group 3...
50954 ORA-1624 signalled during: alter database drop logfile group 2...
50966 ORA-1624 signalled during: alter database drop logfile group 2...
50969 ORA-1624 signalled during: alter database drop logfile group 2...
50988 ORA-1624 signalled during: alter database drop logfile group 3 ...
50997 ORA-1623 signalled during: alter database drop logfile group 3 ...
50999 ORA-1624 signalled during: alter database drop logfile group 2...
51011 ORA-1624 signalled during: alter database drop logfile group 2...




SQL> show parameter mttr

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fast_start_mttr_target integer 0