1. 首页
  2. IT资讯

ORA-01017 、ora 02063

[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

rusing ‘(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*60as select * from t_use@conn_yixun;

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

/24*60as 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博客 ” ,链接:http://blog.itpub.net/27042095/viewspace-749778/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:布吉卡,转转请注明出处:http://www.cxybcw.com/195886.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code