oracle告警日志的ORA-00600错误

db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Process W000 submission failed with error = 20
Mon Aug 08 15:02:49 2011
Process W000 submission failed with error = 20
Mon Aug 08 15:04:36 2011
Process m000 submission failed with error = 20
Errors in file e:\app\hwbyserver07\diag\rdbms\itestportalcenter\itestportalcenter\trace\itestportalcenter_mmon_5672.trc (incident=66180):
ORA-00600: 内部错误代码, 参数: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []
Process m000 submission failed with error = 20
Process m000 submission failed with error = 20
请高手踢教。。

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

贴出来TRACE文件，看看，还有什么操作触发的600错误
600错误对应一堆的可能性。。  找到相关的trc文件吧。
Trace file e:\app\hwbyserver07\diag\rdbms\itestportalcenter\itestportalcenter\trace\itestportalcenter_mmon_5672.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows Server 2003 Version V5.2 Service Pack 2
CPU                 : 4 - type 586, 1 Physical Cores
Process Affinity    : 0x00000000
Memory (Avail/Total): Ph:1694M/4082M, Ph+PgF:1433M/5870M, VA:1987M/4095M
Instance name: itestportalcenter
Redo thread mounted by this instance: 1
Oracle process number: 15
Windows thread id: 5672, image: ORACLE.EXE (MMON)
*** 2011-08-08 13:04:38.727
*** SESSION ID:(321.3) 2011-08-08 13:04:38.727
*** CLIENT ID:() 2011-08-08 13:04:38.727
*** SERVICE NAME:(SYS$BACKGROUND) 2011-08-08 13:04:38.727
*** MODULE NAME:() 2011-08-08 13:04:38.727
*** ACTION NAME:() 2011-08-08 13:04:38.727

