在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