中间层连接ORACLE,过几小时后,出错:ORA-03114(200)

数据服务器:WIN2003+ ORA10G ,中间层:WIN2003 它们都在同一防火墙内,且通过局域网IP连接,中间层连接ORACLE,开始没问题,但过几小时后,出错:ORA-03114,实际上用PLSQL连上去ORACLE是没有问题的.

ORA-03113: end-of-file on communication channel Cause: The connection between Client and Server process was broken.Action: There was a communication error that requires further investigation. First, check for network problems and review the SQL*Net setup. Also, look in the alert.log file for any errors. Finally, test to see whether the server process is dead and whether a trace file was generated at failure time.

连接池等待太多，导致中间层死掉。确定是不是线程池的连接释放有问题

连接没及时释放的问题

连接池当然要过一段时间才释放的,不会那么及时的

中间层并没有死.只是有这个错出现