How to prevent automatic disconnection?(n18)

We are making a system composed of
 - Oracle RDBMS (ver 7.3.2) and server with Unix SCO
 - Clients running on windows NT Workstation 4.0
The different machines are linked together with TCP.IP
protocol and SQL*Net Ver 2.0. Dialog between clients and
server uses OCI commands. We have this problem :

If the client connected to the server doesn't work
(no SQL request sent) for about 2 hours, the link with the
data base is broken and so the client doesn't received information
sent
by the server anymore.
How is it possible to prevent automatic disconnection ?


Ans1:

If I understood correctly, you should do this --

Check the view dba_users to see which profile is assigned to that user,
then
select idle_time from dba_profiles where profile=bla-bla

I guess this query will return 120, which means that after 120 minutes
of idle time this user will be disconnected. You should alter this
profile to allow users keep longer connections.

Juhan


Ans2:

Or modify the SQLNET.EXPIRE_TIME value in the sqlnet.ora of each client.
 
 
 

Hosted by www.Geocities.ws

1