listener.ora 两种写法
[第一种]
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST=172.16.1.1)(PORT=1521))
)
)
)
【第二种】
LISTENER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST=172.16.1.1)(PORT=1521))
)
)
这两种写法是不是在效果上一样的。有没有什么参考文件能够看到详细的配置，我在oracle 联机文档中没有查到~
[quote]问题补充：
那还可以这样写不？？？
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST=172.16.1.1)(PORT=1521))
（ADRESS = (PROTOCOL = TCP)(HOST=172.16.1.2)(PORT=1521))
) [/quote]
可以。如：
net_service_name=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=sales1-svr)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=sales2-svr)(PORT=1521)))
(ADDRESS_LIST=
(FAILOVER=on)
(ADDRESS=(PROTOCOL=tcp)(HOST=sales1-svr)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=sales2-svr)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=sales.us.acme.com)))
[url]http://download.oracle.com/docs/cd/B10500_01/network.920/a96581/tnsnames.htm[/url]
效果是一样的。[第一种]DESCRIPTION_LIST，也就是可以写多个DESCRIPTION：
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.1.23)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 100.15.100.22)(PORT = 1522))
)
)
当只有一个时，当然就是一样的了。