unable to connect to Oracle DB..TNS operation timed out error..
Posted on 2007-03-28
I am unable to connect an Oracle database from my machine. The following entry is there in the tnsnames.ora file.
(ADDRESS = (PROTOCOL = TCP)(HOST = YYY.com)(PORT = 1521))
(SERVICE_NAME = XXX)
There is another db in the same server, which has a similar database, and I am able to connect to it with no problem.
When I try to tnsping XXX, I get
TNS-12535 : TNS: operation timed out error.
Any ideas why this error is happening?