Re: About ORA-12541 and ORA-12514 errors

From: Warnke Wittrock <warnke.wittrock_at_dbitc.de>
Date: 18 Sep 2001 06:35:26 -0700
Message-ID: <c808c670.0109180535.61914dc4_at_posting.google.com>


[Quoted] Hi Paul,

that's what the manual says about TNS-12541:

TNS:no listener
Cause: The connection request could not be completed because the listener is not running.
Action: Ensure that the supplied destination address matches one of the addresses used by the listener. Compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to go by way of an Interchange). Start the listener on the remote machine.

You can check the listener status by "lsnrctl status" on the server. You can start it by "lsnrctl start".
Check if the NT service Oracle<Oracle_Home>TNSListener is started. I don't think it's a question of the port number, use the default.

HTH Warnke Received on Tue Sep 18 2001 - 15:35:26 CEST

Original text of this message