ORA-01017 : invalid username/password; logon denied (Using Database Link)

SQL> create database link test_link connect to scott identified by tiger using 'Test';

 

SQL> select * from dual@test_link;

 

ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from VODCMS

 

Reason:

Case sensitive logon enabled in target database.

Check in target database:

SQL>  show parameter sec_case_sensitive_logon;

 

NAME                                           TYPE                              VALUE

------------------------------ --------------------------------- ------------------------------

sec_case_sensitive_logon             boolean                           TRUE

 

How to fix:

SQL> create database link test_link connect to "scott" identified by "tiger" using 'Test';

Comments