One home, a carrier phone to, create Dblink error ora-02063/ora-01017
On this bug, the encounter is not a single time, Oracle for the bug described as follows
Bug 6738104:ora-01017 ORA-02063 while connecting from10g to 11G VIA public DBLINK
Cause
The following Bug 6738104 is logged for this issue which is closed as not abug saying the cause being introduction of PA ssWOrd Case sensitivity Feature in11g
When the one creates a database link connection, a user name and password for theconnection needs to is defined. When the database link was 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, must re-create the password for this database link using alluppercase letters.
The reason need to re-create the password using all uppercase letters is sothat it would match how Oracle Database stor ES database link passwords. Oracledatabase always stores this type of password in uppercase letters, even if Thepassword had originally been created U Sing lower or mixed case letters. If casesensitivity is disabled, the user can enter the password using the case Thepassword were created in.
When the low version connects to the 11G library via Dblink, the password is changed to uppercase by default.
Solution is simple, re-create Dblink, password using double quotation marks + lowercase
Example: 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)
Ten (SID = Wxboss)
11)
12) ';
Hereby record.
Low version using Dblink connection 11G version times wrong ora-02063/ora-01017