Re: Oracle 7 - TCP-IP-Port

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 10 Jul 2002 19:50:01 +0200
Message-ID: <ilsoiu09pr248sb333voc7m4n0pmm2aqsq@4ax.com>

On Wed, 10 Jul 2002 08:14:11 +0100, "Guenter Weckert" <Guenter.Weckert_at_Schaeff.com> wrote:

>> >what TCP-IP-Port use Oracle 7 to connect the Clients with the Server. I
>> >think about the ports 1521 and 1526. Are there other ports requiered??
>> >I have to create a connection throuh a firewall.
>
>> sqlnet uses port redirection. You'll get back a random port.
>> Using Oracle 7 there are 2 possible solutions
>> - get firewall software with a socalled sqlnet proxy install on it
>> - configure MTS. This will use a fixed port always.
>What ist MTS?? Can you help me?
>guenter.weckert_at_schaeff.com
>
>
>> In Oracle 8 this problem has been solved by use_shared_sockets or
>> connection manager.
>> Sybrand Bakker, Senior Oracle DBA
>

Multithreaded server.
In Oracle 7 it's being configured by setting up

mts_servers
mts_dispatchers
mts_listener_address

It is documented in the sqlnet v2 manual and in the Oracle administrators manual.
The PGA will now be in the shared pool, you do need to increase your shared pool at the same time.
If you really need to I can retrieve mts settings from a system my company is using to track customer related incidents. You need to be quick, as that system is going to start a second life and the app will be migrated to 8i and go to a different server.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jul 10 2002 - 12:50:01 CDT