We are experiencing the following error with a C# application trying to connect to our Oracle Database:
ORA-12170: TNS:Connect timeout occurred at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
at Oracle.DataAccess.Client.OracleConnection.Open()
at ADF_Controller.DbHelper.UpdateJobEventsTable()
the C# application is a file watcher just polling certain directories for files. When a file is put in one of the watched directories, the application picks it up and attempts to load its contents into Oracle. The database version is 10.2.0.1.0.
This process has been working for about 3 months, and then in the last 2 weeks we started to encounter issues. Please note that for the majority of the time, this process works, i.e. the c#application connects succesfully to Oracle, but occasionally we get this ORA-12170 error.
I have tried to investigate what this issue may be - some sources suggest the sqlnet.ora file. The contents of the sqlnet.ora file that the c#application uses is listed below:
# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
Please can anyone provide any insight as to what maybe causing this issue?
Many thanks