ORA-02019: connection description for remote database not found
977400Dec 1 2012 — edited Dec 1 2012I 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?