| db link [message #60900] |
Fri, 12 March 2004 05:15  |
Kapil
Messages: 145
Registered: May 2002
|
Senior Member |
|
|
I created a database link to Orace 7.x from oracle 8i, and when i try to use it. i wont work. it keep says tns couldn't resolve. what should i be doing. help me.
thank you.
|
|
|
|
| Re: db link [message #60917 is a reply to message #60900] |
Fri, 12 March 2004 13:42  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
You need to add the 7.x database to $ORACLE_HOME/network/admin/tnsnames.ora on the server (the 8i ORACLE_HOME).
When adding the entry - be sure to use the syntax (SID=...) not (SERVICE_NAME=...). There is/was a bad bug related to that where it connected to the first DB in the listener - not the one specified.
|
|
|
|
|
|
| Re: db link [message #60919 is a reply to message #60918] |
Fri, 12 March 2004 15:03 |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
See Note#232896.999 on metalink.
If you had the same user with the same password on 2 databases serviced by the remote listener, then it would connect to the first one specified in the listener. To determine that, just do a "select global_name from global_name@db_link". On 7.3.x that maybe be "select * from v$instance@db_link" or something. Obviously having different passwords would protect you...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
