Yechiel - This is an inexperienced reply, but since I will be facing your situation soon, I thought I would share my ideas also. 1. Most application servers can do connection pooling, so why use MTS as a second layer on top of connection pooling? 2. I believe Oracle uses a range of ports, so the firewall needs to have those open. I did some quick searches on Metalink and Google and saw a wealth of information, but couldn't easily summarize what I found. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED]
-----Original Message----- Sent: Tuesday, November 19, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Hello all First a little background. We work with oracle 8.1.6.3.4 on NT or win2000 servers. The technical people have just move an application server behind a firewall. The application servers access a database that is a central repository of user connections (i.e. all applications on the intranet access this database for each page for each user). They saw that the application works fine for a while and then they get access denied. They track it down to the port numbers in the firewall. We are working with dedicated connections and it seems that the port numbers for each connections are climbing up until they exceeded the range of open ports in the firewall. They said that they had the same problems in another server, they brought an outside guy (of course without telling the DBA group) and he solved the problem. They brought me the init.ora file of that database (I can not access it via the firewall) and showed me the parameters that made the difference. The guy put in: mts_dispatchers= ... port=8000) (5 dispatchers). Since they want me to do it on a central and essential database I want to ask you guys: 1) Any gotcha moving from dedicated connections to MTS? 2) Is each dispatcher assigned for the current sql command and then released or is it assigned for the duration of the session? 3) What is the ratio of users per dispatcher? 4) Is there a way to tell oracle to reuse port numbers for dedicated connections that were closed? 5) Anything else you care to share. Sorry if my questions are somewhat trivial but we need a decision tomorrow morning (in 18 hours) as they start doing some training session on the system on Sunday and time is short. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
