-
When I create a dB link to one of my databases, it works just fine:
CREATE DATABASE LINK testdb
CONNECT TO wms_owner IDENTIFIED BY "the-pass0"
USING 'testdb'
When I create another link (same source database) to another database, the create works but the usage fails!
CREATE DATABASE LINK wmsp
CONNECT TO wms_owner IDENTIFIED BY "the-pass0"
USING 'wmsp1'
I get: ORA-02019: connect description for remote database not found:
SOME FACTS:
-the userid/ password and connect string are correct
-wmsp1 is defined in my local TNS and connects with SQL/PLUS ie. CONNECT wms_owner/the-pass0@wmsp1
- The instance is named WMSP1 but the dB is WMSP (some day we will use RAC)
PARAMETERS for both database are the same or equivalent:
-------------------------dB1------dB2
db_name(s)................testdb....wmsp
instance_name(s)........testdb....wmsp1
db_domain (s).............NULL......NULL
global_names(s).........FALSE....FALSE
What else could it be that makes the link not work????
Your help is much needed and appreciated
-
You need to ensure the tnsnames.ora on the server db1 is on has the necessary entry for "wmsp1".
-
ora 2019
02019, 00000, "connection description for remote database not found"
// *Cause:
// *Action:
Note:Make sure you have correct entry.Can you copy and paste your tnsnames file..?
Thanigaivasan
-
You guys are right on target!!!!
my tnsnames.ora **on the server*** needed work!
I spun my wheels for hours and if not for this post it would have taken much more time.
Thanks!
