| Error ORA-01115 [message #51403] |
Tue, 21 May 2002 13:26  |
NS
Messages: 7
Registered: May 2002
|
Junior Member |
|
|
Hi,
I got this following error message while processing some financial transactions. I am not able to figure out a possible solution. Can anybody help me fix this.
Here is the error message:
Error ORA-1115 occurred during multi_fetch
ORA-01115: IO error reading block from file 29 (block # 262144)
ORA-01110: data file 29: '/odata02/oradata/baandev2/co100/data/utfdat1.dbf'
ORA-27072: skgfdisp: I/O error
SVR4 Error: 25: Inappropriate ioctl for device
Additional information: 262143
Thanks for you help,
NS
|
|
|
|
| Re: Error ORA-01115 [message #51416 is a reply to message #51403] |
Wed, 22 May 2002 05:44  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
I would run dbv on the file. You may need to shutdown the database to do this unless you run unix. Once you have run dbv it should give you more info. This script will do all DB files and is for unix but feel free to modify it.
set serveroutput on
set echo off
set head off
set pages 0
set feedback off
set linesize 100
spool dbv.sh
select 'dbv '||' file='||file_name||' feedback=300'||' BLOCKSIZE='||value
from dba_data_files, v$parameter
where v$parameter.name = 'db_block_size';
spool off;
!chmod +x dbv.sh
!./dbv.sh
|
|
|
|
| Re: Error ORA-01115 [message #52478 is a reply to message #51416] |
Thu, 25 July 2002 02:12 |
Erich K
Messages: 42
Registered: July 2002
|
Member |
|
|
|
I got this error on AIX 4.3 for no reason at all with a SQL*C-program that was compiled with the -O3 optimization switch; recompiling with "CFLAGS=-O" in the makefile solved the problem.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
