Home » RDBMS Server » Networking and Gateways » TOAD:TNS listner not found error. (Toad 8.5 and oracle 10g on vista)
icon14.gif  TOAD:TNS listner not found error. [message #362137] Mon, 01 December 2008 03:17 Go to next message
chaks123
Messages: 2
Registered: December 2008
Location: India
Junior Member

Hi all,

I have installed oracle 10g personal edition on Windows vista basic OS and Toad 8.5.

I am able to access sqlplus using scott/tiger credentials.

I wanted to connect toad to my oracle database but i am getting the error ORA-12541:TNS no listner when i am trying to connect.

Please let me know what needs to be done to connect toad to oracle.

Please note i while installing oracle i created an DB ORCL.

//Chakshu.
Re: TOAD:TNS listner not found error. [message #362151 is a reply to message #362137] Mon, 01 December 2008 03:44 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Have you started the listener?

$ oerr ora 12541
12541, 00000, "TNS:no listener"
// *Cause: The connection request could not be completed because the listener
// is not running.
// *Action: Ensure that the supplied destination address matches one of
// the addresses used by the listener - compare the TNSNAMES.ORA entry with
// the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to
// go by way of an Interchange). Start the listener on the remote machine.
Re: TOAD:TNS listner not found error. [message #362390 is a reply to message #362151] Tue, 02 December 2008 02:39 Go to previous messageGo to next message
chaks123
Messages: 2
Registered: December 2008
Location: India
Junior Member

Quote:



Thanks....a lot..... i tried..the same...but it doest not work..
The entries in TNS.ora and listner.ora are same..

Both toad and oracle 10g are installed in same laptop .. n m able to access through sqlplus.

Please suggest something... Smile
Re: TOAD:TNS listner not found error. [message #362391 is a reply to message #362390] Tue, 02 December 2008 02:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
The entries in TNS.ora and listner.ora are same..

These files are not used by Oracle. Better use the correct ones.

Regards
Michel
Re: TOAD:TNS listner not found error. [message #429481 is a reply to message #362137] Wed, 04 November 2009 02:20 Go to previous messageGo to next message
wedjy
Messages: 1
Registered: November 2009
Location: Germany
Junior Member
I'm not Oracle savy myself but while researching the issues I'm havin it became apparent to me that when dealing with TNS its important to ensure you are using the correct port.

Hope this helps.
Re: TOAD:TNS listner not found error. [message #429856 is a reply to message #362390] Fri, 06 November 2009 00:21 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
Thanks....a lot..... i tried..the same...but it doest not work..


What you tried.... post here.

Sriram.

[Updated on: Fri, 06 November 2009 00:24]

Report message to a moderator

Re: TOAD:TNS listner not found error. [message #429863 is a reply to message #429856] Fri, 06 November 2009 00:50 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, whatever he did, he did that a year ago (note dates of previous messages) so - it is now a questionable discussion.
Re: TOAD:TNS listner not found error. [message #429875 is a reply to message #429863] Fri, 06 November 2009 01:22 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Littlefoot wrote on Fri, 06 November 2009 00:50
Well, whatever he did, he did that a year ago (note dates of previous messages) so - it is now a questionable discussion.



Ohh.. I am sorry...
I just seen the date of "wedjy"..Not the main post.

Sriram.
Previous Topic: ORA-12505, TNS:listener does not currently know of SID given
Next Topic: TNS Names
Goto Forum:
  


Current Time: Fri Mar 29 04:28:43 CDT 2024