| ORA-01115 ORA-01110 ORA-27091 ORA-27070 [message #62012] |
Thu, 17 June 2004 17:01  |
liuxnp
Messages: 3
Registered: April 2003
|
Junior Member |
|
|
Detail:
Source Exception:
Message:ORA-01115: 从文件 1 读取块时出现 IO 错误 (块 # 51449)
ORA-01110: 数据文件 1: 'D:ORACLEORADATAWEBDBSYSTEM01.DBF'
ORA-27091: skgfqio: 无法进行 I/O 操作
ORA-27070: skgfdisp: 异步读取/写入失败
OSD-04006: ReadFile() 失败, 无法读取文件
O/S-Error: (OS 1167) 设备没有连接。
SQL Or Message:Select ORD_NO From TB_ORDERHEAD Where[sp] (ORD_STATUS In ( 'NEW') ) And (REMOVE_IND='N') Order By[sp] TB_ORDERHEAD.ORD_DATE DESC
at bigning.db.AbstractDal.doSelect(AbstractDal.java:252)
at bigning.db.DefaultResultSetLister.list(DefaultResultSetLister.java:36)
at bigning.db.DefaultResultSetLister.list(DefaultResultSetLister.java:58)
at bigning.db.ext.AbstractBeanSet.<INIT>(AbstractBeanSet.java:39)
at bigning.db.ext.AbstractBeanSet.<INIT>(AbstractBeanSet.java:70)
at bigning.db.ext.BeanSetListerWrapper.getBeans(BeanSetListerWrapper.java:69)
at _jhkmanager._order._order_0list__jsp._jspService(_order_0list__jsp.java:162)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:506)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com32web.filter.Com32webVisitLogFilter.doFilter(Com32webVisitLogFilter.java:77)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:536)
Nested Exception:
java.sql.SQLException: ORA-01115: 从文件 1 读取块时出现 IO 错误 (块 # 51449)
ORA-01110: 数据文件 1: 'D:ORACLEORADATAWEBDBSYSTEM01.DBF'
ORA-27091: skgfqio: 无法进行 I/O 操作
ORA-27070: skgfdisp: 异步读取/写入失败
OSD-04006: ReadFile() 失败, 无法读取文件
O/S-Error: (OS 1167) 设备没有连接。
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:943)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2126)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2331)
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:6223)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:640)
at bigning.db.AbstractDal.doSelect(AbstractDal.java:243)
at bigning.db.DefaultResultSetLister.list(DefaultResultSetLister.java:36)
at bigning.db.DefaultResultSetLister.list(DefaultResultSetLister.java:58)
at bigning.db.ext.AbstractBeanSet.<INIT>(AbstractBeanSet.java:39)
at bigning.db.ext.AbstractBeanSet.<INIT>(AbstractBeanSet.java:70)
at bigning.db.ext.BeanSetListerWrapper.getBeans(BeanSetListerWrapper.java:69)
at _jhkmanager._order._order_0list__jsp._jspService(_order_0list__jsp.java:162)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:506)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com32web.filter.Com32webVisitLogFilter.doFilter(Com32webVisitLogFilter.java:77)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:536)
POSITION of :Inheritance of bigning.db.DalException: ORA-01115: 从文件 1 读取块时出现 IO 错误 (块 # 51449)
ORA-01110: 数据文件 1: 'D:ORACLEORADATAWEBDBSYSTEM01.DBF'
ORA-27091: skgfqio: 无法进行 I/O 操作
ORA-27070: skgfdisp: 异步读取/写入失败
OSD-04006: ReadFile() 失败, 无法读取文件
O/S-Error: (OS 1167) 设备没有连接。
bigning.db.DalException
|---java.lang.Exception
[sp][sp][sp] |---java.lang.Throwable
[sp][sp][sp][sp][sp][sp][sp] |---java.io.Serializable [[I]]
[sp][sp][sp][sp][sp][sp][sp] |---java.lang.Object
at _errorpage__jsp._jspService(_errorpage__jsp.java:116)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:506)
...
at java.lang.Thread.run(Thread.java:536)
[[ printed by bigning.debug.Debugger.print() ]]
Exception Occored At:Jun 17, 2004 17:58:39
|
|
|
|
| Re: ORA-01115 ORA-01110 ORA-27091 ORA-27070 [message #62016 is a reply to message #62012] |
Fri, 18 June 2004 01:19  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
Oracle cannot read database file D:ORACLEORADATAWEBDBSYSTEM01.DBF'. Windows error 1167 means "the device is not connected". Fix the problem on OS level and re-try.
01115, 00000, "IO error reading block from file %s (block # %s)"
// *Cause: Device on which the file resides is probably offline
// *Action: Restore access to the device
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
