看看
C:>tnsping 服务名
能不能连接.或者用 Net 重新配置一次.
由于 IP/主机名 产生的,把 Net 里头的 "主机名" 改成 IP地址的方式来重新配置一次.================
Net 的意思是指:
8i: "net8 configuration assistant"
9i: "net configuration assistant"
C:>tnsping 服务名
能不能连接.或者用 Net 重新配置一次.
由于 IP/主机名 产生的,把 Net 里头的 "主机名" 改成 IP地址的方式来重新配置一次.================
Net 的意思是指:
8i: "net8 configuration assistant"
9i: "net configuration assistant"
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
用 Net8 配置的时候,记得 协议用 TCP.把 主机名 输入机子的 IP 地址.如:127.0.0.1 (指的是本机)
--------------------------------------------
赞成 gladness(gladness) 的说法。配置除了用 Net8 之外,还可以直接改文件.
# 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)
)
)
(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))
)
)
也就是可以PING的通才行呀