Connection leak at Oracle server end

[rajeshm9]

Connection leaks are happening at oracle server end whenever there are timeout happens.
We have configured following parameters at sqlnet.ora for send/recv/connect timeout which is working fine.

SQLNET.SEND_TIMEOUT = 60
SQLNET.RECV_TIMEOUT = 60
TCP.CONNECT_TIMEOUT = 60
SQLNET.INBOUND_CONNECT_TIMEOUT = 60

Our code snippet:

if(!OCI_ExecuteStmt(st,query))
{
err = OCI_GetLastError();
debugLogging(ERRLOG,DEBUG_LEVEL,"SE,%s,%s",OCI_ErrorGetString(err),stCallCDR.msgId);
OCI_StatementFree(st);
OCI_ConnectionFree(cn);

                            continue;
                    }

Application Error Logging:

09-08-2016 15:05:04:077,SE,ORA-12609: TNS: Receive timeout occurred,147073525815394422530

Connection at our end:

    4 active connection (ESTABLISED state)

Connection at server end:

192  connection from our node.

Issue & Resolutions:

    No further insertion or operations are happening on server. Need to kill the server end connections.

[vrogier]

Does not seem to be an OCILIB issue but rather OCI / Network issues (error ORA-12609).