ORA-12541 NO LISTENER PROCESS

[Guest]

Hello all,

I did install toad version 6.3.11.1 on my cpmputer.But the toad cannot
make connection to the database, the message error appears ORA-12541 NO
LISTENER PROCESS . i have oracle 8i on my pc.

Even if i want to log in with sql plus i get the same error ORA-12541
NO LISTENER PROCESS .

Does you know what might be the reason en how i can solve it ? i
appreciate your help.

thank you

[Daniel Morgan]

zana_f@hotmail.com wrote:
Hello all, I did install toad version 6.3.11.1 on my cpmputer.But the toad cannot make connection to the database, the message error appears ORA-12541 NO LISTENER PROCESS . i have oracle 8i on my pc. Even if i want to log in with sql plus i get the same error ORA-12541 NO LISTENER PROCESS . Does you know what might be the reason en how i can solve it ? i appreciate your help. thank you

Is the database on the same machine or a remote machine?
What is the value of ORACLE_HOME?
What is the value of ORACLE_SID?
What is the operating system?
What release of Oracle 8i? (8.1.5, 8.1.6, 8.1.7.4)?
Have you used Listener Control to check the listener status?
lsnrctl status
Is the listener service running in the control panel services?
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[Frank van Bortel]

zana_f@hotmail.com wrote: Hello all, I did install toad version 6.3.11.1 on my cpmputer.But the toad cannot make connection to the database, the message error appears ORA-12541 NO LISTENER PROCESS . i have oracle 8i on my pc.

V6.3?!? Does it support 8i? The current major version is 7 (I have 7.6).
Even if i want to log in with sql plus i get the same error ORA-12541 NO LISTENER PROCESS .

Open a command prompt (assuming Microsoft), or a shell, and type
lsnrctl status
Post the result (or try: lsnrctl start).

--
Regards,
Frank van Bortel

[GQ]

Presuming the database is in a Windows environment,
you should also check the state of your "Oracle...Listener..." SERVICE
(make sure it is Started).
I've notice that the "lsnrctl status" can occasionally be different
from the windows service status.

The other thing you could check is to make sure Toad is hitting the
right server/port/SID.
To do this, do a "tnsping <name used to connect in Toad>" (eg tnsping
mydb.world)