Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*NET Dead Connection Detection Feature
jbelcher_at_csc.com wrote:
>
> Has anyone had problems with the "SQLNET.EXPIRE_TIME" parameter that
> is
> placed within SQLNET.ORA to poll clients for inactivity? We have a
> problem of 1) knowing whether it is working on the server side and
> 2) whether the feature is compatible with sql*net
> 2.0.12.1.0?
>
> We are currently running 2.1.4.1.0 release of sql*net on the server
> and
> trying to use the Dead Connection Detection feature (
> SQLNET.EXPIRE_TIME )
> to detect any client connections that are no longer responding. We
> are
> having problems with one of our clients responding. They are
> currently
> running SQL*NET 2.0.12.1.0 and they are intermittently being
> disconnected
> due to the server process being dropped. We have talked to ORACLE and
> five different people have told us three different stories. If anyone
>
> has experienced something similar and was able to resolve the problem
> please let me know.
I haven't had any luck with that feature before SQL*Net 2.3.? on the server --
it
sort of works with 16-bit Windows SQL*Net 2.0.? clients.
Cheers,
Finn
-- -------------------------------------------------------------------------------- Finn Ellebaek Nielsen Oracle Associated Senior Consultant Ellebaek Consulting E-mail: ellebuk_at_post3.tele.dk Niels Ebbesens Vej 9, 3. th. Mobile Phone: +45 20 32 49 25 DK-1911 Frederiksberg C Mobile Phone SMS: 20324925_at_sms.tdm.dk (Subject) Denmark Private Phone: +45 33 25 34 50 -------------------------------------------------------------------------------- "Life is a beach and then you dive" "Divers do it deeper"Received on Thu Sep 04 1997 - 00:00:00 CDT