Urgent: ORA-01115 in alert.log

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Tue, 15 May 2001 11:17:07 +0200
Message-ID: <3B00F413.A15F6156@mytoys.de>

Hi there,

since some days I have a message in my alert.log, saying that:

Tue May 15 11:06:02 2001
Errors in file
/opt/app/oracle/product/MTPRT/admin/MTPRT/bdump/mtprt_smon_12839.trc:

ORA-01115: IO error reading block from file 16 (block # 262144)
ORA-01110: data file 16: '/erp_b_8/oradata/MTPRT/dbs/apps02MTPRT.ndx'
ORA-27072: skgfdisp: I/O error

SVR4 Error: 2: No such file or directory Additional information: 262143

My questions:

1. How do I find out, which index is using the block?
2. When I know a), will a drop index and create index solve the problem?
3. Why is there a message: SVR4 Error: 2: No such file or directory?

Thank you in advance.

Regards,

Knut Received on Tue May 15 2001 - 04:17:07 CDT