ORA-03113 end-of-file on communication channel Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the SQL*Net, two task, software. This message could occur if the shadow two-task process associated with a SQL*Net 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 connection attempt, check the setup files for the appropriate SQL*Net driver and confirm SQL*Net 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. 出现这个错误,一般是由于连结断了~~ 你的dblink在sqlplus下能正常使用吗?
03113, 00000, "end-of-file on communication channel" // *Cause: // *Action: 先测试一下dblink是否可用,有可能是远程主机当掉了。
maybe remote server is down
Action: If this message occurs during a connection attempt, check the setup files for the appropriate SQL*Net driver and confirm SQL*Net 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. 出现这个错误,一般是由于连结断了~~
你的dblink在sqlplus下能正常使用吗?
// *Cause:
// *Action:
先测试一下dblink是否可用,有可能是远程主机当掉了。
然后再在sqlplus中进行测试看能否使用数据库链接;
如果都是ok的啦,那么应该就没问题啦
设置HS_FDS_TRACE_LEVEL=15,查看.trc文件,分析问题出现在哪里,帖出来看看,大家分析