Stack Overflow
Stack Overflow

Questions tagged [ora-12170]

ORA-12170: TNS:Connect timeout occurred

From https://docs.oracle.com/cd/B19306_01/server.102/b14219/net12150.htm:

Cause:

The server shut down because connection establishment or communication with a client failed to complete within the allotted time interval. This may be a result of network or 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 or system, reconfigure one or all of the parameters SQLNET.INBOUND_CONNECT_TIMEOUT, SQLNET.SEND_TIMEOUT, SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values.
  • 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).
28 questions
33
votes
9 answers

ORA-12170: TNS:Connect timeout occurred

I was trying to connect to the database here in my laptop using Oracle Toad but I kept on having this error: ORA-12170: TNS:Connect timeout occurred What are the possible reasons why I kept on having this error? I accessed the same database…
Pseudonymous
  • 625
  • 1
  • 5
  • 13
8
votes
3 answers

Where is TNSNAMES.ORA?

I am working on a Windows server and access Oracle databases using the Oracle ODBC driver. I have Oracle ODBC connections that work fine on this machine. However I want to add a new connection, and when testing it I get the error Unable to…
Alexis Eggermont
  • 7,665
  • 24
  • 60
  • 93
7
votes
9 answers

How come sqlplus not connecting?

My goal is to connect to an Oracle 9i instance from my OS X machine. I've followed the setup instructions here and got through them with no errors (eventually). However, I'm finding that sqlplus is unable to connect: [ ethan@gir ~ ]$ sqlplus…
Ethan
  • 57,819
  • 63
  • 187
  • 237
4
votes
1 answer

JDBC and Oracle 11g connection reset on ubuntu

I am having this strange issue connection JDBC to Oracle 11g. It started happening suddenly this Monday without any settings changes that either me or the team were aware of. Reading in Stackoverflow and Oracle forums (see links at the bottom) I've…
amit
  • 1,991
  • 1
  • 18
  • 29
3
votes
3 answers

[Oracle][ODBC][Ora]ORA-12170: TNS:Connect timeout occurred ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

I created a SSIS package to pull data from Oracle database to SQL server database. I have set up ODBC connection successfully on my local machine and on the server, I can connect to Oracle database using sqlplus on both environments. And my package…
Coco
  • 31
  • 1
  • 1
  • 3
2
votes
1 answer

How to access Oracle 10g Server over a Local Area Network?

I installed Oracle 10g server Express edition on a System(say host-a[100.101.102.103]) And I tried access the database from another system(say host-b[100.101.102.104]) using the command on the sql command line "**connect…
Raja Anbazhagan
  • 27
  • 8
2
votes
1 answer

Oracle connection ok but ORA-12170: TNS:Connect timeout occurred when executing queries

I have some errors executing queries against a oracle 11g database from a .net c# console application. The connection seems to be established properly (the conn.State property is Open after the following lines) OracleConnection conn = new…
klautern
  • 129
  • 3
  • 7
  • 26
2
votes
1 answer

How do I know which ORA file my SSIS package is using to connect to Oracle 10g?

I am maintaining an SSIS package which extracts data from an Oracle 10g database. When the connection timed out with the error code: Test connection failed because of an error in initializing provider. ORA-12170: TNS:Connect timeout occurred I was…
Blanthor
  • 2,568
  • 8
  • 48
  • 66
2
votes
1 answer

ORA-12170: TNS:Connect timeout occurred When try to connect from host OS

I have Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production installed on virtual machine(VirtualBox, OS: Oracle Linux 7). All going normal, when I try to connect from the virtual machine where oracle database installed.…
Etanol
  • 21
  • 1
  • 1
  • 2
2
votes
1 answer

Connection Error:Oracle.DataAccess.Client.OracleException ORA-12170

This has taken many hours of mine. I have to get this .Net app to run on an XP system. Someone seems to have messed up some files so conn.Open() in the C# is causing this error: Connection Error:Oracle.DataAccess.Client.OracleException…
psyb0rg
  • 85
  • 2
  • 9
1
vote
1 answer

Oracle Connection String for ODP.NET with LDAP name

I'm using the current version of ODP.NET and trying to connect to an Oracle Server using an LDAP name. I tried the basic string: Data Source=ServerName;User Id=RemovedUserId;Password=RemovedPwd; The connection attempt just times out with the…
Josh
  • 8,219
  • 13
  • 76
  • 123
1
vote
2 answers

PHP error when connect to Oracle 10G R2

I have this code : ociinternaldebug(1); // try connecting to the database $conn = oci_new_connect('username', 'password', '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.1 )(PORT = 1521)) (CONNECT_DATA = (SID = dpsid)))'); // check for…
Saleh
  • 2,657
  • 12
  • 46
  • 73
1
vote
2 answers

ERROR ORA-12170: TNS:Connect timeout occurred (oracle forms 11g)

I'm struggling to connect to the database using oracle forms 11g. I'm using my machine as a local host using weblogic and XE database. When I try to connect to the database using oracle forms, this error pops "ERROR ORA-12170: TNS:Connect timeout…
pato
  • 41
  • 1
  • 7
1
vote
1 answer

Connect timeout occurred in sql server with linked server

I Connected to Oracle as Linked Server from Sql Server 2008 R2 after Executing 20-30 Min i getting following error: OLE DB provider "OraOLEDB.Oracle" for linked server "CBSLINKED" returned message "ORA-12170: TNS:Connect timeout occurred". …
Dgan
  • 10,077
  • 1
  • 29
  • 51
1
vote
0 answers

Getting Error on Oracle Export Schemas

execute following Command expdp scott/tiger@orcl schemas=EMPLOYEES directory=DB_BAK dumpfile=SCOTT.dmp logfile=expdpSCOTT.log Getting this error when I execute above command for export Schemas Export: Release 11.2.0.1.0 - Production on Wed Mar 12…
Tanim
  • 26
  • 2
1
2