Dropped Connection After 5 Minutes, V8.0.3

From: Lane W. Sharman <lane_at_opendoors.com>
Date: Sat, 02 Jan 1999 18:45:06 -0800
Message-ID: <368ED9B2.FE5DBDC2@opendoors.com>

Hi,

Are you aware of why Oracle would drop a connection when using the MTS facility under V8.0.3? Any answer would be greatly appreciated.

-------------Listener.ora--------------- SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = saturn)
(SID_NAME = ORC1)

 (prespawn_max=20)
 (prespawn_list=
  (prespawn_desc=(protocol=tcp) (pool_size=4) (timeout=5))  )

    )
    (SID_DESC =
(SID_NAME = extproc)
(PROGRAM=extproc)

    )
  )

---

-------------Relevant section of initorcl.ora--------------

#
# reuse cursors in shared memory
#

serial_reuse=all

#
# Allows for multiple listeners:
#

mts_multiple_listeners=true

#
# Multiple Dispatchers
#

mts_dispatchers = "(Protocol=TCP) (Dispatchers=4) (Conn=20) (Sessions=40) (Multiplex=ON) (Pool=ON)"

#
# The number of mts servers to start
#

mts_servers = 4

#
# Upper Threshold on the number of mts servers
#

mts_max_servers = 20

#
# The local listener address; allows for a co-location of listener with the server
#
local_listener="(Address_List=(Address=(Protocol=TCP) (Host=localhost) (Port=1521)))"

---

--
Lane Sharman
CTO: http://www.opendoors.com/lane
Professional Services: http://www.opendoors.com/ps Time Management: http://www.opendoors.com/gt Application Server Construction SDK:
http://www.opendoors.com/instant/lcis
Evolving Software: http://www.opendoors.com/instant/mcm User Interface Builder (Open Source): http://www.freebongo.org Sales/Direct: 800-923-TIME/619-755-2868 Solutions, Not Hand Waving Received on Sat Jan 02 1999 - 20:45:06 CST