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!

DB Link error - ORA-02019: connection description for remote database

485386Apr 11 2006 — edited Apr 12 2006

Hi All,

I'm trying to configure Streams on Oracle 10g. I have not used database link very much and I can't figure out why my db link is not working properly. It's causing me to get errors in the propagation portion of the stream. I am running on Linux and trying to connect to another database on a separate machine but within the same network. I created the db link like this:

CREATE DATABASE LINK CMSDB CONNECT TO stradmin IDENTIFIED BY ******* USING 'CMSDB';

I have verified that my tnsnames.ora file is setup properly. Doesn't the dblink use the tnsnames to connect to remote db's. I can connect to CMSDB via sqlplus from other my database server. Any tips on what i could be missing?

Any help would be appreciated.

Thank, Dave

Locked Post

New comments cannot be posted to this locked post.

Locked on May 10 2006

Added on Apr 11 2006

#general-database-discussions

2 comments

980 views