create database link test_link connect to xx identified by xx using ‘(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.xx.xx.xx7)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.xx.xx.xx6)(PORT = 1521)) (FAILOVER = on) (LOAD_BALANCE = on) ) (CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = ora11g)))‘;
load_balance=on 负载平衡
可以加也可以不加
相关文章
- 09-06Oracle LISTENER 主机名修改为IP地址后LISTENER无法监听到实例 oracle监听错误与hosts文件配置
- 09-06Linux下搭建Oracle11g RAC(2)----配置DNS服务器,确认SCAN IP可以被解析
- 09-06oracle dblink配置
- 09-06[转]Oracle 11g RAC SCAN ip的原理及配置
- 09-06Linux下搭建Oracle11g RAC(1)----IP分配与配置IP
- 09-06Oracle VM VirtualBox安装Centos8后配置静态ip,使用xshell6的ssh连接方便操作,下载docker
- 09-06oracle dblink 配置两个ip
- 09-06Oracle两个数据库联合查询,使用Oracle DBLink
- 09-06Oracle两个数据库互相访问,DBLink使用-转
- 09-06Linux7/Redhat7/Centos7 安装Oracle 12C_配置IP、系统参数_02