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

[smita81]

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.

[Nandarangu]

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.