ORACLE出现ORA-00600: internal error code, arguments: [qcsfbdnp:1]该如何解决

来源：百度知道 编辑：UC知道 时间：2024/05/15 04:05:13
出现问题：
Error 500: PreparedStatementCallback; uncategorized SQLException for SQL [ select TO_CHAR(LEVEL) mod_order, a.* from (SELECT distinct R.MOD_ID, R.MOD_Name, R.MOD_POWER, MOD_USEABLE, R.MOD_MANAGER, r.mod_fatherid, r.mod_sort FROM gy_module R where (R.mod_type = '1' or r.mod_type is null) and R.mod_useable = '1' connect by prior mod_fatherid = mod_id start with mod_id in ( select m.mod_id from gy_rept001 r, gy_module m where (m.mod_type = '1' or m.mod_type is null) and m.mod_useable = '1' and r.r0102 = m.mod_id and r.reportid in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) union all select m.mod_id from gy_rept002 r, gy_module m where (m.mod_type = '1' or m.mod_type is null) and m.mod_useable = '1' and r.r0102 = m.mod_id and r.reportrunid in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ) union all select r.reportid, r.r0101, 'T', '3', '', m.mod_id, '0' from gy_rept001 r, gy_module m where (m.mod_type = '1' or m.

这个bug 和绑定变量有关，去掉绑定变量可以workaround，但要改程序。

另外可能与cursor_sharing参数的设置有关，具体要看alert.log

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队