Re: Problem with cluster_database parameter

alter system reset cluster_database scope=spfile sid='orcl051';
alter system reset cluster_database scope=spfile sid='ocrl021';
alter system reset cluster_database scope=spfile sid='orcl21';
alter system reset cluster_database scope=spfile sid='*';

It left the two entries orcl021 and orcl022. But when I restarted the database, it brought back these (prevously reset) entries again.

I then had to recreate the spfile after editing pfile and leaving only following:

*.cluster_database=true

But restarting the database from node 1 via srvctl caused issue with instance 2 (orcl2)

Question: Is the right parameter to be left in spfile be *.cluster_database or it should be orcl1.cluster_database and orcl2.cluster_database??

Thanks.

On Tue, Sep 16, 2014 at 11:03 AM, Radoulov, Dimitre <cichomitiko_at_gmail.com> wrote:

> I mean that removing a parameter from the spfile/pfile and setting it to
> its default value should have the same effect.
>
> Dimitre
>
>
> On 16/09/2014 16:59, Saad Khan wrote:
>
> Please correct me if 'm wrong but the default value is FALSE and that
> could cause problem with the startup of instance just like im facing right
> now. Those incorrect "name" shouldnt be there at all.
>
> On Tue, Sep 16, 2014 at 5:06 AM, Radoulov, Dimitre <cichomitiko_at_gmail.com>
> wrote:
>
>>
>> [...]
>>> But will that reset command remove the entries from spfile?
>>>
>>> i thought reset will move the value of parameter to the default!
>>>
>>>
>> What's the difference?
>>
>>
>> Dimitre
>>
>
>
>

--
http://www.freelists.org/webpage/oracle-l