Home » RDBMS Server » Server Administration » I've got the ORA-600 error, but metalink can not help me much more! (Linux x86_64, Oracle 9.2.0.1)
I've got the ORA-600 error, but metalink can not help me much more! [message #381591] |
Sun, 18 January 2009 21:37 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
trantuananh24hg
Messages: 744 Registered: January 2007 Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
Hi all!
Before I post here, I've just searched in Google/at_here_OraFaq/Metalink. I've got error:
Quote: |
ORA-12801: error signaled in parallel query server P000
ORA-00600: internal error code, arguments: [ksmals], [qrarr], [], [], [], [], [], []
|
At metalink, I found that, this is the bug 3204937
Bug 3204937 PQ slave may fail with OERI [ksmals], [qrarr]
https://metalink.oracle.com/metalink/plsql/f?p=130:14:8043186014275975382::::p14_database_id,p14_docid,p14_show_header,p14_show_help, p14_black_frame,p14_font:NOT,3204937.8,1,0,1,helvetica
But it can not help me to solve the problem.
Whenever execute the query with ORDER BY, I've got this error.
May you help me?
Thank you!
|
|
|
|
|
|
Re: I've got the ORA-600 error, but metalink can not help me much more! [message #381602 is a reply to message #381600] |
Sun, 18 January 2009 22:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
trantuananh24hg
Messages: 744 Registered: January 2007 Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
Yeap!
The Oracle database bug list introduces only the brief information, not internal why, what, and how.
Example:
http://www.wowunix.com/down/patch/oracle/patchset/man/9207_buglist.htm
Some time, I might work as with my experience, some time I can not.
With this error, because of the result was not slowly with few rows to retrieve, ~ 20.000 rows, no such more sessions call concurrently, then I removed parallel hint in this query and it works now.
But I think I need to upgrade to 9.2.0.7.
Thanks again!
|
|
|
|
Goto Forum:
Current Time: Mon Aug 26 03:40:39 CDT 2024
|