Search results matching tags 'Oracle' and 'ORA-12154'

Connectivity problem with Oracle Database

sachin0922 — Mon, 05 May 2008 04:00:00 GMT

Hello All,

I am trying to access Oracle database from my ASP.NET application but it is giving me error "System.Data.OracleClient.OracleException: ORA-12154: TNS:could not resolve service name" .

I have given full control to my ASP.NET Machine Account over my Oracle root directory and child directories. I am able to connect database using TOAD but from ASP.NET application it gives above error. I tried to tnsping the alias name of my database and it is getting resolved from proper location(location where my TNSNAMES.ORA and SQLNET.ORA is stored).

Dont know what to do now.

Can anyone help me..!!!

Regards,

Sachin

Re: asp.net to oracle application produces error ORA-12154 :TNS:could not resolve the connect identifier specified

ORA-12154 — Tue, 06 Nov 2007 05:00:00 GMT

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.

Oracle problems for remote users

Loki — Wed, 05 Sep 2007 04:00:00 GMT

My project uses a provider insensitive ado I wrote using System.Data.Common. When I access the website on my local machine, everything runs fine. If a user tries to access the website hosted on my machine, they get an error.

First, it was System.Exception : System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

So, I added System.Data.OracleClient to the references and set copy local to true.

Then, they got this error

System.Data.OracleClient.OracleException : Error while trying to retrieve text for error ORA-12154

Some reserch showed me this may be related to TNS names. Why should it matter what the client has for oracle when the code is on my local (and works when run locally)? Any ideas on how to fix this problem? It doesn't error at all for the Microsoft SQL Server 2005 databases that I am using.