This discussion is archived
13 Replies Latest reply: Mar 8, 2013 4:17 PM by EdStevens RSS

problem with srvctl stop home

EdStevens Guru
Currently Being Moderated
Oracle GI 11.2.0.2
Oracle db 11.2.0.1.1
- three databases, 2 on ASM, and one not.
Oracle Linux 5.6
Standalone ASM -- no clusters

Built this system as a sandbox under VirtualBox to begin work on upgrading my live databases to 11.2.0.2. Before proceeding I need to relocate my ORACLE_BASE (actually I'll take all of /u01) to a larger newly created file system. I'm looking at the DB Admin Guide, chapter 4, under "Stopping and Restarting Oracle Restart for Maintenance Operations".

First I set ORACLE_HOME for the databases and ran 'srvctl stop home -o $ORACLE_HOME -s $ORACLE_HOME/crs_state'. Ran as expected, no errors and the databases were stopped.
Next I set ORACLE_HOME for ASM and ran the same command 'srvctl stop home -o $ORACLE_HOME -s $ORACLE_HOME/crs_state', but with problems:
oracle:+ASM$ cd $ORACLE_HOME

oracle:+ASM$ srvctl stop home -o $ORACLE_HOME -s $ORACLE_HOME/crs_state
PRCH-1002 : Failed  to stop resources running from CRS home /u01/app/oracle/11.2.0/grid
PRCH-1030 : One or more resources failed to stop: PRCH-1026 : Failed to stop ASM
PRCD-1027 : Failed to retrieve database vbdwdev
PRCD-1035 : Database vbdwdev is not a cluster database


oracle:+ASM$ srvctl start home -o $ORACLE_HOME -s $ORACLE_HOME/crs_state

oracle:+ASM$
Hmm. Database vbdwdev is not a cluster database. No it isn't. What's the issue there? And what is it trying to do with the database anyway? That was supposed to be dealt with when running 'srvctl stop' from the database, which was already done.

Google and MetaLink searches on the error messages keep coming back to cluster related issues, often during upgrades, and this situation is neither.

Ideas?
  • 1. Re: problem with srvctl stop home
    r chandran Newbie
    Currently Being Moderated
    Hello,

    Please use following, it should give you a hint where the error is coming from:

    export SRVM_TRACE=1
    srvctl start home ....... <complete command>

    This should give you detailed tracing. You should be able to see where the error is coming from.

    Cheers,
    Rijesh
  • 2. Re: problem with srvctl stop home
    EdStevens Guru
    Currently Being Moderated
    Rijesh wrote:
    Hello,

    Please use following, it should give you a hint where the error is coming from:

    export SRVM_TRACE=1
    srvctl start home ....... <complete command>

    This should give you detailed tracing. You should be able to see where the error is coming from.

    Cheers,
    Rijesh
    Ok. getting back to it this evening. spent the day recovering from an SA error.

    Here's what I got, with some comments embedded.
    oracle:11g$ export SRVM_TRACE=1
    At this point, OHOME is set for the db instances.
    oracle:11g$ srvctl stop home -o $ORACLE_HOME -s $ORACLE_BAESE/rdbms_stat
    [main] [ 2013-03-04 19:07:31.601 CST ] [OPSCTLDriver.setInternalDebugLevel:171]  tracing is true at level 2 to file null
    [main] [ 2013-03-04 19:07:31.612 CST ] [OPSCTLDriver.main:115]  SRVCTL arguments : args[0]=stop args[1]=home args[2]=-o args[3]=/u01/app/oracle/product/11.2.0/dwdev args[4]=-s args[5]=/u01/app/oracle/rdbms_stat 
    [main] [ 2013-03-04 19:07:31.747 CST ] [Version.isPre:304]  version to be checked 11.2.0.1.0 major version to check against10
    [main] [ 2013-03-04 19:07:31.748 CST ] [Version.isPre:315]  isPre.java: Returning FALSE
    [main] [ 2013-03-04 19:07:31.749 CST ] [OCR.loadLibrary:308]  
    <snip remainder of this operation, as everything went as expected>
    Now change home to ASM/grid and do it again. I am including the full output, but reading every line nothing raised my eyebrows until my next embedded comment.


    Also, be aware that 'vbdwdev' is the name of both the server AND one of the database instances. I wouldn't do it that way, but that's how things fell out with the naming standard I use for my sandboxes. I don't think it should be an issue, but in the interest of 'full disclosure' ....
    oracle:11g$ . oraenv
    ORACLE_SID = [11g] ? +ASM
    The Oracle base remains unchanged with value /u01/app/oracle
    
    
    oracle:+ASM$ srvctl stop home -o $ORACLE_HOME -s $ORACLE_BASE/asm_stat
    [main] [ 2013-03-04 19:08:26.404 CST ] [OPSCTLDriver.setInternalDebugLevel:198]  tracing is true at level 2 to file null
    [main] [ 2013-03-04 19:08:26.429 CST ] [OPSCTLDriver.main:141]  SRVCTL arguments : args[0]=stop args[1]=home args[2]=-o args[3]=/u01/app/oracle/11.2.0/grid args[4]=-s args[5]=/u01/app/oracle/asm_stat 
    [main] [ 2013-03-04 19:08:26.469 CST ] [Version.isPre:465]  version to be checked 11.2.0.2.0 major version to check against10
    [main] [ 2013-03-04 19:08:26.469 CST ] [Version.isPre:476]  isPre.java: Returning FALSE
    [main] [ 2013-03-04 19:08:26.471 CST ] [OCR.loadLibrary:311]  
     Inside constructor of OCR
    [main] [ 2013-03-04 19:08:26.486 CST ] [OCR.loadLibrary:319]  Going to load the ocr library
    [main] [ 2013-03-04 19:08:26.487 CST ] [Library.load:188]  library.load
    [main] [ 2013-03-04 19:08:26.494 CST ] [sPlatform.isHybrid:66]  osName=Linux osArch=amd64 JVM=64 rc=false
    [main] [ 2013-03-04 19:08:26.495 CST ] [sPlatform.isHybrid:66]  osName=Linux osArch=amd64 JVM=64 rc=false
    [main] [ 2013-03-04 19:08:26.495 CST ] [Library.load:264]  Loading  library /u01/app/oracle/11.2.0/grid/lib/libsrvmocr11.so
    [main] [ 2013-03-04 19:08:26.512 CST ] [OCR.loadLibrary:321]  loaded ocr libraries
    [main] [ 2013-03-04 19:08:26.512 CST ] [OCR.isCluster:959]  Calling OCRNative for isCluster()
    [main] [ 2013-03-04 19:08:26.514 CST ] [nativesystem.OCRNative.Native]  JNI: isCluster() Successfully initialized meta context
    [main] [ 2013-03-04 19:08:26.514 CST ] [nativesystem.OCRNative.Native]  JNI: procr_get_conf() retValue = 0
    [main] [ 2013-03-04 19:08:26.515 CST ] [nativesystem.OCRNative.Native]  The OCR file is configured & local_only=true
    
    [main] [ 2013-03-04 19:08:26.515 CST ] [OCR.isCluster:963]  OCR Result status = true
    [main] [ 2013-03-04 19:08:26.516 CST ] [OCR.isCluster:975]  Bolean result = false
    [main] [ 2013-03-04 19:08:26.516 CST ] [CommandLineParser.<init>:397]  Is this a cluster? : false
    [main] [ 2013-03-04 19:08:26.517 CST ] [CommandLineParser.parse:409]  parsing cmdline args
    [main] [ 2013-03-04 19:08:26.517 CST ] [CommandLineParser.parse2WordCommandOptions:2466]  parsing 2-word cmdline, args count = 6
    [main] [ 2013-03-04 19:08:26.518 CST ] [CommandLineParser.parse2WordCommandOptions:2474]  Checking single valued options
    [main] [ 2013-03-04 19:08:26.518 CST ] [CommandLineParser.parse2WordCommandOptions:2479]  argInx = 2, option =-o
    [main] [ 2013-03-04 19:08:26.519 CST ] [CommandLineParser.parse2WordCommandOptions:2481]  Option string: -o
    [main] [ 2013-03-04 19:08:26.519 CST ] [CommandLineParser.parse2WordCommandOptions:2479]  argInx = 4, option =-s
    [main] [ 2013-03-04 19:08:26.521 CST ] [CommandLineParser.parse2WordCommandOptions:2481]  Option string: -s
    [main] [ 2013-03-04 19:08:26.522 CST ] [CommandLineParser.parse2WordCommandOptions:2568]  Checking mandatory options
    [main] [ 2013-03-04 19:08:26.522 CST ] [CommandLineParser.parse2WordCommandOptions:2581]  brace_begin_index: -1 vertical_bar_index: -1 brace_end_index: -1
    [main] [ 2013-03-04 19:08:26.523 CST ] [CommandLineParser.checkIntegersAndSpecificValues:3497]  check specificMultiValues
    [main] [ 2013-03-04 19:08:26.524 CST ] [CommandLineParser.validateSingleValueOption:3594]  Validating single-value option: n , value = null
    [main] [ 2013-03-04 19:08:26.525 CST ] [CommandLineParser.validateSingleValueOption:3594]  Validating single-value option: o , value = /u01/app/oracle/11.2.0/grid
    [main] [ 2013-03-04 19:08:26.525 CST ] [CommandLineParser.validateSingleValueOption:3594]  Validating single-value option: s , value = /u01/app/oracle/asm_stat
    [main] [ 2013-03-04 19:08:26.526 CST ] [OPSCTLDriver.execute:207]  executing srvctl command
    [main] [ 2013-03-04 19:08:26.536 CST ] [OPSCTLDriver.execute:216]  checking for -H option: print verbose command syntax
    [main] [ 2013-03-04 19:08:26.536 CST ] [OPSCTLDriver.execute:262]  executing 2-word command verb=4 noun=113
    [main] [ 2013-03-04 19:08:26.548 CST ] [StopAction.internalExecuteHome:1277]  execute stop Home
    [main] [ 2013-03-04 19:08:26.562 CST ] [Version.isPre:465]  version to be checked 11.2.0.2.0 major version to check against10
    [main] [ 2013-03-04 19:08:26.563 CST ] [Version.isPre:476]  isPre.java: Returning FALSE
    [main] [ 2013-03-04 19:08:26.564 CST ] [OCR.loadLibrary:311]  
     Inside constructor of OCR
    [main] [ 2013-03-04 19:08:26.564 CST ] [OCR.isCluster:959]  Calling OCRNative for isCluster()
    [main] [ 2013-03-04 19:08:26.565 CST ] [nativesystem.OCRNative.Native]  JNI: isCluster() Successfully initialized meta context
    [main] [ 2013-03-04 19:08:26.565 CST ] [nativesystem.OCRNative.Native]  JNI: procr_get_conf() retValue = 0
    [main] [ 2013-03-04 19:08:26.566 CST ] [nativesystem.OCRNative.Native]  The OCR file is configured & local_only=true
    
    [main] [ 2013-03-04 19:08:26.566 CST ] [OCR.isCluster:963]  OCR Result status = true
    [main] [ 2013-03-04 19:08:26.566 CST ] [OCR.isCluster:975]  Bolean result = false
    [main] [ 2013-03-04 19:08:26.570 CST ] [HASContext.<init>:119]  moduleInit = 7
    [main] [ 2013-03-04 19:08:26.571 CST ] [Library.load:188]  library.load
    [main] [ 2013-03-04 19:08:26.571 CST ] [sPlatform.isHybrid:66]  osName=Linux osArch=amd64 JVM=64 rc=false
    [main] [ 2013-03-04 19:08:26.572 CST ] [sPlatform.isHybrid:66]  osName=Linux osArch=amd64 JVM=64 rc=false
    [main] [ 2013-03-04 19:08:26.572 CST ] [Library.load:264]  Loading  library /u01/app/oracle/11.2.0/grid/lib/libsrvmhas11.so
    [main] [ 2013-03-04 19:08:26.585 CST ] [has.HASContextNative.Native]  prsr_trace: no lsf ctx, line=Native: allocHASContext
    
    [main] [ 2013-03-04 19:08:26.586 CST ] [has.HASContextNative.Native]  
     allocHASContext: Came in
    [main] [ 2013-03-04 19:08:26.586 CST ] [has.HASContextNative.Native]  allocHASContext: module_init = 7
    [main] [ 2013-03-04 19:08:26.587 CST ] [has.HASContextNative.Native]  
     allocHASContext: META context [1]
    [main] [ 2013-03-04 19:08:26.588 CST ] [has.HASContextNative.Native]  
     allocHASContext: LSF context [1]
    [main] [ 2013-03-04 19:08:26.588 CST ] [has.HASContextNative.Native]  prsr_trace: Native: prsr_initSCLS
    
    [main] [ 2013-03-04 19:08:26.589 CST ] [has.HASContextNative.Native]  
     allocHASContext: SCLS context [1]
    [main] [ 2013-03-04 19:08:26.589 CST ] [has.HASContextNative.Native]  
     allocHASContext: retval [1]
    [main] [ 2013-03-04 19:08:26.590 CST ] [Util.<init>:91]  Util Instance created.
    [main] [ 2013-03-04 19:08:26.591 CST ] [has.UtilNative.Native]  prsr_trace: Native: getCRSHome
    
    [main] [ 2013-03-04 19:08:26.592 CST ] [has.UtilNative.Native]  prsr_trace: Native: getCRSHome crs_home=/u01/app/oracle/11.2.0/grid(**)
    
    [main] [ 2013-03-04 19:08:26.592 CST ] [HASContext.getCRSHome:567]  /u01/app/oracle/11.2.0/grid
    [main] [ 2013-03-04 19:08:26.593 CST ] [Util.getCRSHome:549]  getCRSHome: ret=/u01/app/oracle/11.2.0/grid
    [main] [ 2013-03-04 19:08:26.593 CST ] [Util.<init>:91]  Util Instance created.
    [main] [ 2013-03-04 19:08:26.594 CST ] [has.UtilNative.Native]  prsr_trace: Native: getCRSHome
    
    [main] [ 2013-03-04 19:08:26.595 CST ] [has.UtilNative.Native]  prsr_trace: Native: getCRSHome crs_home=/u01/app/oracle/11.2.0/grid(**)
    
    [main] [ 2013-03-04 19:08:26.595 CST ] [HASContext.getCRSHome:567]  /u01/app/oracle/11.2.0/grid
    [main] [ 2013-03-04 19:08:26.596 CST ] [Util.getCRSHome:549]  getCRSHome: ret=/u01/app/oracle/11.2.0/grid
    [main] [ 2013-03-04 19:08:26.655 CST ] [has.HASContextNative.Native]  prsr_trace: Native: allocHASContext
    
    [main] [ 2013-03-04 19:08:26.656 CST ] [has.HASContextNative.Native]  
     allocHASContext: Came in
    [main] [ 2013-03-04 19:08:26.656 CST ] [has.HASContextNative.Native]  allocHASContext: module_init = 64
    [main] [ 2013-03-04 19:08:26.657 CST ] [has.HASContextNative.Native]  prsr_trace: Native: prsr_initCLSCRS
    
    [main] [ 2013-03-04 19:08:26.657 CST ] [has.HASContextNative.Native]  prsr_trace: prsr_initCLSCRS: before calling prcr_init_crs
    
    [main] [ 2013-03-04 19:08:26.688 CST ] [has.HASContextNative.Native]  
     allocHASContext: CLSCRS context [1]
    [main] [ 2013-03-04 19:08:26.688 CST ] [has.HASContextNative.Native]  
     allocHASContext: retval [1]
    [main] [ 2013-03-04 19:08:26.716 CST ] [CRSNative.internalQueryResources:1530]  About to doQueryResources: eType resource, nodeName null, filter (TYPE CONTAINS diskgroup)
    [main] [ 2013-03-04 19:08:26.779 CST ] [CRSNative.internalQueryResources:1538]  found 4 resources
    [main] [ 2013-03-04 19:08:26.780 CST ] [CRSNative.internalQueryResources:1540]  ora.DEV_LARGE.dg
    [main] [ 2013-03-04 19:08:26.781 CST ] [CRSNative.internalQueryResources:1540]  ora.DEV_SMALL.dg
    [main] [ 2013-03-04 19:08:26.782 CST ] [CRSNative.internalQueryResources:1540]  ora.LARGE.dg
    [main] [ 2013-03-04 19:08:26.783 CST ] [CRSNative.internalQueryResources:1540]  ora.SMALL.dg
    [Finalizer] [ 2013-03-04 19:08:26.792 CST ] [Util.finalize:122]  Util: finalized called for oracle.ops.mgmt.has.Util@37f5d386
    [Finalizer] [ 2013-03-04 19:08:26.792 CST ] [Util.finalize:122]  Util: finalized called for oracle.ops.mgmt.has.Util@6c121f1d
    [main] [ 2013-03-04 19:08:26.794 CST ] [HomeImpl.stopCRSHomeres:742]  dgresname = ora.DEV_LARGE.dg
    [main] [ 2013-03-04 19:08:26.802 CST ] [Util.<init>:91]  Util Instance created.
    [main] [ 2013-03-04 19:08:26.803 CST ] [has.UtilNative.Native]  prsr_trace: Native: getCRSHome
    
    [main] [ 2013-03-04 19:08:26.805 CST ] [has.UtilNative.Native]  prsr_trace: Native: getCRSHome crs_home=/u01/app/oracle/11.2.0/grid(**)
    
    [main] [ 2013-03-04 19:08:26.806 CST ] [HASContext.getCRSHome:567]  /u01/app/oracle/11.2.0/grid
    [main] [ 2013-03-04 19:08:26.807 CST ] [Util.getCRSHome:549]  getCRSHome: ret=/u01/app/oracle/11.2.0/grid
    [main] [ 2013-03-04 19:08:26.809 CST ] [DiskGroupImpl.<init>:108]  name = ora.DEV_LARGE.dg, display name = DEV_LARGE
    [main] [ 2013-03-04 19:08:26.857 CST ] [CRSNative.isEntityRegistered:733]  entity: ora.DEV_LARGE.dg, type: 1, registered: true
    [main] [ 2013-03-04 19:08:26.858 CST ] [DiskGroupImpl.<init>:138]  name = ora.DEV_LARGE.dg, display name = DEV_LARGE
    [main] [ 2013-03-04 19:08:26.859 CST ] [HomeImpl.stopCRSHomeres:746]  diskgroup  name is DEV_LARGE
    [main] [ 2013-03-04 19:08:26.863 CST ] [CRSNative.getResourceInstancesID:1598]  Looking for RIs using filter: ((NAME == ora.DEV_LARGE.dg) && ((STATE == ONLINE) || (STATE == INTERMEDIATE)))
    [main] [ 2013-03-04 19:08:26.928 CST ] [CRSNative.getResourceInstancesID:1606]  found 1 RIs
    [main] [ 2013-03-04 19:08:26.929 CST ] [CRSNative.getResourceInstancesID:1608]  ora.DEV_LARGE.dg vbdwdev 1
    [main] [ 2013-03-04 19:08:26.931 CST ] [CRSNative.getResourceInstancesID:1598]  Looking for RIs using filter: ((NAME == ora.DEV_LARGE.dg) && ((STATE != OFFLINE) || (TARGET != OFFLINE)))
    [main] [ 2013-03-04 19:08:26.978 CST ] [CRSNative.getResourceInstancesID:1606]  found 1 RIs
    [main] [ 2013-03-04 19:08:26.979 CST ] [CRSNative.getResourceInstancesID:1608]  ora.DEV_LARGE.dg vbdwdev 1
    [main] [ 2013-03-04 19:08:26.980 CST ] [CRSNative.internalStopResource:1662]  About to stop resource: name ora.DEV_LARGE.dg, force false, keepDepTgt true, options 0
    [main] [ 2013-03-04 19:08:27.057 CST ] [CRSNativeResult.addLine:106]  callback: ora.DEV_LARGE.dg false CRS-2673: Attempting to stop 'ora.DEV_LARGE.dg' on 'vbdwdev'
    [main] [ 2013-03-04 19:08:27.567 CST ] [CRSNativeResult.addLine:106]  callback: ora.DEV_LARGE.dg false CRS-2677: Stop of 'ora.DEV_LARGE.dg' on 'vbdwdev' succeeded
    [main] [ 2013-03-04 19:08:27.569 CST ] [HomeImpl.writeresname:434]  resname = ora.DEV_LARGE.dg
    [main] [ 2013-03-04 19:08:27.570 CST ] [HomeImpl.stopCRSHomeres:742]  dgresname = ora.DEV_SMALL.dg
    [main] [ 2013-03-04 19:08:27.570 CST ] [DiskGroupImpl.<init>:108]  name = ora.DEV_SMALL.dg, display name = DEV_SMALL
    [main] [ 2013-03-04 19:08:27.620 CST ] [CRSNative.isEntityRegistered:733]  entity: ora.DEV_SMALL.dg, type: 1, registered: true
    [main] [ 2013-03-04 19:08:27.621 CST ] [DiskGroupImpl.<init>:138]  name = ora.DEV_SMALL.dg, display name = DEV_SMALL
    [main] [ 2013-03-04 19:08:27.622 CST ] [HomeImpl.stopCRSHomeres:746]  diskgroup  name is DEV_SMALL
    [main] [ 2013-03-04 19:08:27.624 CST ] [CRSNative.getResourceInstancesID:1598]  Looking for RIs using filter: ((NAME == ora.DEV_SMALL.dg) && ((STATE == ONLINE) || (STATE == INTERMEDIATE)))
    [main] [ 2013-03-04 19:08:27.668 CST ] [CRSNative.getResourceInstancesID:1606]  found 1 RIs
    [main] [ 2013-03-04 19:08:27.670 CST ] [CRSNative.getResourceInstancesID:1608]  ora.DEV_SMALL.dg vbdwdev 1
    [main] [ 2013-03-04 19:08:27.672 CST ] [CRSNative.getResourceInstancesID:1598]  Looking for RIs using filter: ((NAME == ora.DEV_SMALL.dg) && ((STATE != OFFLINE) || (TARGET != OFFLINE)))
    [main] [ 2013-03-04 19:08:27.729 CST ] [CRSNative.getResourceInstancesID:1606]  found 1 RIs
    [main] [ 2013-03-04 19:08:27.731 CST ] [CRSNative.getResourceInstancesID:1608]  ora.DEV_SMALL.dg vbdwdev 1
    [main] [ 2013-03-04 19:08:27.732 CST ] [CRSNative.internalStopResource:1662]  About to stop resource: name ora.DEV_SMALL.dg, force false, keepDepTgt true, options 0
    [main] [ 2013-03-04 19:08:27.830 CST ] [CRSNativeResult.addLine:106]  callback: ora.DEV_SMALL.dg false CRS-2673: Attempting to stop 'ora.DEV_SMALL.dg' on 'vbdwdev'
    [main] [ 2013-03-04 19:08:27.831 CST ] [CRSNativeResult.addLine:106]  callback: ora.DEV_SMALL.dg false CRS-2677: Stop of 'ora.DEV_SMALL.dg' on 'vbdwdev' succeeded
    [main] [ 2013-03-04 19:08:27.832 CST ] [HomeImpl.writeresname:434]  resname = ora.DEV_SMALL.dg
    [main] [ 2013-03-04 19:08:27.832 CST ] [HomeImpl.stopCRSHomeres:742]  dgresname = ora.LARGE.dg
    [main] [ 2013-03-04 19:08:27.833 CST ] [DiskGroupImpl.<init>:108]  name = ora.LARGE.dg, display name = LARGE
    [main] [ 2013-03-04 19:08:27.887 CST ] [CRSNative.isEntityRegistered:733]  entity: ora.LARGE.dg, type: 1, registered: true
    [main] [ 2013-03-04 19:08:27.887 CST ] [DiskGroupImpl.<init>:138]  name = ora.LARGE.dg, display name = LARGE
    [main] [ 2013-03-04 19:08:27.888 CST ] [HomeImpl.stopCRSHomeres:746]  diskgroup  name is LARGE
    [main] [ 2013-03-04 19:08:27.889 CST ] [CRSNative.getResourceInstancesID:1598]  Looking for RIs using filter: ((NAME == ora.LARGE.dg) && ((STATE == ONLINE) || (STATE == INTERMEDIATE)))
    [main] [ 2013-03-04 19:08:27.938 CST ] [CRSNative.getResourceInstancesID:1606]  found 1 RIs
    [main] [ 2013-03-04 19:08:27.940 CST ] [CRSNative.getResourceInstancesID:1608]  ora.LARGE.dg vbdwdev 1
    [main] [ 2013-03-04 19:08:27.942 CST ] [CRSNative.getResourceInstancesID:1598]  Looking for RIs using filter: ((NAME == ora.LARGE.dg) && ((STATE != OFFLINE) || (TARGET != OFFLINE)))
    [main] [ 2013-03-04 19:08:27.978 CST ] [CRSNative.getResourceInstancesID:1606]  found 1 RIs
    [main] [ 2013-03-04 19:08:27.979 CST ] [CRSNative.getResourceInstancesID:1608]  ora.LARGE.dg vbdwdev 1
    [main] [ 2013-03-04 19:08:27.981 CST ] [CRSNative.internalStopResource:1662]  About to stop resource: name ora.LARGE.dg, force false, keepDepTgt true, options 0
    [main] [ 2013-03-04 19:08:28.030 CST ] [CRSNativeResult.addLine:106]  callback: ora.LARGE.dg false CRS-2673: Attempting to stop 'ora.LARGE.dg' on 'vbdwdev'
    [main] [ 2013-03-04 19:08:28.062 CST ] [CRSNativeResult.addLine:106]  callback: ora.LARGE.dg false CRS-2677: Stop of 'ora.LARGE.dg' on 'vbdwdev' succeeded
    [main] [ 2013-03-04 19:08:28.063 CST ] [HomeImpl.writeresname:434]  resname = ora.LARGE.dg
    [main] [ 2013-03-04 19:08:28.064 CST ] [HomeImpl.stopCRSHomeres:742]  dgresname = ora.SMALL.dg
    [main] [ 2013-03-04 19:08:28.064 CST ] [DiskGroupImpl.<init>:108]  name = ora.SMALL.dg, display name = SMALL
    [main] [ 2013-03-04 19:08:28.087 CST ] [CRSNative.isEntityRegistered:733]  entity: ora.SMALL.dg, type: 1, registered: true
    [main] [ 2013-03-04 19:08:28.088 CST ] [DiskGroupImpl.<init>:138]  name = ora.SMALL.dg, display name = SMALL
    [main] [ 2013-03-04 19:08:28.088 CST ] [HomeImpl.stopCRSHomeres:746]  diskgroup  name is SMALL
    [main] [ 2013-03-04 19:08:28.089 CST ] [CRSNative.getResourceInstancesID:1598]  Looking for RIs using filter: ((NAME == ora.SMALL.dg) && ((STATE == ONLINE) || (STATE == INTERMEDIATE)))
    [main] [ 2013-03-04 19:08:28.130 CST ] [CRSNative.getResourceInstancesID:1606]  found 1 RIs
    [main] [ 2013-03-04 19:08:28.131 CST ] [CRSNative.getResourceInstancesID:1608]  ora.SMALL.dg vbdwdev 1
    [main] [ 2013-03-04 19:08:28.135 CST ] [CRSNative.getResourceInstancesID:1598]  Looking for RIs using filter: ((NAME == ora.SMALL.dg) && ((STATE != OFFLINE) || (TARGET != OFFLINE)))
    [main] [ 2013-03-04 19:08:28.189 CST ] [CRSNative.getResourceInstancesID:1606]  found 1 RIs
    [main] [ 2013-03-04 19:08:28.190 CST ] [CRSNative.getResourceInstancesID:1608]  ora.SMALL.dg vbdwdev 1
    [main] [ 2013-03-04 19:08:28.191 CST ] [CRSNative.internalStopResource:1662]  About to stop resource: name ora.SMALL.dg, force false, keepDepTgt true, options 0
    [main] [ 2013-03-04 19:08:28.250 CST ] [CRSNativeResult.addLine:106]  callback: ora.SMALL.dg false CRS-2673: Attempting to stop 'ora.SMALL.dg' on 'vbdwdev'
    [main] [ 2013-03-04 19:08:28.286 CST ] [CRSNativeResult.addLine:106]  callback: ora.SMALL.dg false CRS-2677: Stop of 'ora.SMALL.dg' on 'vbdwdev' succeeded
    [main] [ 2013-03-04 19:08:28.287 CST ] [HomeImpl.writeresname:434]  resname = ora.SMALL.dg
    [main] [ 2013-03-04 19:08:28.296 CST ] [Version.isPre:465]  version to be checked 11.2.0.2.0 major version to check against10
    [main] [ 2013-03-04 19:08:28.297 CST ] [Version.isPre:476]  isPre.java: Returning FALSE
    [main] [ 2013-03-04 19:08:28.297 CST ] [OCR.loadLibrary:311]  
     Inside constructor of OCR
    [main] [ 2013-03-04 19:08:28.298 CST ] [OCR.isCluster:959]  Calling OCRNative for isCluster()
    [main] [ 2013-03-04 19:08:28.298 CST ] [nativesystem.OCRNative.Native]  JNI: isCluster() Successfully initialized meta context
    [main] [ 2013-03-04 19:08:28.299 CST ] [nativesystem.OCRNative.Native]  JNI: procr_get_conf() retValue = 0
    [main] [ 2013-03-04 19:08:28.299 CST ] [nativesystem.OCRNative.Native]  The OCR file is configured & local_only=true
    
    [main] [ 2013-03-04 19:08:28.299 CST ] [OCR.isCluster:963]  OCR Result status = true
    [main] [ 2013-03-04 19:08:28.300 CST ] [OCR.isCluster:975]  Bolean result = false
    [main] [ 2013-03-04 19:08:28.320 CST ] [CRSNative.internalQueryResources:1530]  About to doQueryResources: eType resource, nodeName null, filter (TYPE == ora.asm.type)
    [main] [ 2013-03-04 19:08:28.346 CST ] [CRSNative.internalQueryResources:1538]  found 1 resources
    [main] [ 2013-03-04 19:08:28.349 CST ] [CRSNative.internalQueryResources:1540]  ora.asm
    [main] [ 2013-03-04 19:08:28.383 CST ] [Version.isPre:465]  version to be checked 11.2.0.2.0 major version to check against11
    [main] [ 2013-03-04 19:08:28.384 CST ] [Version.isPre:476]  isPre.java: Returning FALSE
    [main] [ 2013-03-04 19:08:28.384 CST ] [Version.isPre112:393]  version to be checked 11.2.0.2.0 minor version to check against2
    [main] [ 2013-03-04 19:08:28.385 CST ] [Version.isPre112:404]  isPre112 : Returning FALSE for minor version check
    [main] [ 2013-03-04 19:08:28.385 CST ] [OCR.loadLibrary:311]  
     Inside constructor of OCR
    [main] [ 2013-03-04 19:08:28.385 CST ] [OCR.getOCRLocations:983]  Calling OCRNative for getOCRLocations()
    [main] [ 2013-03-04 19:08:28.386 CST ] [nativesystem.OCRNative.Native]  JNI: isCluster() Successfully initialized meta context
    [main] [ 2013-03-04 19:08:28.386 CST ] [nativesystem.OCRNative.Native]  JNI: procr_get_conf() retValue = 0
    [main] [ 2013-03-04 19:08:28.387 CST ] [nativesystem.OCRNative.Native]  The OCR file is configured & local_only=true
    
    [main] [ 2013-03-04 19:08:28.387 CST ] [nativesystem.OCRNative.Native]  
    Number of OCR Locations = 1
    .
    Will have to continue in a second message ...
  • 3. Re: problem with srvctl stop home
    EdStevens Guru
    Currently Being Moderated
    continuing ....
    and one final item. Immediately after the failed srvctl command we see the following processes still running
    oracle:11g$ ps -ef|grep "grid/bin"
    oracle    3444     1  0 18:21 ?        00:00:00 /u01/app/oracle/11.2.0/grid/bin/ohasd.bin reboot
    oracle    3702     1  0 18:22 ?        00:00:00 /u01/app/oracle/11.2.0/grid/bin/oraagent.bin
    oracle    3724     1  0 18:22 ?        00:00:00 /u01/app/oracle/11.2.0/grid/bin/evmd.bin
    oracle    3761  3724  0 18:22 ?        00:00:00 /u01/app/oracle/11.2.0/grid/bin/evmlogger.bin -o /u01/app/oracle/11.2.0/grid/evm/log/evmlogger.info -l /u01/app/oracle/11.2.0/grid/evm/log/evmlogger.log
    oracle    3773     1  0 18:22 ?        00:00:00 /u01/app/oracle/11.2.0/grid/bin/cssdagent
    oracle    3776     1  0 18:22 ?        00:00:00 /u01/app/oracle/11.2.0/grid/bin/orarootagent.bin
    oracle    3791     1  0 18:22 ?        00:00:00 /u01/app/oracle/11.2.0/grid/bin/diskmon.bin -d -f
    oracle    3804     1  0 18:22 ?        00:00:00 /u01/app/oracle/11.2.0/grid/bin/ocssd.bin
    oracle    5903  5815  0 19:36 pts/0    00:00:00 grep grid/bin
    
    oracle:11g$
    Edited by: EdStevens on Mar 4, 2013 7:47 PM
  • 4. Re: problem with srvctl stop home
    Dude! Guru
    Currently Being Moderated
    Just a guess, but perhaps your database vbdwdev isn't a valid registered resource, hence it cannot shutdown the ASM instance when it's in use.

    What is your output of the following:
    crsctl status resource
    srvctl stop database -d vbdwdev
    What happens if you shutdown database vbdwdev through sqlplus prior to running your srvctl stop command?

    If the above works, perhaps the following might solve the issue:
    srvctl remove database -d vbdwdev
    srvctl srvctl add database -d vbdwdev -o /u01/app/oracle/product/11.2.0/dbhome_1
  • 5. Re: problem with srvctl stop home
    EdStevens Guru
    Currently Being Moderated
    Dude wrote:
    Just a guess, but perhaps your database vbdwdev isn't a valid registered resource, hence it cannot shutdown the ASM instance when it's in use.

    What is your output of the following:
    crsctl status resource
    crsctl stop database -d vbdwdev
    What happens if you shutdown database vbdwdev through sqlplus prior to running your srvctl stop command?

    If the above works, perhaps the following might solve the issue:
    srvctl remove database -d vbdwdev
    srvctl srvctl add database -d vbdwdev -o /u01/app/oracle/product/11.2.0/dbhome_1
    Due to some other issues, I deleted and re-created all 3 databases on this server, along with deleting and recreating the 4 disk groups in ASM. I took the opportunity to use different names for the db's, changing vbdwdev to dwdevvb, etc. This helped the confusion between 'vbdwdev' as both a server name and a database name. I didn't expect it to fix the immediate problem, and it didn't, but at least I have more clarity in my names going forward.

    I guess you were giving the commands off the top of your head. 'database' doesn't appear to be a valid option for the 'crsctl stop' command. The 'crsctl status' does show the database in question.
    However, as I was sorting this out in the crsctl command reference (Appendix E-3 in Clusterware Admin and Deployment Guide) I noticed a 'stop has' option. Hmm. Tried it and it did shut down everything. Confirmed by following with 'ps -ef | grep oracle' and the only process left were my own putty sessions. Well, I believe that is really what I was after in the first place ... shut everything down so I can move all of my OHOME directories to a larger file system and remount back as /u01.

    Maybe it's just me an my relative lack of direct experience with all things GI, but it seems that this is another case of Oracle docs just assuming if you are using GI, you are clustered.  In any event, I'll spend some more time studying 'srvctl' vs. 'crsctl' to see if I can get a better grasp of it all.

    Spending some 'quality time' with chapter 4 of the Database Admin Guide.

    Edited by: EdStevens on Mar 5, 2013 2:05 PM
  • 6. Re: problem with srvctl stop home
    Dude! Guru
    Currently Being Moderated
    Yes, sorry I confused srvctl and crsctl.

    crsctl srvctl stop database -d orcl

    I corrected my post, You can also verify here:
    http://docs.oracle.com/cd/E11882_01/server.112/e25494/restart005.htm
    crsctl disable has
    crsctl stop has
    ... disables and stops the Oracle Restart software. Before doing so, you should verify that the components are stopped first. The idea of Oracle Restart is to automatically start and stop database components and to setup dependencies.
  • 7. Re: problem with srvctl stop home
    EdStevens Guru
    Currently Being Moderated
    Sorry for the delay. Demands of live systems and all that .... ;-)

    No joy with the documented procedures, but at the end I'll throw in what does seem to accomplish my end goal.
    =~=~=~=~=~=~=~=~=~=~=~= PuTTY log 2013.03.06 14:29:24 =~=~=~=~=~=~=~=~=~=~=~=
    login as: oracle
    oracle@vbdwdev's password: 
    Last login: Tue Mar  5 08:04:47 2013 from 192.168.56.1
    
    The Oracle base has been set to /u01/app/oracle
    check what's running
    oracle:11g$ ps -ef|grep pmon
    oracle    3871     1  0 14:28 ?        00:00:00 ora_pmon_cogdevvb
    oracle    4088     1  0 14:28 ?        00:00:00 asm_pmon_+ASM
    oracle    4424     1  0 14:28 ?        00:00:00 ora_pmon_dwdevvb
    oracle    4452     1  0 14:28 ?        00:00:00 ora_pmon_dwstgvb
    oracle    5063  5014  0 14:29 pts/0    00:00:00 grep pmon
    take a look at oratab
    oracle:dwdevvb$ cat /etc/oratab
    <snip the comments>
    #
    11g:/u01/app/oracle/product/11.2.0/dwdev:N
    +ASM:/u01/app/oracle/11.2.0/grid:N
    cogdevvb:/u01/app/oracle/product/11.2.0/dwdev:N# line added by Agent
    dwdevvb:/u01/app/oracle/product/11.2.0/dwdev:N# line added by Agent
    dwstgvb:/u01/app/oracle/product/11.2.0/dwdev:N# line added by Agent
    ok, let's start by re-registering the database
    oracle:11g$ . oraenv
    ORACLE_SID = [11g] ? dwdevvb
    The Oracle base remains unchanged with value /u01/app/oracle
    
    
    oracle:dwdevvb$ 
    oracle:dwdevvb$ cd $ORACLE_BASE
    
    oracle:dwdevvb$ srvctl stop database -d dwdevvb
    
    oracle:dwdevvb$ ps -ef|grep pmon
    oracle    3871     1  0 14:28 ?        00:00:00 ora_pmon_cogdevvb
    oracle    4088     1  0 14:28 ?        00:00:00 asm_pmon_+ASM
    oracle    4452     1  0 14:28 ?        00:00:00 ora_pmon_dwstgvb
    oracle    5200  5014  0 14:33 pts/0    00:00:00 grep pmon
    
    
    oracle:dwdevvb$ srvctl remove database -d dwdevvb
    Remove the database dwdevvb? (y/[n]) y
    
    
    oracle:dwdevvb$ srvctl add database -d dwdevvb -o $ORACLE_HOME
    
    
    oracle:dwdevvb$ srvctl start database -d dwdevvb
    
    
    oracle:dwdevvb$ ps -ef|grep pmon
    oracle    3871     1  0 14:28 ?        00:00:00 ora_pmon_cogdevvb
    oracle    4088     1  0 14:28 ?        00:00:00 asm_pmon_+ASM
    oracle    4452     1  0 14:28 ?        00:00:00 ora_pmon_dwstgvb
    oracle    5344     1  0 14:34 ?        00:00:00 ora_pmon_dwdevvb
    oracle    5616  5014  0 14:34 pts/0    00:00:00 grep pmon
    so far, so good

    Now we'll stop the rdbms home
    oracle:dwdevvb$ srvctl stop home -o $ORACLE_HOME -s state_rdbms
    
    
    oracle:dwdevvb$ ps -ef | grep pmon
    oracle    4088     1  0 14:28 ?        00:00:00 asm_pmon_+ASM
    oracle    5714  5014  0 14:35 pts/0    00:00:00 grep pmon
    so far, so good

    Now we'll stop the grid home
    oracle:dwdevvb$ . oraenv
    ORACLE_SID = [dwdevvb] ? +ASM
    The Oracle base remains unchanged with value /u01/app/oracle
    
    
    oracle:+ASM$ srvctl stop home -o $ORACLE_HOME -s state_grid
    PRCH-1002 : Failed  to stop resources running from CRS home /u01/app/oracle/11.2.0/grid
    PRCH-1030 : One or more resources failed to stop: PRCH-1026 : Failed to stop ASM
    PRCD-1027 : Failed to retrieve database dwdevvb
    PRCD-1035 : Database dwdevvb is not a cluster database
    
    oracle:+ASM$ ps -ef | grep pmon
    oracle    4088     1  0 14:28 ?        00:00:00 asm_pmon_+ASM
    oracle    5807  5014  0 14:36 pts/0    00:00:00 grep pmon
    
    oracle:+ASM$ 
    Going back to the 'crsctl stop' commands and playing around with that a bit, I found that if I just issued that, everything got shut down, but the databases were 'shutdown abort'. Howerver, if I shut the dabases down first ('srvctl stop home .....' - on the database home) the db's were shut down 'immediate'. At that point I bypassed the 'svrctl stop home' on the grid home and went straight to 'crsctl stop has'. The asm instance looked to shut down cleanly and at the end, all of the miscellaneous oracle process were stopped.

    Unless you can show my why not, it looks like I have a proven - though counter to the docs - method of shutting down for maintenance of the ORACLE_HOME directories. But of course I'm still left with
    - WHY the shutdown of the grid home was even trying to shut down a database. The docs are pretty clear that srvctl commands only work on objects in the current ORACLE_HOME. ("Preparing to Run SRVCTL" on pg 4-10 of the DB Admin Guide).
    - WHY , when it chose to shut down the database anyway, it complained that it wasn't a clustered database.
  • 8. Re: problem with srvctl stop home
    r chandran Newbie
    Currently Being Moderated
    Hello,

    Is there any chance that your ORACLE_HOME (db home) is relinked with rac_on option or was it part of a RAC Cluster before? Also can you check the CRS resource profile for the database resource 'dwdevvb' with following:

    /u01/app/oracle/11.2.0/grid/bin/crsctl stat res 'ora.dwdevvb.db' -p | egrep 'CLUSTER_DATABASE=|DATABASE_TYPE='

    (Please ensure the database resource name is 'ora.dwdevvb.db' by running 'crsctl stat res -t')

    In the resource profile, please check what you find for CLUSTER_DATABASE and DATABAE_TYPE. Is this something like below?:

    CLUSTER_DATABASE=true
    DATABASE_TYPE=RAC

    If this appears as above, then your database is treated as a cluster database and any attempt to stop the ASM HOME will automatically look for all dependent resources (crsctl stat res 'ora.asm' -p |egrep 'START_DEPENDENCIES|STOP_DEPENDENCIES') while stopping.

    Thanks,
    Rijesh
  • 9. Re: problem with srvctl stop home
    Dude! Guru
    Currently Being Moderated
    Why do you use "srvctl stop home -o $ORACLE_HOME"?

    I'm not sure, but I'd say the +ASM instance and Oracle Databases are typically not installed in the same Oracle home and hence you cannot shutdown any databases specifying the GRID home. You can however force shutdown the ASM instance using the following command:
    srvctl stop asm -f
    If yo have any database running while doing a force shutdown of the ASM instance, any database using the ASM instance will crash and perform a recovery at the next startup.

    The following should work:
    $ srvctl stop database -d orcl
    $ srvctl stop listener
    $ srvctl stop diskgroup -g DATA
    $ srvctl stop asm
    If the above fails, see what resources you have online:
    crsctl status resource
    Then to start it:
    $ srvctl start asm
    $ srvctl start database -d orcl
    The listener should start automatically since it is a dependent action item.
    $ srvctl config listener
    $ crsctl stat res -t
    $ crsctl stat res ora.orcl.db -f
    
    START_DEPENDENCIES=weak(type:ora.listener.type,uniform:ora.ons)
  • 10. Re: problem with srvctl stop home
    EdStevens Guru
    Currently Being Moderated
    Dude wrote:
    Why do you use "srvctl stop home -o $ORACLE_HOME"?
    Maybe I need to clarify exactly what my (mis)? understanding is ..
    First, to reiterate, my problem is to move the entire ORACLE_BASE to a larger disk. My plan is to mount the new disk to /u02, copy all of /u01 to /u02, then dismount /u02 and mount the disk to /u01.

    Looking at the Database Administrator's Guide, pg 4-27, under "Stoppoing and Restarting Oracle Restart for Maintenance Operations" seems to be exactly my situation.
    The overall outline of the procedure is to use 'srvctl stop home', followed by 'crsctl disable has' and 'crsctl stop has'; do the maintenance, then reverse the crsctl and srvctl sequence to start up.
    Drilling down a little further, the first step given is "prepare to run srvctl, as described ... on page 4.10. Refering back to that, it specifies that srvctl should be run out of the HOME that relates to the components being addressed -- database home for databases, grid home for ASM, etc. So my sequence is to
    - set the environment (including ORACLE_HOME) for the database
    - srvctl stop home ....
    - set the environment (including ORACLE_HOME) for the GI
    - srvctl stop home ....

    And it is that second 'stop home' -- the one on the GI home, that is complaining that one of my databases is not clustered ..

    as for my exact syntax of "srvctl stop home -o $ORACLE_HOME", I figured it was just easier and not prone to fat-finger errors to just specify the environment variable rather than type in the entire home name ..





    I'm not sure, but I'd say the +ASM instance and Oracle Databases are typically not installed in the same Oracle home and hence you cannot shutdown any databases specifying the GRID home.
    Correct. Two separate homes, as evidenced in my oratab:
    {code}
    +ASM:/u01/app/oracle/11.2.0/grid:N
    cogdevvb:/u01/app/oracle/product/11.2.0/dwdev:N # line added by Agent
    dwstgvb:/u01/app/oracle/product/11.2.0/dwdev:N # line added by Agent
    dwdevvb:/u01/app/oracle/product/11.2.0/dwdev:N # line added by Agent
    {code}

    And so, with two homes and according to the referenced item in the Admin Guide, two 'srvctl stop home' statements.

    You can however force shutdown the ASM instance using the following command:
    {code}
    srvctl stop asm -f
    {code}
    If yo have any database running while doing a force shutdown of the ASM instance, any database using the ASM instance will crash and perform a recovery at the next startup.

    The following should work:
    {code}
    $ srvctl stop database -d orcl
    $ srvctl stop listener
    $ srvctl stop diskgroup -g DATA
    $ srvctl stop asm
    {code}

    If the above fails, see what resources you have online:
    {code}
    crsctl status resource
    {code}

    Then to start it:
    {code}
    $ srvctl start asm
    $ srvctl start database -d orcl
    {code}

    The listener should start automatically since it is a dependent action item.
    {code}
    $ srvctl config listener
    $ crsctl stat res -t
    $ crsctl stat res ora.orcl.db -f

    START_DEPENDENCIES=weak(type:ora.listener.type,uniform:ora.ons)
    {code}
  • 11. Re: problem with srvctl stop home
    EdStevens Guru
    Currently Being Moderated
    Rijesh wrote:
    Hello,

    Is there any chance that your ORACLE_HOME (db home) is relinked with rac_on option or was it part of a RAC Cluster before? Also can you check the CRS resource profile for the database resource 'dwdevvb' with following:

    /u01/app/oracle/11.2.0/grid/bin/crsctl stat res 'ora.dwdevvb.db' -p | egrep 'CLUSTER_DATABASE=|DATABASE_TYPE='

    (Please ensure the database resource name is 'ora.dwdevvb.db' by running 'crsctl stat res -t')
    it reported CLUSTER_DATABASE=false.
    oracle:+ASM$ /u01/app/oracle/11.2.0/grid/bin/crsctl stat res 'ora.dwdevvb.db' -p | egrep 'CLUSTER_DATABASE=|DATABASE_TYPE='
    CLUSTER_DATABASE=false
    In the resource profile, please check what you find for CLUSTER_DATABASE and DATABAE_TYPE. Is this something like below?:

    CLUSTER_DATABASE=true
    DATABASE_TYPE=RAC

    If this appears as above, then your database is treated as a cluster database and any attempt to stop the ASM HOME will automatically look for all dependent resources (crsctl stat res 'ora.asm' -p |egrep 'START_DEPENDENCIES|STOP_DEPENDENCIES') while stopping.

    Thanks,
    Rijesh
  • 12. Re: problem with srvctl stop home
    Dude! Guru
    Currently Being Moderated
    For what it's worth, I checked the procedure on a VirtualBox installation using Oracle 11.2.0.2. It should work, please see below:
    $ . oraenv
    ORACLE_SID = [oracle] ? orclasm
    The Oracle base has been set to /u01/app/oracle
    $ srvctl stop home -o $ORACLE_HOME -s /home/oracle/state1
    $ cat /home/oracle/state1
    db-orclasm
    
    $ . oraenv
    ORACLE_SID = [orclasm] ? +ASM
    The Oracle base remains unchanged with value /u01/app/oracle
    $ srvctl stop home -o $ORACLE_HOME -s /home/oracle/state2
    $ cat /home/oracle/state2
    diskgroup-ora.DATA.dg
    asm-ora.asm
    lsnr-LISTENER
    The following document might be of useful, showing what seems to be exactly your problem:
    http://oracletoday.blogspot.com/2010/12/applying-grid-infrastructure-patch-set.html
  • 13. Re: problem with srvctl stop home
    EdStevens Guru
    Currently Being Moderated
    Dude wrote:
    For what it's worth, I checked the procedure on a VirtualBox installation using Oracle 11.2.0.2. It should work, please see below:
    $ . oraenv
    ORACLE_SID = [oracle] ? orclasm
    The Oracle base has been set to /u01/app/oracle
    $ srvctl stop home -o $ORACLE_HOME -s /home/oracle/state1
    $ cat /home/oracle/state1
    db-orclasm
    
    $ . oraenv
    ORACLE_SID = [orclasm] ? +ASM
    The Oracle base remains unchanged with value /u01/app/oracle
    $ srvctl stop home -o $ORACLE_HOME -s /home/oracle/state2
    $ cat /home/oracle/state2
    diskgroup-ora.DATA.dg
    asm-ora.asm
    lsnr-LISTENER
    The following document might be of useful, showing what seems to be exactly your problem:
    http://oracletoday.blogspot.com/2010/12/applying-grid-infrastructure-patch-set.html
    I think you may be on to something there. The machine I've been demoing the problem is a VBox machine I built to mimic my live test server. That server I inherited and have so far applied no patches or updates beyond what was there when I took it.. I have no history of how it got to be in the state it is in, beyond what I can get from opatch lsinventory. The db home and previous grid home are at 11.2.0.1.1 and the current grid home at 11.2.0.2.0. The patch and upgrade plan I used to get the production server up to the same level (grid was still at 12.2.0.1 when I took it) was worked out on a VBox machine built for that purpose and still running as my 'test for production' box. That those none of my machines (real or vbox) have the cited patches (9413827 and 9706490 ). When preparing to upgrade grid on my prod box, I don't recall seeing any instructions to run srvctl or 'rootcrs.pl', but then I had so many documents -- readmes, chapters in the Grid admin guide, chapters in the DB Admin guide, ML notes, cross-references, circular references .... and trying to sift out what applied only to clustered environements ... The blog you cited had this comment that I found particularly interesting:

    rootcrs.pl is the script used for RAC environments. If you have non-RAC GI the script you need to use is roothas.pl. After changing rootcrs.pl with roothas.pl and unlocking the grid home you can continue with applying the patch.

    At one point in my testing I found that after the upgrade to 11.2.0.2 ,the next time the ASM instance was started it would come back up with v$instance reporting it was 11.2.0.1. Found a ML doc on that giving a fix to be made to roothas.pl, and that was incorporated into my own instructions.

    And with that, even though we don't have a pinpoint diagnosis for my exact problem, I think we are as close as we're going to get and I'm pretty satisfied we're looking at another issue going back to oracle not making enough clarity between clustered and non-clustered GI installations.

    Thanks for your help.

    Edited by: EdStevens on Mar 8, 2013 6:17 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points