Re: sqlnet timeout if no network connectivity

Jun Tirso wrote:

> I'm developing a client that allows users to work offline if the
> database server is down or there is no network connectivity (mobile
> clients). If an attempt to login fails, I bring the client to offline
> mode. Problem is, when the client machine is not connected to the
> network and a sql login is executed (using Pro-c), sqlnet takes a long
> time to detect that there is no network connection. Furthermore, the
> behavior between Pentium 200 and Pentium II 400 machines differ (pentium
> II takes longer) even though the sqlnet.ora of both machines are
> identical.
>
> Does anyone know the configuration parameters of sqlnet that let's
> sqlnet return an error code quickly if there is no network connection.
>
> Thanks.

Jun Tirso

Probably u need to setup the SDU and TDU parameters on ur listener.ora and tnsnames.ora identically.
SDU -- Service layer buffer
TDU -- Transport layer buffer

Thanks
Sai Received on Wed Apr 14 1999 - 10:39:48 CDT