Re: tnsping, oracle and the oracle listener process

Yeah, thanks for nothing. Smacks of Adolescence, your response smacks of inexperience.
And yes, you can talk to the listener, it is like any other listener process/daemon(telnet, ftp, etc). Further, a packet sniffer will provide you with the question posed to the listener and the response
from the listener. Even further, the listener trace will not give you any meaningful information
outside of "ping", please check and you will see. Still even further, don't lecture me about
cross postings, I do it only because it was an advanced question and I wanted to hit as many
people as I could with the hopes that someone would afford me meaningful insight into this
question, I was wrong. If you can't provide any useful information I would suggest that you do not
dole your unwarranted insults as if you know what the hell you are talking about. Think before you
write my good man, think! It is not that hard!

L

"Yong Huang" <yhuang_at_indigopool.com> wrote in message news:8ran54$s5l$1_at_news.sinet.slb.com...
> 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 Tue Oct 03 2000 - 19:45:14 CDT