I would create a separate listener for each database and name the listener
accordingly. For e.g. for the orcl database create a listener,
lsnr_orcl_1521 and let your users do ps -ef and grep for the pattern
lsnr_$ORACLE_SID_1521 in their shell script..
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com
"Usual disclaimer apply..Use at your risk"
"Rao, Maheswara"
<Maheswara.Rao@Sung To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
ardp3.com> cc:
Sent by: Subject: RE: How to find a listener
service without running
[EMAIL PROTECTED] lsnrctl servic
02/21/01 08:11 AM
Please respond to
ORACLE-L
Hi Djordje,
Thank you for the suggestion.
Doing grep for a specific service on an output produced by lsnrctl
services,
yes, I could get the answer. However, I am trying to create a shell script
through which the user will find whether a specific listener service is up
or not. The problem is I do not want to give the password of listener.
Also, by greping the output of lsnrctl --- this output could have been
produced some time back but at the time the user is querying the service
might be down.
Please suggest a way to do the above.
Thanks,
Rao
[EMAIL PROTECTED]
-----Original Message-----
Sent: Tuesday, February 20, 2001 6:50 PM
To: Multiple recipients of list ORACLE-L
Why not running it from a script, and grep and awk from output wht you need
to see ?
Djordje
----- Original Message -----
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, February 20, 2001 6:00 PM
> Hi DBAs,
>
> I would like to find out whether a specific listener service is up or not
without running the command ---> lsnrctl services. Is there any way I can
do this through a shell script or unix command?
>
> My environment : Solaris 2.7 : Oracle 8.0.4
>
> Thanks for your help,
>
> Rao
>
> [EMAIL PROTECTED]
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rao, Maheswara
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
