4 Replies Latest reply: Nov 12, 2012 5:52 PM by DoctorSparkle RSS

    ORA-00600 [rworupo.2]

    874532
      Hi,

      Today, we received OEM alert as DB encountered ORA-00600: internal error code, arguments: [rworupo.2], [2], [1], [], [], [], [] , [], [], [], [], [] error.

      When we verified the incident file, below is what we see:

      2011-07-11 00:00:24.080
      SESSION ID:(580.56971) 2011-07-11 00:00:24.080
      CLIENT ID:() 2011-07-11 00:00:24.080
      SERVICE NAME:(SYS$USERS) 2011-07-11 00:00:24.080
      MODULE NAME:(DBMS_SCHEDULER) 2011-07-11 00:00:24.080
      ACTION NAME:(ORA$AT_SQ_SQL_SW_1007) 2011-07-11 00:00:24.080

      There was no SQL statement in execution when this occurred.

      I looked a little in Oracle Support to find out the bug fix with no luck. Support documents suggested few bugs/articles for DBs lower than 11.2.0.2, but we are on 11.2.0.2.

      If anyone know any article/bug/patch, it would be greatly appreciated. And, I'm new to this forum. this is my very first post.

      Thanks
      Siraj
        • 1. Re: ORA-00600 [rworupo.2]
          Helios-GunesEROL
          ORA-00600: internal error code,

          You are gettion oracle internal error(ORA 600) which mean you could need to work wiht oracle support team. Please see below note, if its not help than i suggest log a sr:
          Troubleshoot an ORA-600 or ORA-7445 Error Using the Error Lookup Tool [ID 153788.1]

          Regard
          Helios
          • 2. Re: ORA-00600 [rworupo.2]
            CKPT
            Today, we received OEM alert as DB encountered ORA-00600: internal error code, arguments: [rworupo.2], [2], [1], [], [], [], [] , [], [], [], [], [] error.

            When we verified the incident file, below is what we see:
            Check this metalink note.

            *ORA-600 [rworupo.2] [ID 265937.1]*

            Subit alert & trace files to support further for any internal errors.
            • 3. Re: ORA-00600 [rworupo.2]
              user12002557
              I have the same issue on an 11.2.0.2 database and do not see any resolution on Metalink. I will open an SR but was wondering if Siraj found an answer.

              *** 2012-03-19 22:00:26.768
              *** SESSION ID:(217.42513) 2012-03-19 22:00:26.768
              RA$AT_SQ_SQL_SW_5706
              *** CLIENT ID:() 2012-03-19 22:00:26.768
              *** SERVICE NAME:(SYS$USERS) 2012-03-19 22:00:26.768
              *** MODULE NAME:(DBMS_SCHEDULER) 2012-03-19 22:00:26.768
              *** ACTION NAME:(ORA$AT_SQ_SQL_SW_5706) 2012-03-19 22:00:26.768

              Thanks!
              • 4. Re: ORA-00600 [rworupo.2]
                DoctorSparkle
                Hi,
                I also received this error in 11.2.0.3 and was presented with this bug as the possible cause:
                Bug 14576583 : ORA-600 [RWORUPO.2]
                ORA-600 [rworupo.2] error is reported on top of 11.2.0.2 when using the SQL Performance Analyzer (SPA).
                Bug is not fixed and there are no patches as of 13/11/2012
                Work around is to disable the autotask (for the job), and let it sit overnight. Then, the next day, re-enable the autotask.
                I hope this helps someone.
                Daz