By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,983 Members | 1,468 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,983 IT Pros & Developers. It's quick & easy.

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

P: 3
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
Share this Question
Share on Google+
1 Reply


P: 2
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.