public database link error [message #372127] |
Thu, 11 January 2001 17:05 |
user
Messages: 3 Registered: July 2000
|
Junior Member |
|
|
Hi ,
I've created public database link by name mpl_link.
But i am getting the following error.Any ideas?
Thanks in advance.
SQL> select count(*) from t1@mpl_link;
select count(*) from t1@mpl_link
*
ERROR at line 1:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
|
|
|
Re: public database link error [message #372135 is a reply to message #372127] |
Fri, 12 January 2001 10:50 |
Bala
Messages: 205 Registered: November 1999
|
Senior Member |
|
|
Hi,
Check the init parameter global_names
if it is true
then you have to give the whole db name
ex. dbname.world
while creating the link...
I am not sure this is the problem..
but you can give it a try....
Bala
|
|
|
Re: public database link error [message #372292 is a reply to message #372127] |
Wed, 31 January 2001 06:30 |
Stelios Karkazis
Messages: 1 Registered: January 2001
|
Junior Member |
|
|
First of all you must have a connect string with Easy Net Config.
Then create the link with Oracle Schema Manager and as system. Create a public database link with a different name than the connect string, but be sure to give the service_name (like mp1). In the connection details leave Connected User.
|
|
|