NO LISTENER STATUS

From: Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com>
Date: Fri, 10 Feb 2006 11:43:41 -0600
Message-ID: <B39B7B7D8C8CEA419D0ED45FD7FA4C53FB4255@CWYMSX06.Corp.Acxiom.net>

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.

---

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 10 2006 - 11:43:41 CST