I use TOAD for Oracle Database (version 10.6.1.3). And when I try to connect server database it returns error:
ORA-12170: TNS:Connect time out occurred
I wrote username, password, for DIRECT-Host, Port, SID and connect using: OraClient11g_home. Do u have any idea about this error?
LL: TOAD for Oracle version 10 was released in October 2009. What were the major enhancements? BS: TOAD for Oracle version 10 was probably the most significant release in a decade. The development team upgraded their compiler — which required purchasing and integrating all new third-party components that worked with the new compiler.
kamalkamal
1 Answer
If port 1521 is blocked, you will get this error message. Make sure the port is open from your source IP (Toad server) to your destination IP (Oracle DB); you can test it with telnet.
Note that it's possible to use a different port as well; you can confirm the port configured in Toad in the New Connection window by clicking on the
TNSNames Editor
button.RandallRandall