Re: Slow tnsping!

"Fred" <res0jhe3_at_verizon.cm> wrote in message news:76T39.7088$qJ5.3640_at_nwrddc04.gnilink.net...
> Mr.M, Is this the sqlnet.ora on the server or clients?
>
> L
> "Mr. M" <mrm_at_nospamsorry.com> wrote in message
> news:1028648570.16893.0.nnrp-01.c2d92da9_at_news.demon.co.uk...
> > Have a look in the sqlnet.ora file for the following parameter
> >
> > SQLNET.AUTHENTICATION_SERVICES
> >
> > If it's there comment it out
> >
> > #SQLNET.AUTHENTICATION_SERVICES
> >
> > "Fred" <res0jhe3_at_verizon.cm> wrote in message
> > news:WbR39.4181$5T5.1759_at_nwrddc03.gnilink.net...
> > > I need some direction regarding slow database response or actually no
> > > response. On one of our servers we have test and development
> environments.
> > I
> > > get interrmittent/long tnsping rates. However, the OS ping command
works
> > > fine. Could anyone help with some direction here for troubleshooting?
> > > Basically how to begin troubleshooting these tns issues...
> > >
> > >
> > > Thx, Larry
> > >
> > >
> >
> >
>
>

As you ping from the clients, on the clients. I'm not sure it is going to help though. And when are you using tnsping. I for me almost never. Also it only ascertains the presence of a listener, not the presence of a database.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address