469,923 Members | 1,570 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,923 developers. It's quick & easy.

got an error message " ORA -12541 :TNS no Listener" while try to log in to Toad

Hi,
I have a problem while trying to login to toad.
My operating system is WINDOWS XP.
I have Oracle 9i at my system. I installed the Toad into the system.When I start the Toad "Toad Server Login Version 7.5.2.0" pop up opens.
It asks to enter : Database or(user @database)
User/Schema :
Password :
Connection as :,here three options given .They are
NORMAL ,SYSDBA ,SYSOPER.
I inserted the values as for Database : ORA
for User : ORA
for password :ORA
for connection : NORMAL.
and got an error message " ORA -12541 :TNS no Listener".
How can I fix this problem?
waiting for your suggestions.
Nov 20 '06 #1
1 19196
Assuming ORA is a local database on your XP machine. You need to have an entry in listener.ora file SID=ORA. Start the listener using

"lsnrctl start" at the command prompt

If its not your local database then verify if the listener is up using "lsnrctl stat" at the command prompt.
Nov 20 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Patrick Dugan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.