Home » RDBMS Server » Networking and Gateways » ora-12154 TNS could not able to resolve sevice name
ora-12154 TNS could not able to resolve sevice name [message #200397] Mon, 30 October 2006 13:51 Go to next message
SRIVASUWIN
Messages: 45
Registered: October 2006
Location: TRICHY
Member

hello sir,

i got this error ora-12154 TNS could not able to resolve sevice name in the application.the actual problem is its shows an error in one session at the time we copy the codings and run in the another session with that same machine its work fine and also all user where connected properly.i dont know why this error occur in that particular session(coding in c#.net backend oracle)

thank you sir..waiting for your reply
Re: ora-12154 TNS could not able to resolve sevice name [message #200398 is a reply to message #200397] Mon, 30 October 2006 13:53 Go to previous messageGo to next message
SRIVASUWIN
Messages: 45
Registered: October 2006
Location: TRICHY
Member
SRIVASUWIN wrote on Mon, 30 October 2006 13:51

hello sir,

i got this error ora-12154 TNS could not able to resolve sevice name in the application.the actual problem is its shows an error in one session at the time we copy the codings and run in the another session with that same machine its work fine and also all user where connected properly.i dont know why this error occur in that particular session(coding in c#.net backend oracle)

thank you sir..waiting for your reply

Re: ora-12154 TNS could not able to resolve sevice name [message #200404 is a reply to message #200398] Mon, 30 October 2006 15:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Problem with your tnsentries/listener.ora entries.
Please search the forum. This question is asked too frequently.
Re: ora-12154 TNS could not able to resolve sevice name [message #200433 is a reply to message #200404] Mon, 30 October 2006 22:20 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

As per mention "Mahesh" search on forms or
check tnsnames.ora file service clause is right specified with ur Oracle_sid = name is not then correct and try to connect again.

Re: ora-12154 TNS could not able to resolve sevice name [message #201136 is a reply to message #200404] Thu, 02 November 2006 14:37 Go to previous message
richmondlake
Messages: 4
Registered: May 2006
Location: MIDWEST
Junior Member

All the more it should be made easier

I cannot for the life of me think why a tool would be so hard to set up.

TNS Names this, Listener that, SID This, Instance name that, gosh....what about a plain ole connection string or something straight forward.



My 2 cents.

P.S. I am off my box.
Previous Topic: Connecting 9i database with JDBC Type 2 driver
Next Topic: TNS Names Worked a second ago now errors
Goto Forum:
  


Current Time: Thu Dec 08 12:51:25 CST 2016

Total time taken to generate the page: 0.06357 seconds