[Fix]-ORA-12170 error occurred-connection problem

Wikitechy | 978 Views | oracle | 28 May 2016


ORA-12170 connection timeout occurred.


Connecting to oracle 10g db through TOAD installed on another machine. 

Fix 1: 

This could be due to DNS resolution problems. Try the command dnslookup <hostname> to check for DNS resolution status.

Fix 2:

The listener port is different than that of the configured. Standard port value is 1521.

Fix 3:

Sometime the firewall can block from accessing the database. Try performing the connections with TOAD on the same machine and if it works, adjust the firewall.

Fix 4:

Check for the database listener and activate it.


Bug Bounty
IOT Hackathon

Join our Community