11g 数据库连接报用户密码错

最新推荐文章于 2022-10-10 15:06:13 发布

转载最新推荐文章于 2022-10-10 15:06:13 发布 · 237 阅读

本文介绍了解决Oracle 11g RAC架构下因密码大小写敏感导致的连接错误问题。当从较低版本数据库连接到11g数据库时，需确保数据库链接密码全为大写，以匹配Oracle存储习惯。

前几天配置了一个11G的RAC架构，今天程式测试连接报用户密码错误：

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

到网上一搜，找到一段英文解释，如下：

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. Oracle Database always stores this type of password in uppercase letters, even if the password had originally been created using lower or mixed case letters. If case sensitivity is disabled, the user can enter the password using the case the password was created in.

Solution
++ As the password case sensitivity is enabled by default, create the database link to the 11g database as shown below :

应该是这样的：当9i连接11g时，会自动将密码转化为大写，所以，如果11g的数据库用户密码中，如果有小写字母，应该全部改成大写，然后再去用9i去连接，问题就解决了。

实际测试，果真如此。

问题又来了，其他没有问题的程序，怎么办？如: toad for oracle?sqlplus?

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

转载于:http://blog.itpub.net/110321/viewspace-700496/