Hi All,
I have tried to configure MTS with Connect Pooling and Multiplexing with
8.0.5.2 and 8.1.5 on Sun 4500 Solaris 2.6.
I have made it work on both versions, but I had a Major problem on both
of the versions.
In Addition I have few MTS questions.
First I will introduce the Problem and than my two questions.
- Sqlnet.expire_time:
Sqlnet.expire_time DOES NOT WORK.
All the connection which terminated abnormally, stay for ever.
We have Web Application, and WWW users which connect via web server
that not always close normally the connection.
A simple test of connecting with sql*plus and terminating the session
abnormally made the killed session stay for ever. This test works
with a dedicated server configuration and the connection die with the
dead connection detection
The problem is critical for us because we can have unlimited number
of users, in general, that connect to the DB, and this way Users
Accumulating and exceeding the processes init.ora parameter.
Also, You can not kill any Unix Process because the Unix Processes
are the Shared Servers and Dispatchers.
Did anyone experience this problem ? Any solutions ?
Is it suppose to work like this (I doubt it)?
- MTS Questions:
When You Work with MTS with Connect Pooling and Multiplexing you
need to configure:
- Connection Manager.
- MTS params with plex=yes and pool=yes ,local_listener in the
init.ora.
- Tnsnames.ora (Connection Manager port and Source_Route=yes) and
Sqlnet.ora (Use_Cman=true).
- After You get everything work you can monitor that a connection is
working with MTS dispatchers,
But How do you know, and monitor, that it is actually using the
Connect Pooling and Multiplexing Features ?
- What is the best way to configure Multiple Listeners for Load
Balancing with the MTS and Connect Pooling and Multiplexing
and How can it be Monitored ?
- Can the Connection manager work with multiple Ports itself for
Load Balancing between ports ? I couldn't make it work.
If yes, How everything work together (Multiple Listeners,
Dispatchers...) ?
Thanks,
Eyal Sorek
Oracle DBA
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sun Dec 12 1999 - 08:50:52 CST
