Re: Communication Timeout : Client SQL*Net to Oracle

You might want to check idle_time column in user_resource_limits table for the user account. The idle_time is specified in minutes. You can alter the profile
associated with the user account.(find the profile_name for the user account).

alter profile profile_name limit idle_time <nn>

(where nn is minutes)

Let me know if this helped.

Chinna

Olivia Siow <olivias_at_jtc.gov.sg> wrote in article <340FBC80.C99B89B1_at_jtc.gov.sg>...
> 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
>
>
>
Received on Wed Sep 17 1997 - 00:00:00 CDT