Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dblink not working in select

DBA_1976Aug 31 2010 — edited Sep 1 2010

Hi,
I have created a public dblink say lnkA from server a to connect to server b. When I tested the db link in toad, it resolves successfully. I am able to connect to the server b by sqlplus i.e from server a if I try

sqlplus uid/pwd@svrB_instance I am able to connect. But when I tried to execute a sql statement using dblink from server a, I get this error.

ERROR at line 1:
ORA-02019: connection description for remote database not found

tnsping also resolves successfully.

Please help.
What am I missing?

Edited by: pransuj on Aug 31, 2010 10:37 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 29 2010

Added on Aug 31 2010

#general-database-discussions

15 comments

8,054 views