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