oracle数据库 Remote error: ORA-00600: 内部错误代码, 参数: [qerpxInitialize],

发布网友发布时间：2022-04-11 20:55

共2个回答

热心网友时间：2022-04-11 22:24

Bug 7308675 OERI:qerpxInitialize from parallel query using CONNECT BY
This note gives a brief overview of bug 7308675.
The content was last updated on: 27-MAY-2009
Click here for details of each of the sections below.

Affects:
Proct (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)

Symptoms:

Related To:

Internal Error May Occur (ORA-600)
ORA-600 [qerpxInitialize]

Connect By / Hierarchical Queries
Parallel Query (PQO)

Description
A select query using a connect-by clause executing using
parallel query may fail with ORA-600 [qerpxInitialize].

你这语句是否并行执行了，如果是那么改成串行可能可以解决该问题

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

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

热心网友时间：2022-04-11 23:42

ora-00600一般是内部错误，难道你遇到oracle的bug了？
将你的sql语句换种写法试试。