ORA-12170 and 03113 - 04/13/22 02:06 PM
We have an intermittent problems with communications between clients and Oracle servers (both Windows.) We may see ORA-12170: TNS:Connect timeout occurred or ORA-03113: end-of-file on communication channel. When this happens there is no error on the Oracle server. We believe it is a network issue but we can't make it happen on demand and haven't been able to diagnose.
Sometimes a multi-user application using a session with ThreadSafe = true just hangs without generating an exception; it seems that the client waits indefinitely, and requests from other threads back up behind it. Should SQLNET.RECV_TIMEOUT and SEND_TIMEOUT help? If we used a TOracleSessionPool with a timeout set, would it terminate the thread?
Thanks or any suggestions.
Sometimes a multi-user application using a session with ThreadSafe = true just hangs without generating an exception; it seems that the client waits indefinitely, and requests from other threads back up behind it. Should SQLNET.RECV_TIMEOUT and SEND_TIMEOUT help? If we used a TOracleSessionPool with a timeout set, would it terminate the thread?
Thanks or any suggestions.