plsql连接rac

最新推荐文章于 2023-03-15 17:02:23 发布

stevenfeng

最新推荐文章于 2023-03-15 17:02:23 发布

阅读量857

点赞数

CC 4.0 BY-SA版权

分类专栏： plsql 文章标签：数据库网络

本文链接：https://blog.youkuaiyun.com/fengqinyun168/article/details/84092966

plsql 专栏收录该内容

4 篇文章

订阅专栏

来自[url]http://hi.baidu.com/magiclin/blog/item/cf07f8af34a237f3fbed50df.html[/url]


在tnsnames.ora中添加：(host ip皆为vip)
RAC =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.221)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.222)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RAC.WORLD)
    )
)

LISTENERS_RAC =
(ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.221)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.222)(PORT = 1521))
)

RAC2 =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.222)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RAC.WORLD)
      (INSTANCE_NAME = RAC2)
    )
)

RAC1 =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.221)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RAC.WORLD)
      (INSTANCE_NAME = RAC1)
    )
)

在hosts中添加
各节点的IP及hostname，否则可能出现连不上服务器或找不到对象的错误