Re: tnsping, oracle and the oracle listener process

One of the potential reasons for listener sluggishness is the listener is maintaining a log file to which it is appending all the time. Most people don't care to just delete the log file occasionally and will end up with a log file of a few hundred megabytes.
I would recommend investigating this issue first, before trying to implement such radical measures.
Talking about radical, you seem usually to post to many, many newsgroups. Could you *please* refrain from that, there's no need for it and you are wasting bandwith.

Regards,

Sybrand Bakker, Oracle DBA

"Louis V. Frolio" <lvflcv_at_rcn.com> wrote in message news:8reraq$e11$1_at_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 - 18:54:31 CEST