4 Replies Latest reply: Sep 6, 2013 9:02 AM by user13053167 RSS

    Need help adding diskgroups as resources

    user13053167

      Hello,

       

      I have 2-node 11gR2 cluster.  ASM is running and all of the diskgroups are mounted.  However, my DATA and FRA diskgroups are not shown as resources.

       

      I tried adding ora.DATA.dg and ora.FRA.dg with "crsctl add resource ora.DATA.dg -type ora.diskgroup.type.  However, there are OFFLINE and become UNKNOWN if i try to start them.

       

      Does anybody know of a way to add them as resources?

       

      :[grid@porsche1 bin]$ crsctl stat res -t

      --------------------------------------------------------------------------------

      NAME           TARGET  STATE        SERVER                   STATE_DETAILS

      --------------------------------------------------------------------------------

      Local Resources

      --------------------------------------------------------------------------------

      ora.CRS_DATA.dg

                     ONLINE  ONLINE       porsche1

                     ONLINE  ONLINE       porsche2

      ora.LISTENER.lsnr

                     ONLINE  ONLINE       porsche1

                     ONLINE  ONLINE       porsche2

      ora.asm

                     ONLINE  ONLINE       porsche1                 Started

                     ONLINE  ONLINE       porsche2                 Started

      ora.eons

                     ONLINE  ONLINE       porsche1

                     ONLINE  ONLINE       porsche2

      ora.gsd

                     OFFLINE OFFLINE      porsche1

                     OFFLINE OFFLINE      porsche2

      ora.net1.network

                     ONLINE  ONLINE       porsche1

                     ONLINE  ONLINE       porsche2

      ora.ons

                     ONLINE  ONLINE       porsche1

                     ONLINE  ONLINE       porsche2

      ora.registry.acfs

                     ONLINE  ONLINE       porsche1

                     ONLINE  ONLINE       porsche2

      --------------------------------------------------------------------------------

      Cluster Resources

      --------------------------------------------------------------------------------

      ora.LISTENER_SCAN1.lsnr

            1        ONLINE  ONLINE       porsche2

      ora.LISTENER_SCAN2.lsnr

            1        ONLINE  ONLINE       porsche1

      ora.LISTENER_SCAN3.lsnr

            1        ONLINE  ONLINE       porsche1

      ora.oc4j

            1        OFFLINE OFFLINE

      ora.porsche1.vip

            1        ONLINE  ONLINE       porsche1

      ora.porsche2.vip

            1        ONLINE  ONLINE       porsche2

      ora.scan1.vip

            1        ONLINE  ONLINE       porsche2

      ora.scan2.vip

            1        ONLINE  ONLINE       porsche1

      ora.scan3.vip

            1        ONLINE  ONLINE       porsche1

       

       

      Here, you can see they are mounted:

      porsche1.carmax.org-grid-+ASM1-/home/grid > asmcmd

      ASMCMD> lsdg

      State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name

      MOUNTED  HIGH    N         512   4096  1048576     24417    23161              506            7551              0             N  CRS_DATA/

      MOUNTED  EXTERN  N         512   4096  1048576   1105848    30904                0           30904              0             N  DATA/

      MOUNTED  EXTERN  N         512   4096  1048576    307180   280069                0          280069              0             N  FRA/

       

      And they are in the ASM spfile:

      *.asm_diskgroups='DATA','FRA'

      *.asm_diskstring='/dev/ASM*'

      *.asm_power_limit=1

      *.diagnostic_dest='/u01/app/grid'

      *.instance_type='asm'

      *.large_pool_size=12M

      *.remote_login_passwordfile='EXCLUSIVE'

        • 1. Re: Need help adding diskgroups as resources
          Levi Pereira

          Using crs_* or crsctl commands on resources with the prefix ora.* (resources provided by Oracle) remains unsupported.


          You should use "srvctl add diskgroup", check documentation.

           

           

          http://levipereira.wordpress.com/2012/05/30/what-should-i-use-srvctl-add-serverpool-or-crsctl-add-serverpool/


          • 2. Re: Need help adding diskgroups as resources
            user13053167

            Thanks Levi.

             

            Unfortunately, in my 11.2.0.1 environment, the "srvctl add diskgroup" functionality doesn't exist.

             

            $ srvctl add diskgroup -help

            Usage: srvctl <command> <object> [<options>]

                commands: enable|disable|start|stop|relocate|status|add|remove|modify|getenv|setenv|unsetenv|config

                objects: database|instance|service|nodeapps|vip|asm|diskgroup|listener|srvpool|server|scan|scan_listener|oc4j|home|filesystem|gns

            For detailed help on each command and object and its options use:

              srvctl <command> -h or

              srvctl <command> <object> -h

            PRKO-2011 : Invalid object specified on command line: diskgroup

             

             

             

            The SRVCTL add command adds the configuration and the Oracle Clusterware application to the OCR for the cluster database, named instances, named services, or for the named nodes.

            Usage: srvctl add database -d <db_unique_name> -o <oracle_home> [-m <domain_name>] [-p <spfile>] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}] [-s <start_options>] [-t <stop_options>] [-n <db_name>] [-y {AUTOMATIC | MANUAL}] [-g "<serverpool_list>"] [-x <node_name>] [-a "<diskgroup_list>"]
            Usage: srvctl add instance -d <db_unique_name> -i <inst_name> -n <node_name> [-f]
            Usage: srvctl add service -d <db_unique_name> -s <service_name> {-r "<preferred_list>" [-a "<available_list>"] [-P {BASIC | NONE | PRECONNECT}] | -g <server_pool> [-c {UNIFORM | SINGLETON}] } [-k   <net_num>] [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC | MANUAL}] [-q {TRUE|FALSE}] [-x {TRUE|FALSE}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}] [-z <failover_retries>] [-w <failover_delay>]
            Usage: srvctl add service -d <db_unique_name> -s <service_name> -u {-r "<new_pref_inst>" | -a "<new_avail_inst>"}
            Usage: srvctl add nodeapps { { -n <node_name> -A <name|ip>/<netmask>/[if1[|if2...]] } | { -S <subnet>/<netmask>/[if1[|if2...]] } } [-p <portnum>] [-m <multicast-ip-address>] [-e <eons-listen-port>] [-l <ons-local-port>]  [-r <ons-remote-port>] [-t <host>[:<port>][,<host>[:<port>]...]] [-v]
            Usage: srvctl add vip -n <node_name> -k <network_number> -A <name|ip>/<netmask>/[if1[|if2...]] [-v]
            Usage: srvctl add asm [-l <lsnr_name>]
            Usage: srvctl add listener [-l <lsnr_name>] [-s] [-p "[TCP:]<port>[, ...][/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]"] [-o <oracle_home>] [-k <net_num>]
            Usage: srvctl add scan -n <scan_name> [-k <network_number> [-S <subnet>/<netmask>[/if1[|if2|...]]]]
            Usage: srvctl add scan_listener [-l <lsnr_name_prefix>] [-s] [-p [TCP:]<port>[/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]]
            Usage: srvctl add srvpool -g <pool_name> [-l <min>] [-u <max>] [-i <importance>] [-n "<server_list>"]
            Usage: srvctl add oc4j [-v]
            Usage: srvctl add filesystem -d <volume_device> -v <volume_name> -g <dg_name> [-m <mountpoint_path>] [-u <user>]
            Usage: srvctl add gns [-v] -d <domain> -i <vip_name|ip> [-k <network_number> [-S <subnet>/<netmask>[/<interface>]]]
            For detailed help on each command and object and its options use:
              srvctl <command> <object> -h

            • 3. Re: Need help adding diskgroups as resources
              Levi Pereira

              Hi,

              I did not realize the version of  Clusterware on the previous post, my fault.

               

              You are right,  does not exist  "srvctl add diskgroup" on 11.2.

               

              When you issue "alter diskgroup mount" using Sqlplus or using ASMCA to mount it the ASM Diskgroup is automatically registred in OCR.

               

              I suggest you use ASMCA to mount your diskgroup it should force register DISKGROUP in OCR.

               

              If it don't work post here alertog of clusterware relevant info only.

              • 4. Re: Need help adding diskgroups as resources
                user13053167

                This appears to be an issue within the cluster itself, ASM is functioning as normal.  However, when I dismount and mount the diskgroups, crs is throwing error messages about registering the resources.  I've been working with Oracle Support on this, but they haven't figured out a solution.  At this point, I'm probably just going to rebuild it.

                 

                Thanks for your help.