Setting SQLNET.EXPIRE_TIME in sqlnet.ora to a non-zero value will
enable DCD (Dead Connection Detection). Probe packets will be sent
to the client and if response is not received within expire_time seconds,
connection is considered dead and shadow is killed. But the best way
to deal with such problems is to fix the client software to always close
connection gracefully.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Eric Menzel" <oracle8_at_firemail.de> wrote in message
news:58d6a85c.0206180221.e740ee_at_posting.google.com...
> Hi,
>
> on my Oracle 8.1.7.3 server (Linux) I have the problem that a remote
> client connection never gets killed if the client has dropped the
> connection due to an application crash. I also can't kill the session
> on the server side. When issueing "alter system kill session..." I get
> a "System altered" reply but the session is still in v$session and
> server is set to "pseudo". Do I really have to kill the dedicated
> server process on OS level? And what shall I do with a shared server
> connection? The server has both dedicated and shared server
> connections.
> I don't have any timeout parameters set.
>
> listener.ora:
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = oraserv)(PORT = 1521))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = ICP)(KEY = EXTPROC))
> )
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = (opt/oracle/product/817)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = ORA8I)
> (ORACLE_HOME = (opt/oracle/product/817)
> (SID_NAME = ORA8I)
> )
> )
>
>
> sqlnet.ora:
>
> NAMES.DEFAULT_DOMAIN = puke.com
> NAMES.DIRECTORY_PATH = (TNSNAMES)
>
>
> tnsnames.ora:
>
> ORASRV.PUKE.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = oraserv)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = ORA8I.puke.com)
> (SERVER = DEDICATED)
> )
> )
>
> Some clients have (SERVER = SHARED) in their tnsnames.ora
>
>
> I am looking forward to any comments,
>
> Eric
Received on Tue Jun 18 2002 - 13:41:53 CDT
