现象 :
我在一台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地址
我在一台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博客 ” ,链接:http://blog.itpub.net/18234/viewspace-629136/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/18234/viewspace-629136/