Let’s start a post with the steps which use for the solve ORA-01017: invalid username/password; logon denied (Using Database Link) Create a database link with the wrong password
1 |
SQL> create database link test_link connect to scott identified by tiger using 'Test'; |
Test the DB link
1 2 3 4 |
SQL> select * from dual@test_link; ORA-01017: invalid username/password; logon denied ORA-02063: preceding line from VODCMS |
Reason: Case sensitive login enabled in the target database. Check-in target database:
1 2 3 4 |
SQL> show parameter sec_case_sensitive_logon; NAME TYPE VALUE ------------------------------ --------------------------------- ------------------------------ sec_case_sensitive_logon boolean TRUE |
How to fix: Drop and recreate the database link […]