3 Replies Latest reply: Feb 21, 2013 1:46 AM by Marwim RSS

    Data Insertion error

    986109
      ORA-12801: error signaled in parallel query server P039
      ORA-00600: internal error code, arguments: *[kole_case-1]*, [], [], [], [], [], [], [], [], [], [], []

      Kindly put some light on the error..?
      thanks
        • 1. Re: Data Insertion error
          Marwim
          Hello,

          without further information it is hard to tell {message:id=9360002}
          Usually an ORA-00600 means: Contact Oracle Support (or at least search the knowledgebase at My Oracle Support)

          Regards
          Marcus
          • 2. Re: Data Insertion error
            986109
            Hi Marcus, I can share the trace file..


            *** 2013-02-20 13:26:44.515
            *** SESSION ID:(137.60889) 2013-02-20 13:26:44.515
            *** CLIENT ID:() 2013-02-20 13:26:44.515
            *** SERVICE NAME:(xyz) 2013-02-20 13:26:44.515
            *** MODULE NAME:(xyd) 2013-02-20 13:26:44.515
            *** ACTION NAME:() 2013-02-20 13:26:44.515

            Incident 132418 created, dump file: /DBsvr/app/oracle/diag/rdbms/xyz/xyz/incident/incdir_132418/xyz_ora_23455_i132418.trc
            ORA-00600: internal error code, arguments: [kole_case-1], [], [], [], [], [], [], [], [], [], [], []

            qerpxFetch
            rwsrid:3 pxid:1 qbas:542006:err:12801
            ----- Explain Plan Dump -----
            ----- Compact Format (Stream) -----
            • 3. Re: Data Insertion error
              Marwim
              I can't say more than
              Contact Oracle Support (or at least search the knowledgebase at My Oracle Support)
              ORA-00600 is an internal error. If you cannot find a solution at My Oracle Support then you have to open a Service Request and Oracle will ask for the necessary information.

              I doubt that you will get help at the forum, especially since a search for kole_case in the knowledge base returned only one result about a bug (Fixed: 9.2.0.5, 10.1.0.2)

              Regards
              Marcus

              Edited by: Marwim on 21.02.2013 08:42
              BTW: This is the wrong forum for this question. It is about the tool {forum:id=260}. Your question might be asked at {forum:id=75} or {forum:id=61}. Though I still think that you really should contact support.