oracle 10g上的ora-600 [19004]问题居然在11gr2上还有?
应用报600错误。
查日志发现果然有600错误。
alert log file:
Mon Dec 05 19:08:08 2011
Errors in file d:appibsadmindiagrdbmsorclorcltraceorcl_ora_3664.trc (incident=5137):
ora-00600: internal error code, arguments: [19004], [], [], [], [], [], [], [], [], [], [], []
Incident details in: d:appibsadmindiagrdbmsorclorclincidentincdir_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:appibsadmindiagrdbmsorclorcl
incidentincdir_5137orcl_ora_3664_i5137.trc
查看trace文件,发现是一个SQL导致的错误。
C:Documents and Settingsibsadmin>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
查看select
iis7站长之家:
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.