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

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

Test the DB link

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:

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

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

Thought of the day!

Learn to enjoy every minute of your life. Be happy now. Don’t wait for something outside of yourself to make you happy in the future. Think how really precious is the time you have to spend, whether it’s at work or with your family. Every minute should be enjoyed and savoured.
By Earl Nightingale

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Tagged:

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.