1 2 Previous Next 22 Replies Latest reply: Feb 27, 2013 1:01 PM by rukbat RSS

    ORA-00600: internal error code

    Tiny_Oracle
      Hello,

      I couldn't start my database, this is the log:

      Mon Jun 21 00:37:32 2010
      Starting ORACLE instance (normal)
      LICENSE_MAX_SESSION = 0
      LICENSE_SESSIONS_WARNING = 0
      Picked latch-free SCN scheme 3
      Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
      Autotune of undo retention is turned on.
      IMODE=BR
      ILAT =27
      LICENSE_MAX_USERS = 0
      SYS auditing is disabled
      Starting up:
      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options.
      Using parameter settings in server-side spfile C:\ORACLE\CDS\PRODUCT\11.2.0\CLICK_DBHOME\DATABASE\SPFILECLICK11G.ORA
      System parameters with non-default values:
      processes = 150
      memory_target = 1G
      control_files = "C:\ORACLE\CLICK11G\ORADATA\CLICK11G\CONTROL01.CTL"
      control_files = "C:\ORACLE\CLICK11G\RECOVERY_AREA\CLICK11G\CONTROL02.CTL"
      db_block_size = 8192
      compatible = "11.2.0.0.0"
      db_recovery_file_dest = "C:\Oracle\Click11g\recovery_area"
      db_recovery_file_dest_size= 25G
      undo_tablespace = "UNDOTBS1"
      remote_login_passwordfile= "EXCLUSIVE"
      db_domain = ""
      dispatchers = "(PROTOCOL=TCP) (SERVICE=click11gXDB)"
      audit_file_dest = "C:\ORACLE\CLICK11G\ADMIN\CLICK11G\ADUMP"
      audit_trail = "DB"
      db_name = "click11g"
      open_cursors = 300
      diagnostic_dest = "C:\ORACLE\CLICK11G"
      Mon Jun 21 00:37:32 2010
      PMON started with pid=2, OS id=736
      Mon Jun 21 00:37:32 2010
      VKTM started with pid=3, OS id=1484 at elevated priority
      VKTM running at (10)millisec precision with DBRM quantum (100)ms
      Mon Jun 21 00:37:32 2010
      GEN0 started with pid=4, OS id=2944
      Mon Jun 21 00:37:32 2010
      DIAG started with pid=5, OS id=1512
      Mon Jun 21 00:37:32 2010
      DBRM started with pid=6, OS id=2304
      Mon Jun 21 00:37:33 2010
      PSP0 started with pid=7, OS id=2892
      Mon Jun 21 00:37:33 2010
      DIA0 started with pid=8, OS id=2064
      Mon Jun 21 00:37:33 2010
      MMAN started with pid=9, OS id=3044
      Mon Jun 21 00:37:33 2010
      DBW0 started with pid=10, OS id=2340
      Mon Jun 21 00:37:33 2010
      LGWR started with pid=11, OS id=2668
      Mon Jun 21 00:37:33 2010
      CKPT started with pid=12, OS id=2844
      Mon Jun 21 00:37:33 2010
      SMON started with pid=13, OS id=2108
      Mon Jun 21 00:37:33 2010
      RECO started with pid=14, OS id=3052
      Mon Jun 21 00:37:33 2010
      MMON started with pid=15, OS id=2168
      starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
      Mon Jun 21 00:37:33 2010
      MMNL started with pid=16, OS id=3056
      starting up 1 shared server(s) ...
      ORACLE_BASE from environment = C:\Oracle\Click11g
      Mon Jun 21 00:37:33 2010
      ALTER DATABASE MOUNT
      Successful mount of redo thread 1, with mount id 2405271053
      Database mounted in Exclusive Mode
      Lost write protection disabled
      Completed: ALTER DATABASE MOUNT
      Mon Jun 21 00:37:38 2010
      ALTER DATABASE OPEN
      Beginning crash recovery of 1 threads
      parallel recovery started with 2 processes
      Started redo scan
      Completed redo scan
      read 13627 KB redo, 0 data blocks need recovery
      Errors in file c:\oracle\click11g\diag\rdbms\click11g\click11g\trace\click11g_ora_1992.trc (incident=51767):
      ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [107], [57549], [57552], [], [], [], [], [], [], []
      Incident details in: c:\oracle\click11g\diag\rdbms\click11g\click11g\incident\incdir_51767\click11g_ora_1992_i51767.trc
      Aborting crash recovery due to error 600
      Errors in file c:\oracle\click11g\diag\rdbms\click11g\click11g\trace\click11g_ora_1992.trc:
      ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [107], [57549], [57552], [], [], [], [], [], [], []
      Errors in file c:\oracle\click11g\diag\rdbms\click11g\click11g\trace\click11g_ora_1992.trc:
      ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [107], [57549], [57552], [], [], [], [], [], [], []
      ORA-600 signalled during: ALTER DATABASE OPEN...
      Trace dumping is performing id=[cdmp_20100621003740]

      Where is the problem ?

      I performed recovery using EM, but the database couldn't start.
      I just want single package from this database, how could I restore this tablespace or get any type of export?

      thanks very much
        • 1. Re: ORA-00600: internal error code
          618702
          Tiny_Oracle,

          If you have metalink access it would be better for you to check the ORA-600 diagnostic tool in there.

          read 13627 KB redo, 0 data blocks need recovery
          Errors in file c:\oracle\click11g\diag\rdbms\click11g\click11g\trace\click11g_ora_1992.trc (incident=51767):
          ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [107], [57549], [57552], [], [], [], [], [], [], []
          Incident details in: c:\oracle\click11g\diag\rdbms\click11g\click11g\incident\incdir_51767\click11g_ora_1992_i51767.trc
          Aborting crash recovery due to error 600

          I think you have had a bad restart of the database or something has corrupted lately, is that true? What is more in the alert.log file btw?

          Ogan
          • 2. Re: ORA-00600: internal error code
            asifkabirdba
            ORA - 00600 Error

            Read the post.


            Regards
            Asif Kabir
            • 3. Re: ORA-00600: internal error code
              mbobak
              Hm....different version of Oracle....different ORA-600....why is he supposed to read that post?

              -Mark
              • 4. Re: ORA-00600: internal error code
                Tiny_Oracle
                Thanks Ogan,

                Yes that occures after hardware failure and I don't have SR at Oracle Support :(
                There's no more at log file about this issue.

                All what I want is to restore single important package, Can I perform cold backup or some thing like that ?

                Regards
                • 5. Re: ORA-00600: internal error code
                  618702
                  Tiny_Oracle,

                  Ok then;

                  Create the pfile from the spfile and start the database with that pfile BUT first delete everything inside it other than controlfile paths. We have to eliminate possibilities that this may be caused by a parameter in the spfile.

                  Other than that i really shouldn't be guiding you when you have seen ORA-00600 error, no one has.

                  Ogan
                  • 6. Re: ORA-00600: internal error code
                    Tiny_Oracle
                    Thanks asifkabirdba,

                    I made this:

                    SQL> conn sys/******* as sysdba
                    Connected.
                    SQL> shutdown immediate
                    ORA-01109: database not open


                    Database dismounted.
                    ORACLE instance shut down.
                    SQL> startup mount
                    ORACLE instance started.

                    Total System Global Area 1068937216 bytes
                    Fixed Size 2182592 bytes
                    Variable Size 750780992 bytes
                    Database Buffers 310378496 bytes
                    Redo Buffers 5595136 bytes
                    Database mounted.
                    SQL> alter database open;
                    alter database open
                    *
                    ERROR at line 1:
                    ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
                    [107], [57549], [57552], [], [], [], [], [], [], []

                    SQL>

                    As I told you that happened after Hardware failure, when I fixed the server I got at first this error:
                    ORA-01033: ORACLE initialization or shutdown in progress

                    I let the database "Starting !" all the night but It couldn't start, then I performed the recovery and I'm here now !

                    Regards
                    • 7. Re: ORA-00600: internal error code
                      618702
                      Tiny_Oracle,

                      Have you tried recover database and alter database open resetlog commands?

                      I have never seen this ORA-600 error before but i presume it can not complete the crash recovery. So you may should have to apply the latest archivelog to the database, if your database was in archive log mode.

                      Ogan
                      • 8. Re: ORA-00600: internal error code
                        Billy~Verreynne
                        Before trying any suggestion or attempting any kind of recovery... cold backup the entire database first!

                        ORA-600's are also best dealt with by logging a Service Request (SR) with Oracle Support - unless you find the exact same error with exact same symptoms and exact same o/s and versions listed on a Metalink/MoS support note that provides a workaround to use or patch to install.
                        • 9. Re: ORA-00600: internal error code
                          785714
                          Have you found a fix yet? I have a similar error. My computer had a hard shutdown and checkdisk fixed some index files. Windows 2008 R2 x64 enterprise. Oracle 11.2.0.1 r2x64. Below is the error.

                          SQL> shutdown immediate;
                          ORA-01109: database not open


                          Database dismounted.
                          ORACLE instance shut down.
                          SQL> startup mount;
                          ORACLE instance started.

                          Total System Global Area 313159680 bytes
                          Fixed Size 2175328 bytes
                          Variable Size 255856288 bytes
                          Database Buffers 50331648 bytes
                          Redo Buffers 4796416 bytes
                          Database mounted.
                          SQL> alter database open;
                          alter database open
                          *
                          ERROR at line 1:
                          ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
                          [38], [50733], [50921], [], [], [], [], [], [], []

                          Edited by: user13370564 on Jul 17, 2010 3:22 PM
                          • 10. Re: ORA-00600: internal error code
                            668953
                            i had a server crash (solaris 10) and the 11gR2 database on it has the same error now when i try to open database:

                            SQL> alter database open;
                            alter database open
                            *
                            ERROR at line 1:
                            ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [5885], [2139], [2141], [], [], [], [], [], [], []

                            when i did a oracle support search, found:
                            Bug 10100975: DATABASE CRASH AND FAILS TO OPEN WITH ORA-600 [KCRATR_NAB_LESS_THAN_ODR]

                            and unfortunately, there is no workaround:
                            WORKAROUND:
                            -----------
                            None. Restore and recover PITR.
                            • 11. Re: ORA-00600: internal error code
                              askraks
                              Hi,

                              Yes i reviewd the bug and you need to do PITR.

                              One more why is , Bug is status 11 and you can with escalating the bug :) hope you may get better workaround soon :)

                              Kind Regards,
                              Rakesh Jayappa
                              • 12. Re: ORA-00600: internal error code
                                807900
                                This is my first attempt to write oracle forums, so i hope i will not cause any trouble.

                                2 days ago i got a similar error due to abnormal shutdown.
                                (ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [789], [26030], [26155], [], [], [], [], [], [], [])
                                i spent whole day for log tracing and error fixing.
                                Unfortunately i didnt have chance of PITR. I didnt have a back up of my 11g database (my fault, i omit to set up recovery routine as always ).
                                After an extensive log tracing, i figured out that 11g is getting error after Completed redo scan. While trying to make recovery off data blocks.
                                Since db was a production system and since i had to wait metalink for a solution, there was no harm on trying some workarounds on copy db.
                                So i assumed that i can pretend my data and control files as cold back up.
                                Just in case once more i backed up my crashed db and than started the recovery process. This is what i did 2 days ago :

                                *>connect sys as sysdba*
                                *> startup mount*
                                *> alter database recover until cancel using backup controlfile; (i have ignored promtings).*
                                *> alter database recover continue default; (until it says “no such file or directory” or there are no more suggestions.)*
                                *> alter database recover cancel;*
                                *> alter database open resetlogs;*

                                And my database was alive .. In my case i havent lost any data but i do not guarantee that this method is data loss free (im just a rookie :) ).
                                This just brings my database back to life.
                                I hope this will also a workaround for you ...
                                • 13. Re: ORA-00600: internal error code
                                  841747
                                  Many thanks its a good workaround and it worked for me.......
                                  • 14. Re: ORA-00600: internal error code
                                    841336
                                    wow! it works like a charm! thanks a lot for the sharing!!!
                                    1 2 Previous Next