DB LINK Error Help! [message #219060] |
Mon, 12 February 2007 14:38 |
Rustican
Messages: 51 Registered: July 2006
|
Member |
|
|
I'm in the process of setting up streams between two databases and started creating a database link from my source DB to the destination. I'm using oralce 10g and set up my links in the Enterprise Manager.
I created the link and the test button in the Enterprise Manager says that my link is active. But when i try to set up my streams to use the link that i defined i'm gettin the following error in my propogation job.
ORA-02019: connection description for remote database not found
Can anyone help?
|
|
|
Re: DB LINK Error Help! [message #219064 is a reply to message #219060] |
Mon, 12 February 2007 16:05 |
roopla
Messages: 52 Registered: May 2006
|
Member |
|
|
Make sure your db link works fine.
Try doing select * from dual@<your database link name>.
If it returns ok, then your db link is working fine or something wrong with your tnsnames stuff
Hope it helps
|
|
|