db_links not working
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: db_links not working

  1. #1
    Join Date
    Nov 2000
    Posts
    21

    db_links not working

    hi ALL,

    Is there any reason why my db_link is not working between PROD and TEST, I keep getting :TNS error: service name cannot be resolved...which I dont understand as I have entries for both instances in the tnsnames.ora and located in the right place $ORACLE_HOME/network.
    the link is from prod to test for a particular schema...DO I have to go into test to create this.

    please help..
    regards Giddy

  2. #2
    Join Date
    Nov 2002
    Posts
    39
    Can you try to tnsping your test database from your production machine. Give the results here.
    Sathish

  3. #3
    Join Date
    Nov 2000
    Posts
    21
    yes it worked from both mu C drive and unix

    TNS Ping Utility for IBM/AIX RISC System/6000: Version 8.1.7.1.0 - Production on 05-FEB-2003 09:22:43

    (c) Copyright 1997 Oracle Corporation. All rights reserved.

    Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=tracks)(PORT=1523))

    OK (70 msec)
    and I can even connect from sqlplus on prod to test...
    using
    connect username/password@test.
    regards Giddy

  4. #4
    Join Date
    Feb 2003
    Location
    UK
    Posts
    4
    A long shot here, try changing SERVICE_NAME to SID in the TNSNAMES file in $ORACLE_HOME/network/admin

  5. #5
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    Make sure GLOBAL_NAMES=false. If not then:

    alter system set global_names=false;
    Agasimani
    OCP(10g/9i/8i/8)

  6. #6
    Join Date
    Nov 2000
    Posts
    21
    yep,
    its worked ....my last bit in the create syntax "using test.world" was wrong so I dropped db link and created it as "using test" without the world...
    the service name in the tnsnames.ora was test and not test.world
    this worked eventually, its very much annoying for such little stuff to bugger the mind.
    thanks everyone.
    regards Giddy

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