pl/sql(windows xp操作系统)连接oracle9.2.0.7.0(AIX5.3操作系统) 时而没问题,时而报“ORA-12545因目标主机或对象不存在,连接失败” 数据库采用IBM HACMP双机热备(地址为:10.156.200.12,10.156.200.18),以下是客户端tnsnames.ora内容: lghx_LBN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.200.12)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.200.18)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVICE_NAME = lbn)
)
) lgex_LBN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.200.12)(PORT = 1526))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.200.18)(PORT = 1526))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVICE_NAME = lbn)
)
)
采用SERVICE_NAME访问服务器会时而没问题,时而有问题。
如果采用SID访问,则一直没有问题:
lghx_LBN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.200.12)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.200.18)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SID = lbn1)
(SERVER = DEDICATED)
)
)
请高手指点。
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.200.12)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.200.18)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVICE_NAME = lbn)
)
) lgex_LBN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.200.12)(PORT = 1526))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.200.18)(PORT = 1526))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVICE_NAME = lbn)
)
)
采用SERVICE_NAME访问服务器会时而没问题,时而有问题。
如果采用SID访问,则一直没有问题:
lghx_LBN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.200.12)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.200.18)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SID = lbn1)
(SERVER = DEDICATED)
)
)
请高手指点。
解决方案 »
- 如何将oracle数据库中的数据按星期算出每个星期的平均值? 每条数据都有时间字段。
- 菜鸟求助 oracle数据库更新
- 如何把用户A所有表的select权限赋给用户B?
- 关于oracle instant client设置DSN的问题。
- 开发过程中怎样来考虑并发性和死锁的问题
- 请问如何控制每次只从数据库读取固定条数的记录集?
- oracle高手请进
- 请问:oracle10g客户端不能安装
- 请问哪位前辈知道一些免费的oracle9irac的电子资料,请你指点!!!
- 请问一个理论问题:应用程序中可以得到Oracle的错误码,这在数据库服务中是怎么实现的
- 寻求一个SQL查询语句
- ORACLE里 CASE DECODE 的问题相关。在线等待
Use the full hostname.domain_name in remote_listener configuration in tnsnames.ora. Restart the instance and listener, check lsnrctl service output, make sure full hostname.domain_name show up.eg:
in init.ora (or spfile)
remote_listener=LISTENERS_R920in tnsnames.ora:
LISTENERS_R920 =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = aulnx1.au.oracle.com)(PORT = 1527))
(ADDRESS = (PROTOCOL = TCP)(HOST = aulnx2.au.oracle.com)(PORT = 1527))
)