Re: Problem with cluster_database parameter
From: Yong Huang <yong321_at_yahoo.com>
Date: Thu, 18 Sep 2014 11:30:13 -0700
Message-ID: <1411065013.280.YahooMailNeo_at_web184801.mail.gq1.yahoo.com>
That SQL statement will bring up instance orcl1 to non-cluster or exclusive mode. That requires the other instance to be down. If it's up, you would get "ORA-01102: cannot mount database in EXCLUSIVE mode". It's not possible to run one instance in non-cluster and the other in cluster (shared) mode.
From: Saad Khan <saad4u_at_gmail.com>
To: Yong Huang <yong321_at_yahoo.com>
Cc: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Thursday, September 18, 2014 10:15 AM Subject: Re: Problem with cluster_database parameter
Date: Thu, 18 Sep 2014 11:30:13 -0700
Message-ID: <1411065013.280.YahooMailNeo_at_web184801.mail.gq1.yahoo.com>
That SQL statement will bring up instance orcl1 to non-cluster or exclusive mode. That requires the other instance to be down. If it's up, you would get "ORA-01102: cannot mount database in EXCLUSIVE mode". It's not possible to run one instance in non-cluster and the other in cluster (shared) mode.
From: Saad Khan <saad4u_at_gmail.com>
To: Yong Huang <yong321_at_yahoo.com>
Cc: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Thursday, September 18, 2014 10:15 AM Subject: Re: Problem with cluster_database parameter
...
But one more thing. When I refresh the database from prod on node 1, I issue following statement before shutting down the db:
alter system set
cluster_database=false scope=spfile sid='orcl1';
Can this sid= clause in the command be creating problem?
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 18 2014 - 20:30:13 CEST