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

Thread: What is this error?

  1. #1
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178

    What is this error?

    SQL> alter database mount;
    alter database mount
    *
    ERROR at line 1:
    ORA-00600: internal error code, arguments: [1403], [], [], [], [], [], [], []


    How do I fix this?

  2. #2
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282
    ORA-00600 is an internal error, contact oracle support.



    F.

  3. #3
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178
    I created a UNDO tablespace and added:

    UNDO_MANGEMENT = AUTO
    UNTO_TABLESPACE = UNDOTBS1

    and restarted a 9.2 database and it won't start giving the above error. Luckily I have a cold backup at 11.26am this morning and I restored the cold backup and now even startup mount hangs like this:

    ORA-00600: internal error code, arguments: [549], [], [], [], [], [], [], []

    What could be wrong? I am on win2000 server. Is it a win2000 issue? I have 2- 9.2 databases running on this machine with about 512Meg. memory. The other database is working fine.
    Last edited by newbie5; 02-05-2003 at 04:09 PM.

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by Mnemonical
    ORA-00600 is an internal error, contact oracle support.
    yes yeS yES YES

    Not your fault at all, newbie5! (probably).
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    UNDO_MANGEMENT = AUTO
    UNTO_TABLESPACE = UNDOTBS1

    is that a typo or what
    plus restoring old backup have you changed your init.ora to old setting?

  6. #6
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178
    Yes typo on Undo_Tablespace.

    I restored the init.ora and the spfile.ora.

    If there are two oracle9.2 instances on win2000 server, do I need to change any memory settings like unix semaphores?

  7. #7
    Join Date
    May 2002
    Posts
    2,645
    What is UNDO_MANGEMENT? Did you mean UNDO_MANAGEMENT?

  8. #8
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178
    They are just typos in this post! Not actual init.ora entries! Had a rough day!!!

    After battling four hours and offline dropping few datafiles I could bring the database up (without oracle support). However, it is very slow now. Shutdown takes 15 minutes!! startup another 15 minutes!!.

    Can someone ignore my typos and gimme some hints are what is going on!!
    Last edited by newbie5; 02-05-2003 at 07:04 PM.

  9. #9
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    post the trace files

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