Oracle 9i DBLINK连接11G 错误ora-01017,ora-02063的解决方案

---

链接：  http://blog.itpub.net/28602568/viewspace-1278993/

标题： Oracle 9i DBLINK连接11G 错误ora-01017,ora-02063的解决方案

作者： ｌōττéｒｙ ©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]

---

今天客户要在9i 环境创建dblink 读取11g 数据 ，在创建后检验dblink是否有效时；

报错 【  ORA-01017: invalid username/password; logon denied；ORA-02063: 紧接着line（源于DB_XX）】

分析原因：Oracle 11g 开始用户的密码才区分大小写；

测试：11g前密码是否会自动转换大写？

---

11g 区分大小写  

[oracle@xcd ~]$ sqlplus BACKUP2014 /BACKUP2014

SQL*Plus: Release  11.2.0.3.0  Production on Tue Sep 23 17:30:50 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> 

---

9i 数据库 创建dblink

---

Connected to Oracle9i Enterprise Edition  Release 9.2.0.1.0
Connected as haikuo@192.168.0.31/orapp

SQL> create database link db_test  connect to backup2014 identified by backup2014 using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.1.1  )(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = sinodb)))';

Database link created

校验dblink：

SQL> SELECT usename FROM user_users@db_test;

USERNAME         
------------------ 

BACKUP2014     

  解决方案 将小写密码加双引号如下例子..
SQL> create  database link db_sinotest_link  connect to  "sinotest_link"  identified by "maohaiqing" using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.1.2)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = testdb)))';

Database link created

校验dblink：

SQL> SELECT usename  FROM user_users@db_sinotest_link;

USERNAME       
------------------
SINOTEST_LINK 

SQL> 

提示：

   11g可以通过参数sec_case_sensitive_logon或dba_users.password_versions字段查询 密码大小写是否敏感；

---

此条目发表在 Oracle  分类目录。将固定连接 加入收藏夹。

---

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28602568/viewspace-1278993/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28602568/viewspace-1278993/