Re: NO LISTENER STATUS

  • From: Dennis Williams <oracledba.williams@xxxxxxxxx>
  • To: lawrence.wolfson@xxxxxxxxxx
  • Date: Fri, 10 Feb 2006 12:47:23 -0600

Larry,

So add another IF statement in your monitoring script to not page you
between 23:45 and 1:15.
Problem solved.

Dennis Williams


On 2/10/06, Wolfson Larry - lwolfs <lawrence.wolfson@xxxxxxxxxx> wrote:
>
>  Anyone experience this?
>
>
>
> We have a little monitoring script we've been running successfully for
> years.
>
> We just installed it  on a server that hadn't been monitored before.
>
>
>
> the script simply does a status command and if the listener isn't up
>
> does a start command.  If the start fails we get paged.
>
> If we have some kind of blackout for maintenace etc. that says don't run
> during that window(s).
>
>
>
> Funny thing is between 23:50 AND 01:00 EVERY NIGHT
>
> we get paged the listener is down
>
>
>
> the status command returns 1 and the lsnrctl start command doe too.
>
>
>
> What's odd is neither shows up in listener log
>
>
>
> Ordinarily if I do a start command and the listener is running I get a
> 12502 in the log
>
>
> 10-FEB-2006 11:22:26 * 12502 TNS-12502: TNS:listener received no
> CONNECT_DATA from client
> 10-FEB-2006 11:23:03 * 12502 TNS-12502: TNS:listener received no
> CONNECT_DATA from client
>
>   but neither the status command or the start show up!
>
>   Then at 1AM everything is fine again.
>
>     A little debugging display below.
>
>     Haven't had hardly any listener issues since 7.3
>
>     TIA
>     Larry
>
>
> Thu Feb  9 22:00:00 CST 2006 LSNR_STATUS=0
> Thu Feb  9 22:10:00 CST 2006 LSNR_STATUS=0
> Thu Feb  9 22:20:00 CST 2006 LSNR_STATUS=0
> Thu Feb  9 22:30:00 CST 2006 LSNR_STATUS=0
> Thu Feb  9 22:40:00 CST 2006 LSNR_STATUS=0
> Thu Feb  9 22:50:00 CST 2006 LSNR_STATUS=0
> Thu Feb  9 23:00:00 CST 2006 LSNR_STATUS=0
> Thu Feb  9 23:10:00 CST 2006 LSNR_STATUS=0
> Thu Feb  9 23:20:00 CST 2006 LSNR_STATUS=0
> Thu Feb  9 23:30:00 CST 2006 LSNR_STATUS=0
> Thu Feb  9 23:40:00 CST 2006 LSNR_STATUS=0
> Thu Feb  9 23:50:00 CST 2006 LSNR_STATUS=0
> Fri Feb 10 00:00:00 CST 2006 LSNR_STATUS=1
> Fri Feb 10 00:10:00 CST 2006 LSNR_STATUS=1
> Fri Feb 10 00:20:00 CST 2006 LSNR_STATUS=1
> Fri Feb 10 00:30:00 CST 2006 LSNR_STATUS=1
> Fri Feb 10 00:40:00 CST 2006 LSNR_STATUS=1
> Fri Feb 10 00:50:00 CST 2006 LSNR_STATUS=1
> Fri Feb 10 01:00:00 CST 2006 LSNR_STATUS=0
> Fri Feb 10 01:10:00 CST 2006 LSNR_STATUS=0
> Fri Feb 10 01:20:00 CST 2006 LSNR_STATUS=0
> Fri Feb 10 01:30:00 CST 2006 LSNR_STATUS=0
> Fri Feb 10 01:40:00 CST 2006 LSNR_STATUS=0
> Fri Feb 10 01:50:00 CST 2006 LSNR_STATUS=0
>
> 09-FEB-2006 23:56:23 * 
> (CONNECT_DATA=(SID=XXX)(CID=(PROGRAM=notify.pl)(HOST=LNW)(USER=root))
> ) * (ADDRESS=(PROTOCOL=ipc)(KEY=XXX)) * establish * XXX * 0
> 09-FEB-2006 23:57:08 * 
> (CONNECT_DATA=(SID=XXX)(CID=(PROGRAM=notify.pl)(HOST=LNW)(USER=root))
> ) * (ADDRESS=(PROTOCOL=ipc)(KEY=XXX)) * establish * XXX * 0
>
> ???????????????????????????
>
> 10-FEB-2006 00:00:07 * 
> (CONNECT_DATA=(SID=XXX)(CID=(PROGRAM=notify.pl)(HOST=LNW)(USER=root))
> ) * (ADDRESS=(PROTOCOL=ipc)(KEY=XXX)) * establish * XXX * 0
> 10-FEB-2006 00:00:35 * service_update * XXX * 0
> 10-FEB-2006 00:00:53 * 
> (CONNECT_DATA=(SID=XXX)(CID=(PROGRAM=notify.pl)(HOST=LNW)(USER=root))
> ) * (ADDRESS=(PROTOCOL=ipc)(KEY=XXX)) * establish * XXX * 0
> 10-FEB-2006 00:01:00 * 
> (CONNECT_DATA=(SID=XXX)(CID=(PROGRAM=notify.pl)(HOST=LNW)(USER=root))
> ) * (ADDRESS=(PROTOCOL=ipc)(KEY=XXX)) * establish * XXX * 0
> 10-FEB-2006 00:01:01 * (CONNECT_DATA=(SID=XXX)(CID=(PROGRAM=?
> @LNW)(HOST=LNW)(USER=root))) * (ADDRESS=(PROTOCOL=ipc)(KEY=XXX)) * establish
> * XXX * 0
> 10-FEB-2006 00:01:02 * service_update * XXX * 0
>
> ***************************************************************************
> The information contained in this communication is confidential, is
> intended only for the use of the recipient named above, and may be legally
> privileged.
>
> If the reader of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or copying of this
> communication is strictly prohibited.
>
> If you have received this communication in error, please resend this
> communication to the sender and delete the original message or any copy
> of it from your computer system.
>
> Thank You.
> ****************************************************************************
>
>

Other related posts: