RE: lsnrctl question

From: Kevin Lange <kgel_at_ppoone.com>
Date: Thu, 31 May 2001 10:18:32 -0700
Message-ID: <F001.003160BC.20010531095100@fatcity.com>

On unix you can look for the process running the listener. In our shop this is done by :

$ ps -ef | grep tnslsnr
oracle 413 1 0 May 18 ? 2:36 /u03/home/oracle/product/8.0.5/bin/tnslsnr listener.1526 -inherit oracle 447 1 0 May 18 ? 0:08 /u03/home/oracle/product/8.0.5/bin/tnslsnr listener.1514 -inherit oracle 455 1 0 May 18 ? 0:00 /u03/home/oracle/product/8.0.5/bin/tnslsnr external_procedure_listener
-inherit

oracle 13084 12853 0 11:45:32 pts/14 0:00 grep tnslsnr $

Note that each process has the listener name as a parameter. In this case the external procedure listener is simply "external_procedure_listener"

You can then use this in the lsnrctl status external_procedure_listener command.

Or, you can always look in your listener.ora file for the name of it.

Kevin
-----Original Message-----

Sent: Thursday, May 31, 2001 10:46 AM
To: Multiple recipients of list ORACLE-L

If I want to know the status of the external procedure listener for the current SID, but do not know what the external procedure listener's name is, how can I use lsnrctl to find out it's status.

John

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: John Dunn
INET: john.dunn_at_sefas.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Lange
INET: kgel_at_ppoone.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message