Re: Problem with cluster_database parameter

Thats why this whole behaviour is very strange.

Again, should it be *.cluster_database parameter in the pfile/spfile or should it be orcl1.cluster_database and orcl2.cluster_database?

On Wed, Sep 17, 2014 at 6:27 PM, Riyaj Shamsudeen < riyaj.shamsudeen_at_gmail.com> wrote:

> *.cluster_database=true is the only version of the parameter you would
> need.
>
> If you have reset the parameter and checked the spfile, then restarting
> the database should not bring in the parameters. May be that, you have
> started the database with a different spfile? Verify that you are using
> just one common spfile between the nodes, hopefully, kept in ASM. If you
> are using two different spfiles between the nodes, then you will have to
> repeat the commands in both instances.
>
>
> Cheers
>
> Riyaj Shamsudeen
> Principal DBA,
> Ora!nternals - http://www.orainternals.com - Specialists in Performance,
> RAC and EBS
> Blog: http://orainternals.wordpress.com/
> Oracle ACE Director and OakTable member <http://www.oaktable.com/>
>
> Co-author of the books: Expert Oracle Practices
> <http://tinyurl.com/book-expert-oracle-practices/>, Pro Oracle SQL,
> <http://tinyurl.com/ahpvms8> <http://tinyurl.com/ahpvms8>Expert RAC
> Practices 12c. <http://tinyurl.com/expert-rac-12c> Expert PL/SQL practices
> <http://tinyurl.com/book-expert-plsql-practices>
>
> <http://tinyurl.com/book-expert-plsql-practices>
>
>
> On Wed, Sep 17, 2014 at 2:54 PM, Saad Khan <saad4u_at_gmail.com> wrote:
>
>> So I reset the system today by issueing following:
>>
>> 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