Re: ORA-12541 NO LISTENER PROCESS

From: GQ <dbaguy_ott_at_yahoo.com>
Date: 15 Dec 2004 08:30:50 -0800
Message-ID: <1103128250.595349.34950_at_c13g2000cwb.googlegroups.com>


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) Received on Wed Dec 15 2004 - 17:30:50 CET

Original text of this message