Re: telnet to listener

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'
Or just login using sqlplus. Or use OEM.

You're on what platform/version?

> Rocky
> > On Wed, 31 Mar 2004 16:33:32 GMT, Rocky <PerlGuRu2b_at_bobotheclown.org>
> > wrote:
> >
> >>Anyone know what string I can send to an oracle DB while telnetted into
> >>it's listener to first connect then verify that it is alive?
> >> I would like to keep the string inexepensive as I will be sending it
> >>every couple of minutes. Thank you.
> >>Rocky
> >
> > You get exact the same feature when using tnsping.
> > And there is NO NEED WHATSOEVER to do it evey few minutes.

jg

--
@home.com is bogus.
http://ask.slashdot.org/askslashdot/04/03/31/1420252.shtml?tid=126&tid=156&tid=187