Re: Entry of "dispatchers" parameter on Oracle 9 - how?

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 16 Apr 2004 10:01:10 +1000
Message-ID: <407f224a$0$4544$afc38c87@news.optusnet.com.au>

Sybrand Bakker wrote:

> On Thu, 15 Apr 2004 13:17:41 +0200, "Ariel" <senseless_at_a.com> wrote:
> 
> 

>>Where I can to set this parameter?
>>When I set on OEM I got ORA-02065 error.
>>
>>Below value which I can set:
>>(address=(protocol=tcp)(host=192.168.1.76)(port=5000))
>>
>>Oracle 9 Standard Edition.
>>
>>Regards.
>>

> 
> 
> An ALTER SYSTEM set dispatchers= should do fine.

But would only be temporary, for the lifetime of the instance, and only provided you explicitly request a scope=memory.

If you try alter system with a scope implying the editing of the spfile, it won't work.

Regards
HJR Received on Thu Apr 15 2004 - 19:01:10 CDT