DBLINK 9i 连接11G 错误信息ora-01017,ora-02063的解决方法

最新推荐文章于 2022-10-24 14:46:33 发布

mouseshuai

最新推荐文章于 2022-10-24 14:46:33 发布

阅读量9.3k

点赞数

CC 4.0 BY-SA版权

分类专栏： ORACLE 文章标签： database oracle11g oracle 数据库 user 测试

本文链接：https://blog.youkuaiyun.com/mouseshuai/article/details/5221809

当尝试从Oracle 9i通过DBLINK连接到Oracle 11g时，可能会遇到ORA-01017和ORA-02063错误。这由于11g引入了密码大小写敏感特性。解决方案是确保在创建DBLINK时使用全大写的密码，因为Oracle始终以大写形式存储数据库链接密码。测试证实，将11g数据库用户的密码更改为全大写后，可以成功从9i连接。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在oracle9i中建立一个dblink指向一个oracle11g的数据库，用户名、密码配置完毕以后测试，抛出这样的错误码：

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

然后不知所措，到网上一搜，找到一段英文解释，如下：

Cause
The following Bug 6738104 was logged for this issue which was closed as not a bug saying the cause being introduction of password case sensitivity feature in 11g

When one creates a database link connection, a user name and password for the connection needs to be defined. When the database link is created, the password is case sensitive. Before a user can connect from a pre-release 11g database to a 11g release database and as the password case sensitivity is enabled by default, you must re-create the password for this database link using all uppercase letters.

The reason you need to re-create the password using all uppercase letters is so that it will match how Oracle Database stores database link passwords. Oracl