Re: Problem with cluster_database parameter

From: Riyaj Shamsudeen <riyaj.shamsudeen_at_gmail.com>
Date: Mon, 15 Sep 2014 14:30:16 -0700
Message-ID: <CAA2DszwVk9vtsNRbH66RJWYbOuv+bs+cuAyivtDMMFQRu0MGNw_at_mail.gmail.com>


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
Received on Mon Sep 15 2014 - 23:30:16 CEST

Original text of this message