1 2 Previous Next 19 Replies Latest reply on Aug 14, 2009 7:26 AM by user00726

    ORA-00600: internal error code, arguments[12700], [34135], [16970867], [14]

    user00726
      Hi all,

      I am using Oracle 9.2.0.6 on SUSE 10....

      In the alert logfile i am getting an error
      Tue Aug 11 10:57:07 2009
      Errors in file /u01/app/oracle/admin/icai/udump/icai_ora_17955.trc:
      ORA-00600: internal error code, arguments: [12700], [34135], [16970867], [14], [
      15771418], [25], [], []
      Tue Aug 11 10:59:04 2009
      Errors in file /u01/app/oracle/admin/icai/udump/icai_ora_18009.trc:
      ORA-00600: internal error code, arguments: [12700], [34135], [16970867], [14], [
      15807313], [25], [], []
      Tue Aug 11 11:01:06 2009
      Errors in file /u01/app/oracle/admin/icai/udump/icai_ora_18009.trc:
      ORA-00600: internal error code, arguments: [12700], [34135], [16970867], [14], [
      15807313], [25], [], []
      Tue Aug 11 11:02:08 2009
      Errors in file /u01/app/oracle/admin/icai/udump/icai_ora_18009.trc:
      ORA-00600: internal error code, arguments: [12700], [34135], [16970867], [14], [
      15807313], [25], [], []
      SQL> exec oerr12700diag(34135,16970867,14);
      --------------------------------------------------
      IF dbv did not show any corruption, you can try to
      find the corrupted indexes using following queries:
      -------------------------------------------------------
      If a query returns "no rows selected" index is sane
      If a query returns AAAIVXAAEAAAvRzAAO index is corrupted
      ..................................................
      .
      To test  data3.OM_STUDENT_HEAD indexes
      .
      .
      To test  INDEX OM_STUDENT_HEAD_HEAD_UK01 you run :
      .
      select rowid "OM_STUDENT_HEAD_HEAD_UK01 corrupted!"
      from
      (SELECT /*+ INDEX_FFS(OM_STUDENT_HEAD,OM_STUDENT_HEAD_HEAD_UK01) */
      STUD_COMP_CODE,rowid from data3.OM_STUDENT_HEAD where
      STUD_COMP_CODE=STUD_COMP_CODE)
      where rowid='AAAIVXAAEAAAvRzAAO';
      .
      To test  INDEX STUD_SYS_ID_PK you run :
      .
      select rowid "STUD_SYS_ID_PK corrupted!"
      from
      (SELECT /*+ INDEX_FFS(OM_STUDENT_HEAD,STUD_SYS_ID_PK) */
      STUD_SYS_ID,rowid from data3.OM_STUDENT_HEAD where STUD_SYS_ID=STUD_SYS_ID)
      where rowid='AAAIVXAAEAAAvRzAAO';
      .
      To test  INDEX IDX_STUD_REF_NO you run :
      .
      select rowid "IDX_STUD_REF_NO corrupted!"
      from
      (SELECT /*+ INDEX_FFS(OM_STUDENT_HEAD,IDX_STUD_REF_NO) */
      STUD_REF_NO,rowid from data3.OM_STUDENT_HEAD where STUD_REF_NO=STUD_REF_NO)
      where rowid='AAAIVXAAEAAAvRzAAO';
      .
      To test  INDEX IDM_STUD_COURSE you run :
      .
      select rowid "IDM_STUD_COURSE corrupted!"
      from
      (SELECT /*+ INDEX_FFS(OM_STUDENT_HEAD,IDM_STUD_COURSE) */
      STUD_COURSE_CODE,rowid from data3.OM_STUDENT_HEAD where
      STUD_COURSE_CODE=STUD_COURSE_CODE)
      where rowid='AAAIVXAAEAAAvRzAAO';
      .
      To test  INDEX IDM_STUD_SRN you run :
      .
      select rowid "IDM_STUD_SRN corrupted!"
      from
      (SELECT /*+ INDEX_FFS(OM_STUDENT_HEAD,IDM_STUD_SRN) */
      STUD_SRN,rowid from data3.OM_STUDENT_HEAD where STUD_SRN=STUD_SRN)
      where rowid='AAAIVXAAEAAAvRzAAO';
      .
      To test  INDEX IDM_STUD_TEMP_REF_NO you run :
      .
      dbv logfile
      DBVERIFY: Release 9.2.0.4.0 - Production on Tue Aug 11 13:04:43 2009
      
      Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
      
      
      DBVERIFY - Verification starting : FILE = /oradata/data/indx01.dbf
      
      DBVERIFY - Verification complete
      
      Total Pages Examined         : 1
      Total Pages Processed (Data) : 0
      Total Pages Failing   (Data) : 0
      Total Pages Processed (Index): 1
      Total Pages Failing   (Index): 0
      Total Pages Processed (Other): 0
      Total Pages Processed (Seg)  : 0
      Total Pages Failing   (Seg)  : 0
      Total Pages Empty            : 0
      Total Pages Marked Corrupt   : 0
      Total Pages Influx           : 0
      ~
      ~
      ~
      pls suggest me....

      when i exec the above query using the give rowid i am not getting any output so can anybody suggest me why it is generating ora-06000
        • 1. Re: ORA-00600: internal error code, arguments[12700], [34135], [16970867], [14]
          Pavan DBA
          ora-600 error cause and solution can be checked out using "ora-600 lookup tool" in metalink.
          always it is recommended to use it and also contact oracle support if required.
          • 2. Re: ORA-00600: internal error code, arguments[12700], [34135], [16970867], [14]
            Satish Kandi
            Assuming you are following MOS note 155933.1 for this diagnostic, refer section "-6- If no data or index corruption is found" under the same.
            • 3. Re: ORA-00600: internal error code, arguments[12700], [34135], [16970867], [14]
              user00726
              Satish,

              Yes i am using the same metalink note no. but i cannot afford any downtime....
              • 4. Re: ORA-00600: internal error code, arguments[12700], [34135], [16970867], [14]
                Satish Kandi
                If you are able to reproduce the problem with sql*plus, then altering the session should be fine. There would be no need for downtime in that case. Else, I don't see a way around.
                • 5. Re: ORA-00600: internal error code, arguments[12700], [34135], [16970867], [14]
                  Kamran Agayev A.
                  While getting ORA-00600 internal errors, the only solution you can find is by contacting Oracle Support
                  • 6. Re: ORA-00600: internal error code, arguments[12700], [34135], [16970867], [14]
                    user00726
                    How to find block number against the rowid.
                    • 7. Re: ORA-00600: internal error code, arguments[12700], [34135], [16970867], [14]
                      Anand...
                      Hi...


                      SELECT DBMS_ROWID.ROWID_BLOCK_NUMBER(’ROWID’) FROM DUAL;


                      HTH
                      Anand
                      • 8. Re: ORA-00600: internal error code, arguments[12700], [34135], [16970867], [14]
                        Satish Kandi
                        user00726 wrote:
                        How to find block number against the rowid.
                        http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_rowid.htm#CIHDGIGD
                        • 9. Re: ORA-00600: internal error code, arguments[12700], [34135], [16970867],
                          Kamran Agayev A.
                          The format of a rowid is <object id><file id><block id><row number>, and is represented as OOOOOOFFFBBBBBBRRR (numbers 6,3,6,3). This is the Extended rowid format from 9i onwards

                          http://www.orafaq.com/wiki/ROWID

                          Edited by: Kamran Agayev A. on Aug 12, 2009 11:51 AM
                          • 10. Re: ORA-00600: internal error code, arguments[12700], [34135], [16970867],
                            user00726
                            I am really not getting what should i do to overcome this problem....

                            As we are not having any oracle support....

                            do i need to recreate the indexes...
                            SQL> SELECT DBMS_ROWID.ROWID_BLOCK_NUMBER('AAAIVXAAEAAAvRzAAO') from dual;
                            
                            DBMS_ROWID.ROWID_BLOCK_NUMBER('AAAIVXAAEAAAVRZAAO')
                            ---------------------------------------------------
                                                                         193651
                            
                            SQL>  SELECT DBMS_ROWID.ROWID_object('AAAIVXAAEAAAvRzAAO') from dual;
                            
                            DBMS_ROWID.ROWID_OBJECT('AAAIVXAAEAAAVRZAAO')
                            ---------------------------------------------
                                                                    34135
                            
                            
                            SQL> select OBJECT_NAME from dba_objects where DATA_OBJECT_ID=34135;
                            
                            OBJECT_NAME
                            --------------------------------------------------------------------------------
                            OM_STUDENT_HEAD
                            
                            SQL>
                            Can anybody suggest me....
                            • 11. Re: ORA-00600: internal error code, arguments[12700], [34135], [16970867],
                              Satish Kandi
                              Going back, what was the output of "SQL> exec oerr12700diag(34135,16970867,14);" query execution recommendations?

                              Did you get ROWID as output or no output?
                              • 12. Re: ORA-00600: internal error code, arguments[12700], [34135], [16970867],
                                user00726
                                NO, iam not getting any output

                                and the block dump of
                                SQL> select DBMS_ROWID.ROWID_OBJECT('AAAIVXAAEAAAvRzAAO') "OBJECT",DBMS_ROWID.RO
                                WID_RELATIVE_FNO('AAAIVXAAEAAAvRzAAO') "FILE",
                                DBMS_ROWID.ROWID_BLOCK_NUMBER('AAAIVXAAEAAAvRzAAO') "BLOCK",DBMS_ROWID.ROWID_ROW
                                _NUMBER('AAAIVXAAEAAAvRzAAO') "ROW"
                                    from dual;
                                    /
                                  2    3
                                    OBJECT       FILE      BLOCK        ROW
                                ---------- ---------- ---------- ----------
                                     34135          4     193651         14
                                
                                SQL>
                                    OBJECT       FILE      BLOCK        ROW
                                ---------- ---------- ---------- ----------
                                     34135          4     193651         14
                                
                                SQL> select tablespace_name,file_name from dba_data_files
                                  2  where relative_fno = 4;
                                
                                TABLESPACE_NAME
                                ------------------------------
                                FILE_NAME
                                --------------------------------------------------------------------------------
                                DATARO
                                /u01/oradata/data/dataro01.dbf
                                
                                
                                SQL>
                                sql> alter system dump datafile 4 block 193651

                                block
                                /u01/app/oracle/admin/ai/udump/ai_ora_3281.trc
                                Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
                                With the Partitioning, OLAP and Oracle Data Mining options
                                JServer Release 9.2.0.4.0 - Production
                                ORACLE_HOME = /u01/app/oracle/product/9.2.0.4.0/db_1
                                System name:     Linux
                                Node name:     ai-oracle
                                Release:     2.6.16.21-0.8-bigsmp
                                Version:     #1 SMP Mon Jul 3 18:25:39 UTC 2006
                                Machine:     i686
                                Instance name: ai
                                Redo thread mounted by this instance: 1
                                Oracle process number: 267
                                Unix process pid: 3281, image: oracle@ai-oracle (TNS V1-V3)
                                
                                *** 2009-08-12 12:42:17.503
                                *** SESSION ID:(390.3748) 2009-08-12 12:42:17.461
                                Start dump data blocks tsn: 12 file#: 4 minblk 193651 maxblk 193651
                                buffer tsn: 12 rdba: 0x0102f473 (4/193651)
                                scn: 0x0000.756f0c6e seq: 0x01 flg: 0x06 tail: 0x0c6e0601
                                frmt: 0x02 chkval: 0xb948 type: 0x06=trans data
                                Block header dump:  0x0102f473
                                 Object id on Block? Y
                                 seg/obj: 0x8557  csc: 0x00.756f0c6b  itc: 2  flg: E  typ: 1 - DATA
                                     brn: 0  bdba: 0x102f18b ver: 0x01
                                     inc: 0  exflg: 0
                                 
                                 Itl           Xid                  Uba         Flag  Lck        Scn/Fsc
                                0x01   0x0007.027.00000b8d  0x00871ac1.01c7.13  C---    0  scn 0x0000.756f0c67
                                0x02   0x0034.026.0000046c  0x00856961.01aa.1d  --U-    1  fsc 0x0000.756f0c6e
                                 
                                data_block_dump,data header at 0xad7be64
                                ===============
                                tsiz: 0x1f98
                                hsiz: 0x30
                                pbl: 0x0ad7be64
                                bdba: 0x0102f473
                                     76543210
                                flag=--------
                                ntab=1
                                nrow=15
                                frre=-1
                                fsbo=0x30
                                fseo=0x3be
                                avsp=0x3ff
                                tosp=0x3ff
                                0xe:pti[0]     nrow=15     offs=0
                                0x12:pri[0]     offs=0x1e0e
                                0x14:pri[1]     offs=0x1bff
                                0x16:pri[2]     offs=0x1a56
                                0x18:pri[3]     offs=0x1886
                                0x1a:pri[4]     offs=0x16e8
                                0x1c:pri[5]     offs=0x154f
                                0x1e:pri[6]     offs=0x1378
                                0x20:pri[7]     offs=0x1156
                                0x22:pri[8]     offs=0xf42
                                0x24:pri[9]     offs=0xd75
                                0x26:pri[10]     offs=0x3be
                                0x28:pri[11]     offs=0xbd4
                                0x2a:pri[12]     offs=0xa0c
                                0x2c:pri[13]     offs=0x831
                                0x2e:pri[14]     offs=0x823
                                block_row_dump:
                                tab 0, row 0, @0x1e0e
                                tl: 394 fb: --H-FL-- lb: 0x0  cc: 114
                                col  0: [ 5]  c4 03 0d 31 13
                                col  1: [ 4]  49 43 41 49
                                col  2: [ 8]  52 45 47 53 35 31 30 30
                                col  3: [ 5]  c4 29 5e 17 06
                                col  4: [ 7]  78 6d 08 07 01 01 01
                                col  5: [ 2]  c1 0a
                                col  6: [ 1]  80
                                col  7: *NULL*
                                col  8: *NULL*
                                col  9: *NULL*
                                col 10: [ 2]  53 43
                                col 11: [ 3]  c2 06 02
                                col 12: [ 8]  46 45 43 53 35 31 30 30
                                col 13: [ 5]  c4 29 5d 0a 50
                                col 14: [ 5]  c4 02 3a 26 2a
                                col 15: [ 1]  43
                                col 16: [11]  43 52 4f 54 30 32 39 36 36 35 37
                                col 17: [10]  43 52 4f 30 33 32 36 34 31 32
                                col 18: [ 2]  4d 52
                                col 19: [ 4]  59 41 53 48
                                col 20: [ 5]  4b 55 4d 41 52
                                col 21: [ 4]  47 41 52 47
                                col 22: *NULL*
                                col 23: [ 1]  4d
                                col 24: [ 7]  77 c0 08 04 01 01 01
                                col 25: [ 1]  46
                                col 26: [19]  56 49 52 41 4e 44 52 41 20 4b 55 4d 41 52 20 47 41 52 47
                                col 27: [ 1]  4e
                                col 28: *NULL*
                                col 29: [ 3]  43 50 54
                                col 30: [ 1]  4e
                                col 31: *NULL*
                                col 32: *NULL*
                                col 33: [ 1]  4e
                                col 34: *NULL*
                                col 35: [ 3]  49 4e 44
                                col 36: [ 1]  4e
                                col 37: [ 3]  47 45 4e
                                col 38: [ 1]  4e
                                col 39: [ 3]  48 49 4e
                                col 40: [17]  39 2f 31 33 34 2c 20 4a 41 54 49 20 4b 41 54 52 41
                                col 41: [10]  4d 4f 54 49 20 4b 41 54 52 41
                                col 42: *NULL*
                                col 43: *NULL*
                                col 44: [ 5]  43 41 47 52 41
                                col 45: [ 6]  32 38 32 30 30 33
                                col 46: *NULL*
                                col 47: [ 1]  4e
                                 end_of_block_dump
                                End dump data blocks tsn: 12 file#: 4 minblk 193651 maxblk 193651
                                
                                *snip*
                                Edited by: user00726 on Aug 12, 2009 12:19 AM
                                • 13. Re: ORA-00600: internal error code, arguments[12700], [34135], [16970867],
                                  Satish Kandi
                                  NO, iam not getting any output
                                  Why are you worried then?

                                  This is what the procedure prompts during execution.
                                  *If a query returns "no rows selected" index is sane*
                                  If a query returns AAAIVXAAEAAAvRzAAO index is corrupted
                                  • 14. Re: ORA-00600: internal error code, arguments[12700], [34135], [16970867],
                                    user00726
                                    Beauce when user tries to exec the belwo script they are getting

                                    SELECT * FROM OM_STUDENT_HEAD WHERE STUD_SRN='O0326424'
                                                                                    *
                                    ERROR at line 1:
                                    ORA-00600: internal error code, arguments: [12700], [34135], [16970867], [14],
                                    [15807313], [25], [], []
                                    DBV log file output
                                    DBVERIFY: Release 9.2.0.4.0 - Production on Wed Aug 12 13:01:46 2009
                                    
                                    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
                                    
                                    
                                    DBVERIFY - Verification starting : FILE = /u01/oradata/data/dataro01.dbf
                                    Block Checking: DBA = 16970867, Block Type = KTB-managed data block
                                    data header at 0xb7246264
                                    kdbchk: row locked by non-existent transaction
                                            table=0   slot=14
                                            lockid=89   ktbbhitc=2
                                    Page 193651 failed with check code 6101
                                    Block Checking: DBA = 16970869, Block Type = KTB-managed data block
                                    data header at 0xb724a264
                                    kdbchk: the amount of space used is not equal to block size
                                            used=6852 fsc=0 avsp=1222 dtl=8088
                                    Page 193653 failed with check code 6110
                                    Block Checking: DBA = 16970883, Block Type = KTB-managed data block
                                    data header at 0xb7266264
                                    kdbchk: the amount of space used is not equal to block size
                                            used=6990 fsc=0 avsp=1070 dtl=8088
                                    Page 193667 failed with check code 6110
                                    Block Checking: DBA = 16970885, Block Type = KTB-managed data block
                                    data header at 0xb726a264
                                    kdbchk: the amount of space used is not equal to block size
                                            used=7333 fsc=0 avsp=734 dtl=8088
                                    Page 193669 failed with check code 6110
                                    Block Checking: DBA = 16970906, Block Type = KTB-managed data block
                                    data header at 0xb7294264
                                    kdbchk: the amount of space used is not equal to block size
                                            used=6924 fsc=0 avsp=1157 dtl=8088
                                    Page 193690 failed with check code 6110
                                    Block Checking: DBA = 16970926, Block Type = KTB-managed data block
                                    data header at 0xb72bc264
                                    kdbchk: the amount of space used is not equal to block size
                                            used=7214 fsc=0 avsp=867 dtl=8088
                                    Page 193710 failed with check code 6110
                                    Block Checking: DBA = 16970963, Block Type = KTB-managed data block
                                    data header at 0xb7306264
                                    kdbchk: the amount of space used is not equal to block size
                                            used=7173 fsc=0 avsp=908 dtl=8088
                                    Page 193747 failed with check code 6110
                                    Block Checking: DBA = 16970996, Block Type = KTB-managed data block
                                    data header at 0xb7248264
                                    kdbchk: the amount of space used is not equal to block size
                                            used=7108 fsc=0 avsp=973 dtl=8088
                                    Page 193780 failed with check code 6110
                                    Block Checking: DBA = 16971030, Block Type = KTB-managed data block
                                    data header at 0xb728c264
                                    kdbchk: the amount of space used is not equal to block size
                                            used=7011 fsc=0 avsp=1070 dtl=8088
                                    Page 193814 failed with check code 6110
                                    Block Checking: DBA = 16971102, Block Type = KTB-managed data block
                                    data header at 0xb731c264
                                    kdbchk: the amount of space used is not equal to block size
                                            used=7073 fsc=0 avsp=1008 dtl=8088
                                    Page 193886 failed with check code 6110
                                    Block Checking: DBA = 16971119, Block Type = KTB-managed data block
                                    data header at 0xb733e264
                                    kdbchk: the amount of space used is not equal to block size
                                            used=7222 fsc=0 avsp=859 dtl=8088
                                    Page 193903 failed with check code 6110
                                    Block Checking: DBA = 16971124, Block Type = KTB-managed data block
                                    data header at 0xb7248264
                                    kdbchk: the amount of space used is not equal to block size
                                            used=7119 fsc=0 avsp=955 dtl=8088
                                    Page 193908 failed with check code 6110
                                    Block Checking: DBA = 16973749, Block Type = KTB-managed data block
                                    data header at 0xb72ca264
                                    kdbchk: the amount of space used is not equal to block size
                                            used=7125 fsc=0 avsp=921 dtl=8088
                                    Page 196533 failed with check code 6110
                                    Block Checking: DBA = 16973765, Block Type = KTB-managed data block
                                    data header at 0xb72ea264
                                    kdbchk: the amount of space used is not equal to block size
                                            used=7081 fsc=0 avsp=979 dtl=8088
                                    Page 196549 failed with check code 6110
                                    Block Checking: DBA = 16973791, Block Type = KTB-managed data block
                                    data header at 0xb731e264
                                    kdbchk: the amount of space used is not equal to block size
                                            used=7236 fsc=0 avsp=845 dtl=8088
                                    Page 196575 failed with check code 6110
                                    Block Checking: DBA = 16973807, Block Type = KTB-managed data block
                                    data header at 0xb733e264
                                    kdbchk: the amount of space used is not equal to block size
                                            used=7233 fsc=0 avsp=848 dtl=8088
                                    Page 196591 failed with check code 6110
                                    Block Checking: DBA = 16973823, Block Type = KTB-managed data block
                                    data header at 0xb725e264
                                    kdbchk: the amount of space used is not equal to block size
                                            used=7114 fsc=0 avsp=967 dtl=8088
                                    Page 196607 failed with check code 6110
                                    Block Checking: DBA = 16973855, Block Type = KTB-managed data block
                                    data header at 0xb729e264
                                    kdbchk: the amount of space used is not equal to block size
                                            used=7021 fsc=0 avsp=1060 dtl=8088
                                    Page 196639 failed with check code 6110
                                    Block Checking: DBA = 16973871, Block Type = KTB-managed data block
                                    data header at 0xb72be264
                                    kdbchk: the amount of space used is not equal to block size
                                            used=7217 fsc=0 avsp=864 dtl=8088
                                    Page 196655 failed with check code 6110
                                    
                                    DBVERIFY - Verification complete
                                    
                                    Total Pages Examined         : 124182
                                    Total Pages Processed (Data) : 2213
                                    Total Pages Failing   (Data) : 19
                                    Total Pages Processed (Index): 0
                                    Total Pages Failing   (Index): 0
                                    Total Pages Processed (Other): 32
                                    Total Pages Processed (Seg)  : 0
                                    Total Pages Failing   (Seg)  : 0
                                    Total Pages Empty            : 121937
                                    Total Pages Marked Corrupt   : 0
                                    Total Pages Influx           : 0
                                    Edited by: user00726 on Aug 12, 2009 12:32 AM
                                    1 2 Previous Next