Devart Forums

Hello,

we try to connect to a remote database using DIRECT mode and get always "Ora-03113: end-of-file on communication channel" error. If we connect through Oracle client, the connection succeeds. How can we fix this issue for DIRECT mode?

thanks.

Hello,

Please specify the exact versions of ODAC, IDE and Oracle server.

Hi,

ODAC 9.3.8, XE4, Oracle 12.1.0

please note that this server is behind firewall and port 1521 is open. All tools like sqlplus or jdbc programs can connect without any problem . Also, we can connect to this database using oracle client but direct mode fails. Could you please give us any idea what additional ports are used in direct mode? I suppose that the issue is bound to firewall and that some ports required by ODAC are closed. But why connection through Oracle client succeeds?

any update on this issue?

By default, Oracle opens the connection on any free port (and not on the listener port), try to set TRUE for the USE_SHARED_SOCKET parameter on the server, so that the server works on the same port as the listener.

thank you for your reply. But why connection through oracle client is established but in direct mode not when use_shared_socket parameter is not used?

This behavior of the client is implemented in SQL Net V2, the port that the server returns is used in our direct mode.