Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: ORA-12541 NO LISTENER PROCESS

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@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 - 10:30:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US