紧急求助
现在数据库一直都在使用,有没有不打补丁的解决方案
第1个回答 2014-07-30
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数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
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数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
第2个回答 2011-06-27
ora-00600基本上是oracle版本的bug,只是改自己的东西了本回答被提问者采纳
第3个回答 2011-06-27
这个错误是oracle内部bug造成的,建议你你升级oracle版本吧