在一台linux系统刚装了oracle10g,通过tnsnames配置了如下的地址,无法访问,(PS: 该配置确定没问题,从正常的主机上复制过来的,同时,通过拆分该集群oracle来访问其中一台,却可以访问)
aadb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.98)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.99)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = aadb)
)
)
(如下:拆开可以使用。。。。。。)
aadb1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.98)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = aadb)
)
)
,oracle是刚安装的