ORA-01017: invalid username/password; logon denied(database link error)
December 19, 2011 2 Comments
When I was creating database link from Oracle 10g to 11g like that:
SQL> create database link mylink_name connect to myuser_name identified by mypassword using 'MYSID'; Database link created
got ORA-01017 error.
Cause:
This may happen if in 11g database, there is enabled the following parameter:
SQL> show parameter sec_case_sensitive_logon; NAME TYPE VALUE ----------------------------------- --------- ------------------------------ sec_case_sensitive_logon boolean TRUE
Solution:
Recreate database link by the following way:
SQL> drop database link mylink_name; Database link dropped SQL> create database link mylink_name connect to "myuser_name" identified by "mypassword" using 'MYSID'; Database link created
To check it:
SQL> select * from dual@mylink_name; DUMMY ----- X
About Mariami Kupatadze
DBA Knowledge Base 
Excellent, thanks a lot. When creating the database link I found it was enough to put the password in double quotes to fix the ORA-01017 error, the username didn’t seem to need it.
Thanks for post,very useful..