Dropped Connection After 5 Minutes, V8.0.3 
Author Message
 Dropped Connection After 5 Minutes, V8.0.3

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.***.com/
Professional Services: http://www.***.com/
Time Management: http://www.***.com/
Application Server Construction SDK:
http://www.***.com/
Evolving Software: http://www.***.com/
User Interface Builder (Open Source): http://www.***.com/
Sales/Direct: 800-923-TIME/619-755-2868
Solutions, Not Hand Waving



Wed, 20 Jun 2001 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. V8 Query drops last record...?

2. minutes to hours-minutes

3. function minute (number) to hours and minute

4. Converting minutes to minutes:seconds

5. SQL DBNETLIB drops connection on 28800 connections.

6. Connection broken after some minutes

7. job to kill inactive connections - 15 minutes

8. Connection broken after some minutes

9. ? Connection times out after a few minutes in Oracle Tools

10. connection takes several minutes!

11. Is 100 connections per minute a lot ?

12. Catastrophic failure with pooled connections after 10 minutes


 
Powered by phpBB® Forum Software