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

常用命令

1. 查询

 select * from dba_db_links;

2. 新增

create database link link_name
connect to username identified by password
using ‘(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.13.178)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = rzzqnew)
)
)’;

1， 修改下面配置文件

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

添加：

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;