求教ORACLE的问题，我用的是ORACLE 9I，出现一个ORA-00600:内部错误代码，参数：[qernsRowP],[1],[]....

发布网友发布时间：2022-08-18 13:43

共3个回答

热心网友时间：2023-10-18 06:28

SYMPTOMS
A query involving joins fails with the following error : ORA-600 [qernsRowP]
The call stack in the trace file written by the error includes the functions:

qernsRowP <- qertbFetchByRowID

The parameter star_transformation_enabled is set to true.
CAUSE
This is reported as unpublished bug:6316993, fixed in the 10.2.0.4 patchset.

SOLUTION
1.To workaround the issue either:

a) alter session set star_transformation_enabled=false
or in the (s)pfile: STAR_TRANSFORMATION_ENABLED=False
or:

b) set in the pfile : event="38047 trace name context forever, level 1"
or if using SPFILE:
SQL> alter system set event="38047 trace name context forever, level 1" scope=spfile;

可以尝试设置 STAR_TRANSFORMATION_ENABLED=False 来绕过该问题

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

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

热心网友时间：2023-10-18 06:28

ora-00600基本上是oracle版本的bug,只是改自己的东西了

热心网友时间：2023-10-18 06:29

这个错误是oracle内部bug造成的，建议你你升级oracle版本吧