oracle dblink 和 12c 服务11g客户端连接

常用命令

1. 查询

 select * from dba_db_links;

DROP DATABASE LINK urs

2. 新增

create database link EHRDS
connect to ehrds2021 identified by ehrds2021
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.29.2.5)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = emrp)
)
)'

 

1， 修改下面配置文件

linux查看配置找到 : cat /home/oracle/.bash_profile

命令：

cd $ORACLE_HOME/network/admin

vim sqlnet.ora

没有则新建

 

 

 

添加：

 

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8

 

2. 修改用户密码，修改的密码可以和原来的相同

alter user ehrds2021 identified by ehrds2021;
alter user emrds identified by emrds;