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?
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 anSSL
link between the databases and making the linkCURRENT_USER
enabled.See here: http://download.oracle.com/docs/cd/B12037_01/network.101/b10772/asoeuscf.htm