Oracle DBA Tips and Techniques

By Arjun Raja

CREATING PUBLIC DATABASE LINK FROM 10g to 11g Database.

Posted by Arjun Raja on January 14, 2011

Point to note when creating a new public database link from a 10g to 11g database….the password of the user in the target database (11g) needs to be enclosed within double quotes.

SQL> create public database link 10g_11g_link connect to test identified by test using ‘test’;

Database link created.

SQL> select * from dual@10g_11g_link;

ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from 10G_11G_LINK

SQL> drop public database link 10g_11g_link;

Database link dropped.

SQL> create public database link 10g_11g_link connect to test identified by “test” using ‘test’;

Database link created.

SQL> select * from dual@10g_11g_link;

D

X

SQL>

Therefore since 11g databases have case sensitive passwords, the password in the 11g database must be enclosed within double quotes.- otherwise invalid username/password errors are thrown while using the link.

Advertisements

One Response to “CREATING PUBLIC DATABASE LINK FROM 10g to 11g Database.”

  1. Edgar said

    Thanks, I solved an issue that I have.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: