Re: Urgent: ORA-01115 in alert.log

Is there, in fact, a file by that name in that location (/erp_b_8/oradata/MTPRT/dbs/apps02MTPRT.ndx)  and for which correct permissions have been set?

Knut Talman <knut.talman_at_mytoys.de> wrote:

>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:
>
>a) How do I find out, which index is using the block?
>
>b) When I know a), will a drop index and create index solve the problem?
>
>c) 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 - 11:38:28 CDT