oracle安装成功了，但在net manager配置时，测试通不过，提示 “无监听程序”
具体的截图如下：
在把listener.ora文件贴出来
# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:/oracle/product/10.2.0/db_1)
(SID_NAME = ORCL)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = zk)(PORT = 1521))
)
)
拜托各位大神了，谢谢！
方法1：把HOST= zk换成你的IP试试；
方法2：提供给你一个最简单的listener.ora配置，你只需要简单的把IP和ORACLE_HOME换成你的就可以：
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /opt/app/oracle/product/10.2.0/db1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.47)(PORT = 1521))
方法2：提供给你一个最简单的listener.ora配置，你只需要简单的把IP和ORACLE_HOME换成你的就可以：
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /opt/app/oracle/product/10.2.0/db1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.47)(PORT = 1521))
温馨提示：答案为网友推荐，仅供参考
第1个回答 推荐于2017-11-25
文件删掉，从系统自带的例子里找一个复制过来，然后使用netca（Net Configuration Assistant）配置监听，首次监听配置必须使用netca，netmgr第一次不好使本回答被提问者采纳
相似回答