ORA-02019:未找到远程数据库的连接说明(数据库链接创建)

1. 建立 DATABASE LINK

CREATE PUBLIC DATABASE LINK DATA1TODATA2  CONNECT TO USERNAME IDENTIFIED BY PASS_WORD   USING '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =  (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = orcl)))';

链接名： DATA1TODATA2

链接库账户： USERNAME  PASS_WORD

链接IP：localhost

2.测试

select * from device@DATA1TODATA2