Oracle创建dblink报错:ORA-01017、ORA-02063解决

 

Oracle环境：oracle 10.2.0.1 创建的 public dblink 连接oracle 11.2.0.3

 

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

 

 

一．创建dblink

create public database link dmz63

 

connect to xyy  identified by xyy

 

using '（DESCRIPTION =（ADDRESS_LIST =（ADDRESS = （PROTOCOL = 10.0.0.1）（HOST = 192.xxx.xxx.xxx）（PORT = 2261）））（CONNECT_DATA = （SERVICE_NAME = xyy）））';

 

 

 

 

 

二．创建dblink 后使用时提示如下错误：

select  *   from dual@dmz63

报错如下：

　　ORA-01017: invalid username/password; logon denied

 

　　ORA-02063: