TNS-12545 Connect failed because target host or object does not exist
Cause: The address specified is not valid, or the program being connected to
does not exist.
Action: Ensure the ADDRESS parameters have been entered correctly; the most
likely incorrect parameter is the node name. Ensure that the executable for the
server exists (perhaps "oracle" is missing). If the protocol is TCP/IP, edit the
TNSNAMES.ORA file to change the host name to a numeric IP address and try
again.
Cause: The address specified is not valid, or the program being connected to
does not exist.
Action: Ensure the ADDRESS parameters have been entered correctly; the most
likely incorrect parameter is the node name. Ensure that the executable for the
server exists (perhaps "oracle" is missing). If the protocol is TCP/IP, edit the
TNSNAMES.ORA file to change the host name to a numeric IP address and try
again.
解决方案 »
- 利用存储过程导出为CSV文件时报错(pl-sql)
- ORA-00376 ORA-01110
- ORACLE在Windows运行的企业有那些,多吗:
- 各位大神 小弟求助!!
- “w我们”字符串在oracle中存放占用多少空间?
- 数据库备份问题
- 为什么我每次正常重起,进系统前总是要检测安装oracle的那个分区?
- [求助]Oracle 9i中怎么处理UTF-8的数据???
- SQL*Plus 连服务器时出现ORA-12154:TNS:不能分解服务名称错误,别的机子却可以连上服务器,
- 为什么我不能访问用sqlserver的dts工具导过来的数据?
- 用ADO连接ORACLE,用什么OLE DB不需要安装ORACLE客户端
- sql小问题。
在TNSNAME.ORA中配置服务器SID时,最好服务器有指定的IP,这样问题可以少很多。
同意楼上的应该是网络和tns问题
有时是不是和病毒也有关系呀!我们的服务器经常被病毒破坏
重新启动OracleTNSListenr80服务即可。
例如:
LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = NT_Name)(Port = 1521))
(ADDRESS = (PROTOCOL = TCP)(Host = NT_Name)(Port = 1526))
)
2。使用监听器实用程序:LSNRCTL80.exe
3。检查监听器参数文件:c:\orant\NET80\admin\listener.ora
4。检查监听器日志文件:c:\orant\NET80\log\listener.log
5。Tnsnames.ora文件配置错误,重新配置。
6。检查client 端 Tnsnames.ora