Create a Database link [message #4403] |
Thu, 05 December 2002 03:41 |
jerome
Messages: 13 Registered: May 2000
|
Junior Member |
|
|
HI all,
I try to create a DB Link between 2 oracle dbs
I set it as following:
Name: Boston
Public
Connection details: Fixed user (Username,Password)
Service Name: SID.address
But when I test, I always have ora-02082 databsae link is not active...
Has anyone any idea?
thanks to all in advance
Jerome
|
|
|
Re: Create a Database link [message #4404 is a reply to message #4403] |
Thu, 05 December 2002 04:09 |
Kavitha
Messages: 40 Registered: December 1999
|
Member |
|
|
Hi,
Is the error message ORA-02081 or ORA-02082?
If its ORA-02081 then please check the other database is up and running and the listener is up and running as well. Check if you are able to ping the server and check if you are able to connect thru normal SQL*Net.
If its ORA-02082 then it means that ur database name matches ur link name and thats not allowed. Change the name of the link and that should solve your problems.
Hope this helps.
|
|
|