ORA-12170: TNS:Connect timeout occurred
You might want to check if there is no firewall available that blocks connections to the database server (typically on port 1521), or if the port returned by the listener is not open.
Another possibility is that you accidentally rely on the HOSTNAME feature of sqlnet.ora.
If there is no sqlnet.ora defined, one of the lookup methods used by the TNS networking (apart from tnsnames, oracle names server, oracle internet directory, ...) libraries is hostname lookup.
When the server is not reachable for some reason, you will also get this error.
Either there is no sqlnet.ora in the %ORACLE_HOME%/network/admin directory, or the sqlnet.ora contain following entry: NAMES.DIRECTORY_PATH=(HOSTNAME, TNSNAMES, ...)Now we are trying to make a connection:
H:\>sqlplus system/manager@down.be.dbmotive.com SQL*Plus: Release 11.1.0.7.0 Copyright (c) 1982, 2008, Oracle. All rights reserved. ERROR: ORA-12170: TNS:Connect timeout occurredWe made a tpye and incorrectly used a server name (physical machine) instead of a service name (database name).
Because HOSTNAME is also defined in sqlnet.ora, it tries to connect to the listener on the default port to see if there are available database services.
But our physical server is down at the moment:
C:\>ping down.be.dbmotive.com
Pinging down.be.dbmotive.com [192.168.10.1] with 32 bytes of data:
Request timed out.
Request timed out.
Request timed out.
Request timed out.
Ping statistics for 192.168.10.1:
Packets: Sent = 4, Received = 0, Lost = 4 (100% loss),
So either check that you are not using a hostname by mistake which is not available, or check for network/firewall problems.
Welcome to our forum for Oracle error: ORA-12170 Add your own message
my name is raja, when I am trying to connect to my friend's data base from my laptop, its showing ORA-12170: TNS:Connect timeout occurred error. I tried to increase the value of SQLNET.INBOUND_CONNECT_TIMEOUT parameter. But I cant see this parameter in my sqlnet.ora file. Could you help me to solve this problem.
Thanks in advance.
Is there a firewall in place?
Does tnsping work?
Note:
SQLNET.INBOUND_CONNECT_TIMEOUT =0 is disabled
SQLNET.INBOUND_CONNECT_TIMEOUT = 360 (or whatever) is enabled)
Make sure you and your friend are not running Windows firewall... if you do, there are more things you will need to do (it can be a pain!).
Jeff-
First i got the error ORA-12541 error...tns listener error..
so i went to command prompt and gave lsnrctl..
and tried to stop and start the listener that went fine..
but when i am starting the database using start databasename..
its giving error TNS-01151 Missing listener name,oimdb,in listener.ora...
after that i restarted the listener and oimdb service..
when i tried to restart the SQL plus,its giving ORA-12170 error connection timed out...
so i added SQLNET.INBOUND_CONNECT_TIMEOUT = 360 in sqlnet.ora file...
but still i am getting ORA-12170 connection timed out error...
i will be happy if some body could help me...
Thanks in advance...
I am trying to connect to the Database server from Vista client using code written in VB 6.0, The oracle client installed in Vista is 10.2g
I am using the below code to connect to the oracle database. I tried increasing the INBOUND_CONNECT_TIMEOUT parameter in the SQLNet.ora file, but didn't work.
Set gvobjOraSession = CreateObject(gvOraSession)
Set gvobjOraDatabase = gvobjOraSession.OpenDatabase(gvOraDBName, gvOraDefaultUser & "/" & gvOraDefaultPassword, vOraMode)
Thanks for the help in advance
Anand
Open firewall settings and ensure the listener port is not blocked.
For example, on a Windows system, navigate to Control Panel-> Security Center-> Windows Firewall-> Exceptions. Click on Add port and add port 1521 or whatever port the listener is running on (see listener.ora).
Got the solution from: http://www.orafaq.com/wiki/ORA-12170
when i connect c# with oracle on antoher pc this message ORA-12170: TNS:Connect timeout occurred ,i want to increase timeout but i dont know how ?.and i tray but i dont find SQLNET.INBOUND_CONNECT_TIMEOUT in sqlnet.ora file , so please show me how
Hi,
I am trying to connect to oracle 10g express server with odp.net using c# 2.0 as codebase. While doing so i am getting error of "12170: TNS: Connect timeout occured". but i can connect the same database by using sqlplus developer tool.
Thanks in Adavnce
Enter your message I have two instance in same computer with windows. I can log on as sql form but when I try to connect dbconsole, oem and try to start the dbconsole from command form masege come like connect timeout occured and such services not found
I am trying to make a client-server relation beteen Enterprise edition of Oracle 10G and free version installed on 2 different machines. The firewalls are off. I've still included 1521 port in exceptions. I've included Server's hostname in the Client's Listner.ora and tnsnames.ora.
I am able to achieve connection successfully, but not everytime. Many times, connection timeout message is displayed.Only upon 2-3 restarts of both Server and Client machine, I am able to connect oracle.
I would rule out Network problem, caz both machines are able to ping each other.
Plz suggest how this can be resolved.
Although both servers can ping each other, it doesn't mean this is always the case.
You should check the network card statistics to see if there are no dropped packets, or intermittent network outages
Add your message
If you need more information about this particular error message, you can leave a forum message.
We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.
Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.
In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.
If you do not enter the validation correctly, your message will not be recorded.