topic Re: Elusive Hardware Issue in Operating System - HP-UX

Elusive Hardware Issue

Youlette Etienne_2 — Tue, 28 Aug 2001 14:42:42 GMT

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

Re: Elusive Hardware Issue

Youlette Etienne_2 — Tue, 28 Aug 2001 16:06:09 GMT

here it is

Re: Elusive Hardware Issue

Bart Paulusse — Wed, 29 Aug 2001 11:59:13 GMT

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

Re: Elusive Hardware Issue

Magdi KAMAL — Thu, 30 Aug 2001 06:29:13 GMT

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

Re: Elusive Hardware Issue

Paula J Frazer-Campbell — Thu, 30 Aug 2001 07:56:10 GMT

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

Re: Elusive Hardware Issue

Youlette Etienne_2 — Thu, 30 Aug 2001 13:18:27 GMT

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.