ORA-00600 [6033] 错误解决

2011年9月2日
检查警告日志文件发现以下错误信息：
Fri Sep 2 09:28:40 2011
Errors in file /oraclelog/ngcrm/udump/ngcrm2_ora_24392.trc:
ORA-00600: internal error code, arguments: [6033], [], [], [], [], [], [], []

查看跟踪文件，信息如下：
*** ACTION NAME:() 2011-09-02 09:28:40.102
*** MODULE NAME:(tcscrm1l1serve@crminf2 (TNS V1-V3)) 2011-09-02 09:28:40.102
*** SERVICE NAME:(ngcrm) 2011-09-02 09:28:40.102
*** SESSION ID:(1031.5785) 2011-09-02 09:28:40.102
*** 2011-09-02 09:28:40.101
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [6033], [], [], [], [], [], [], []
Current SQL statement for this session:
SELECT to_char(TRADE_ID) TRADE_ID,to_char(SUBSCRIBE_ID) SUBSCRIBE_ID,to_char(BPM_ID) BPM_ID,TRADE_TYPE_CODE,IN_MODE_CODE,PRIOR
ITY,SUBSCRIBE_STATE,NEXT_DEAL_TAG,PRODUCT_ID,BRAND_CODE,to_char(USER_ID) USER_ID,to_char(CUST_ID) CUST_ID,to_char(USECUST_ID)
USECUST_ID,to_char(ACCT_ID) ACCT_ID,USER_DIFF_CODE,NET_TYPE_CODE,SERIAL_NUMBER,CUST_NAME,to_char(ACCEPT_DATE,'yyyy-mm-dd hh24:
mi:ss') ACCEPT_DATE,ACCEPT_MONTH,TRADE_STAFF_ID,TRADE_DEPART_ID,F_SYS_GETCODENAME('depart_id', TRADE_DEPART_ID, '', '') DEPART
_NAME,TRADE_CITY_CODE,TRADE_EPARCHY_CODE,TERM_IP,EPARCHY_CODE,CITY_CODE,OLCOM_TAG,to_char(EXEC_TIME,'yyyy-mm-dd hh24:mi:ss') E
XEC_TIME,to_char(FINISH_DATE,'yyyy-mm-dd hh24:mi:ss') FINISH_DATE,to_char(OPER_FEE) OPER_FEE,to_char(FOREGIFT) FOREGIFT,to_cha
r(ADVANCE_PAY) ADVANCE_PAY,INVOICE_NO,FEE_STATE,to_char(FEE_TIME,'yyyy-mm-dd hh24:mi:ss') FEE_TIME,FEE_STAFF_ID,CANCEL_TAG,to_
char(CANCEL_DATE,'yyyy-mm-dd hh24:mi:ss') CANCEL_DATE,CANCEL_STAFF_ID,CANCEL_DEPART_ID,CANCEL_CITY_CODE,CANCEL_EPARCHY_CODE,CH
ECK_TYPE_CODE,CHK_TAG,AUDIT_TAG,AUDIT_BATCH_NO,ACTOR_NAME,ACTOR_CERTTYPEID,ACTOR_PHONE,ACTOR_CERTNUM,CONTACT,CONTACT_PHONE,CON
TACT_ADDRESS,REMARK,IF_MAINTENANCE
FROM TF_B_TRADE
WHERE trade_id=TO_NUMBER(:VTRADE_ID)
and accept_month = TO_NUMBER(SUBSTR(:VTRADE_ID,5,2))

----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+64 call ksedst1() 000000000 ? 000000001 ?

查看Oracle Support，已知的ORA-600：[6033]
ORA-600 [6033] "null value retrieved from index leaf lookup" [ID 45795.1]
Modified 03-JUN-2010 Type REFERENCE Status PUBLISHED
Note: For additional ORA-600 related information please read Note:146580.1

PURPOSE:
This article represents a partially published OERI note.
It has been published because the ORA-600 error has been
reported in at least one confirmed bug.
Therefore, the SUGGESTIONS section of this article may help
in terms of identifying the cause of the error.
This specific ORA-600 error may be considered for full publication
at a later date. If/when fully published, additional information
will be available here on the nature of this error.

SUGGESTIONS:
Run the ANALYZE command on any tables and indexes in the
trace file:
Example: ANALYZE TABLE VALIDATE STRUCTURE CASCADE;
Rebuild any corrupted indexes.
If the Known Issues section below does not help in terms of identifying
a solution, please submit the trace files and alert.log to Oracle
Support Services for further analysis.

Known Bugs
NB Bug Fixed Description
6401576 9.2.0.8.P22 OERI[ktbair1] / ORA-600 [6101] index corruption possible
5845232 9.2.0.8.P06 Block corruption / errors from concurrent dequeue operations
2718937 9.2.0.4, 10.1.0.2 OERI:6033 from SELECT on IOT with COMPRESSED PRIMARY KEY
1573283 8.1.7.2, 9.0.1.0 OERI:6033 from ALTER INDEX .. REBUILD ONLINE PARAMETERS ('OPTIMIZE FULL')

通过analyze table validate structure cascade命令验证表和索引，然后重建有问题的索引。

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26121829/viewspace-1054686/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26121829/viewspace-1054686/