Problem w/ database link
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Problem w/ database link

Hybrid View

  1. #1
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    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





  2. #2
    Join Date
    Jun 2001
    Posts
    29
    You need to ensure the tnsnames.ora on the server db1 is on has the necessary entry for "wmsp1".

  3. #3
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    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

  4. #4
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width