Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

General Questions


ORA-12170: TNS:Connect timeout occurred


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

Error:	  ORA-12170  (ORA-12170) Text:	  TNS:Connect timeout occurred Cause:	The server shut down because connection establishment with a  	client failed to complete within the allotted time interval. This  	may be a result of network/system delays; or this may indicate  	that a malicious client is trying to cause a Denial of Service  	attack on the server.  Action:	If the error occurred because of a slow network/system,  	reconfigure the SQLNET.INBOUND_CONNECT_TIMEOUT parameter in  	sqlnet.ora to a larger value. If a malicious client is suspected,  	use the address in sqlnet.log to identify the source and restrict  	access. Note that logged addresses may not be reliable as they can  	be forged (e.g. in TCP/IP).  =============================================0  Set SQLNET.INBOUND_CONNECT_TIMEOUT to a larger value,it defaults to 60s. Value must be specified in seconds.  Werner

thanks.  I presume I can just add the following to the sqlnet.ora file:   SQLNET.INBOUND_CONNECT_TIMEOUT=180     i.e three minutes before timing out.  Many thanks  Paul


Related Links

Oratab entry
Tuning request on slow sort with less than 10 000 rows.
brief report of about 2 months for the sqls run under a specific user ?
Deadlock Graph
UTL_MAIL issue
HOW TO BACKUP AND MAINTAIN PERFORMANCE ALSO?
Startup issue
ora error
os level TL Patch aix6.1 TL6-SP07 compartibility with oracle11gR2
LDAP syncronization
datafile not enabled
form 6i connect to oracle7
Oracle 11G on AIX CPU Load balancing
user password
_db_block_max_scan_pct
Pros and cons of PL/SQL table