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

When I try to connect to a database from my .NET application, I am getting a
"ORA-12154: TNS:could not resolve the connect identifier specified "   error.

I am able to sqlplus login to the database. No errors there. Ping and Tnsping to the server are working fine too..The tnsnames.ora entry is correct also.

How can I fix this problem?

LubomirMasarAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gattu007Commented:
Are you able to connect from sqlplus from the clinet?


The below mentalink note will give all the details regarding this error


Subject:       TROUBLESHOOTING GUIDE: TNS-12154 TNS:could not resolve service name        Doc ID:       Note:114085.1       
0
LubomirMasarAuthor Commented:
yes I am able to connect thru sqlplus! But not thru the web app.
0
LubomirMasarAuthor Commented:
I couldnt access your link..please post again
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

schwertnerCommented:
If this is Oracle 10g seems you have to change LISTENER.ORA file:

For STATIC registration of the Oracle service to the Listener:

Go to the remote 10g installation.
In ...\network\admin open listener.ora

see

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\Ora10g)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
  )

Add the entry
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
with regard to the particular Oracle Home and SID Name.

Restart the listener:
c:>lsnrctl stop
c:>lsnctl start
0
LubomirMasarAuthor Commented:
No schwertner taht did not work..I did make all the changes u suggetsed and restated listener.

In fact listener is working correctly. SqlPlus is able to connect to sid. Tnsping works too. Just the web app is failing.
0
schwertnerCommented:
Then seems you have more then one tnsnames.ora files on your computer
and your web application uses another one
or
your web application do not use tnsnames at all
and has another mechanism to connect the DB.
0
LubomirMasarAuthor Commented:
Solved my problem.

Reinstalled Oracle client. Gave Full access permission to ASPNET user to the Oracle Home directory. Restarted the server. It worked.

Please revoke my points. Question withdrawn.
0
schwertnerCommented:
Ask the Helpdesk for this
0
Computer101Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mservidioCommented:
Hi All - I am having this same exact problem, and have tried all of the above troubleshooting tips with no luck. Does anyone have a definitive list of configurations and such that need to be checked?
0
VenabiliCommented:
mservidio , please ask a new question for your issue. Using someone else's question is kinda against the rules... not to mention that the experts won't see it at all
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.