4 Replies Latest reply: Apr 30, 2013 9:09 PM by Ora_83 RSS

    unable to see diskgroups as a resource

    Ora_83
      Hi

      Standalone database. I can mount the diskgroups but I am unable to see them as a resource. Any suggestion ?


      [oracle@orcl2 ~]$ sqlplus "/ as sysasm"
      
      SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 29 15:39:33 2013
      
      Copyright (c) 1982, 2009, Oracle.  All rights reserved.
      
      Connected to an idle instance.
      
      SQL> startup
      ORA-00099: warning: no parameter file specified for ASM instance
      ASM instance started
      
      Total System Global Area  283930624 bytes
      Fixed Size                  2212656 bytes
      Variable Size             256552144 bytes
      ASM Cache                  25165824 bytes
      ORA-15110: no diskgroups mounted
      
      
      SQL> alter diskgroup DATA mount;
      
      Diskgroup altered.
      
      SQL>  alter diskgroup DATA2 mount;
      
      Diskgroup altered.
      
      
      
      SQL> select state from v$asm_diskgroup;
      
      STATE
      -----------
      MOUNTED
      MOUNTED
      
      
      
      [oracle@orcl2 ~]$ crs_stat -t
      Name           Type           Target    State     Host
      ------------------------------------------------------------
      ora.cssd       ora.cssd.type  ONLINE    ONLINE    orcl2
      ora.diskmon    ora....on.type ONLINE    ONLINE    orcl2
        • 1. Re: unable to see diskgroups as a resource
          JohnWatson
          The crs_stat utility is deprecated. What is the result of
          crsctl stat res -t
          • 2. Re: unable to see diskgroups as a resource
            Ora_83
            [oracle@orcl2 ~]$ crsctl stat res -t
            --------------------------------------------------------------------------------
            NAME           TARGET  STATE        SERVER                   STATE_DETAILS
            --------------------------------------------------------------------------------
            Cluster Resources
            --------------------------------------------------------------------------------
            ora.cssd
                  1        ONLINE  ONLINE       orcl2
            ora.diskmon
                  1        ONLINE  ONLINE       orcl2
            • 3. Re: unable to see diskgroups as a resource
              asahide
              Hi,

              Could you try to use "srvctl add asm" ?
              <<http://docs.oracle.com/cd/E11882_01/server.112/e25494/restart005.htm#CHDJEEIJ>>


              Regards,
              • 4. Re: unable to see diskgroups as a resource
                Ora_83
                Hi,

                I am still unable to see the diskgroups as a resource.

                [oracle@orcl2 ~]$ srvctl add asm -p +DATA/ASM/ASMPARAMETERFILE/REGISTRY.253.811076417
                
                [oracle@orcl2 ~]$ crs_stat -t
                Name           Type           Target    State     Host
                ------------------------------------------------------------
                ora.asm        ora.asm.type   ONLINE    ONLINE    orcl2
                ora.cssd       ora.cssd.type  ONLINE    ONLINE    orcl2
                ora.diskmon    ora....on.type ONLINE    ONLINE    orcl2
                The issue is fixed once I stop/start has
                [oracle@orcl2 ~]$ crs_stat -t
                Name           Type           Target    State     Host
                ------------------------------------------------------------
                ora.DATA.dg    ora....up.type ONLINE    ONLINE    orcl2
                ora.asm        ora.asm.type   ONLINE    ONLINE    orcl2
                ora.cssd       ora.cssd.type  ONLINE    ONLINE    orcl2
                ora.diskmon    ora....on.type ONLINE    ONLINE    orcl2
                Thanks