Oracle TNS-无法通过ODBC管理器连接 [英] Oracle TNS - can't connect through ODBC Administrator

问题描述

我的Oracle ODBC今天停止工作，我不知道为什么.

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

在ODBC Administrator中测试连接时出现的错误是:连接失败，因为目标主机或对象不存在

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

尝试对其进行tnsping时遇到相同的错误.

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.

那会是什么?

推荐答案

TNSPING和PING将大有帮助.
如果您看到类似

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

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

在TNSPING中，尝试在命令提示符下ping自己的地址

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

PING SomeServerOrIPAddress

如果您从PING获得了很好的答复，但TNSPING却没有，那么这对您的DBA来说是一个问题.
如果PING不起作用，则需要查看网络问题:
-客户端是否确实已连接到网络?
-名称解析(如果PING表示无法解析服务器名称) -防火墙/病毒检查器阻止了您的流量
-其他任何东西

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

这篇关于Oracle TNS-无法通过ODBC管理器连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！