OraFAQ Forum: Server Utilities » Toad giving ORA-12154:

Home » RDBMS Server » Server Utilities » Toad giving ORA-12154:

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Toad giving ORA-12154: [message #199817]

Thu, 26 October 2006 06:06

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

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: Toad giving ORA-12154: [message #199825 is a reply to message #199817]

Thu, 26 October 2006 07:01

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.

Report message to a moderator

Re: Toad giving ORA-12154: [message #199858 is a reply to message #199825]

Thu, 26 October 2006 08:15

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

Report message to a moderator

Previous Topic:	How to load substr via sql loader
Next Topic:	"Message 2100 not found" Errors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 23:57:01 CST 2024