Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |