ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [2101]

476115
    Hi,

    I have a problem starting database.
    When I start database (oraclexe) from SQLPLUS I get this error:
    ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [2101],
    [2100], [0x0], [], [], [], []

    Anyone encounterd such a problem?
      • 1. Re: ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [2101]
        Santosh Kumar
        On which platform and what is the database version.
        By the way, for ORA-00600 metalink is the best place to look at.
        • 2. Re: ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [210
          476115
          Thanks for replay.

          OS: WinXP SP2.
          Database Server: Oracle express edition 10.2.0.1

          Regards!
          • 3. Re: ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [210
            Nicolas.Gasparotto
            Try to recreate your controlfiles, and if that doesn't help restore your last valid backup.
            By the way, is it the first startup of your db ? And if not (I mean if it worked before), what did you change on the database/server side ?

            Nicolas.
            • 4. Re: ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [210
              Eduardo Legatti
              Hi,

              Did you already take a look at alert log file (alert_xe.log) for more information?

              Cheers

              Legatti
              • 5. Re: ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [210
                476115
                Hi N. Gasparotto ,

                How to create control file?

                And is not the first startup. It was up and running for some months.
                I did not change anything on server.
                I think reason for problem is unexpected cut of power supply.

                Message was edited by:
                NaimB
                • 6. Re: ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [210
                  476115
                  Hi Legatti,

                  this is what I have in alert_xe.log file:

                  Dump file c:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
                  Sat Dec 15 18:06:31 2007
                  ORACLE V10.2.0.1.0 - Beta vsnsta=1
                  vsnsql=14 vsnxtr=3
                  Windows XP Version V5.1 Service Pack 2
                  CPU : 2 - type 586
                  Process Affinity : 0x00000000
                  Memory (Avail/Total): Ph:255M/503M, Ph+PgF:1035M/1227M, VA:1934M/2047M
                  Sat Dec 15 18:06:31 2007
                  Starting ORACLE instance (normal)
                  LICENSE_MAX_SESSION = 0
                  LICENSE_SESSIONS_WARNING = 0
                  Picked latch-free SCN scheme 2
                  Using LOG_ARCHIVE_DEST_1 parameter default value as C:\oraclexe\app\oracle\product\10.2.0\server\RDBMS
                  Autotune of undo retention is turned on.
                  IMODE=BR
                  ILAT =10
                  LICENSE_MAX_USERS = 0
                  SYS auditing is disabled
                  ksdpec: called for event 13740 prior to event group initialization
                  Starting up ORACLE RDBMS Version: 10.2.0.1.0.
                  System parameters with non-default values:
                  sessions = 49
                  __shared_pool_size = 54525952
                  __large_pool_size = 8388608
                  __java_pool_size = 4194304
                  __streams_pool_size = 0
                  spfile = C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
                  sga_target = 146800640
                  control_files = C:\ORACLEXE\ORADATA\XE\CONTROL.DBF
                  __db_cache_size = 75497472
                  compatible = 10.2.0.1.0
                  undo_management = AUTO
                  undo_tablespace = UNDO
                  remote_login_passwordfile= EXCLUSIVE
                  dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
                  shared_servers = 4
                  local_listener = (ADDRESS=(PROTOCOL=TCP)(HOST=datanet)(PORT=1521))
                  job_queue_processes = 4
                  audit_file_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
                  background_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
                  user_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
                  core_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
                  db_name = XE
                  open_cursors = 300
                  pga_aggregate_target = 16777216
                  PMON started with pid=2, OS id=1952
                  PSP0 started with pid=3, OS id=1868
                  MMAN started with pid=4, OS id=2044
                  DBW0 started with pid=5, OS id=2072
                  LGWR started with pid=6, OS id=2080
                  CKPT started with pid=7, OS id=2084
                  SMON started with pid=8, OS id=2096
                  RECO started with pid=9, OS id=2104
                  CJQ0 started with pid=10, OS id=2112
                  MMON started with pid=11, OS id=2116
                  MMNL started with pid=12, OS id=2120
                  Sat Dec 15 18:06:33 2007
                  starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                  starting up 4 shared server(s) ...
                  Oracle Data Guard is not available in this edition of Oracle.
                  Sat Dec 15 18:06:33 2007
                  alter database mount exclusive
                  Sat Dec 15 18:06:38 2007
                  Setting recovery target incarnation to 2
                  Sat Dec 15 18:06:38 2007
                  Successful mount of redo thread 1, with mount id 2522565865
                  Sat Dec 15 18:06:38 2007
                  Database mounted in Exclusive Mode
                  Completed: alter database mount exclusive
                  Sat Dec 15 18:06:38 2007
                  alter database open
                  Sat Dec 15 18:06:38 2007
                  Beginning crash recovery of 1 threads
                  Sat Dec 15 18:06:38 2007
                  Started redo scan
                  Sat Dec 15 18:06:38 2007
                  Completed redo scan
                  124 redo blocks read, 39 data blocks need recovery


                  Regards

                  NaimB
                  • 7. Re: ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [210
                    604693
                    To recreate a control file,issue:
                    alter database backup controlfile to trace;
                    Check your trace file and modify/copy/paste in sqlplus.
                    • 8. Re: ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [210
                      Nicolas.Gasparotto
                      How to create control file?
                      CREATE CONTROLFILE

                      Nicolas.
                      • 9. Re: ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [210
                        Madrid
                        After the power failure your controlfile may have ended up corrupted. Do you have a multiplexed controlfile? Before trying to rebuild your controlfile, get a cold backup and try to use the copy from the multiplexed controlfile.


                        ~ Madrid
                        • 10. Re: ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [210
                          616045
                          I have the same problem ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [11713],[11710], [0x0], [], [], [], [], when I try to mount database oracle.

                          How could I know If I have multiplexed controlfile?, and How could I get a cold backup?. Because I am going to create ControlFile, but I hope I can find a better solution.

                          Thanks in advance for your help,

                          My best regards,

                          Diego Urrutia
                          • 11. Re: ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [210
                            Eduardo Legatti
                            Hi,

                            >>How could I know If I have multiplexed controlfile?
                            At SQL*PLUS type show parameter control_files

                            >>and How could I get a cold backup?
                            I'm not sure what did you mean. If you have a valid cold backup, then you can use it to restore all database files. Otherwise, that isn't the best solution in your case.

                            >>Because I am going to create ControlFile, but I hope I can find a better solution.
                            The better solution is re-create the control file ...

                            Cheers

                            Legatti
                            • 12. Re: ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [210
                              Madrid
                              First of all, specify your oracle version and os platform. An ora-00600 is always a very serious matter. If you are not sure about how to proceed I strongly suggest you to address this issue to customer support.

                              If your controlfile is currently not multiplexed there is nothing you can do about it, your controlfile most probably is corrupt by now. You can verify either way, if you have at least one more copy of your controfile, then you can say it is multiplexed, startup the instance up to the nomount level and query the V$PARAMETER view, look for the parameter name control_files or issue the command show parameter controlfile, this will let you know how many multiplexed controlfiles you have.

                              You should have a valid backup now. Are you the dba, or is there a dba responsible for taking backups? In order for you to take a backup, if you haven't done so, shutdown your instance and backup your controlfiles, and datafiles, just in case you are not successful in solving this issue, at least you can have a base line where you can come back and leave the environment just exactly as you find it now, so in case a second attempt has to be made it doesn't get unnecessarily complicated.


                              ~ Madrid
                              • 13. Re: ORA-00600: internal error code, arguments:  [kzsrgpw]
                                user12081439
                                When I try to login to one of my database using enterprise manager console i get this error. I tried with sys username and password and it works fine for me. For a while ago I got the same error when tried with another database in this same tree and for that database i am good now without doing anything. Why does this happen? Is there anything conflicting in my local system or database? What should i do and where should i look for the error?

                                My database configuration for these are ORACLE 10g 10.2.0.4 and solaris 10. These are my pre production and test servers. Please help and i am new to database administration.
                                • 14. Re: ORA-00600: internal error code, arguments:  [kzsrgpw]
                                  sb92075
                                  ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
                                  1 2 上一个 下一个