Incident 66156 created, dump file: e:\app\hwbyserver07\diag\rdbms\itestportalcenter\itestportalcenter\incident\incdir_66156\itestportalcenter_mmon_5672_i66156.trc
ORA-00600: 内部错误代码, 参数: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []08/08/11 13:04:39 >ERROR: exception at dbms_ha_alerts_prvt.post_instance_up308: SQLCODE -600,ORA-00600: 内部错误代码, 参数: [kjh
n_post_ha_alert0-862], [], [], [], [], [], [], []
08/08/11 13:04:39 >ERROR: exception at dbms_ha_alerts_prvt.check_ha_resources76: SQLCODE -1400,ORA-01400: 无法将 NULL 插入 ("
SYS"."RECENT_RESOURCE_INCARNATIONS$"."INSTANCE_NAME")
08/08/11 13:04:39 >parameter dump for dbms_ha_alerts_prvt.check_ha_resources
08/08/11 13:04:39 > - local_db_unique_name (ItestPortalCenter)
08/08/11 13:04:39 > - local_db_domain (==N/A==)
ORA-00020: No more process state objects available
Unable to schedule a MMON slave at: Maintain AWR Baseline Thresholds Task
  Unknown return code: 3*** 2011-08-08 13:04:54.586
ORA-00020: No more process state objects available
***KELR Apply Log: unable to schedule MMON Slave, error 3*** 2011-08-08 13:05:33.601
ORA-00020: No more process state objects available*** 2011-08-08 13:05:54.695
ORA-00020: No more process state objects available
***KELR Apply Log: unable to schedule MMON Slave, error 3*** 2011-08-08 13:06:33.710
ORA-00020: No more process state objects available*** 2011-08-08 13:06:54.726
ORA-00020: No more process state objects available
***KELR Apply Log: unable to schedule MMON Slave, error 3*** 2011-08-08 13:07:33.741
ORA-00020: No more process state objects available*** 2011-08-08 13:07:54.757
ORA-00020: No more process state objects available
***KELR Apply Log: unable to schedule MMON Slave, error 3*** 2011-08-08 13:08:33.772
ORA-00020: No more process state objects available*** 2011-08-08 13:08:54.788
ORA-00020: No more process state objects available
***KELR Apply Log: unable to schedule MMON Slave, error 3*** 2011-08-08 13:09:33.803
ORA-00020: No more process state objects available
*** 2011-08-08 13:09:39.850
DDE: Problem Key 'ORA 600 [kjhn_post_ha_alert0-862]' was flood controlled (0x2) (incident: 66157)
ORA-00600: 内部错误代码, 参数: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []
08/08/11 13:09:39 >ERROR: exception at dbms_ha_alerts_prvt.post_instance_up308: SQLCODE -600,ORA-00600: 内部错误代码, 参数: [kjh
n_post_ha_alert0-862], [], [], [], [], [], [], []
08/08/11 13:09:39 >ERROR: exception at dbms_ha_alerts_prvt.check_ha_resources76: SQLCODE -1400,ORA-01400: 无法将 NULL 插入 ("
SYS"."RECENT_RESOURCE_INCARNATIONS$"."INSTANCE_NAME")
08/08/11 13:09:39 >parameter dump for dbms_ha_alerts_prvt.check_ha_resources
08/08/11 13:09:39 > - local_db_unique_name (ItestPortalCenter)
08/08/11 13:09:39 > - local_db_domain (==N/A==)*** 2011-08-08 13:09:54.866
ORA-00020: No more process state objects available
***KELR Apply Log: unable to schedule MMON Slave, error 3*** 2011-08-08 13:10:33.881
ORA-00020: No more process state objects available*** 2011-08-08 13:10:54.897
ORA-00020: No more process state objects available
***KELR Apply Log: unable to schedule MMON Slave, error 3*** 2011-08-08 13:11:33.897
ORA-00020: No more process state objects available*** 2011-08-08 13:11:57.897
ORA-00020: No more process state objects available
***KELR Apply Log: unable to schedule MMON Slave, error 3*** 2011-08-08 13:12:33.897
ORA-00020: No more process state objects available*** 2011-08-08 13:13:00.897
ORA-00020: No more process state objects available
***KELR Apply Log: unable to schedule MMON Slave, error 3*** 2011-08-08 13:13:33.897
ORA-00020: No more process state objects available*** 2011-08-08 13:14:03.897
ORA-00020: No more process state objects available
***KELR Apply Log: unable to schedule MMON Slave, error 3*** 2011-08-08 13:14:33.928
ORA-00020: No more process state objects available
ORA-00020: No more process state objects available
ktte_monitor_ts: unable to schedule MMON Slave, error 3*** 2011-08-08 13:14:39.975
DDE: Problem Key 'ORA 600 [kjhn_post_ha_alert0-862]' was flood controlled (0x2) (incident: 66158)
ORA-00600: 内部错误代码, 参数: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []
08/08/11 13:14:39 >ERROR: exception at dbms_ha_alerts_prvt.post_instance_up308: SQLCODE -600,ORA-00600: 内部错误代码, 参数: [kjh
n_post_ha_alert0-862], [], [], [], [], [], [], []
08/08/11 13:14:39 >ERROR: exception at dbms_ha_alerts_prvt.check_ha_resources76: SQLCODE -1400,ORA-01400: 无法将 NULL 插入 ("
SYS"."RECENT_RESOURCE_INCARNATIONS$"."INSTANCE_NAME")
08/08/11 13:14:39 >parameter dump for dbms_ha_alerts_prvt.check_ha_resources
08/08/11 13:14:39 > - local_db_unique_name (ItestPortalCenter)
08/08/11 13:14:39 > - local_db_domain (==N/A==)*** 2011-08-08 13:15:04.006
ORA-00020: No more process state objects available
***KELR Apply Log: unable to schedule MMON Slave, error 3*** 2011-08-08 13:15:34.022
ORA-00020: No more process state objects available*** 2011-08-08 13:16:04.038
ORA-00020: No more process state objects available
***KELR Apply Log: unable to schedule MMON Slave, error 3*** 2011-08-08 13:16:34.053
ORA-00020: No more process state objects available*** 2011-08-08 13:17:04.069
ORA-00020: No more process state objects available
***KELR Apply Log: unable to schedule MMON Slave, error 3*** 2011-08-08 13:17:34.084
ORA-00020: No more process state objects available*** 2011-08-08 13:18:04.100
ORA-00020: No more process state objects available
***KELR Apply Log: unable to schedule MMON Slave, error 3*** 2011-08-08 13:18:34.116
ORA-00020: No more process state objects available*** 2011-08-08 13:19:04.131
ORA-00020: No more process state objects available
***KELR Apply Log: unable to schedule MMON Slave, error 3*** 2011-08-08 13:19:34.147
ORA-00020: No more process state objects available*** 2011-08-08 13:19:40.178
看到好几个错误代码：
1.ORA-01400
ORA-01400 cannot insert NULL into ("SCOTT"."A"."A1") : which means you
cannot insert NULL into "SCOTT"."A"."A1".
Action: Retry the operation with a value other than NULL.
2.ORA-00600
不清楚了。
CSDN搞DBA的同学呢，有木有。。
把db_recovery_file_dest_size扩大点。alter system set db_recovery_file_dest_size=3G，归档日志满了
ERROR: exception at dbms_ha_alerts_prvt.check_ha_resources76: SQLCODE -1400,ORA-01400: 无法将 NULL 插入 ("
SYS"."RECENT_RESOURCE_INCARNATIONS$"."INSTANCE_NAME")
ERROR: exception at dbms_ha_alerts_prvt.check_ha_resources76: SQLCODE -1400,ORA-01400: 无法将 NULL 插入 ("
SYS"."RECENT_RESOURCE_INCARNATIONS$"."INSTANCE_NAME")
是的，一直在报，SCOTT用户我们都没用。
ORA-00600: 内部错误代码, 参数: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []
Incident details in: e:\app\hwbyserver07\diag\rdbms\itestportalcenter\itestportalcenter\incident\incdir_82960\itestportalcenter_mmon_5808_i82960.trc
Thu Aug 11 17:55:24 2011
Trace dumping is performing id=[cdmp_20110811175524]
Thu Aug 11 17:55:24 2011
Sweep Incident[82960]: completed
Thu Aug 11 18:00:24 2011
Errors in file e:\app\hwbyserver07\diag\rdbms\itestportalcenter\itestportalcenter\trace\itestportalcenter_mmon_5808.trc  (incident=82961):
ORA-00600: 内部错误代码, 参数: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []
Thu Aug 11 18:00:24 2011
Sweep Incident[82961]: completed
Thu Aug 11 18:05:24 2011
Errors in file e:\app\hwbyserver07\diag\rdbms\itestportalcenter\itestportalcenter\trace\itestportalcenter_mmon_5808.trc  (incident=82962):
ORA-00600: 内部错误代码, 参数: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []
Thu Aug 11 18:05:24 2011
Sweep Incident[82962]: completed
Thu Aug 11 18:10:24 2011
Errors in file e:\app\hwbyserver07\diag\rdbms\itestportalcenter\itestportalcenter\trace\itestportalcenter_mmon_5808.trc  (incident=82963):
ORA-00600: 内部错误代码, 参数: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []
Thu Aug 11 18:10:25 2011
Sweep Incident[82963]: completed
Thu Aug 11 18:15:24 2011
Errors in file e:\app\hwbyserver07\diag\rdbms\itestportalcenter\itestportalcenter\trace\itestportalcenter_mmon_5808.trc  (incident=82964):
ORA-00600: 内部错误代码, 参数: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []
Thu Aug 11 18:15:25 2011
Sweep Incident[82964]: completed
Thu Aug 11 18:20:25 2011
Errors in file e:\app\hwbyserver07\diag\rdbms\itestportalcenter\itestportalcenter\trace\itestportalcenter_mmon_5808.trc  (incident=82965):
ORA-00600: 内部错误代码, 参数: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []
Thu Aug 11 18:20:25 2011
Sweep Incident[82965]: completed
Sweep Incident[82958]: completed
Thu Aug 11 18:25:25 2011
Errors in file e:\app\hwbyserver07\diag\rdbms\itestportalcenter\itestportalcenter\trace\itestportalcenter_mmon_5808.trc  (incident=82966):
ORA-00600: 内部错误代码, 参数: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []
Thu Aug 11 18:25:25 2011
Sweep Incident[82966]: completed
Thu Aug 11 18:30:25 2011
Errors in file e:\app\hwbyserver07\diag\rdbms\itestportalcenter\itestportalcenter\trace\itestportalcenter_mmon_5808.trc  (incident=82967):
ORA-00600: 内部错误代码, 参数: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []
Thu Aug 11 18:30:25 2011
Sweep Incident[82967]: completed
Thu Aug 11 18:35:25 2011
Errors in file e:\app\hwbyserver07\diag\rdbms\itestportalcenter\itestportalcenter\trace\itestportalcenter_mmon_5808.trc  (incident=82968):
ORA-00600: 内部错误代码, 参数: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []
Thu Aug 11 18:35:25 2011
Sweep Incident[82968]: completed
Thu Aug 11 18:40:25 2011
Errors in file e:\app\hwbyserver07\diag\rdbms\itestportalcenter\itestportalcenter\trace\itestportalcenter_mmon_5808.trc  (incident=82969):
ORA-00600: 内部错误代码, 参数: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []
Thu Aug 11 18:40:25 2011
Sweep Incident[82969]: completed
db_recovery_file_dest_size of 2048 MB is 0.00% used.
一点都没用，怎么会满呢
此问题属于oracle自身bug,bug号5173066，解决办法：
SQL>conn / as sysdba
SQL>create table r_r_i$bk as select * from recent_resource_incarnations$;
SQL>truncate table recent_resource_incarnations$;
SQL>shutdown;
SQL>startup;