当尝试从Oracle 9i通过DBLINK连接到Oracle 11g时，可能会遇到ORA-01017和ORA-02063错误。这由于11g引入了密码大小写敏感特性。解决方案是确保在创建DBLINK时使用全大写的密码，因为Oracle始终以大写形式存储数据库链接密码。测试证实，将11g数据库用户的密码更改为全大写后，可以成功从9i连接。
在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 Dat
最低0.47元/天 解锁文章
5万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
