TNS-12545 大哥门过来帮帮忙。

[JankerW]

Message 1070 not found; No message file for product=network, facility=TNSTNS-125
45: Message 12545 not found; No message file for product=network, facility=TNS
TNS-12560: Message 12560 not found; No message file for product=network, facili
ty=TNS
TNS-00515: Message 515 not found; No message file for product=network, facilit
y=TNS
Linux Error: 2: No such file or directory

[chanet]

看看
C:>tnsping 服务名
能不能连接.

或者用 Net 重新配置一次.
由于 IP/主机名 产生的,把 Net 里头的 "主机名" 改成 IP地址的方式来重新配置一次.

================
Net 的意思是指:
8i: "net8 configuration assistant"
9i: "net configuration assistant"

[gladness]

是不是listener.ora的内容有问题呀，贴出来看看

[JankerW]

谢谢。
tnsping 还是不行。
我装的是817，另外的一台机器上安装正常，
然而在这台上面运行 lsnrctl start 给出提示：

Message 1070 not found; No message file for product=network, facility=TNSTNS-125
45: Message 12545 not found; No message file for product=network, facility=TNS
TNS-12560: Message 12560 not found; No message file for product=network, facili
ty=TNS
TNS-00515: Message 515 not found; No message file for product=network, facilit
y=TNS
Linux Error: 2: No such file or directory

[wangzi163]

在linux上装的阿。

[JankerW]

是的。RH8i

[JankerW]

[oracle@jhtq bin]$ cat /data5/app817/network/admin/listener.ora
# LISTENER.ORA Network Configuration File: /data5/app817/network/admin/listener.
ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.7)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /data5/app817)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = dx817)
(ORACLE_HOME = /data5/app817)
(SID_NAME = dx817)
)
)

[chanet]

把前部分的内容:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.7)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)

改为如下内容试试 (改之前要备份你的文件呀!!!)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.7)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.7)(PORT = 2481))
)
)

[chanet]

ping 不通,就说明监听器没有配置好.

用 Net8 Configuration Assistant 重新配置一次就可以啦.
用 Net8 配置的时候，记得 协议用 TCP.

把 主机名 输入机子的 IP 地址.如：127.0.0.1 (指的是本机)

[chanet]

是不是listener.ora的内容有问题呀，贴出来看看
--------------------------------------------
赞成 gladness(gladness) 的说法。

配置除了用 Net8 之外，还可以直接改文件.

[Drate]

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的通才行呀