Problem: Connecting oracle 11g from oracle9i database using database link
Problem in Connecting oracle 11g from oracle9i database using database link.
When you try connect oracle 11g database with Oracle 9i using database link you are likely to get connection error.
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from your_db_link_name
This might surprise you that even you are giving the correct password you are not able to connect using database link. When you try to connect using 9i client SQLPLUS> you are able to connect.
The one possible cause for problem that you created database link using following
create database link mydb_link connect to myuser identified by mypassword using 'myconnect_string';
To solve this problem drop the database link and recreate it using following
create database link mydb_link connect to myuser identified by "mypassword" using 'myconnect_string';
You need to put your password in double quotes ("")
Need Help in Oracle? Email: blogs@adaptiveit.net