Menu
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?
569
A database link is a pointer that defines a one-way communication path from an Oracle Database server to another database server. The link pointer is actually defined as an entry in a data dictionary table. To access the link, you must be connected to the local database that contains the data dictionary entry.
Any user can query USER_DB_LINKS to determine which database links are available to that user. Only those with additional privileges can use the ALL_DB_LINKS or DBA_DB_LINKS view.
To create a shared database link, use the keyword SHARED in the CREATE DATABASE LINK statement: CREATE SHARED DATABASE LINK dblink_name [CONNECT TO username IDENTIFIED BY password]|[CONNECT TO CURRENT_USER] AUTHENTICATED BY schema_name IDENTIFIED BY password [USING 'service_name'];
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
113
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
