C:\Documents and Settings\chenshian.PRIMARY>tnsping compiereTNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 18-9月 -2 004 14:35:44Copyright (c) 1997 Oracle Corporation. All rights reserved.已使用的参数文件: E:\oracle\ora92\network\admin\sqlnet.ora 已使用 TNSNAMES 适配器来解析别名 Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = Compiere)(PORT = 1521))) (CONNECT_DATA = (SID = Compiere) (SERVER = DEDI CATED))) TNS-12545: 因目标主机或对象不存在,连接失败
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
或 服务名没有配置好~先ping 通服务器~ 再重新配置一下 服务名~
004 14:35:44Copyright (c) 1997 Oracle Corporation. All rights reserved.已使用的参数文件:
E:\oracle\ora92\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = Compiere)(PORT = 1521))) (CONNECT_DATA = (SID = Compiere) (SERVER = DEDI
CATED)))
TNS-12545: 因目标主机或对象不存在,连接失败
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
btw: 服务名可以理解是数据库的名字(或别名)