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!

got "ORA-12560: TNS:protocol adapter error" when query from DBLINK

592748Feb 25 2008 — edited Feb 25 2008

I create database link like this;
create public database link XXXDBLNK
connect to xxx identified by xxx
using 'xxxdb';

And the tns seems ok, I can login with sqlplus myusername/pwd@xxxdb.

But when I "select * from dual@xxxDBLNK", I got the ORA-12560: TNS:protocol adapter error.

How to trouble shooting this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 24 2008

Added on Feb 25 2008

#general-database-discussions

1 comment

1,180 views