Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: tnsping, oracle and the oracle listener process
I don't think you can get the spec for SQL*Net anywhere outside Oracle. All you can do is simply connect to the database using (i.e. on top of) SQL*Net and try a simply select. Actually tnsping doesn't do a real database connection, much less a select inside the database. In addition to using a packet sniffer, you may get more meaningful information by turning on the listener tracing. Set the level to the highest 16 and read the listener log. I don't know much about it so I can't help.
You need to restrict your selection of newsgroups to post to. Posting to too many at a time smacks of adolescence.
Yong Huang
yhuang_at_indigopool.com
Louis V. Frolio <lvflcv_at_rcn.com> wrote in message
news: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 Mon Oct 02 2000 - 14:16:47 CDT