Problems with connection

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
hansjoergp
Posts: 29
Joined: Wed 31 May 2017 14:33

Problems with connection

Post by hansjoergp » Tue 18 May 2021 08:57

Hello,

if we open an direct connection with the hostname we get always an ORA-03113 error (Devart.Data.Oracle.OracleException(0x80004005): ORA-0113: end-of-file on communication channel in Devart.Data.Oracle.Communication.Connect....
The connection works both with Direct = false and the OracleManagedDataAccess library.
The connection with Devart in DirectMode only works if I use either the IPv4 or the IPv6 address. But not with the hostname

With tnsping I get the following information (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PRO
TOCOL=TCP)(HOST=fe80::900d:6ed2:637b:851%12)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(
HOST=169.254.205.37)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.123.5)(PORT
=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.5)(PORT=1521)))
OK

Tnsping works with IPV6, IPV4 and Hostname

What can we do to solve the problem?

DmitryGm
Devart Team
Posts: 42
Joined: Fri 11 Dec 2020 10:27

Re: Problems with connection

Post by DmitryGm » Tue 25 May 2021 13:44

The ORA-03113 error is caused by some system or network problem. This error is so common that it is unlikely that one will find the exact reason without additional information, so you will need to learn how to debug this particular error by reading log and/or trace files. Usually dotConnect for Oracle in the Direct mode can connect by hostname as well as by IP.

hansjoergp
Posts: 29
Joined: Wed 31 May 2017 14:33

Re: Problems with connection

Post by hansjoergp » Mon 07 Jun 2021 12:07

Why the connection is working with all other Oracle drivers, with direct mode = false...?

DmitryGm
Devart Team
Posts: 42
Joined: Fri 11 Dec 2020 10:27

Re: Problems with connection

Post by DmitryGm » Mon 07 Jun 2021 15:53

hansjoergp wrote: Mon 07 Jun 2021 12:07 Why the connection is working with all other Oracle drivers, with direct mode = false...?
With Direct mode = false, dotConnect for Oracle works in the OCI mode, so it uses the connection settings specified in the Oracle Client configuration file - tnsnames.ora. How is your Oracle server alias described in that file? Is the "HOST" parameter specified as an IP or hostname?

hansjoergp
Posts: 29
Joined: Wed 31 May 2017 14:33

Re: Problems with connection

Post by hansjoergp » Tue 22 Jun 2021 11:55

in the tnsnames.ora it works in boot ways. With hostname and IP. The same is with the oracle managed driver

Post Reply