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)
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.