这两天和监听过去不。
在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就搞定了,而我正好反过来,真奇怪。郁闷。
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12771406/viewspace-1017471/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12771406/viewspace-1017471/