MTS hangs [message #56588] |
Thu, 10 April 2003 03:03 |
Yan Seiler
Messages: 13 Registered: December 2001
|
Junior Member |
|
|
Hi,
We had to setup MTS on our 8.1.7 instance in order to allow our webserver to connect and receive data through port 1521 and not through a dynamic port number.
The problem is that our server hangs either after 5 minutes or after a few days regardless of high load or not. This causes the server to be rebooted each time.
Here are the settings in the init.ora file:
MTS_DISPATCHERS = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sglchbi006)(PORT=1521)))
(DISPATCHERS = 5)
(LISTENER = lis)
(SESSIONS = 100)
(CONNECTIONS = 100)
(MULTIPLEX = ON)
(POOL = ON)"
MTS_SERVERS = 2
MTS_MAX_SERVERS = 10
And here is the content of the listener.ora file:
# LISTENER.ORA Network Configuration File: E:oracleora81networkadminlistener.ora
# Generated by Oracle configuration tools.
SID_LIST_LIS =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:oracleora81)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = LIS)
(ORACLE_HOME = E:oracleora81)
(PROGRAM = extproc)
)
)
LIS =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sglchbi006)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sglchbi006))
(PORT = 1521))
)
)
)
Is there something wrong in the setup or do you know any product which could be used to make sure that Oracle listens and answers on the same port number ?
Note that we have about 50 users.
Thanks in advance
Yan
|
|
|