Database Link 10g 11g Fails ORA-01017

September 9, 2010  |  dba, security

When I was testing a database link between a 10g database and an 11g databaase, i got ORA-01017: invalid username/password; logon denied followed by ORA-02063: preceding line from dblink11g.

A database link is a schema object in one database that enables you to access objects on another database. The other database does not need to be an Oracle Database system. However, to access non-Oracle systems you must use Oracle Heterogeneous Services.

Today I was trying to create a database link between a 10g r2 database on RHEL 5 and a Oracle 11g R1 on RHEL 5.


CREATE DATABASE LINK dblink11g
CONNECT TO myuser IDENTIFIED BY MyPass1 USING 'db11.domain.com';

When I was testing it I got this:

SQL> select sysdate from dual@dblink11g;
select sysdba from dual@dblink11g;
*
ERROR at line 1:ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from dblink11g

After a little research I found that 11g R1 passwords are case sensitive by default.

So to solve this in the origin server (10g), I just droped the database link and recreate it using double quotes on the password at the IDENTIFIED BY clause:


SQL> DROP DATABASE LINK dblink11g;
SQL> CREATE DATABASE LINK dblink11g
SQL> CONNECT TO myuser IDENTIFIED BY "MyPass1" USING 'db11.domain.com';

The other option is to disable password case sensitivity in the destination 11g database by setting SEC_CASE_SENSITIVE_LOGON to FALSE.


SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE SCOPE=BOTH;

Problem solved… for you too i hope 🙂


13 Comments


  1. Thanks for this very useful.

  2. Thank you for this article. Very useful!
    Actually, I’ve been searching through tons of forums & articles the last 2 days & none of the solutions worked for my link issue between 10G & 11G DBs. Until i stumbled across your article & it worked like a charm.

  3. Spot on – thanks.

  4. thx for this – helped me solve this problem 🙂

  5. A great tip! Thanks.

  6. Thanks…saved my day… 🙂

  7. Jari Jääskeläinen

    Super! This saved by day as well! 🙂 🙂

  8. great stuff, also worked well for me. 🙂
    I was trying to connect from 9i to 11gr1, however, in my case prior to changing the parameter (SEC_CASE_SENSITIVE_LOGON) I was able to view the content from 11g db but only as system & sys users.
    also, I changed the password to be in the right case.

  9. Thank you!! This 3 year old post is still helping people 🙂

  10. Thanks!! Golden tip!!

  11. Thank you very much… my 10g to 11g link was not working and repeatedly giving me either the invalid username/password error or TNS/listener error. I wasted my 2 hours for looking at the perfect TNS configuration, syntaxes etc. At a moment i even felt that “Do i even know the basics of connectivity in Oracle !!” 😛

    Finally your article threw some light 🙂 🙂

    Thanks again.

  12. Thanks you very much for this post !!
    Link between 9.i and 11.g : ok now !!

    “” pwd ” !!

    Céline D

Leave a Reply