ORACLE常见错误代码的分析与解决

核心提示： Time-outs（超时）File corruption(文件太老)Failed data checks in memory（内存检索失败）Hardware,memory,or I/O errors（硬件、内存或者磁盘错误）Incorrectly restored files（错误的重建文

Time-outs（超时）

File corruption(文件太老)

Failed data checks in memory（内存检索失败）

Hardware,memory,or I/O errors（硬件、内存或者磁盘错误）

Incorrectly restored files（错误的重建文件）

ORA-03113：end-of-file on communication channel

产生原因：通讯不正常结束，从而导致通讯通道终止

解决方法：

1>.检查是否有服进程不正常死机，可从alert.log得知

2>.检查sql*Net Driver是否连接到ORACLE可执行程序

3>.检查服务器网络是否正常，如网络不通或不稳定等

4>.检查同一个网上是否有两个同样名字的节点

5>.检查同一个网上是否有重复的IP地址

相应的英文如下：

Cause:An unexpected end-of-file was processed on the communication channel.The problem could not be handled by the Net8,two task,software.This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally,or if there is a physical failure of the interprocess communication vehicle,that is,the network or server machine went down.

Action:If this message occurs during a commection attempt,check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server.If the message occurs after a connection is well established,and the error is not due to a physical failure,check if a trace file was generated on the server at failure time.Existence of a trace file may suggest an Oracle internal error that requires the assistance of customer support.