Skip to Main Content

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!

ORA-02019: connection description for remote database not found

977400Dec 1 2012 — edited Dec 1 2012
I am using 2 databases (PROD & TEST)

I am created listeners on both database with same name. created 2 db links 1 is plink1 (PROD) & 2 is plink2 (TEST)

I am Try to TNSPING from PROD

[oracle@db ~]$ tnsping TEST

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 01-DEC-2012 19:23:23

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
/u01/app/oracle/product/10.2.0/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dblink.oracle.com)(PORT = 1522)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))))
OK (160 msec)


I am Try to TNSPING from TEST

[oracle@dblink ~]$ tnsping PROD

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 01-DEC-2012 19:25:33

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
/u01/app/oracle/product/10.2.0/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = db.oracle.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))))
OK (200 msec)


now I am try to connect database from PROD

SQL> select * from scott.emp@TEST;
select * from scott.emp@TEST
*
ERROR at line 1:
ORA-02019: connection description for remote database not found..

same error from TEST db also..

why its coming error?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 29 2012
Added on Dec 1 2012
15 comments
106,096 views