Oracle database link
- by Sunit
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?
thanks
Sunit