help!! oracle8.1.5.0 has been crash down!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: help!! oracle8.1.5.0 has been crash down!

  1. #1
    Join Date
    Nov 2004
    Posts
    1

    Unhappy help!! oracle8.1.5.0 has been crash down!

    help!! oracle8.1.5.0 has been crash down!

    when i truncate a table ,suddenly ,the power has down . when i turn on the server and i could not startup the database. and then i tail alert.log and found
    ORA-00600: internal error code, arguments: [2023], [5], [1], [], [], [], [], []
    Mon Nov 8 13:25:47 2004
    PMON: terminating instance due to error 474
    Instance terminated by PMON, pid = 4220

    I use google to search above message and found that was oracle's bug
    this bug would appear in oracle8i to oracle9i when use truncate a table and truncate's process suddenly abort .

    The sticking point was system has dirty information. i had been used
    _corrupted_rollback_segments(system) to drop the system table,when i startup the database ,it indicate that it was not the correct parameter to oracle.

    how can i do ? plesase help me!

  2. #2
    Join Date
    Nov 2004
    Location
    India
    Posts
    9

    Reply

    Hi,

    Probably you need to reinstall the database.

    But before that please checkout the process with pis=4220 is running or not if it is running kill that process and try again.

    Hope this helps

    Regards,
    Jigar D Pota
    Oracle Certified DBA
    India
    98791 88534
    (The Final Frontier !!)

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: Reply

    Originally posted by jigarpota
    Hi,

    Probably you need to reinstall the database.

    But before that please checkout the process with pis=4220 is running or not if it is running kill that process and try again.

    Hope this helps

    Regards,
    It clearly indicates that the process 4220 was of PMON which killed the instance. And when the instance went down PMON will go down by itself.

    As to handle the main question. Better log a priority 1 iTAR. If possible try recovering the database using archived log files if in archived mode, if not then only way to recover would be to restore the cold backup.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #4
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    150
    This has happened to me before. All you need to do is to perform an incomplete recovery up to the time before you issue the 'truncate' command.

    Goodluck.

    Ed

  5. #5
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187

    Re: help!! oracle8.1.5.0 has been crash down!

    Originally posted by kevinkan
    help!! oracle8.1.5.0 has been crash down!

    when i truncate a table ,suddenly ,the power has down . when i turn on the server and i could not startup the database. and then i tail alert.log and found
    ORA-00600: internal error code, arguments: [2023], [5], [1], [], [], [], [], []
    Mon Nov 8 13:25:47 2004
    PMON: terminating instance due to error 474
    Instance terminated by PMON, pid = 4220

    I use google to search above message and found that was oracle's bug
    this bug would appear in oracle8i to oracle9i when use truncate a table and truncate's process suddenly abort .

    The sticking point was system has dirty information. i had been used
    _corrupted_rollback_segments(system) to drop the system table,when i startup the database ,it indicate that it was not the correct parameter to oracle.

    how can i do ? plesase help me!
    drop the system table?
    I'm stmontgo and I approve of this message

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