这两天和监听过去不。

在fedora10下的oracle11g监听文件如下：

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = D:Oracle11gproduct11.1.0db_1)
(SID_NAME = test)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = fedora)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = 0))
)
)

SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = D:Oracle11gproduct11.1.0db_1)
(SID_NAME = test)
)
)

LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.130)(PORT = 1522))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = 1))
)
)

不知道怎么的，LISTENER的只要HOST是IP地址，lsnrctl start就会报错（ora-12514）。别人都是解析不了主机名的时候报错，然后把主机名改为IP就搞定了，而我正好反过来，真奇怪。郁闷。