ORA-00600 qerpxinitialize

This morning, I saw another bug during inspection:

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

Bug 7308675 oeri: qerpxinitialize from parallel query using connect

This note gives a brief overview of bug 7308675.

The content was last updated on: 27-might-2009

Click here for details of each of the sections below.

Affects:

Product (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:
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].WorkaroundExecute the query serially.

 

Please note:The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice.

 

References

Bugs: 7308675 (this link will only work for published bugs)
Note: 245840.1 information on the sections in this article

ORA-00600 qerpxinitialize