Re: Oracle 8 and MTS: how to set the dispatcher port

From: Holger Marzen <holger_at_marzen.de>
Date: 7 Aug 2003 11:33:04 GMT
Message-ID: <bgtddg$2b6$1@bluebell.marzen.de>

• On Thu, 07 Aug 2003 19:30:17 +1000, quarkman wrote:

> On 7 Aug 2003 08:19:26 GMT, Holger Marzen <holger_at_marzen.de> wrote:
>

>> MTS it was only destination port 1521, but now we had to open port 32830
>> as well. So far, so good. But what happens if I restart Oracle? Will
>> another dispatcher port be randomly choosen? That woul be bad because we
>> would have to change the firewall rules after every restart of Oracle.
>>
>> Would be
>>
>> |mts_listener_address="(ADDRESS=(PROTOCOL=tcp)(port=32830))"
>>
>> the right approach to force the dispatcher port to 32830.
>>

> The default listener listens on TCP/IP at port 1521. If you don't change
> those parameters, then dispatchers already know where to go to register
> themselves with the listener. You only need to set local_listener when you
> have a listener which is using either a different protocol or a different
> listening address. It appears you have neither different, so you don't need
> the local_listener parameter (and you certainly don't need the
> mts_listener_address version of it).

Oracle Doc says:

|To force the exact location of dispatchers, add the PORT as follows: |MTS_DISPATCHERS="(ADDRESS=(PROTOCOL=TCP)(HOST=144.25.16.201)(PORT=5000))" I could get a test instance and yes, it works as described. Received on Thu Aug 07 2003 - 06:33:04 CDT