Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: tnsping, oracle and the oracle listener process

Re: tnsping, oracle and the oracle listener process

From: Louis V. Frolio <lvflcv_at_rcn.com>
Date: Wed, 4 Oct 2000 04:55:14 -0400
Message-ID: <8reraq$e11$1@bob.news.rcn.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US