You must Sign In to post a response.
  • Category: BizTalk

    ORA-12154: TNS:could not resolve the connect identifier specified.

    Following is the environment that is established

    Windows Server 2008 R2
    Visual Studio 2010
    SQL Server 2008
    BizTalk Server 2010
    Oralce 10g client (Installation type : administrator)
    TOAD 9
    PLSQL Developer 7.1

    We are planning to migrate on BizTalk Server 2010 from BizTalk Server 2006 R2. For this purpose we create above environment.

    After the creation of this environment we start to deploy our services. These services had been created in BizTalk Server 2006 R2 and we just export MSI, binding, DLL, BRE, IIS , SSO and start to import all these things in BizTalk 2010.

    We have faced several issue in start mostly related to IIS. But with the course of time, one after another we have figure out to solve problem. But we have now stuck on the following error

    ORA-12154: TNS:could not resolve the connect identifier specified.

    Problem is that we have check all related thing, We have only single home. Ora TNS file is placed at correct location.

    We reinstall Oracle client, TOAD and PLSQL Developer but no use.

    Now we think about to recompile projects and redeploy. We take a single service as an example, compile and redeploy it.

    Here we find some different behavior. We have a .Net helper that is class library. We connect TNS in that class library. We are using Oralce.DataAccess assembly.

    We do this by create windows application and add reference of our .Net helper and execute function in .Net helper to connect TNS. It work fine. But same .Net helper is GACed in GAC then it through above error. It is strange.

    We also deployed and configure ODAC112021Xcopy_x64 on our server successfully according to log files.

    Concluded is that

    - We are able to connect to Oracle with PLSQL Developer.
    - We are able to connect to Oracle with TOAD.
    - We are not able to connect with Our .Net Helper when it is GACed.
    - We are able to connect when we add .Net Helper in a .Net Client and Call function to connect to Oracle.
    - When our service hit with same TNS above mention error occurred.

    Kindly suggest the solution.
  • #603867
    Hi,
    Sometimes you will be able to connect the database when you access through PL SQL developer/toad but it fails if you try it using application.

    Execute below query after connecting your database using TOAD or PLSQL developer and compare the output with the name used in tnsnames.ora and make sure you are using the same name in your appication as well.


    select * from global_name


    Below link will help you to find more detailed information,
    http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm


    Regards,
    Asheej T K


  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.