Re: telnet to listener

"Joel Garry" <joel-garry_at_home.com> wrote in message news:91884734.0403311734.2c290960_at_posting.google.com...
> Rocky <PerlGuRu2b_at_bobotheclown.org> wrote in message
news:<pan.2004.03.31.18.29.10.636360_at_bobotheclown.org>...
> > On Wed, 31 Mar 2004 18:57:18 +0200, Sybrand Bakker wrote:
> > I am using Whats up gold to monitor my oracle DB's (I am a sysadmin not
a
> > DBA) and the problem with monitoring the listener or port is that
> > sometimes the listener is up, but the DB is down. What's Up Gold has an
> > ascii socket interface that I can send a string through. It emulates
> > telnet, hence the telnet question. Sorry, perhaps I should have
explained
> > that to begin with.
>
> Why not just add a job to the database that creates a file every few
> minutes that says "what the hey, I'm up!" You could even make it an
> html file with pretty colors and watch it with a browser like
> http://demo.bb4.com/bb/ or just check the date on the file. You might
> also consider checking for the uppittyness of the expected Oracle
> processes ps -ef|egrep -i 'ora_|lsn'

And some of those processes are pretty uppity

> Or just login using sqlplus. Or use OEM.

or wait for the phone to go!

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK