| Database Link Problem [message #373599] |
Wed, 25 April 2001 15:10  |
Breno
Messages: 1
Registered: April 2001
|
Junior Member |
|
|
I have a problem ONLY in this database to create a database link.
LOOK
I'm connect in this database:
conn USER1/PASSWORD1@TNS:TNS1
I'd like create a database link in the 'TNS2'
them
create database link test
connect to user2 identified by password2
using 'TNS2';
When I try to acess a table in this database
"DESC TABLE1@test"
this message show :
ORA-12154: TNS:could not resolve service name
But,
If I write "CONN USER2/PASSWORD2@TNS:TNS2".
I don't have problem to connect.
Why ?
The TNS Name is the same.
Thanks,
Breno
|
|
|
|
| Re: Database Link Problem [message #373629 is a reply to message #373599] |
Fri, 27 April 2001 12:18  |
Koresh
Messages: 4
Registered: April 1999
|
Junior Member |
|
|
Hi,
Didyou try giving the DBlink the same name
as the name of database instance?
(In above example Dblink should be named 'TNS2').
Hope it helps.
Koresh.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
