database link error: tns could not resolve
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: database link error: tns could not resolve

  1. #1
    Join Date
    Jun 2000
    Location
    Bethel CT, USA
    Posts
    18

    Unhappy database link error: tns could not resolve

    with sqlplus i create db link:

    create database link xxx.yyy.zzz
    connect to uuu identified by ppp
    using 'xxx.yyy.zzz';

    tnsnames.ora on the server has a nentry :
    xxx.yyy.zzz = ....


    in sqlplus i select:

    select * from table@xxx.yyy.zzz;

    ERROR at line 1:
    ORA-12154: TNS:could not resolve service name

    -----
    I can manually connect uuu/ppp@xxx.yyy.zzz;
    I can select * from ttt;
    -----

    So what am I forgeting???????

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Something is probably messed up with either your tnsnames.ora or sqlnet.ora on the server. Create the database link with the full description from your tnsnames.ora like:
    Code:
    create database link xxx.yyy.zzz
    connect to uuu identified by ppp
    using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = jeffhpc)(PORT = 1521)))CONNECT_DATA =(SERVICE_NAME = nt817.us)))';
    This should eliminate your networking issues. If this works, you have a problem with your tnsnames.ora or sqlnet.ora.

    If this doesn't work, you may have a tcp/ip issue...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jun 2000
    Location
    Bethel CT, USA
    Posts
    18
    I recreated the link as you suggested, than got into another error that indicated that my global_name=true and need to change to false.

    Finally it worked.

    Thanks for your help.

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