求助，连不上服务器，报没有监听程序，求大神帮忙看看

显示全部楼层 · 2012-7-12 18:47:29

环境：Windows 8.1，VirtualBox装CentOS6_x64 + Oracle 11gR2本机IP：192.168.1.23
虚拟机IP：192.168.56.101
本机ping虚拟机能通，tnsping就报没有监听程序这个错C:\Windows\system32>ping 192.168.56.101
正在 Ping 192.168.56.101 具有 32 字节的数据:
来自 192.168.56.101 的回复: 字节=32 时间tnsping 192.168.56.101
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 14-6月 -
2015 11:01:02
Copyright (c) 1997, 2010, Oracle.All rights reserved.
已使用的参数文件:
D:\app\Benjamin\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora
已使用 EZCONNECT 适配器来解析别名
尝试连接 (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST
=192.168.56.101)(PORT=1521)))
TNS-12541: TNS: 无监听程序我想知道是不是我配置哪里不对，求大神帮忙看看。
本机的tnsnames.ora# tnsnames.ora Network Configuration File: D:\app\Benjamin\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.101)(PORT = 1521))

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.101)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)本机的listener.ora# listener.ora Network Configuration File: D:\app\Benjamin\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\Benjamin\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY

:" />\app\Benjamin\product\11.2.0\dbhome_1\bin\oraclr11.dll&quot

)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.101)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\app\Benjamin服务器上的tnsnames.ora# tnsnames.ora Network Configuration File: /app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)服务器上的listener.ora# listener.ora Network Configuration File: /app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = /app/oracle
对了，已确认监听程序已启动。iptables关掉了。
先谢谢各位了。

千问 · 2012-7-12 18:47:29

1TNSPING 客户端的连接串．
2(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) -- 指定机器名或者IP
3服务器监听器的LISTENER.ORA里没有数据库的信息，

千问 · 2012-7-12 18:47:29

ZALBB 发表于 2015-6-14 12:20
1TNSPING 客户端的连接串．
2(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) -- 指定机 ...
非常感谢！