Re: tnsping, oracle and the oracle listener process

My goal is to monitor listener response time. It is possible that the listener daemon(on Sun) can become corrupt and this may manifest itself as a sluggish listener(response time > 1000ms). This has actually happened to me and our web site was brought to its knees due to the listener latency.

L

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:8reqr1$lln$1_at_soap.pipex.net...
> Why don't you just try to make the connection and capture the oracle error
> that comes back if the database is down?
> "Louis V. Frolio" <lvflcv_at_rcn.com> wrote in message
> news:8rdu3t$8n5$1_at_bob.news.rcn.net...
> > Yes, independence. I do not want to have to depend on any external
 binaries
> > for this operation. I want my program to be independent of all other
> > applications, it will depend only on itself. Besides, spawning out of
 VB
> > and executing a program and then grabbing/parsing that data is not a
 good
> > practice for many reasons.
> >
> > L
> >
> >
> > "Roman Gelfand" <rgelfand_at_masmid.com> wrote in message
> > news:8rd0ug$74g$1_at_bob.news.rcn.net...
> > > Is there a reason why you can not execute the os command from your
 program
> > > and parse/interpret the response?
> > >
> > >
> > > Louis V. Frolio wrote in message <8r7fvh$18d$1_at_bob.news.rcn.net>...
> > > >Greetings All, I am writing a VB app that interfaces with and Oracle
> > > >database. One of
> > > >the things that I would like to do is to mimic the functionality of
 the
> > > >tnsping utility that comes
> > > >with the Oracle client. So, my question is this. Does anybody know
 of
> > > >where I can get my hands on specs for the protocol used when tnsping
 talks
> > > >to the listener? Is there source code for tnsping anywhere? Does
 anybody
> > > >know what tnsping asks of listener when tnsping is invoked? I was
 thinking
> > > >of using a sniffer program to watch the request made by tnsping and
 the
> > > >response that comes back from the listener. Any and all help would
 be
> > > >greatly appreciated.
> > > >
> > > >Louis
> > > >
> > > >
> > >
> > >
> >
> >

>
> Received on Wed Oct 04 2000 - 03:55:14 CDT