Home » RDBMS Server » Server Administration » DB LINK Error Help!
DB LINK Error Help! [message #219060] Mon, 12 February 2007 14:38 Go to next message
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 Go to previous message
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
Previous Topic: Metric Collection Error on OEM cluster
Next Topic: Deallocation of extent in Temporary Segments??
Goto Forum:
  


Current Time: Mon Dec 02 15:48:55 CST 2024