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
