Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Setting specific port for dispatchers

Re: Setting specific port for dispatchers

From: Jeremiah Wilton <jwilton_at_speakeasy.net>
Date: Tue, 10 Aug 2004 10:54:49 -0700 (PDT)
Message-ID: <Pine.LNX.4.58.0408101052550.15267@shell2.speakeasy.net>


Multiple sets of dispatchers are possible and are distinguished by their INDEX number.

If you want to specify a new set of dispatchers with the specific port, you can use the INDEX= attribute to set up a set of dispatchers other than the set you already have with implicit INDEX=0:

SQL> alter system set dispatchers='(address=(protocol=tcp)(host=foobar)(port=22505))(dispatchers=1)(index=1)'

Then you can shut down the old dispatchers that don't have the specific port number if you want:

SQL> alter system shutdown immediate 'D001'; etc.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Tue, 10 Aug 2004 J.Velikanovs_at_alise.lv wrote:


> it's seems you cant change adress of dispachers on the fly.

> "Mary Bahrami" <mbahrami_at_seattletimes.com> wrote:

> This seems like it should be easy:
>
> 1* alter system set =
> dispatchers=3D'(address=3D(HOST=3Dcary.biz.com)(port=3D3620))'
> SQL> /
> alter system set =
> dispatchers=3D'(address=3D(HOST=3Dcary.biz.com)(port=3D3620))'
> *
> ERROR at line 1:
> ORA-00105: dispatching mechanism not configured for network protocol
> (address=3D(HOST=3Dcary.biz.com)(port=3D3620))
>
> also,
> alter system set =
> dispatchers=3D'(address=3D(protocol=3DTCP)(port=3D36200))(dispatchers=3D1=
> )'
> *
> ERROR at line 1:
> ORA-00105: dispatching mechanism not configured for network protocol
> (address=3D(protocol=3DTCP)(port=3D36200))
>
>
> I've tried various permutations, same message. 9.2.0.4 solaris. =
> Currently have 5 dispatchers running TCP.
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------
Received on Tue Aug 10 2004 - 12:50:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US