oracle 10g上的ora-600 [19004]问题居然在11gr2上还有？
oracle 10g上的ora-600 [19004]问题居然在11gr2上还有？
应用报600错误。
查日志发现果然有600错误。
alert log file:
mon dec 05 19:08:08 2011
errors in file d:\app\ibsadmin\diag\rdbms\orcl\orcl\trace\orcl_ora_3664.trc  (incident=5137):
ora-00600: internal error code, arguments: [19004], [], [], [], [], [], [], [], [], [], [], []
incident details in: d:\app\ibsadmin\diag\rdbms\orcl\orcl\incident\incdir_5137\orcl_ora_3664_i5137.trc
mon dec 05 19:08:14 2011
microsoft windows [version 5.2.3790]
(c) copyright 1985-2003 microsoft corp.
c:\documents and settings\ibsadmin>notepad d:\app\ibsadmin\diag\rdbms\orcl\orcl\
incident\incdir_5137\orcl_ora_3664_i5137.trc
查看trace文件，发现是一个sql导致的错误。
c:\documents and settings\ibsadmin>sqlplus / as sysdba
sql*plus: release 11.2.0.1.0 production on mon dec 5 19:18:53 2011
copyright (c) 1982, 2010, oracle.  all rights reserved.
connected to:
oracle database 11g enterprise edition release 11.2.0.1.0 - production
with the partitioning, olap, data mining and real application testing options
查看版本：
sql> select * from v$version;
banner
-----------------------------------------------------------------------------
oracle database 11g enterprise edition release 11.2.0.1.0 - production
pl/sql release 11.2.0.1.0 - production
core    11.2.0.1.0      production
tns for 32-bit windows: version 11.2.0.1.0 - production
nlsrtl version 11.2.0.1.0 - production
查看报错语句：
sql> select cv.custom_field_entity_id id, cfe.sequence, cfe.is_active, value fro
m custom_field_entity cfe, custom_field_value cv where cv.custom_field_entity_id
 = cfe.id;
select cv.custom_field_entity_id id, cfe.sequence, cfe.is_active, value from cus
tom_field_entity cfe, custom_field_value cv where cv.custom_field_entity_id = cf
e.id
                      *
error at line 1:
ora-00942: table or view does not exist
sql> conn businessdata
connected.
sql> select cv.custom_field_entity_id id, cfe.sequence, cfe.is_active, value fro
m custom_field_entity cfe, custom_field_value cv where cv.custom_field_entity_id
 = cfe.id;
select cv.custom_field_entity_id id, cfe.sequence, cfe.is_active, value from cus
tom_field_entity cfe, custom_field_value cv where cv.custom_field_entity_id = cf
e.id
                                                                             *
error at line 1:
ora-00600: internal error code, arguments: [19004], [], [], [], [], [], [], [],
[], [], [], []
在10g里可以通过删除统计数据来解决这一问题。在这里也试试。
sql>
sql> execute dbms_stats.delete_schema_stats('businessdata')
pl/sql procedure successfully completed.
再执行sql已经没有问题了。
奇怪的是：
for oracle 10.2.0.3  install patch for bug#5579764. the bug has been fixed in 11g.----看来在windows还有这个问题。
follow instructions of metalink note 390249.1 and delete column histograms.
，