ORA-12170: TNS: Connect timeout occurred tips
Oracle Tips by Burleson Consulting
I'm getting the error "ORA-12170:
TNS:Connect timeout occurred" when I try to connect to my
database via OEM. How do I resolve the "ORA-12170: TNS:
Connect timeout occurred" error?
error can be for many reasons, firewall issue, database down,
listener down, bad sqlnet.ora parm, network trouble, etc.
The docs note:
ORA-12170: TNS:Connect timeout occurred
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).
Your sqlnet.ora file can be
found in your $ORACLE_HOME/network/admin directory.
ORA-12170 and hosts file
Verify that your /etc/hosts file has a
In Windows XP, make your hosts
file is located at win/system32/driver/etc/ and on UNIX, Linux,
Get Complete Oracle Tuning Details
The landmark book
Tuning: The Definitive Reference Third Edition" has been
updated with over 800 pages of expert performance tuning tips.
It's packed with scripts and tools to hypercharge Oracle performance and you can
buy it for 40% off directly from the publisher.
Burleson is the American Team
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
and include the URL for the page.
Copyright ? 1996 - 2014
All rights reserved by
is the registered trademark of Oracle Corporation.