Question

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))
)
)
拜托各位大神了，谢谢！

Answer 1

方法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))

Answer 2

文件删掉，从系统自带的例子里找一个复制过来，然后使用netca（Net Configuration Assistant）配置监听，首次监听配置必须使用netca，netmgr第一次不好使