locked
ORA-12154: TNS:could not resolve the connect identifier specified RRS feed

  • Question

  • I am having issue with the new TNS connection. I have added the below code in to the tnsnames.ora file

    c0xlxx =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxxx)(PORT=xxxxxxxxx))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = xxxxxxx )
        )
      )
    

    I can verify  the connection using the SQL Oracle developer,  it is perfect.

    But when I use in the BizTalk application in test environment using WCF-Custom adapter for OracleDBBinding  with URI oracledb://c0xlxx/ it is throwing error

    The adapter failed to transmit message going to send port "WcfSendPort_LTMDBBindingtoAX_View_VW_JOB_DEPT_Custom" with URL "oracledb://c0xlxx/". It will be retransmitted after the retry interval specified for this Send Port. Details:"Microsoft.ServiceModel.Channels.Common.ConnectionException: ORA-12154: TNS:could not resolve the connect identifier specified ---> Oracle.DataAccess.Client.OracleException: ORA-12154: TNS:could not resolve the connect identifier specified

    Any help is greatly appreciated. I did the sameway in the BizTalk application dev environment, it is working perfectly.

    Thanks

    Monday, August 17, 2015 11:41 AM

Answers

All replies

  • Hi,

    You need to install Oracle Data Provider .NET package. Here is the link 

    http://www.oracle.com/technetwork/topics/dotnet/index-085163.html

    Download the suitable version and check.

    You can also try action provided in the below link:

    http://ora-12154.ora-code.com/


    Please mark as answer or vote as helpful if my reply does

    Monday, August 17, 2015 12:03 PM
    Moderator
  • The other TNS connections are working fine. Just this new one is throwing the error. Do I need to still install Oracle Data Provider .NET package?

    Monday, August 17, 2015 12:11 PM
  • Please anyone help me with this. Thanks
    Monday, August 17, 2015 2:43 PM
  • Hi,

    Sometimes the issue could be with the sequencing of the values in the TNSNAMES.ORA. Try using the TNSNAMES.ORA file which works and just make the values i.e. Host, Port, Service name of the TNSNAMES.ORA which you want to use.

    Please indicate "Mark as Answer" or "Mark as Helpful" if this post has answered the question

    Regards

    Rahul Madaan

    biztalkvillage.blogspot.com

    Tuesday, August 18, 2015 4:05 AM
  • I tried copying the values from the dev environment tnsnames.ora (where it works perfectly) and test environment tnsnames.ora. But still it is throwing the same error.

    I can connect other connection strings in the test environment, just this new one is giving the trouble...

    Tuesday, August 18, 2015 11:57 AM
  • Hi 

    Here you have more details about this error : 

    http://docs.oracle.com/cd/B19306_01/server.102/b14219/net12150.htm

    Have you tried to connect to Oracle DB using Oracle tools (i.e. tnsping, sqlplus)? 

    Regards, 


    Aurel BERA, MSFT
    MSDN Community Support. LE CONTENU EST FOURNI "TEL QUEL" SANS GARANTIE D'AUCUNE SORTE, EXPLICITE OU IMPLICITE.
    S'il vous plaît n'oubliez pas de "Marquer comme réponse" les réponses qui ont résolu votre problème. C'est une voie commune pour reconnaître ceux qui vous ont aidé, et rend plus facile pour les autres visiteurs de trouver plus tard la résolution.

    Tuesday, August 18, 2015 2:49 PM
  • Try Using http://ora-12154.ora-code.com/

    And if you are using 64 bit host instance than you need to do some modification

    To work around this problem, follow these steps:

    1.  Click Start , click Run , type regedit , and then press ENTER. 

    2.  In Registry Editor, locate the ImagePath registry entry in the following registry key:

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\BTSSvc$<Your64bitBizTalkHostname>

    3.  Change the value of the registry entry as follows to avoid using parenthesis in the path.

    Refer :http://blogs.msdn.com/b/asiatech/archive/2009/03/31/ora-12154-tns-could-not-resolve-the-connect-identifier-specified.aspx

    Note : you need to install  Oracle Data Provider .NET package

    Thanks
    Abhishek

    • Marked as answer by vdha Thursday, August 20, 2015 1:55 PM
    Wednesday, August 19, 2015 5:03 AM