oracle 11g启动监听程序时报错“监听该对象时出错: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))”

Question

我listener.ora文件内容：
DFTESTLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = LBWin7-king)(PORT = 1521))
)
)
SID_LIST_CDFTESTLISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CDFTEST)
(ORACLE_HOME = D:\installation\oracle11g\installation\app\product\11.2.0\dbhome_1)
(ENVS = "EXTPROC_DLLS=ONLY:D:\installation\oracle11g\installation\app\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
ADR_BASE_CDFTESTLISTENER = D:\installation\oracle11g\installation\app

Answer 1

有问题。动态的DESCRIPTION加一个(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)
静态的，把ENVS那段删了。
最后那个ADR，给oracle home地址，D:\installation\oracle11g\installation\app\product\11.2.0\dbhome_1
我给你个linux版本参考下。
如下：
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DS00)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = EIN1)
(ORACLE_HOME=/u01/app/oracle/products/11.2.0.3/db_1)
(SID_NAME = EIN1)
)
)
ADR_BASE_LISTENER = /u01/app/oracle