Oracle database link

Question

I'm currently using Windows Authentication with 2 Oracle servers - SP3DSMP1 & SP3DSMP4. I created a database link on SMP1 to connect to SMP4 as:

SQL> create public database link LINK_SMP4 2 connect to CURRENT_USER 3 using 'SP3DSMP4';

Database link created.

However when I try to do a query, I get the error:

ERROR at line 1: ORA-01017: invalid username/password; logon denied

Any ideas what might be wrong here?

Can one Oracle server authenticate to another Oracle server using Windows auth? Too lazy to look at actual docs now, but I doubt it, and this would be the first thing I'd check. — 9000
– 9000, Commented Dec 27, 2010 at 23:28

Quassnoi · Accepted Answer · 2010-12-27 23:46:35Z

7

Credentials are not passed over the dblink connection.

When creating a CURRENT_USER dblink, a trust should be established between the databases. This requires setting up an enterprise domain, adding the databases to it, setting an SSL link between the databases and making the link CURRENT_USER enabled.

See here: http://download.oracle.com/docs/cd/B12037_01/network.101/b10772/asoeuscf.htm

answered Dec 27, 2010 at 23:46

Quassnoi

427k94 gold badges628 silver badges623 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle database link

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related