低版本使用dblink連接11G版本時(shí)報(bào)錯(cuò)ora-02063/ora-01017

1回家，某運(yùn)營商電話至，創(chuàng)建dblink報(bào)錯(cuò)ora-02063/ora-01017 

關(guān)于這個(gè)BUG，遇到不是1次了，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.

當(dāng)?shù)桶姹就ㄟ^dblink連接11G庫時(shí)，默許會將密碼改成大寫。

solution就很簡單啦，重新創(chuàng)建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 )';

特此記錄。

生活不易，碼農(nóng)辛苦
如果您覺得本網(wǎng)站對您的學(xué)習(xí)有所幫助,可以手機(jī)掃描二維碼進(jìn)行捐贈