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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> <META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6617.47"> <TITLE>ORA-01115 (See ORA-01115.ora-code.com) IO error reading block from file string </TITLE> </HEAD> <BODY> <!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Courier New">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 SIZE=2 FACE="Courier New">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>
