I'd certainly consider running dbverify against the datafiles.
Are all the files on the same volume?
On 5/25/06, Freeman, Donald <dofreeman@(protected)> wrote: > > We have started experiencing this error in the last few weeks and are > trying to identify the cause. We opened a ticket with Oracle and one with > HP (SAN).I just checked the logs from the web servers and found this > ORA-01115 (See ORA-01115.ora-code.com) error was logged by the web application 6 times yesterday between > 2:49 and 3:10 PM. We're not sure if it's both nodes or just one. The last > time it had been logged previously was 12/22/05. Four of those times, it > was the same file that our batch process had a problem with -- > PARTIES_DATA01.dbf. On the other 2 occasions, it was PARTIES_DATA02.dbf and > LOCATION_DATA01.dbf. > > HP says the SAN is healthy, Windows hasn't logged any issues, and Oracle > says it isn't their problem. If anyone has a suggestion for diagnosing > this, I'm all ears. > > *ORA-01115 (See ORA-01115.ora-code.com) IO error reading block from file string (block # string) > Cause:* The device on which the file resides is probably off line. > *Action:* Restore access to the device, then retry the operation. > > Don Freeman > Database Administrator 1 > Bureau of Information Technology > Pennsylvania Department of Health > (717) 703-5782 >
<div>I'd certainly consider running dbverify against the datafiles. </div> <div> </div> <div>Are all the files on the same volume? <br><br> </div> <div><span class="gmail_quote">On 5/25/06, <b class="gmail_sendername">Freeman, Donald</b> <<a href="mailto:dofreeman@(protected)">dofreeman@(protected)</a> > wrote:</span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0 .8ex; BORDER-LEFT: #ccc 1px solid"> <div> <div> <p><font face="Courier New" size="2">We have started experiencing this error in the last few weeks and are trying to identify the cause. We opened a ticket with Oracle and one with HP (SAN).I just checked the logs from the web servers and found this ORA-01115 (See ORA-01115.ora-code.com) error was logged by the web application 6 times yesterday between 2:49 and 3:10 PM. We're not sure if it's both nodes or just one. The last time it had been logged previously was 12/22 /05. Four of those times, it was the same file that our batch process had a problem with -- PARTIES_DATA01.dbf. On the other 2 occasions, it was PARTIES_DATA02.dbf and LOCATION_DATA01.dbf. </font></p> <p><font face="Courier New" size="2">HP says the SAN is healthy, Windows hasn't logged any issues, and Oracle says it isn't their problem. If anyone has a suggestion for diagnosing this, I'm all ears. </font></p> <p><b><font face="Times New Roman">ORA-01115 (See ORA-01115.ora-code.com) IO error reading block from file string (block # string)<br>Cause:</font></b><font face="Times New Roman"> The device on which the file resides is probably off line.</font> <br> <b><font face="Times New Roman">Action:</font></b><font face="Times New Roman"> Restore access to the device, then retry the operation.</font> </p><br> <p><font face="Arial" size="2">Don Freeman</font> <br><font face="Arial" size= "2">Database Administrator 1</font> <br><font face="Arial" size="2">Bureau of Information Technology</font> <br><font face="Arial" size="2">Pennsylvania Department of Health </font> <br><font face="Arial" size="2">(717) 703-5782</font> </p></div></div>< /blockquote></div><br><br clear="all"><br>-- <br>Niall Litchfield<br>Oracle DBA <br><a href="http://www.orawin.info">http://www.orawin.info</a>
