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.
