FAQ
Greetings,

I can't find it at the moment but there are notes on Metalink taking you step-by-step through the removal of CRS on both Windows and unix.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208
From: oracle-l-bounce_at_freelists.org On Behalf Of Tony Adolph
Sent: Monday, May 18, 2009 3:39 PM
To: Oracle Discussion List
Subject: Remover CRS

Hi Folks,

I've been playing at home attempting to setup a 2 node RAC with 10g R2 on Suse 10.1 (VMware)

I sort of got things going, but I have problems. Lots of things are working as they should be, so I'd like to go back to the simple stand-alone DB: drop the CRS and start again.

Any pointers? I'd rather not just re-create the VM guest (which is a possibility), but go through the steps required to remove CRS, bring up the DB and then start again.

Its just an exercise to get me back into the operations DBA realm (from development DBA (Infranet/BRM))

Regards
Tony

Search Discussions

  • Alex Fatkulin at May 19, 2009 at 12:08 am
    take a look at note 239998.1
    On Mon, May 18, 2009 at 6:39 PM, Tony Adolph wrote:
    Any pointers?
    --
    Alex Fatkulin,
    http://afatkulin.blogspot.com
    http://www.linkedin.com/in/alexfatkulin
    --
    http://www.freelists.org/webpage/oracle-l
  • Bobak, Mark at May 19, 2009 at 4:34 am
    Hi Tony,

    Problem is, even single-instance ASM needs a small sliver of clusterware to run. It's not a full blown CRS like you just deinstalled, it's a small subset of it. It's normally installed and configured when you do an ASM installation on a single node.

    See Doc ID 745271.1 for details on doing a localconfig.

    Hope that helps,

    -Mark

    From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Tony Adolph [tony.adolph.dba_at_gmail.com]
    Sent: Monday, May 18, 2009 22:07
    To: Thomas Roach
    Cc: Oracle Discussion List
    Subject: Re: Remover CRS

    Still not there,......

    I've run the following:

    oracle_at_rac2:/mnt/oracle/10g/database> netca

    Oracle Net Services Configuration:
    rac1...

    Deleted listener: LISTENER_RAC1
    rac2...

    Deleted listener: LISTENER_RAC2
    Oracle Net Services configuration successful. The exit code is 0

    then on both nodes (as root):

    # rootdelete.sh local nosharedvar nosharedhome

    all looked good

    # install/rootdeinstall.sh

    Removing contents from OCR device
    2560+0 records in
    2560+0 records out
    10485760 bytes (10 MB) copied, 0.32744 seconds, 32.0 MB/s

    rebooted both nodes.

    oracle_at_rac1:/u01/app/oracle/oracle/product/10.2.0/db_1/dbs> ps -ef | egrep "crs|css|evm"
    oracle 7486 4707 0 14:03 pts/1 00:00:00 /bin/grep -E crs|css|evm

    oracle_at_rac1:/u01/app/oracle/oracle/product/10.2.0/db_1/dbs> . oraenv
    ORACLE_SID = [+ASM] ?

    oracle_at_rac1:/u01/app/oracle/oracle/product/10.2.0/db_1/dbs> sqlplus / as sysdba

    SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 19 14:03:28 2009

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    Connected to an idle instance.

    14:03:28 idle> startup pfile=init+ASM.ora
    ORA-29701: unable to connect to Cluster Manager

    14:03:44 idle> !cat init+ASM.ora
    +ASM.asm_diskgroups='DG1','DG2','FLASH'#Manual Mount
    *.asm_diskgroups='DG1','DG2','FLASH'
    *.background_dump_dest='/u01/app/oracle/admin/+ASM/bdump'
    *.core_dump_dest='/u01/app/oracle/admin/+ASM/cdump'
    *.instance_type='asm'
    *.large_pool_size=12M
    *.remote_login_passwordfile='SHARED'
    *.user_dump_dest='/u01/app/oracle/admin/+ASM/udump'

    What tells ASM is *still* in a cluster? The ocr has been blown away.

    Regards
    Tony
  • Bobak, Mark at May 19, 2009 at 5:43 am
    Yes, that's correct, if you install ASM on a single node, the installer will detect that no clusterware is running, and it will install ocssd.bin to run from /etc/inittab. The ocssd.bin binary is in the ASM ORACLE_HOME, so, there won't be a clusterware home installed at all. If you install ASM on a cluster, ASM will detect the clusterware (since you're required to install it before ASM), and so won't enable ocssd.bin setup in the ASM ORACLE_HOME.

    Hope that's clear,

    -Mark

    From: Tony Adolph [tony.adolph.dba_at_gmail.com]
    Sent: Tuesday, May 19, 2009 1:17
    To: Bobak, Mark
    Cc: Thomas Roach; Oracle Discussion List
    Subject: Re: Remover CRS

    Hi Mark,

    Thanks for the help.

    localconfig add did the trick, see below (for info).

    So does that mean that before I installed CRS when I had a database running with ASM, I had this sliver of CRS running under the covers?

    What I've done so far is:

    -1- Build simple DB
    -2- create an ASM instance
    -3- migrate the simple DB to ASM
    -4- install CRS and screw things up

    Things went wrong so I decided to remove CRS (services, but not the CRS home) and restart from there. So at step 2 or 3 above, I had some sort of cut down version of CRS running?

    Regards
    Tony

    rac1:/u01/app/oracle/oracle/product/10.2.0/db_1/dbs # localconfig add
    Successfully accumulated necessary OCR keys.
    Creating OCR keys for user 'root', privgrp 'root'..
    Operation successful.
    Configuration for local CSS has been initialized

    Adding to inittab
    Startup will be queued to init within 90 seconds.
    Checking the status of new Oracle init process...
    Expecting the CRS daemons to be up within 600 seconds.
    CSS is active on these nodes.

    rac1
    CSS is active on all nodes.
    Oracle CSS service is installed and running under init(1M)

    rac1:/u01/app/oracle/oracle/product/10.2.0/db_1/dbs # sqlplus / as sysdba

    SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 19 17:07:29 2009

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    Connected to an idle instance.

    17:07:29 idle> startup
    ASM instance started

    Total System Global Area 92274688 bytes

    Fixed Size 1217884 bytes
    Variable Size 65890980 bytes
    ASM Cache 25165824 bytes

    ASM diskgroups mounted
  • William Wagman at May 19, 2009 at 3:27 pm
    Greetings, and I found the Metalink note I was searching for, 239998.1. The same information as contained in the reference Thomas pointed at.

    Thanks.

    Bill Wagman
    Univ. of California at Davis
    IET Campus Data Center
    wjwagman_at_ucdavis.edu
    (530) 754-6208
    From: Thomas Roach
    Sent: Monday, May 18, 2009 4:36 PM
    To: William Wagman
    Cc: tony.adolph.dba_at_gmail.com; Oracle Discussion List
    Subject: Re: Remover CRS

    I found this.

    http://www.dbaexpert.com/blog/?p=110
    On Mon, May 18, 2009 at 7:07 PM, William Wagman > wrote:

    Greetings,

    I can't find it at the moment but there are notes on Metalink taking you step-by-step through the removal of CRS on both Windows and unix.

    Bill Wagman
    Univ. of California at Davis
    IET Campus Data Center
    wjwagman_at_ucdavis.edu
    (530) 754-6208

    From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tony Adolph
    Sent: Monday, May 18, 2009 3:39 PM
    To: Oracle Discussion List
    Subject: Remover CRS

    Hi Folks,

    I've been playing at home attempting to setup a 2 node RAC with 10g R2 on Suse 10.1 (VMware)

    I sort of got things going, but I have problems. Lots of things are working as they should be, so I'd like to go back to the simple stand-alone DB: drop the CRS and start again.

    Any pointers? I'd rather not just re-create the VM guest (which is a possibility), but go through the steps required to remove CRS, bring up the DB and then start again.

    Its just an exercise to get me back into the operations DBA realm (from development DBA (Infranet/BRM))

    Regards
    Tony

    --
    Thomas Roach
    813-404-6066
    troach_at_gmail.com

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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMay 18, '09 at 11:07p
activeMay 19, '09 at 3:27p
posts5
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase