As you know in Oracle 11g passwords are case sensitive by default. This applies to connecting via SQL*Plus or other client tools. And it also applies to database links between databases. So when you link from Oracle 10g to Oracle 11g create database link like this:
CREATE DATABASE LINK my_linkDo not forget to enclose password by double-quote marks!
CONNECT TO remote_user IDENTIFIED BY "CaSe_SeNsItIvE_PaSsWoRd"
USING 'TNS_ID_11G';
When you do not set password this way, you will be getting:
ORA-01017: invalid username/password; logon denied.Hope this small tip will be useful for someone.
Paweł
More on Creating Database Links.
--
Related Articles on Paweł Barut blog:
19 comments:
Thank you!!
Thank you very much! it helps me a lot!
when I tried to created a db link pointing to Oracle 11g from Oracle 10g database, I got this error. Strange thing if both databases are 11g, I didn't see any issue, meaning: I didn't quote password at all, it can work oin both 11g database.
In 11g there is no issue with this, as password is automatically case sensitive. So it is treated same way as you add quote marks.
BR/Paweł
Thanks ! it helps me -
Thank you!
Thank you so much for the tip.
-Santhosh
Thank you...
this tip helped me...
Thank you soo much!! please keep posting such brilliant tips!! keep it up!
thanks is usefull post.
Thanks so much for this tip.We are trying to connect from 9i to 11g database and we were not able to do until we saw you post.
Thanks a lot!!!!!
Thank you
Thanks a lot helped a lot.. Keep posting :)
Thank you for this info.
I'm trying to connect from 11g to 9 and still facing this error.
There is no problem to connect from 9 to 11 though...
Great. Helped a lot.
Thanks for sharing.
It helps a lot! I got errors and could not figure out why. Searching online for a while and finally found the correct answer. Thanks.
Hi Barut,
Thanks alot for your Awesome tip.
Naveen Sangam.
Oracle DBA
Thanks! We were unable to create a DB link from 10g to 11g w/ valid credentials. This fix worked perfectly.
I just created passwords all with UPPER LETTERS in 11g, it also helps, because 10g and previous versions seems by default store passwords all in upper case, like creating a table.
Your tip is still helping people. It was my first hit on Google for ORA-01017 database link 11g and it solved my problem. Thank you.
-- Sloot
Post a Comment