12 / 2 页

论坛徽章:: 15

11楼 [报告]

发表于 2012-02-10 16:11 |只看该作者

(ADDRESS = (PROTOCOL = TCP)(HOST = ip1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ip2)(PORT = 1521))

这样不行吗？

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

shibq007

白手起家

论坛徽章:: 0

12楼 [报告]

发表于 2012-02-13 10:41 |只看该作者

本帖最后由 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

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

yzkarchive

小富即安

论坛徽章:: 15

13楼 [报告]

发表于 2012-02-13 15:21 |只看该作者

回复 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)
               )
      )

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

shibq007

白手起家

论坛徽章:: 0

14楼 [报告]

发表于 2012-02-13 17:38 |只看该作者

客户端的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