Re: Communication Timeout : Client SQL*Net to Oracle

Olivia Siow <olivias_at_jtc.gov.sg> wrote:

>Hello,
 

>My company is using Oracle7 (Release 7.1.5.2.4) on a VAX machine.
>The Windows95 Client PC communicates with it via SQL*Net (V2.1.4.1.4C),
>TCPIP & Pathworks5. The problem is, we kept getting kicked out of Oracle
>at the client end, the communication channel just drops if there's no
>activity for one minute. However, no such problem occurs if I login to
>the VAX Oracle server directly, using VT32 terminal emulator or
>Reflection.
 

>Could anyone help ? Thanks in advance.
 

>olivias_at_jtc.gov.sg

Olivia,

When you connect to the VAX server directly, are you using a SQL*Net connect string (ie. sqlplus username/passwrd_at_servicename) or are you really going directly to the database (ie. sqlplus username/password)?

If you are bypassing SQL*Net when when you log into the VAX Oracle server directly then the problem is probably having the connect_timeout_<listener name> parameter set too low in the server side listener.ora file. Try setting that parameter to 0 (unlimited), stop/start the listener process and see if that fixes the problem.

Good luck,
Mary

Mary Travis
BellSouth Telecommunications
email: Mary.B.Travis_at_bridge.bellsouth.com Received on Mon Sep 08 1997 - 00:00:00 CDT