DIRECT Connection Mode: Ora-03113: end-of-file on communication channel

[tracer609]

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.

[AlexP]

Hello,

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

[tracer609]

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?

[tracer609]

any update on this issue?

[AlexP]

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.

[tracer609]

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?

[AlexP]

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