低版本使用dblink串連11G版本時報錯ora-02063/ora-01017,dblinkora-02063

來源:互聯網
上載者:User

低版本使用dblink串連11G版本時報錯ora-02063/ora-01017,dblinkora-02063

一回家,某電訊廠商電話至,建立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 )';

特此記錄。

 

相關文章

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。