TNS-12545 Connect failed because target host or object does not existCause: 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.你需要确定你的客户端与服务器连接是相通的 也就是可以PING的通才行呀
ping host adress ,sucessfully and act connection at the host machine is sucess but when connecting from the client machine to host ,the result is ora-12545:连接因对象或主机名不存在
在主机上tnsping service name 成功,而且连接测试成功,但是在客户机上TNSPING的 结果如下: 已使用 TNSNAMES 适配器来解析别名 Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.112)(PORT = 1521)))没有下面的服务名 (CONNECT_DATA = (SERVICE_NAME = bnyy.fxg)) 如将tnsname.ora里的主机名换成ip地址,则显示ora-03106:fatal two-task communication protocol error,请问大仙,该怎么解决?我都被困了一个星期了
fatal two-task communication protocol error,指net8层中的two_task communication层有问题,two_task communication层负责客户机服务器字符集间的转换。可能是你的net8协议出问题了。
也可能还是客户端的tnsnames.ora文件配置错误。 如果出现ORA_12545错误, 1。Verify that the address in the tnsnames.ora file or the listener.ora file is corrent. 1.verify that the listener on the remote node has been started.
-------------- (Oracle 的安装目录)
参考一下这个:
http://expert.csdn.net/Expert/topic/2342/2342439.xml?temp=.8971826
也就是可以PING的通才行呀
connecting from the client machine to host ,the result is ora-12545:连接因对象或主机名不存在
结果如下: 已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.112)(PORT = 1521)))没有下面的服务名
(CONNECT_DATA = (SERVICE_NAME = bnyy.fxg))
如将tnsname.ora里的主机名换成ip地址,则显示ora-03106:fatal two-task communication protocol error,请问大仙,该怎么解决?我都被困了一个星期了
如果出现ORA_12545错误,
1。Verify that the address in the tnsnames.ora file or the listener.ora file is corrent.
1.verify that the listener on the remote node has been started.
正在连接...ORA-12541: TNS: 没有监听器
测试未成功。而且我把网络服务名删了重加,把监听器删了重加,都没用。
问题是,有时候莫名其妙的又好了,然后错误无法人工重现,所以出错的时候没有找到本质问题,无法真正解决。
昨天好了之后,今天发现服务器重启过一次,今天就又不行了,不知道是不是和这个有关。
请教高手们!