Can you check how many oracle homes you have on the webserver?

They should be listed under the following registry key 

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

I may be leading you the wrong way but worth a look.

if your database is on another server from the IIS server then you may need to look into impersonation settings in your web.config - had a similare issue but dont have access to the particular config at the moment so cant help with the details

Paul

Hi Prashant,

Thanks again for the prompt response. 

In registry  under Oracle I have 2 Keys "KEY_XEClient and "OracleMTSRecoveryService"

In KEY_XEClient the following are set
...
ORACLE_HOME is set as "C:\XEClient" 
ORACLE _HOME_KEY is "SOFTWARE\ORACLE\KEY_XEClient" ,
ORACLE_BASE is "C:\XEClient"
ORACLE_HOME_NAME is XEClient
... 

I think you might have found a problem !! , I  thought the path would be C:\InstantClient

In my enviroment variables I have the following System variables Path variable "C:\XEClient\bin"..."C:\instantClient"

SQLPATH "C:\XEClient\sqlplus"

I also have the user varaible TNS_ADMIN "C:\instantClient\InstantClient10_1"
 

Should I update the enviroment variable to be  C:\XEClient\sqlplus

Thank you again Praschant  for the help.

Aidan
 

Hi PTEKelly

 

I have <identity impersonate="true" /> in the web.config and I *believe* I have the correct permission for teh ASPNET user on teh appropriate folders

I'm still getting the ORA-12154 error . Any thought on other attributes I'd need for impersonation in teh web.config

Thanks , any help is much appreciated 

 

Aidan 

Try first with giving rights to "NetworkService" on the folder and its subfolders.

And then restart the machine if possible. 

Platform: WindowsXP sp2 / Visual Studio 2003 / .net Framework v1.1.4322 / Oracle 8.1.7.4

After uninstalling and reinstalling oracle 8.1.7.4, I kept getting stubborn "ORA-12154 :TNS:could not resolve the connect identifier specified" from ASP.net app.

I was unable to assign read & execute on my c:\oracle folder to my IUSR_computer account.  Turns out my PC had been renamed before I took possession of it.  IIS properties tab indicated it was using IUSR_OLDcomputer instead of IUSR_CURRENTcomputer.

Adding read & execute on c:\oracle for IUSR_OLDcomputer finally solved ORA-12154.

These permissions are standard fix for ORA-12154 but the OLDcomputer name was a twist not mentioned among all the posts I've read.  Thought I'd share.

Hi

Go to the Oracle Home / Admin / Network folder and look at the tnsnames.ora file.  Your database connection string should match the SID stated in the file.

 Hope this helps

 Fouwaaz

did you ever get this to work?  I too wrote an app that access an Oracle DB on another server.  I get the same error.  I've tried everything that is mentioned on this page.  Any suggestions would be appreciated.

 

Thanks

Tom

Could you post the tnsnames.ora file (Oracle Home / Admin / Network) and the connection string?  That way, we'll be able to get a better idea.

I, too, have run into the same problem.

My scenario is as follows:

- Win 2008
- Oracle 11g
- IIS 7.0, configured to manage .svc-styled web services

Oracle connectivity has been tested through a standard ODP client - successfully.
tnsping shows the tnsnames.ora is properly constructed, and that it is reachable through ORACLE_HOME. SERVICE_NAME (not SID) is used in the CONNECT_DATA section.
Permissions on ORACLE_HOME has been granted to Network Service.

My Web Service method gets the 12154 error and I am at a loss as to why. I can debug into the service method and the connection.Open() method throws an exception when the connection string is identical to the one that was used in the simple database client.

I have seen this same code work in IIS 6. As IIS 7 does not use the same configuration commands as IIS 6, I am wondering if my flavor of this dilemma could be attributable to IIS 7 config.

 Any insights into the problem would be welcomed.

Thanks

I have gotten by this problem by ensuring IUSR_ComputerName, NETWORK SERVICE, ASPNET, and IIS_IUSRS have read access to %ORACLE_HOME%\Network\Admin\TNSNAMES.ORA. Of these, I think the anonymous user and NETWORK SERVICE are the more critical. However, I made sure all of them had access. Rebooting after setting access is important.

I am somewhat shooting in the dark here because I have not narrowed down the cause of my problem to my satisfaction ... I've been hunting for possibilities and believe that my problem was an access problem, and yours may be as well. Ensure that your ORACLE_HOME environment variable is properly defined ... this Oracle error signals some problem accessing ORACLE_HOME and the TNSNAMES.ORA file - so it may point to the fact that your ORACLE_HOME is not pointing to the proper location. To ensure that your TNSNAMES.ORA file is properly structured and you can access it, see if you can tnsping your database. If you cannot, then your TNSNAMES.ORA is either not structured correctly, or you cannot access it. Trying to use sqlplus will also tell you the file is structured right and is accessible. If you can do the above, your problem is most likely an IIS user permission issue. You might try to check out the IIS logs to see which user is trying to access the TNS...ORA file to ensure this user has permissions. IIS authentication method could also be an issue ... you might look into this. Ensure NETWORK SERVICE and IUSR_ComputerName have at least read access to %ORACLE_HOME%\Network\Admin and to the TNSNAMES.ORA in this folder (I assume you have a standard Oracle location for ORACLE_HOME). Ensure your connection string in your app or web config is proper ... and make sure that you are using Oracle's data provider rather than Microsoft's - probably not necessary to resolve an access problem, but it cannot hurt.

http://www.techonthenet.com/oracle/errors/ora12154.php

 

Does this help at all? 

One more addition to this thread: I was facing the same error and tried all of the above. I was running a VB.net application as the administrator of the domain, so access was unlikely to be the problem.

Eventually what appeared to be the root-cause of my problem was the fact that I was running the application on a 64 bit machine and had installed my application in the wrong directory.

I had already installed the 10g oracle client for 64bit for which an earlier error had warned me. However, from that moment on ORA-12154 kept appearing, indicating a communication problem between the application and the Oracle-client.

• TNSPing referred to the correct directory, the connection test worked properly.
• An ODBC connection using the client worked properly, but as soon as I used this through my application using System.Data.ODBC, I had the same problem again.

In the end I moved my application from C:\Program Files (x86) to C:\ProgramFiles and this solved it for me

Hi, guys,

I had the same problem, and I found a workaround- maybe someone will use as I use it.

 

So, I think the problem is with access to tnsnames.ora or sqlnet.ora, because when you run your app in VS Developement Server it runs under your account's right (or user who ran the devenv.exe proccess) and everything is OK (or when you run sql plus, sql developer everything looks the same), when you run under IIS it runs with ASPNET account and its rights which are insufficient  for  these files

To workaround  you can change  or  add  xml node to your web.config or  machine.config. The node should be under  <system.web> section, the node should look like:

 <identity impersonate="true" userName="yourWindowsAccountName" password="appropriatePassword" />

 

Have fun, if betters ideas let as all know! Thx