Re: How to change RAC ASM to non-RAC ASM?
From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 17 Apr 2008 20:10:59 -0700
Message-ID: <1208488258.932076@bubbleator.drizzle.com>
>> On Apr 14, 4:12 pm, Woody Ling <woodyl..._at_gmail.com> wrote:
>>
>>
>>
>>
>>
>>> I try to do it in the following way...
>>> 1. Stop all oracle processes and CRS.
>>> 2. Turn RAC option off:
>>> - Log in as "oracle"
>>> - cd $ORACLE_HOME/rdbms/lib
>>> - make -f ins_rdbms.mk rac_off
>>> - make -f ins_rdbms.mk ioracle
>>> 3. Modify pfile to remove all cluster related options.
>>> 4. Startup the ASM instance with new pfile
>>> But it return "ORA-29701: unable to connect to Cluster Manager" and
>>> ASM failed to start.
>>> It is OK for other database instances use OCFS2 but not ok for ASM so
>>> that all other databases depend on ASM cannot be started. Is it
>>> possible to change RAC ASM to non-RAC ASM?
>>> Thanks.
>>> Woody Ling
>>> Hong Kong
>> Check the status of css if it works normal:crsctl check cssd.Since you
>> stop CRS,you should start CRS first before you start ASM and DB.Just
>> start CRS,then you can start the ASM instance.- Hide quoted text -
>>
>> - Show quoted text -
Date: Thu, 17 Apr 2008 20:10:59 -0700
Message-ID: <1208488258.932076@bubbleator.drizzle.com>
Woody Ling wrote:
> On Apr 14, 4:21 pm, blueprinc..._at_gmail.com wrote:
>> On Apr 14, 4:12 pm, Woody Ling <woodyl..._at_gmail.com> wrote:
>>
>>
>>
>>
>>
>>> I try to do it in the following way...
>>> 1. Stop all oracle processes and CRS.
>>> 2. Turn RAC option off:
>>> - Log in as "oracle"
>>> - cd $ORACLE_HOME/rdbms/lib
>>> - make -f ins_rdbms.mk rac_off
>>> - make -f ins_rdbms.mk ioracle
>>> 3. Modify pfile to remove all cluster related options.
>>> 4. Startup the ASM instance with new pfile
>>> But it return "ORA-29701: unable to connect to Cluster Manager" and
>>> ASM failed to start.
>>> It is OK for other database instances use OCFS2 but not ok for ASM so
>>> that all other databases depend on ASM cannot be started. Is it
>>> possible to change RAC ASM to non-RAC ASM?
>>> Thanks.
>>> Woody Ling
>>> Hong Kong
>> Check the status of css if it works normal:crsctl check cssd.Since you
>> stop CRS,you should start CRS first before you start ASM and DB.Just
>> start CRS,then you can start the ASM instance.- Hide quoted text -
>>
>> - Show quoted text -
> > I am sorry if my description is not clear. > > I want to disable and remove CRS and start ASM instance as non-RAC one.
Reconsider your approach. If you have a RAC cluster and you drop all but one node you have a stand-alone database.
If you are creating a new database then just point it at the ASM instance for its storage.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Apr 17 2008 - 22:10:59 CDT