ORA-00600 [4146] while opening Database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: ORA-00600 [4146] while opening Database

  1. #1
    Join Date
    Jan 2003
    Location
    France
    Posts
    5

    ORA-00600 [4146] while opening Database

    Hello,

    We have these messages when we start our DB :

    PMON started
    DBWR started
    LGWR started
    Tue Jan 14 14:22:21 2003
    alter database mount exclusive
    Successful mount of redo thread 1.
    Tue Jan 14 14:22:21 2003
    Completed: alter database mount exclusive
    Tue Jan 14 14:22:21 2003
    alter database open
    Beginning crash recovery of 1 threads
    Crash recovery completed successfully
    Tue Jan 14 14:22:23 2003
    Thread 1 advanced to log sequence 214
    Current log# 1 seq# 214 mem# 0: /ora733/oracle/adminoralog/log1ADMIN.dbf
    Thread 1 opened at log sequence 214
    Current log# 1 seq# 214 mem# 0: /ora733/oracle/adminoralog/log1ADMIN.dbf
    Successful open of redo thread 1.
    Tue Jan 14 14:22:23 2003
    SMON: enabling cache recovery
    SMON: enabling tx recovery
    Tue Jan 14 14:22:24 2003
    Completed: alter database open
    Tue Jan 14 14:22:24 2003
    Errors in file /ora733/oracle/adminoralog/rdbms/smon_28778.trc:
    ORA-00600: internal error code, arguments: [4146], [41], [38], [], [], [], [], []

    We tried to suppress the rollback_segs from init.ora without effect.
    We tried to use _corrupted_rollback_segments without effect.
    Can you help us ?
    XD

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    when you have corrupted rollback segment you best bet is call support because depending on situation the way of solving is different

    to start with I would make a cold backup of your current database

  3. #3
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    Using _corrupted_rollback_segments is not a wise solution unless:
    1. You are a genius DBA and you know what you are doing
    2. Oracle support asks you to do so

    My suggestion is take a cold backup asap as pando has suggested and contact Oracle.
    Agasimani
    OCP(10g/9i/8i/8)

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    ORA-600 Lookup on Metalink.

    http://metalink.oracle.com/metalink/...&p_id=153788.1


    But it doesn't return anything for the argument in your ORA-600.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  5. #5
    Join Date
    Jan 2003
    Location
    France
    Posts
    5
    Now I can open the database (after the command ALTER DATABASE DATAFILE 'Path of the RBS.dbf' OFFLINE DROP') .... BUT !

    ... the RBS are in NEEDS RECOVERY status and I can't put them offline to drop them.

    I tried once again to use the _corrupted_rollback_segments parameter without success.
    I can't anymore drop the tablespace.

    Thanks for your help.
    XD

  6. #6
    Join Date
    Jan 2003
    Location
    France
    Posts
    5
    Some news :

    When I try to export the full database, I receveive these messages :

    EXP-00008: ORACLE error 376 encountered
    ORA-00376: file 2 cannot be read at this time
    ORA-01110: data file 2: 'Path of the RBS tablespace.dbf'

    ... for all the tables to export.

    Then core dump.....
    XD

  7. #7
    Join Date
    Dec 2002
    Location
    USA
    Posts
    53
    1. Shutdown the database and modified init.ora file,
    _offline_rollback_segments=R01, R02....

    2. Restart database and now those rollback_segments will be offline and you can drop them.

  8. #8
    Join Date
    Jan 2003
    Location
    France
    Posts
    5

    Cool

    I've found this solution :

    To put the datafile in OFFLINE status:
    - RECOVER DATABASE USING BACKUP CONTROLFILE
    then
    - ALTER DATABASE OPEN RESETLOGS

    Then using _CORRUPTED_ROLLBACK_SEGMENTS in init.ora it's possible to drop the RBS then their tablespace.

    Now I can re-create the tablespace (reusing the datafile) then re-create the rollback segments.
    XD

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