当前位置:Gxlcms > mysql > 低版本使用dblink连接11G版本时报错ora-02063/ora-01017

低版本使用dblink连接11G版本时报错ora-02063/ora-01017

时间:2021-07-01 10:21:17 帮助过:14人阅读

一回家,某运营商电话至,创建dblink报错ora-02063/ora-01017 关于这个BUG,遇到不是一次了,ORACLE对于该BUG 描述如下 Bug 6738104: ORA-01017 ORA-02063 WHILE CONNECTING FROM10G TO 11G VIA PUBLIC DBLINK Cause The following Bug 6738104 was logged f

一回家,某运营商电话至,创建dblink报错ora-02063/ora-01017

关于这个BUG,遇到不是一次了,ORACLE对于该BUG 描述如下

Bug 6738104: ORA-01017 ORA-02063 WHILE CONNECTING FROM10G TO 11G VIA PUBLIC DBLINK

Cause
The following Bug 6738104 was logged for this issue which was closed as not abug saying the cause being introduction of password case sensitivity feature in11g
When one creates a database link connection, a user name and password for theconnection needs to be defined. When the database link is created, the passwordis case sensitive. Before a user can connect from a pre-release 11g database toa 11g release database and as the password case sensitivity is enabled bydefault, you must re-create the password for this database link using alluppercase letters.
The reason you need to re-create the password using all uppercase letters is sothat it will match how Oracle Database stores database link passwords. OracleDatabase always stores this type of password in uppercase letters, even if thepassword had originally been created using lower or mixed case letters. If casesensitivity is disabled, the user can enter the password using the case thepassword was created in.

当低版本通过dblink连接11G库时,默认会将密码改为大写。

solution就很简单啦,重新创建dblink,密码使用双引号+小写即可

例:create database link db_test
2 connect to wxboss
3 identified by "wxboss"
4 using '(DESCRIPTION =
5 (ADDRESS_LIST =
6 (ADDRESS = (PROTOCOL =TCP)(HOST = 192.168.99.100)(PORT = 1521))
7 )
8 (CONNECT_DATA =
9 (SERVER = DEDICATED)
10 (SID = wxboss)
11 )
12 )';

特此记录。

人气教程排行