12 Replies Latest reply: Mar 26, 2013 5:05 AM by Osama_Mustafa RSS

    ORA-00600 Error

    Venkateshj
      Hi all

      My Oracle Database Version is Oracle Database 11g Release 11.2.0.1.0 - 64bit
      My Operating System is Windows Server 2008 R2 Standard(64-bit OS)

      I have a error in alert log file which was generated on MAR-22-2013 & MAR-23-2013, but my database is working fine..

      I don't know the cause of this error?

      My log files details show as below..

      Fri Mar 22 00:06:53 2013
      Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_j000_5316.trc (incident=2593):
      ORA-00600: internal error code, arguments: [ktsk_dba_to_hwm-1], [], [], [], [], [], [], [], [], [], [], []
      Incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_2593\orcl_j000_5316_i2593.trc
      Fri Mar 22 00:07:02 2013
      Trace dumping is performing id=[cdmp_20130322000702]
      Fri Mar 22 00:07:10 2013
      Thread 1 advanced to log sequence 12875 (LGWR switch)
      Current log# 2 seq# 12875 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG
      Fri Mar 22 00:07:22 2013



      Sat Mar 23 00:07:01 2013
      Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_j000_5780.trc (incident=2673):
      ORA-00600: internal error code, arguments: [ktsk_dba_to_hwm-1], [], [], [], [], [], [], [], [], [], [], []
      Incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_2673\orcl_j000_5780_i2673.trc
      Sat Mar 23 00:07:05 2013
      Trace dumping is performing id=[cdmp_20130323000705]
      Sat Mar 23 00:07:14 2013
      Thread 1 cannot allocate new log, sequence 13063
      Checkpoint not complete
      Current log# 3 seq# 13062 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
      Thread 1 advanced to log sequence 13063 (LGWR switch)
      Current log# 1 seq# 13063 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG
      Sat Mar 23 00:07:29 2013
      Thread 1 cannot allocate new log, sequence 13064
      Private strand flush not complete
      Current log# 1 seq# 13063 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG
      Thread 1 advanced to log sequence 13064 (LGWR switch)


      Is there any error occurr possibility in future?

      Please give a solution..


      Thanks in advance...
        • 1. Re: ORA-00600 Error
          Chanchal Wankhade
          Hi,

          Since your database is working fine after throwing ora 600 you just need to take pricautions and hence raise a SR with oracle for more info since they are the only who will help you with ora 600 in a better way and you should do it on priority.
          • 2. Re: ORA-00600 Error
            Pavan DBA
            ORA-600 is called as internal error and for this you need to refer to "ora-600 lookup tool" in My oracle support. there you will find the exact reason and solution for your issue.

            if it is not documented, then it is advised to raise SR with oracle support.

            by the way, have you opened the trace file mentioned in alert log and checked it?
            • 3. Re: ORA-00600 Error
              Salman Qureshi
              Hi,
              Refer to MOS note ID 1050103.1. This is because of a bug fixed in 11.2.0.2. This is related to index shrinking with statement ALTER INDEX SHRINK... command.

              Salman
              • 4. Re: ORA-00600 Error
                762492
                Hi,

                This is oracle internal error, might have some issues with harddisk also.

                Pls. approach Oracle for detailed help.
                • 5. Re: ORA-00600 Error
                  Venkateshj
                  Pavan DBA wrote:
                  ORA-600 is called as internal error and for this you need to refer to "ora-600 lookup tool" in My oracle support. there you will find the exact reason and solution for your issue.

                  if it is not documented, then it is advised to raise SR with oracle support.

                  by the way, have you opened the trace file mentioned in alert log and checked it?
                  ya sir.. i checked the trace files..

                  Dump file d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_2673\orcl_j000_5780_i2673.trc
                  Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
                  Windows NT Version V6.1
                  CPU : 8 - type 8664, 4 Physical Cores
                  Process Affinity : 0x0x0000000000000000
                  Memory (Avail/Total): Ph:1248M/4085M, Ph+PgF:4852M/8169M
                  Instance name: orcl
                  Redo thread mounted by this instance: 1
                  Oracle process number: 34
                  Windows thread id: 5780, image: ORACLE.EXE (J000)


                  *** 2013-03-23 00:07:01.691
                  *** SESSION ID:(67.54518) 2013-03-23 00:07:01.691
                  *** CLIENT ID:() 2013-03-23 00:07:01.691
                  *** SERVICE NAME:(SYS$USERS) 2013-03-23 00:07:01.691
                  *** MODULE NAME:() 2013-03-23 00:07:01.691
                  *** ACTION NAME:() 2013-03-23 00:07:01.691

                  Dump continued from file: d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_j000_5780.trc
                  ORA-00600: internal error code, arguments: [ktsk_dba_to_hwm-1], [], [], [], [], [], [], [], [], [], [], []

                  ========= Dump for incident 2673 (ORA 600 [ktsk_dba_to_hwm-1]) ========

                  *** 2013-03-23 00:07:01.706
                  dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
                  ----- Current SQL Statement for this session (sql_id=53rmyb1483y06) -----
                  Alter Table DIGDATA115 shrink space
                  ----- PL/SQL Stack -----
                  ----- PL/SQL Call Stack -----
                  object line object
                  handle number name
                  000007FF2F28A410 27 procedure DLIAREA.PROC_DEL_DATA_SPACE
                  000007FF2F380F78 251 procedure DLIAREA.PROC_DEL_NMDL_DATA
                  000007FF505B6548 1 anonymous block

                  ----- Call Stack Trace -----
                  calling call entry argument values in hex
                  location type point (? means dubious value)
                  -------------------- -------- -------------------- ----------------------------
                  ksedst1()+129 CALL??? skdstdst() 01D950640 006F604E8 000002004
                  2050034BEBEA703
                  ksedst()+69 CALL??? ksedst1() 000000002 000000000 006F605E0
                  000000000
                  dbkedDefDump()+4536 CALL??? ksedst() 000000287 000000000 000000000
                  000000000
                  ksedmp()+43 CALL??? dbkedDefDump() 000000003 000000002 000000000
                  000468E71
                  ksfdmp()+87 CALL??? ksedmp() 000000000 000000000 000000000
                  000000000
                  dbgexPhaseII()+1819 CALL??? ksfdmp() 000000000 000000000 000000000
                  000000000
                  dbgexProcessError() CALL??? dbgexPhaseII() 01D950640 01D95D518 000000A71
                  +2563 000000002
                  dbgeExecuteForError CALL??? dbgexProcessError() 01D950640 01D957610 000000001
                  ()+65 000000000
                  dbgePostErrorKGE()+ CALL??? dbgeExecuteForError 029C43804 029C438E8 029C438B8
                  1726 () 01F4DB048
                  dbkePostKGE_kgsf()+ CALL??? dbgePostErrorKGE() 0212A3510 01DC30040
                  75 7FF00000258 EF53F1B92C7F
                  kgeadse()+342 CALL??? dbkePostKGE_kgsf() 0212A2F50 000F0A5C2 000000000
                  000000000
                  kgerinv_internal()+ CALL??? kgeadse() 029C44020 0000240C0 000000000
                  76 000000001
                  kgerinv()+49 CALL??? kgerinv_internal() 000020C78 7FF58240050
                  7FF7378D258 7FF580142A8
                  kgeasnmierr()+64 CALL??? kgerinv() EF53F1B2444C 00145ED00
                  00000079E 7FF58240014
                  ktsk_dba_to_hwm()+2 CALL??? kgeasnmierr() 000000001 0040144F4 000000000
                  740 000000000
                  ktskha_get_new_hwm( CALL??? ktsk_dba_to_hwm()+2 000000000 00140BE90 01E6112B0
                  )+264 54 0088CABB0
                  ktskha_drv()+147 CALL??? ktskha_get_new_hwm( 029C44B60 029C444B8 000000000
                  ) 000000000
                  ktskshk1()+4511 CALL??? ktskha_drv() 029C44B60 000000000 000000006
                  000000001
                  atb_shk_prim()+1252 CALL??? ktskshk1()+2030 029C44EA0 000000000
                  7FF00000178 000002000
                  atb_shk_drv()+181 CALL??? atb_shk_prim() 000000001 000B8A9A5 000000001
                  01E600108
                  atbdrv()+11590 CALL??? atb_shk_drv() 029C454C0 029C45920 029C45928
                  100000002
                  opiexe()+24568 CALL??? atbdrv() 00000000F 000000003
                  7FF00000102 000000000
                  opiosq0()+5129 CALL??? opiexe()+16981 59500000004 000000000
                  029C47020 000000000
                  opipls()+12841 CALL??? opiosq0() 000000003 00000000E 029C474E0
                  029C40220
                  opiodr()+1662 CALL??? opipls()+11351 000000066 7FF00000007
                  029C49428 000000003
                  rpidrus()+862 CALL??? opiodr() 000000066 000000007 029C49428
                  000000009
                  rpidru()+154 CALL??? rpidrus() 029C487F8 000000000 0212A2F50
                  000000006
                  rpiswu2()+2757 CALL??? rpidru() 029C49080 00060F661 01D963B68
                  006EB80C0
                  rpidrv()+6105 CALL??? rpiswu2() 7FF7667E510 000000055
                  7FF7667E594 27F00000002
                  psddr0()+614 CALL??? rpidrv() 000000009 000000066 029C49428
                  000000038
                  psdnal()+510 CALL??? psddr0() 000000009 000000066 029C49428
                  000000030
                  pevm_EXIM()+229 CALL??? psdnal() 000000000 000000000 01F4F8340
                  000000000
                  pfrinstr_EXIM()+41 CALL??? pevm_EXIM() 01E5F6820 029C49820 01E5F6890
                  00AFC0000
                  pfrrun_no_tool()+65 CALL??? pfrinstr_EXIM() 029C497A8 7FF2CFA433A
                  02A5591A8 7FF00000000
                  pfrrun()+1241 CALL??? pfrrun_no_tool() 000000102 029C49818 000000000
                  000000000
                  plsql_run()+875 CALL??? pfrrun() 01E5F6820 01E5F5970 000073FFF
                  000000000
                  peicnt()+329 CALL??? plsql_run() 01E5F6820 000000001 000000000
                  000000000
                  kkxexe()+616 CALL??? peicnt() 029C4A760 01E5F6820
                  7FF418689D0 000000000
                  opiexe()+20006 CALL??? kkxexe() 01E5F8F20 000000003
                  7FF00000102 000000000
                  opiodr()+1662 CALL??? opiexe()+16981 7FF00000004 000000004
                  029C4D3B0 000E35314
                  rpidrus()+862 CALL??? opiodr() 000000004 000000004 029C4D3B0
                  000000006
                  rpidru()+154 CALL??? rpidrus() 029C4C9F8 000000000 000000000
                  000000000
                  rpiswu2()+2757 CALL??? rpidru() 029C4D280 029C4D378 000000000
                  000000000
                  rpidrv()+6105 CALL??? rpiswu2() 7FF7667E510 27F00000055
                  7FF7667E594 000000002
                  rpiexe()+123 CALL??? rpidrv() 000000006 000000004 029C4D3B0
                  000000008
                  kkjex1e()+9506 CALL??? rpiexe() 000000006 7FF00000003
                  029C4D6D8 000000004
                  kkjsexe()+379 CALL??? kkjex1e() 029C4E3F4 000000017 000000000
                  029C4E3E0
                  kkjrdp()+947 CALL??? kkjsexe() 000000000 008A56754 006E22EE0
                  008B0BC7C
                  opirip()+1570 CALL??? kkjrdp() 00000001E 006E2A284 029C4F920
                  000000001
                  opidrv()+909 CALL??? opirip() 000000032 000000004 029C4FD10
                  615C3A6400000000
                  sou2o()+98 CALL??? opidrv()+150 000000032 000000004 029C4FD10
                  000000000
                  opimai_real()+299 CALL??? sou2o() 1CE272B3026FB96 000000000
                  170016000307DD 5020E001C003B
                  opimai()+191 CALL??? opimai_real() 000000000 000000000 000000000
                  000000000
                  BackgroundThreadSta CALL??? opimai() 029C4FE58 000000001 000000000
                  rt()+693 000000000
                  000000007722F56D CALL??? BackgroundThreadSta 00C402300 000000000 000000000
                  rt() 000000000
                  0000000077463281 CALL??? 000000007722F560 000000000 000000000 000000000
                  000000000


                  --------------------- Binary Stack Dump ---------------------
                  • 6. Re: ORA-00600 Error
                    Kh$n
                    As per metalink id 435780.1

                    sql> show parameter archive_lag_target;

                    if archive_log_target value is other than 0 than alter it to zero which will solve ur problem.

                    Edited by: Asad99 on Mar 26, 2013 12:23 AM

                    Edited by: Asad99 on Mar 26, 2013 12:25 AM
                    • 7. Re: ORA-00600 Error
                      Venkateshj
                      Asad99 wrote:
                      As per metalink id 435780.1

                      sql> show parameter archive_lag_target;

                      if archive_log_target value is other than 0 than alter it to zero which will solve ur problem.

                      Edited by: Asad99 on Mar 26, 2013 12:23 AM

                      Edited by: Asad99 on Mar 26, 2013 12:25 AM
                      SQL> sho parameter archive_lag_target

                      NAME TYPE VALUE
                      ------------------------------------ ----------- ------------
                      archive_lag_target integer 0
                      SQL>
                      • 8. Re: ORA-00600 Error
                        Pavan DBA
                        ----- Current SQL Statement for this session (sql_id=53rmyb1483y06) -----
                        Alter Table DIGDATA115 shrink space
                        from your trace file it is clear that shrink command is having issue. As Salman suggested, refer to this MOS doc 1050103.1.
                        • 9. Re: ORA-00600 Error
                          KR10822864
                          its a BUG.as per the metalink Interim patches are no longer created for this release, apply the PSU(11.2.0.3) to over come this issue.
                          please check below.
                          Bug 9295217 - ORA-600 [ktsk_dba_to_hwm-1] / corruption during SHRINK of HWM [ID 9295217.8]

                          Edited by: KR10822864 on Mar 26, 2013 2:27 AM
                          added metalink note
                          • 10. Re: ORA-00600 Error
                            EdStevens
                            Asad99 wrote:
                            As per metalink id 435780.1
                            <snip MetaLink content>

                            It is a violation of the terms of your user agreement to re-publish any content from MOS.
                            >
                            Edited by: Asad99 on Mar 26, 2013 12:23 AM

                            Edited by: Asad99 on Mar 26, 2013 12:25 AM
                            Edited by: EdStevens on Mar 26, 2013 4:54 AM
                            • 11. Re: ORA-00600 Error
                              Osama_Mustafa
                              Like ed said Don't try to Post any MOS Information here , it's illegal to do that
                              • 12. Re: ORA-00600 Error
                                Osama_Mustafa
                                to understand ORA-00600
                                http://osamamustafa.blogspot.com/2013/02/what-is-ora-00600.html