[oracle@dbreport admin]$ oerr ora 01017

01017, 00000, "invalid username/password; logon denied"

// *Cause:

// *Action:

[oracle@dbreport admin]$ oerr ora 02063

02063, 00000, "preceding %s%s from %s%s"

// *Cause: an Oracle error was received from a remote database link.

// *Action: refer to the preceding error message(s)

错误描述：

SQL> create database link conn_yixun connect to newspaper identified by newspape

r using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL

= TCP)(HOST = 172.16.10.252)(PORT = 1521)) ) (CONNECT_DATA =

(SERVICE_NAME = orcl) ) )' ;

数据库链接已创建。

SQL> create materialized view mv_yixun refresh fast start with sysdate next sysd

ate+1/24*60 as select * from t_use@conn_yixun;

create materialized view mv_yixun refresh fast start with sysdate next sysdate+1

/24*60 as select * from t_use@conn_yixun

*

第 1 行出现错误:

ORA-04052: 在查找远程对象

NEWSPAPER.T_USE@CONN_YIXUN.REGRESS.RDBMS.DEV.US.ORACLE.COM 时出错

ORA-00604: 递归 SQL 级别 1 出现错误

ORA-01017: invalid username/password; logon denied

ORA-02063: 紧接着line (起自 CONN_YIXUN)

出现这个错误的原因是由于双方的版本不一致造成的，我们需要对用双引号将密码引起来，否则密码会被自动转化为大写：

SQL> create database link conn_yixun connect to newspaper identified by "newspap

er" using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCO

L = TCP)(HOST = 172.16.10.252)(PORT = 1521)) ) (CONNECT_DATA =

(SERVICE_NAME = orcl) ) )' ;

我测试了一下，不管版本是不是相同，建dblink的密码加上双引号，都没问题的。不加的时候，如果遇上版本问题，就惨了。所以建立dblink的时候，密码最好用双引号给括起来，养成好的习惯。

ITPub博客

ORA-01017 、ora 02063