Re: Problem with cluster_database parameter

But will that reset command remove the entries from spfile?

i thought reset will move the value of parameter to the default!

On Mon, Sep 15, 2014 at 5:30 PM, Riyaj Shamsudeen < riyaj.shamsudeen_at_gmail.com> wrote:

>
> 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='*';
>
> Not sure, if singles quotes will come through fine or not, when you cut
> and paste this commands though.
>
>
>
> 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 Mon, Sep 15, 2014 at 2:14 PM, Saad Khan <saad4u_at_gmail.com> wrote:
>
>>
>> This is 2 node cluster with Oracle database EE 11.1 on AIX 6.1
>>
>> We are facing problem with restoring one of the test environments from
>> production via RMAN.
>>
>> Before refresh, we reset the parameter cluster_database to false for
>> relevant instance with the following command:
>> alter system set cluster_database=false scope=spfile sid='orcl021';
>>
>> However, while trying to restart after refresh, both the instances
>> couldnt start with error on cluster. Only one of them could.
>> Error : CRS:resource not available
>>
>> Now doing a little research I found that there were irrelevant entries
>> for cluster_database parameter.
>>
>>
>> SELECT SID,NAME,VALUE,DISPLAY_VALUE FROM V$SPPARAMETER WHERE
>> NAME='cluster_database'
>> sys_at_orcl021> /
>>
>> SID NAME VALUE DISPL
>> ---------- -------------------- ----- -----
>> orcl051 cluster_database FALSE FALSE
>> ocrl021 cluster_database FALSE FALSE
>> orcl21 cluster_database FALSE FALSE
>> * cluster_database FALSE FALSE
>> orcl022 cluster_database TRUE TRUE
>> orcl021 cluster_database TRUE TRUE
>>
>> 6 rows selected.
>>
>> There should be only orcl021 and orcl022 entries.
>>
>> How can we remove the other irrelevant entries.
>> I know we can use "alter system reset cluster_database=true scope=spfile
>> sid=" command but that wont delete the extra entries I assume.
>>
>> Can you pllease let us know ASAP? Thanks.
>>
>>
>

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