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';