SYS@ora10g> shutdown abort
ORACLE instance shut down.
SYS@ora10g> startup
ORACLE instance started.
Total System Global Area? 524288000 bytes
Fixed Size? ? 1220384 bytes
Variable Size? 327155936 bytes
Database Buffers? 192937984 bytes
Redo Buffers? ? 2973696 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
SYS@ora10g> shutdown abort
ORACLE instance shut down.
SYS@ora10g> startup mount pfile=/u01/app/oracle/product/10.2.0/db_1/dbs/initora10g.ora
ORACLE instance started.
Total System Global Area? 524288000 bytes
Fixed Size? ? 1220384 bytes
Variable Size? 327155936 bytes
Database Buffers? 192937984 bytes
Redo Buffers? ? 2973696 bytes
Database mounted.
SYS@ora10g> create spfile from pfile;
File created.
SYS@ora10g> shutdown abort
ORACLE instance shut down.
SYS@ora10g> startup mount
ORACLE instance started.
Total System Global Area? 524288000 bytes
Fixed Size? ? 1220384 bytes
Variable Size? 327155936 bytes
Database Buffers? 192937984 bytes
Redo Buffers? ? 2973696 bytes
Database mounted.
SYS@ora10g> show parameter spfile
NAME? ? ? TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile? ? ? string /u01/app/oracle/product/10.2.0
?/db_1/dbs/spfileora10g.ora
SYS@ora10g> alter database open;
alter database open
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
--查看此时alert日志，报ora-600错误 [4194]
Wed Jun 24 11:55:14 2015
Errors in file /u01/app/oracle/admin/ora10g/udump/ora10g_ora_4112.trc:
ORA-00600: internal error code, arguments: [4194], [36], [33], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [36], [33], [], [], [], [], []
Wed Jun 24 11:55:42 2015
Errors in file /u01/app/oracle/admin/ora10g/bdump/ora10g_smon_4098.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4194] [36] [33]
Wed Jun 24 11:55:44 2015
Fatal internal error happened while SMON was doing active transaction recovery.
Wed Jun 24 11:55:44 2015
Errors in file /u01/app/oracle/admin/ora10g/bdump/ora10g_smon_4098.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4194] [36] [33]
SMON: terminating instance due to error 474
Instance terminated by SMON, pid = 4098
通常ORA-00600 [4194]的错误会跟回滚段错误相关，继续查看trace文件/u01/app/oracle/admin/ora10g/bdump/orcl_smon_4098.trc，看到下述相关信息：
13121D07:00000B4B? ? 15? 159 10444? 14 Acq rbs SYSTEM
13122395:00000B4C? ? 15? 159 10444? 13 UNDO SEG (BEFORE RECOVERY): usn = 0
131224AB:00000B4D? ? 15? 159 10444? 13 UNDO SEG (BEFORE RECOVERY): usn = 0
13124171:00000B4E? ? 15? 159 10444? 14 Rec rbs _SYSSMU1$
1312455C:00000B4F? ? 15? 159 10444? 13 UNDO SEG (BEFORE RECOVERY): usn = 1
13131FE0:00000B50? ? 15? 159 10005? 4 KSL POST SENT postee=6 loc='ksasnd' id1=0 id2=0 name=? type=0
13133EDD:00000B59? ? 15? 159 10444? 14 Rec rbs _SYSSMU2$
13134C80:00000B5A? ? 15? 159 10444? 13 UNDO SEG (BEFORE RECOVERY): usn = 2
13135B8B:00000B5B? ? 15? 159 10005? 4 KSL POST SENT postee=6 loc='ksasnd' id1=0 id2=0 name=? type=0
13136B7A:00000B5F? ? 15? 159 10444? 14 Rec rbs _SYSSMU3$
13136EA7:00000B60? ? 15? 159 10444? 13 UNDO SEG (BEFORE RECOVERY): usn = 3
13137438:00000B61? ? 15? 159 10005? 4 KSL POST SENT postee=6 loc='ksasnd' id1=0 id2=0 name=? type=0
13138A0D:00000B67? ? 15? 159 10444? 14 Rec rbs _SYSSMU4$
13138FA8:00000B68? ? 15? 159 10444? 13 UNDO SEG (BEFORE RECOVERY): usn = 4
13139598:00000B69? ? 15? 159 10005? 4 KSL POST SENT postee=6