Elusive Hardware Issue

[Youlette Etienne_2]

We have Oracle 8 installed on a k580, 11.0, Raid 5 array system. The oracle users are receiving the following error message:

ORA-01115: 1O error reading block from file 116 (block #431619) :ORA-01110: data file 116: '/odws35/oradata/ODWS/fact_serv6_ts.dbf' :ORA-27072:skgfdisp: I/O error:HP-UX Error: 2: No such file or directory :Additional information: 431491:-1115

I have done the following:
1) copied the above file to another disk without errors
2) created a file on this disk without errors
3) ran pvdisplay/lvdisplay to look for 'stale' sectors. There are none
4) checked syslog.log files, there are no hardware errors
5) ran ioscan to make sure that all devices show as claimed.

Has anyone encountered this error before on a similar system setup?

--Youlette

[Youlette Etienne_2]

here it is

[Bart Paulusse · Accepted solution]

Hi Youlette,

2 months ago we had the same errors. We ended up restoring the entire database after it crashed!
The problem was caused by filesystem corruption. We installed these patches to solve the vxfs problem:
PHKL_24014
PHCO_23651

regards,

Bart

[Magdi KAMAL]

Hi Youlette,

You mentioned the following message :
"I/O error:HP-UX Error: 2: No such file or directory " :

So, Oracle can't find any more one of its files ( data file, control file, password file, or any other needed file ).

Check if all fo them are existing !

Magdi

[Paula J Frazer-Campbell]

Hi
Try this

1. Copy the file to a *.copy in the same dir.
2. Rename the original file to *.bak
3. Rename the *.copy to the correct name.

The file will then exist on a diffent area of the disk and if the failure occurs again then either the file is corrupt or other associated files.

HTH

Paula

[Youlette Etienne_2]

Thank you for responding.

Magdi: The problem has not reoccurred and the database is still functioning. It has even been shutdown and started for backup without problems, atleast that I know of. The dba is running a table space analysis for errors.

Bart: These patches are not installed on the server, so I will schedule some downtime to do this.

Paula: I didn't think of trying this, so if it reoccurs, I'll add this to write the file to a different area.

Thanks again.