Urgent: Ora 600 need advice
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Urgent: Ora 600 need advice

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Hello my client was attempting to drop an invalid procedure but when he did that as the owner of the procedure
    he got this ORA-00600: internal error code, arguments: [4882], [104778064], [72136508], [104715400], [], [],
    [], [].
    some kind of dead lock. We attempted to drop the procedure using system and received same error. I feel that that procedure is somehow locked. I tried killing the session of that user but it didnt release the locks nor did it rollback anthing.

    please help
    thanks
    Jigar

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Check dba_ddl_locks to see if anybody else has that object locked. In general, ORA-600 messsages indicate a bug with oracle and should be reported to Oracle Support.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    This is a 7.3.4 database. Please advice.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    OK. Are you saying that there is no DBA_DDL_LOCKS or that you can't contact Oracle Support?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Yes dba_ddl_locks doesnt exists in 7.3.4

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You've got a real problem. I'm not very fluent on 7.x, in 8.1.5 the view is created via catblock.sql.

    Other than that, you could bounce the db and bring it up in restricted mode and drop it from there.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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