Question Re: ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [] in Technology Q&A

ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], []

Former Member — Sat, 20 Mar 2010 12:33:44 GMT

Hi,

I got block corrupt on development server(Test system also on same area),i got this error in checkDB and verifyDB

VerifyDB:

BR0278W Command output of 'D:\oracle\DCE\102\BIN\dbv file=I:\ORACLE\DCE\SAPDATA3\DCE_4\DCE.DATA4 blocksize=8192

DBVERIFY: Release 10.2.0.4.0 - Production on Sat Mar 20 13:14:07 2010

DBVERIFY - Verification starting : FILE = I:\ORACLE\DCE\SAPDATA3\DCE_4\DCE.DATA4

Block Checking: DBA = 21204988, Block Type = KTB-managed data block

data header at 0x2c8625c

kdbchk: row locked by non-existent transaction

table=0 slot=37

lockid=82 ktbbhitc=2

Page 233468 failed with check code 6101

DBVERIFY - Verification complete

Total Pages Examined : 258560

Total Pages Processed (Data) : 46893

Total Pages Failing (Data) : 1

Total Pages Processed (Index): 47654

Total Pages Failing (Index): 0

Total Pages Processed (Other): 20247

Total Pages Processed (Seg) : 0

Total Pages Failing (Seg) : 0

Total Pages Empty : 143766

Total Pages Marked Corrupt : 0

Total Pages Influx : 0

Highest block SCN : 1251807644 (0.1251807644)

BR0398E DBVERIFY has detected corrupt blocks in I:\ORACLE\DCE\SAPDATA3\DCE_4\DCE.DATA4

checkDB:

ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], [], []

BR0976W Database message alert - level: ERROR, line: 834150, time: 2010-03-18 16.47.26, me

ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], [], []

kindly help

Regards

Sreekar

Re: ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], []

stefan_koehler — Sat, 20 Mar 2010 15:09:05 GMT

Hello Sreekar,

check this thread:

Any steps to solve this issue is described in there.

Maybe the reason for this corruption is oracle bug #7329252, which is described in sapnote #1413928.

Regards

Stefan

Re: ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], []

Former Member — Wed, 05 Jun 2013 04:02:54 GMT

Hi All,

In a case like this the first thing to check is table spaces , just check all datafiles are having the status online

Log in to SQLPLUS and issue "select file#,name,status from v$datafile;" check all datafiles are having the status online if any of them having the status "recover" then you have to recover the data file with oracle archive available

recover datafile file#;

After that issue

alter database datafile file# online;

then try to shtdown and restart the database;

Shanaka.

Re: ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], []

Former Member — Thu, 06 Jun 2013 08:32:32 GMT

hi sreekar,

Run this command as your orasid user oradce user dbv file=I:\ORACLE\DCE\SAPDATA3\DCE_4\DCE.DATA4 in the command line.

This will display if it is a false alert or actually corrupt.

Regards,

Johan

Re: ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], []

former_member206552 — Thu, 06 Jun 2013 08:54:09 GMT

Hi Sreekar

another option is to use rman to verify files

http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup005.htm

Using RMAN to Validate Database Files

Best Regards

Marius

Re: ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], []

former_member207463 — Wed, 19 Jun 2013 20:30:06 GMT

Please check SAP Note 1868324 about Handling ORA-600/ORA-7445 error.

Check also notes:

23345

Consistency check of ORACLE database

365481

Block corruptions

Best regards,

Jeisson Leonel

Re: ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], []

Former Member — Wed, 26 Jun 2013 19:58:32 GMT

This message was moderated.