This discussion is archived
4 Replies Latest reply: Nov 12, 2012 3:52 PM by DoctorSparkle RSS

ORA-00600 [rworupo.2]

874532 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points