正看着书呢，突然收到监控平台发来的一条短信：数据出现了ORA-00600: internal error code, arguments: [evapth : unexpected ev

正看着书呢，突然收到监控平台发来的一条短信：数据出现了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.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. ERROR: ORA-600 [evapth : unexpected evaluation] [a] [b] [c] [d] [e] SUGGESTIONS: 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 Issues: Bug# 5262483 See Note:5262483.8 OERI[evapth : unexpected evaluation] from CONNECT BY query Fixed: 10.2.0.5, 11.2 Bug# 5234295 See Note:5234295.8 OERI[evapth : unexpected evaluation] from SYS_CONNECT_BY_PATH Fixed: 10.2.0.5, 11.1.0.6 Bug# 3703176 See Note:3703176.8 OERI[evapth : unexpected evaluation] selecting from set view using SYS_CONNECT_BY_PATH Fixed: 9.2.0.7, 10.1.0.4, 10.2.0.1 Bug# 3365439 See Note:3365439.8 OERI[evapth : unexpected evaluation] using SYS_CONNECT_BY_PATH Fixed: 9.2.0.7, 10.1.0.4, 10.2.0.1 Bug# 2627306 See Note:2627306.8 OERI:[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]

下载本文