Devart Forums

Hi

Recently we change the conection string in the aplication to connect to a new BD in Oracle. But we have this error.


The TNSPING responding positive comunication between two servers (aplication server and BD server) and the user and password autentication are correct in the BD using the sqlplus for oracle



Somebody have any idea? Thanks

Network error: 2514
Devart.Data.Oracle.OracleException (0x80004005): Network error: 2514
en Devart.Data.Oracle.DirectUtils.b(Int32 A_0)
en Devart.Data.Oracle.d8.m()
en Devart.Data.Oracle.d8.h()
en Devart.Data.Oracle.cq.a(String A_0, String A_1, String A_2, String A_3)
en Devart.Data.Oracle.dw.a(cv A_0, Boolean A_1)
en Devart.Data.Oracle.dw.a(cv A_0, s A_1)
en Devart.Data.Oracle.OracleInternalConnection..ctor(cv connectionOptions, OracleInternalConnection proxyConnection)
en Devart.Data.Oracle.a1.a(ag A_0, Object A_1, DbConnectionBase A_2)
en Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, ag A_1, DbConnectionBase A_2)
en Devart.Common.DbConnectionPool.a(DbConnectionBase A_0)
en Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection)
en Devart.Common.DbConnectionFactory.b(DbConnectionBase A_0)
en Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
en Devart.Common.DbConnectionBase.Open()
en Devart.Data.Oracle.OracleConnection.Open()
en System.BCL.Storage.OracleStorage.dbClient.Prepare()

Please clarify:

1.) The version of dotConnect for Oracle.
2.) Do you connect in Direct Mode or OCI Mode?
3.) The version of Oracle Client (if using OCI Mode)
4.) The type of the application (.NET3, NET5, or .NET Framework project)
5.) The platform of the application (Windows or Linux)
6.) Does the Oracle connection use TCPS protocol and Oracle Wallet?

Hi,Thanks for reply

We had everything fine until, due to a database failure, we had to change the connection to the mirror database. With the previous database it communicated fine. It is the same server and the same application what we changed was the IP address, Port and SID, to connect to the mirror DB and the problems began. I send you the information you request

1.) The version of dotConnect for Oracle:. Version dotConnect 9.1.131.0
2.) Do you connect in Direct Mode or OCI Mode? : Direct Mode
3.) The version of Oracle Client (if using OCI Mode)--In this server exist a version 11.2 for oracle, because there are other applications that use it.
4.) The type of the application (.NET3, NET5, or .NET Framework project): .NET Framework 4.7.2
5.) The platform of the application (Windows or Linux) Windows Server 2008 R2 standard
6.) Does the Oracle connection use TCPS protocol and Oracle Wallet? use TCPS protocol

We are not aware of any connectivity issues with this configuration. Most likely there are local network problems, especially since you have previously successfully connected to another server. Make sure there are no local or network firewalls blocking communication with the server.

Just in case, let's check:

• Your application uses locally installed Devart assemblies (not NuGet packages), doesn't it?
• Is the IP address of the Oracle server IPv4 or IPv6?