Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ORA -01115 error in db13 checkdb

Hi expert ,

i am new to this fouram i have ora-01115 error in sap oracle 9i database ,

Please help me to solve the problem .

I am using ECC 5.0 ,win2k3 enterprise edition ,Oracle 9i

could anybody explain me what the relation of oracle block segment ,and windows block segment .

Could i solve the problem without reinstalling sap .

<b>Please explain me in detail following paragraph ,which i read ,</b>

• <b>a corrupted database due the auto extended bug

• Corrupt block dba: 0x24024cd0 file=5. blocknum=150736.

• found during buffer read on disk type:0. ver.

• dba:0x00000000 inc:0x00000000 seq:0x00000000 incseq:0x00000000

• Entire contents of block is zero - block never written

• Reread of block=24024cd0 file=9. blocknum=150736. found same corupted Data

• Mishandled block information (in certain conditions), upon reading the database block, which indicates that a good block is corrupted. This is the bug in the Oracle version 8.1.x - 9.x, where the Oracle will raise the error:

ORA-600 [kcoapl_blkchk][ABN][RFN][INT CODE]

Pointing to failure condition during block check. This only happens when block checking is enabled.

• A problem with a faulty database trigger operation, causing data block corruptions

• ORA-01115: IO error reading block from file 6 (block # 14873)

• ORA-01110: data file 6: '/oracle/artist/artist01.dbf'

• ORA-27091: skgfqio: unable to queue I/O

• IBM AIX RISC System/6000 Error: 9: Bad file number</b>

Thanx & Regards




This is Forum , Here you will get inputs not Consultants.

In every post you are asking some thing , Have ans to your questions in all the threads. You are not at all replying to your questions.

I said Ora 600 Errors are not easy to handle They are internal errors Consult your DBA .

and in Log you have many messages Its described Please read documentation

Ex Archiver Space Datafile missing Datablock Corrupted Every thing is Explained in SAP Documentation. As you are new it will be Good for you to READ THE DOC AND unstd.


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question