oracle 10g创建dblink 链接11g 报错的解决

最新推荐文章于 2023-04-02 13:09:01 发布

zwxiaole

最新推荐文章于 2023-04-02 13:09:01 发布

阅读量366

点赞数

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

本文链接：https://blog.csdn.net/zwxiaole/article/details/84699198

版权

数据库专栏收录该内容

47 篇文章 1 订阅

订阅专栏

10g创建dblink代码

-- Create database link 
create database link jxkp
  connect to jxkp identified by jxkp
  using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.40.155)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = fxgl)
    )
  )';

一直报错

ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from

一开始以为是用户名密码区分大小写

但后来发现用户名密码是对的

最终发现原因：

因为11g建dblink时用户的密码必需加上双引号""

正确的写法是

-- Create database link 
create database link jxkp
  connect to jxkp identified by "jxkp"
  using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.40.155)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = fxgl)
    )
  )';

成功了