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:appibsadmindiag dbmsorclorcl raceorcl_ora_3664.trc （incident=5137）:
ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], [], [], [], [], []
Incident details in: d:appibsadmindiag dbmsorclorclincidentincdir_5137orcl_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 Settingsibsadmin>notepad d:appibsadmindiag dbmsorclorcl
incidentincdir_5137orcl_ora_3664_i5137.trc
查看trace文件，发现是一个SQL导致的错误。
C:Documents and Settingsibsadmin>sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 5 19:18:53 2011Copyright （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.Oracle 11g R2用EXP导出时报EXP-00011错误的解决Oracle时间类型date,timestamp时间差计算相关资讯 Oracle基础教程

Oracle块编程返回结果集详解（11/10/2013 10:45:58）
Oracle基础教程之设置系统全局区（08/22/2013 14:24:00）
Oracle基础教程知识点总结（06/18/2013 07:43:32）

Oracle基础教程之tkprof程序详解（10/22/2013 11:49:50）
Oracle基础教程之sqlplus汉字乱码（07/18/2013 16:30:00）
Oracle 管理之 Linux 网络基础（02/16/2013 18:37:35）

本文评论查看全部评论（0）