Sql*Net problem and time out with dial-on-demand

Hello everyone,

I have a problem with sql*net when I access a remote server with dial-on-demand network setup. The whole idea is that the network setup allows a client to connect to a remote server via the MODEM and dial-on-demand. When sqlplus is started to connect, IP packets travel to the router and it calls the remote modem to connect using PPP.

In theory there should be no problem, there will be a delay waiting for the call to complete and PPP to establish. However after sometime waiting sql*net is stuffed at the level of verifying the TNS connection. The network connection is established but sql*net hang there forever then timeout with an error message. While this sqlplus command hang, one can start another one to connect and this is OK because the virtual connection is now online, so there is no delay for this process.

This is a typical problems with many routers and break even telnet and ftp services. What I am searching for is a way to configure sql*net to be more flexible with time out. For example it I can tell sql*net to start the connection, then sleep for 30 seconds before checking again then connect. If I can do this it should work.

It is very important when one access dblink. Sql*net will fail the first time and there is no way one can hack in with a script that started the network before accessing the remote server. I have read the documentation for sql*net and ther e does not seem to show any relevant timeout settings for the purpose.

Please suggest if you can.

Regards,

Dao Mai Received on Thu Aug 13 1998 - 19:29:47 CDT