Re: URGENT - ORACLE SQLNET

Try

sqlnet.expire_time = 1

in both the clients' and the server's sqlnet.ora. This will cause the listener to poll for sessions each minute.

The TIME_WAIT indicates that the listener does not terminate the connection. So hopefully this parameter causes the server to realize that the session is gone and to terminate the sessions.

Martin

Nuno G wrote:
>
> I’m accessing a oracle database using sql*net V2 over tcp/ip installed on a
> HP-UNIX machine from another HP-UNIX machine. The 2 computers are connect to
> the same LAN.
>
> When the client finishes the connection its socket remains in TIME_WAIT
> for about 1 minute (timeout value ?). This happens even if I use sqlplus to
> access the remote database.
>
> # netstat –a
> tcp 0 0 hpdev.1171 oracle.1521 TIME_WAIT
>
> After a a huge number of connections, new connections are refused with
> TNS-12203 error and i can see a lot of sockets in TIME_WAIT status.
>
> I’ve already contacted oracle support and they are telling me that this not
> happens with their machines (Oracle support has the same machines and
> environment). They recommend me to contact HP to.
> I’m in contact with HP support (that fortunately has also a similar oracle
> environment) and they are still studding the problem.
>
> Do you have any idea if this is an oracle installation problem, or a SO
> problem? Do you have any idea how can I decrease the TIME_WAIT timeout
> value?
>
> Thanks a lot for your attention,
>
> Nuno Guedes
> Nuno.guedes_at_interbolsa.pt
>
> The versions I’m using are:
>
> Oracle server:
> Machine: HP D380/2
> SO: HP-UX 10.20
> Oracle Server: 7.3.4.4.1
> Oracle sql*net: 2.3.4.0.0
>
> Oracle client:
> Machine: HP D200
> SO: HP-UX 10.20
> Oracle sql*net: 2.3.4.0.0
> Oracle sqlplus: 3.3.4.0.0
Received on Fri Jun 09 2000 - 00:00:00 CDT