现象：
我在一台redhat linux6.2 安装了oracle817 ,然后建库都ok ,但是当我在客户端（另外一台pc）用sqlplus连接时提示ORA-12545: 连接失败是因为目标主机或对象不存在
可是，当我把linux server 上的listener重起，就可以连了，当我退出
sqlplus 再连时，又提示那个错误，listener重起又可以连了。

解决:
1. 转发
Listener crash - problem I faced
I had kind of similar situation in W2K Workstation after upgrading my OS (applied some security & critical patches). I was using Ora 8.1.7.3 version. Tried upgrading to 8.1.7.4, the problem persisted the same.

Problem that I experienced was, the Oracle Listener will work for 1 minute exactly and will die after that. But TNSPING was working correct.

Then I turned on tracing to analyze the problem and found out that the MTS_DISPATCHERS parameter was causing problem. Since my server was setup as dedicated server the MTS parameter caused the listener crash.

After I commented out the above parameter, when I restarted the services listener worked fine.

I'm not sure whether this will help you. If it can have fun.

Thanks.
或
2.
先 ping 机器名
tnsping 服务名
如果不行，在windows目录下查hosts 文件，加入 linux机器的IP地址

ITPub博客

解决一个TNS问题!

最新文章