oracle 创建db_link

蓝天4202

已于 2024-08-19 11:13:10 修改

阅读量109

点赞数 3

文章标签：数据库 oracle

于 2024-08-19 11:12:22 首次发布

本文链接：https://blog.csdn.net/weixin_46200835/article/details/141320541

版权

CREATE PUBLIC DATABASE LINK jcjr  CONNECT TO  jcjr  
IDENTIFIED BY jcjr  
USING '85';

或者
CREATE PUBLIC DATABASE LINK jcjr 
CONNECT TO jcjr IDENTIFIED BY "jcjr"
USING '(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=db02)(PORT=1521))
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=bdspoc01)))';


tnsnames.ora添加
85 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.18.85)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = bdspoc01)
    )
  )