Search Oracle Blogs

List of Blogs maintained by Paweł Barut.


Wednesday, August 13, 2008

DB Link to Oracle 11g

Written by Paweł Barut
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_link
CONNECT TO remote_user IDENTIFIED BY "CaSe_SeNsItIvE_PaSsWoRd"
USING 'TNS_ID_11G';

Do not forget to enclose password by double-quote marks!
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:

Anonymous said...

Thank you!!

Anonymous said...

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.

Paweł Barut said...

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ł

Anonymous said...

Thanks ! it helps me -

jkpd said...

Thank you!

Sandy said...

Thank you so much for the tip.

-Santhosh

Kiran said...

Thank you...

this tip helped me...

Anonymous said...

Thank you soo much!! please keep posting such brilliant tips!! keep it up!

TigraNAV said...

thanks is usefull post.

arun said...

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!!!!!

Anonymous said...

Thank you

sri hari said...

Thanks a lot helped a lot.. Keep posting :)

Ivo said...

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...

Muruganantham Durairaj said...

Great. Helped a lot.
Thanks for sharing.

Anonymous said...

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.

Naveen A Sangam said...

Hi Barut,

Thanks alot for your Awesome tip.

Naveen Sangam.
Oracle DBA

Tom said...

Thanks! We were unable to create a DB link from 10g to 11g w/ valid credentials. This fix worked perfectly.

Anonymous said...

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.

Anonymous said...

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

 

Copyright © Paweł Barut
Printing from DOS to USB Printer