DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Error while executing DB link

  1. #1
    Join Date
    May 2007
    Posts
    1

    Error while executing DB link

    Hi ALL,
    I am facing a problem in DB link.
    I am able to create DB link but while executing the query or testing the link it is showing the following Error:

    Ora-12154[/B]:TNS:Could Not Resolve Service Name

    Though there is entry for Both DB in Tnsnames.ora File and also Both are Oracle DB.
    Also i have tried giving the whole connection String in DB link Syntax
    Can anyone help pls.....

    This one is for simple DB link and not public DB Link.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Can you ping the target box?
    Can you tnsping the target database?
    Other than thinking you have the right tnsnames entry... have you double-checked if you really have it?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    May 2007
    Posts
    7
    May be ur database is down when ur trying to use that link..! Make sure with ur env guys when u face this problem again.

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by raviindbaworld
    May be ur database is down when ur trying to use that link..! Make sure with ur env guys when u face this problem again.
    Wrong answer... what part of "Ora-12154[/b]:TNS:Could Not Resolve Service Name" wasn't clear enough?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    May 2007
    Posts
    11
    Post your tnsnames.ora
    Post your Create statement for the databaselink

    Make sure with ur env guys when u face this problem again
    uhmm env guys ?

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