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 sqlplus登陆问题
- ORA-02025: SQL 语句的所有表均必须在远程数据库中.........急等问题解决
- 求SELECT语句
- 关于oracle procedure 的exec 参数问题
- 删除字段的问题
- 为什么结果是这样?和预期有点不一样
- sql server的存储过程,表等能导到oracle里去么?
- [急]监听进程不能解析在连接描述符中给出的Service_Name怎么能解决??
- sql语句怎样修改记录中某个字段的部分字符?
- 数据库启动不了,报错ORA 48108 ORA48140 ORA48187
- 寻求一个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))
)