- 论坛徽章:
- 0
|
操作系统: RedHat Linux 4
数据库: Oracle9i
server1: 192.168.1.41 (10.0.0.1 心跳)
server2:192.168.1.42 (10.0.0.2心跳)
漂移IP: 192.168.1.40
现在是Rose HA可以正常切换数据库和oracle的监听服务,实例也能正常启动,客户端通过tnsping是可以ping同服务名的,但是客户端使用oracle自带的企业管理器连接时提示“无法解析连接符中指定的SID”,oracle的listener和tnsname中都是使用的漂移Ip,如果换成实际地址的话就可以正常连接,请问是否oracle的listener和tnsname配置的不正确??下面是我的具体配置:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.40)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/ora9/product/9.2.0.4)
(PROGRAM = extproc)
)
)
————————————————————————————
ORADB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.40)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oradb)
)
) |
|