(ADDRESS = (PROTOCOL = TCP)(HOST = ip2)(PORT = 1521))
这样不行吗? 本帖最后由 shibq007 于 2012-02-13 10:52 编辑
1、没试过,不知道行还是不行
2、是改成如下这样吗?
# listener.ora Network Configuration File: /opt/oracle/product/10.2.0.4/network/admin/listener.ora
# Generated by Oracle configuration tools.
listener =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.101)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.103)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_ORA1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ora1)
(ORACLE_HOME = /opt/oracle/product/10.2.0.4)
(SID_NAME = ora1)
)
)
SID_LIST_ORA2 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ora2)
(ORACLE_HOME = /opt/oracle/product/10.2.0.4)
(SID_NAME = ora2)
)
)
回复 11# yzkarchive
回复 12# shibq007
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.101)(PORT = 1521)))
(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.103)(PORT = 1521)))
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ora1)
(ORACLE_HOME = /opt/oracle/product/10.2.0.4)
(SID_NAME = ora1)
)
(SID_DESC =
(GLOBAL_DBNAME = ora2)
(ORACLE_HOME = /opt/oracle/product/10.2.0.4)
(SID_NAME = ora2)
)
)
客户端的TNSNAMES.ORA文件是这样配置吧
ora1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.101)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora1)
)
)
ora2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.103)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora2)
)
)
回复 13# yzkarchive
回复 14# shibq007
恩,测试listener起来了没得?监听了几个实例了没得?
就按刚我贴出来的办法就行了 我是来学习和获取积分的。呵呵 谢谢大家的帮助
页:
1
[2]