Home » RDBMS Server » Server Utilities » Toad giving ORA-12154:
Toad giving ORA-12154: [message #199817] Thu, 26 October 2006 06:06 Go to next message
ajayanikar
Messages: 4
Registered: October 2006
Location: India
Junior Member

Hi All,

Briefing about the situation:
When we are trying to connect FROM TOAD to a Database instance (A1) with valid Username/Password we are getting
" ORA-12154: TNS:could not resolve service name ". But we are able to connect to the same instance (A1) via the sqlplusw.exe.

We checked the tnsnames.ora, but could not find much what is causing this error?

Can someone guide us where is the error coming ?

[Updated on: Thu, 26 October 2006 06:11]

Report message to a moderator

Re: Toad giving ORA-12154: [message #199819 is a reply to message #199817] Thu, 26 October 2006 06:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I am myself not a TOAD user.
May be TOAD is using a different Tnsnames.ora ( as many oracle clients do).
Check the connection entries.
Re: Toad giving ORA-12154: [message #199825 is a reply to message #199817] Thu, 26 October 2006 07:01 Go to previous messageGo to next message
ajayanikar
Messages: 4
Registered: October 2006
Location: India
Junior Member

thanks for the reply,

we tried changing the tnsnames.ora with another one to check whether TOAD is referring a different tnsnames, but it is referring the correct one.

The question here is when we connect via sql plus it goes through but why not with TOAD?

and also do anyone exactly know how to find which tnsnames is TOAD referring?

And by the way forgot to mention when we did TNSPing to this instance it went through successfully.
Re: Toad giving ORA-12154: [message #199858 is a reply to message #199825] Thu, 26 October 2006 08:15 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

TOAD is defintly using the same tnsnames(if you are using the tnsnames editor from TOAD you will see that)

Have you tried the quest support, the are very quick in reply
Previous Topic: How to load substr via sql loader
Next Topic: "Message 2100 not found" Errors
Goto Forum:
  


Current Time: Thu Dec 08 01:55:02 CST 2016

Total time taken to generate the page: 0.08180 seconds