0

my Oracle ODBC has stopped working today and i can't figure out why.

the error im getting when testing the connection in ODBC Administrator is: connect failed because target host or object does not exist

getting the same error when trying to do a tnsping on it.

everything worked on friday, and no updates or anything has been done to the server.

what could it be?

Madam Zu Zu
  • 6,437
  • 19
  • 83
  • 129

1 Answers1

1

TNSPING and PING will go a long way.
If you see a line like 

.. Attempting to connect to (ADDRESS=SomeServerOrIPAddress)(PORT=1521) ...

from TNSPING, try pinging the address yourself from the command prompt 

PING SomeServerOrIPAddress

If you get a good reply from PING but not TNSPING it's now an issue for your DBA.
If PING doesn't work you need to look at network issues:
- Is the client actually connected to the network ?
- Name resolution if PING said it can't resolve the server name - Firewalls / Virus checkers blocking your traffic
- any number of other things

Morbo
  • 541
  • 2
  • 6
  • Yeap, basic TNS resolution approach; does SQL*Plus work? If not does TNSPING give expected result? If not does PING give expected result? If PING fails its a network issue, if PING succeeds and TNSPING does its a TNS issue. If TNSPING succeeds and client doesn't its a client/config/security issue. – Karl Aug 01 '11 at 23:24