DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ora-12801

  1. #1
    Join Date
    Sep 2003



    i am trying to run a query that uses dblink.
    the wquery works fine at times and execution time is also quick but some time i get the following errors

    [1]: (Error): ORA-12801: error signaled in parallel query server P008, instance abcet:SQUAD5(5) ORA-00600: internal error code, arguments: [ktsxaffs1], [], [], [], [], [], [], [] ORA-02063: preceding 2 lines from SQUAD

    any solution to this.

    Thanks in advance

  2. #2
    Join Date
    Mar 2002
    Mesa, Arizona
    ORA-02063: "preceding %s%s from %s%s"

    Cause: an Oracle error was received from a remote database link.
    Action: refer to the preceding error message(s)

    It's your 600 error from the remote database (SQUAD?) that needs to be addressed, and a metalink TAR is probably your best option at this point. It's definately a obscure error.

    No "ktsxaffs1" hits on metalink, a couple on google .. unfortunately it's a chinese blog.

    Here's the only readable stuff I could find.

    oracle9205 rac aix5.2.0.4 hacmp5.1
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #3
    Join Date
    Sep 2003


    Thanks Ken,

    yes i was also trying to get some info .... i didn't get much on the net.

    need to check with metalink.


  4. #4
    Join Date
    Jan 2001
    If it is intermittent then me thinks it could be a network problem.

    Can you test the SQL locally on the other box and see if you get the error.
    Or ping the box when you get the error, see if there are any glitches.
    I remember when this place was cool.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.