ORA-00600: internal error code, arguments: [evapth : unexpected evaluation], [], [], [], [], [], [],

正看着书呢，突然收到监控平台发来的一条短信：数据出现了ORA-00600: internal error code, arguments: [evapth : unexpected evaluation], [], [], [], [], [], [], []的内部错误，赶紧跑去机房看一下，结果被告知是这个错误是有个哥们在执行一个SQL后造成的，还好只是虚惊一场，不过自己还是想把这问题搞个明白。服务器：AIX 5309数据库：Oracle 10.2.0.4
当时那哥们正在执行的语句是：select distinct t1.loan_no ,--,
       t.customer_cname ,
       t3.industry_class1_name ,
       t3.industry_class1_code,
       t3.industry_class2_name,
       t3.industry_class2_code,
       t3.industry_class3_name,
       t3.industry_class3_code,
       t3.industry_class4_name,
       t3.industry_class4_code,
       t.customer_scale "大中小微分类",
       t7.second_type,
       t7.first_type,
       t7.path_code,
       t7.path_name,
       t2.loan_start_date,
       t2.mature_date,
       t2.loan_amt "发放金额",
       t2.cmis_five_class,
       t1.loan_amt "贷款余额",
       t4.sec_code,
       t4.sec_name,
       t4.fir_code,
       t4.fir_name,
       t.customer_id
      -- sum（t1.loan_amt）
from srcb_ods.c_customer_info t,srcb_fsd.cl_loan_acct t1,srcb_fsd.cl_loan t2,
srcb_fsd.country_standard_industry_clas t3,srcb_fsd.com_bank_hierarchy t4,srcb_fsd.prod_map_tbl t6,
（select t5.loan_type_id,connect_by_root t5.loan_type_id as second_type, connect_by_root t5.upper_loan_type_id as first_type,
sys_connect_by_path（t5.loan_type_id, "/"） as path_code,sys_connect_by_path（t5.loan_type_name, "/"） as path_name
from los.loan_type_info@los t5 start with t5.loan_type_id<>t5.upper_loan_type_id
connect by nocycle prior t5.loan_type_id = t5.upper_loan_type_id） t7
where t.data_date = "20120229"
   and t1.fdate="20120229"
   and t.customer_id=t1.client_no
   and t2.fdate="20120229"
   and t1.loan_no=t2.loan_no
   and substr（t.industry_id,2）=t3.industry_class4_code
   and t2.loan_branch=t4.fir_code
   and t4.fiv_code="00001"
   and t1.settle_ind="N"
-- and t.customer_scale="01"
   and t2.loan_cate="01"
   and t2.loan_sub_type=t6.fsd_prod_code
   and t6.s_prod_code=t7.loan_type_id
   order by t4.sec_code,t4.fir_code,t.customer_id
在网上Google和在MOS上查了一些，都说是因为使用了sys_connect_by_path的原因，注意SQL中的红色部分，单独执行红色SQL是没问题的，但是如果整个SQL语句一起执行的话就会报错。这说明该错误不是那个子SQL造成的，而是与其他语句结合才会出现的错误（Bug）。
注明：不过还发现一个比较奇怪的问题，就是同样是这条语句，我在另一套环境执行则是没问题的。不知道为何，两套环境的数据库补丁集神马都是一样的。

直接附官文：

ORA-600 [evapth : unexpected evaluation] [ID 284511.1]

		修改时间 19-DEC-2011 类型 REFERENCE 状态 PUBLISHED

Note: For additional ORA-600 related information please read Note:146580.1PURPOSE: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 helpin terms of identifying the cause of the error.This specific ORA-600 error may be considered for full publicationat a later date. If/when fully published, additional information will be available here on the nature of this error.ERROR:ORA-600 [evapth : unexpected evaluation] [a] [b] [c] [d] [e]SUGGESTIONS:If the Known Issues section below does not help in terms of identifyinga solution, please submit the trace files and alert.log to Oracle Support Services for further analysis.Known Issues:Bug# 5262483 See Note:5262483.8OERI[evapth : unexpected evaluation] from CONNECT BY queryFixed: 10.2.0.5, 11.2 Bug# 5234295 See Note:5234295.8OERI[evapth : unexpected evaluation] from SYS_CONNECT_BY_PATHFixed: 10.2.0.5, 11.1.0.6 Bug# 3703176 See Note:3703176.8OERI[evapth : unexpected evaluation] selecting from set view using SYS_CONNECT_BY_PATHFixed: 9.2.0.7, 10.1.0.4, 10.2.0.1 Bug# 3365439 See Note:3365439.8OERI[evapth : unexpected evaluation] using SYS_CONNECT_BY_PATHFixed: 9.2.0.7, 10.1.0.4, 10.2.0.1 Bug# 2627306 See Note:2627306.8OERI:[evapth : unexpected evaluation] using SYS_CONNECT_BY_PATH（）Fixed: 9.2.0.4, 10.1.0.2

Bug 5234295 - OERI[evapth : unexpected evaluation] from SYS_CONNECT_BY_PATH [ID 5234295.8]

		修改时间 13-JUL-2011 类型 PATCH 状态 ARCHIVED

Bug 5234295 OERI[evapth : unexpected evaluation] from SYS_CONNECT_BY_PATH

This note gives a brief overview of bug 5234295.
The content was last updated on: 27-MAY-2009
Click here for details of each of the sections below.

Affects:

Product （Component） Oracle Server （Rdbms）
Range of versions believed to be affected Versions < 11
Versions confirmed as being affected
10.2.0.4
Platforms affected Generic （all / most platforms affected）

Fixed:

This issue is fixed in
10.2.0.5 （Server Patch Set）
11.1.0.6 （Base Release）

Symptoms:	Related To:
Internal Error May Occur （ORA-600） ORA-600 [evapth : unexpected evaluation]	Connect By / Hierarchical Queries

Description

An invalid evaluation of the SYS_CONNECT_BY_PATH with a PRIOR clause in frontof it during execution of a CONNECT BY START WITH statement can failwith an ORA-600 .WorkaroundUse a NO_CONNECT_BY_FILTERING hint on the query.

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice.

References

Bug:5234295 （This link will only work for PUBLISHED bugs）
Note:245840.1 Information on the sections in this article

netca报错： line 190: 16835 AbortedOracle 11g不能在创建具有重复列的函数索引了相关资讯 Oracle错误代码

Oracle错误代码大全（02/16/2015 21:31:57）
Oracle中登陆时报ORA-28000: the （03/06/2013 20:06:23）
Oracle 11g startup时报ORA-03113 （02/21/2013 17:25:55）

Oracle Grid Control OUI-25031错（03/09/2013 09:01:36）
ORA-04091:触发器/函数不能读（02/25/2013 08:28:13）
Oracle错误 ORA-12514 解决方法（02/18/2013 08:50:10）

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

*Product （Component）*	Oracle Server （Rdbms）
*Range of versions believed* to be affected**	Versions < 11
*Versions confirmed* as being affected**	10.2.0.4
Platforms affected	Generic （all / most platforms affected）