1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

unable to access remote database object using database link

Discussion in 'SQL PL/SQL' started by laxman, Jul 26, 2010.

  1. laxman

    laxman Forum Expert

    Messages:
    144
    Likes Received:
    0
    Trophy Points:
    230
    Location:
    MUMBAI
    Hi all,
    I have created a database link to a remote server
    Code (SQL):
    SQL> CREATE DATABASE link remote_link CONNECT TO lax_dba IDENTIFIED BY lax_dba USING 'abc.corp.com';

    DATABASE link created
    when i am trying to access any table of lax_dba

    Code (SQL):
    sql> SELECT * FROM laxtab@remote_link;
     
    i am getting this Ora error  
    ORA-12514: TNS:listener does NOT currently know OF service requested IN CONNECT
    I need your help please to solve this issue

    Thanks n Regards
    Laxman
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Seems like something wrong with the Connect descriptor.

    Is it ping from the client ? (TNSPING)
    It is properly configured in tns ?