My Oracle Support Banner

Newly Created Diskgroups Are Not Getting Listed In The crsctl status res -t Output (Doc ID 2021817.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

After creating a diskgroup via sqlplus (or asmca or asmcmd), the new diskgroup does not show as a cluster resource in the 'crsctl stat resource -t' output.

For example:

Create the new diskgroup test in sqlplus:

SQL> CREATE DISKGROUP test EXTERNAL REDUNDANCY DISK '/dev/mapper/abc125' ATTRIBUTE 'compatible.asm'='11.2.0.0.0','compatible.rdbms'='11.1.0.0.0';
Diskgroup created

 The new diskgroup shows in '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  EXTERN  N         512   4096  1048576     15555     2250                0            2250              0             N  DATA/
MOUNTED  EXTERN  N         512   4096  1048576     10370     4972                0            4972              0             N  FRA/
MOUNTED  NORMAL  N         512   4096  1048576      6141     5089             2047            1521              0             Y  OCR/
MOUNTED  EXTERN  N         512   4096  1048576      6141     4973                0            4973              0             N  TEST/
ASMCMD>

 and also in 'sqlplus':

SQL> SELECT GROUP_NUMBER,NAME,TYPE,STATE,TOTAL_MB,FREE_MB  FROM V$ASM_DISKGROUP;

GROUP_NUMBER NAME                           TYPE   STATE         TOTAL_MB    FREE_MB
------------ ------------------------------ ------ ----------- ---------- ----------
           1 DATA                           EXTERN MOUNTED          15555       2250
           2 FRA                            EXTERN MOUNTED          10370       4972
           3 OCR                            NORMAL MOUNTED           6141       5089
           4 TEST                           EXTERN MOUNTED           6141       4973

SQL>

 however it's missing in the 'crsctl stat res -t' output (here with filter -w 'TYPE = ora.diskgroup.type'):

$ crsctl stat res -w 'TYPE = ora.diskgroup.type' -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       racnode1                                       
ora.FRA.dg
               ONLINE  ONLINE       racnode1                                       
ora.OCR.dg
               ONLINE  ONLINE       racnode1 
$

 In the CRS daemon log (<GI home>/log/><node>/crsd/crsd.log) the following messages are recorded:


2015-08-18 07:37:36.890: [UiServer][1180911936]{1:25306:6130} Container [ Name: UI_REGISTER
        API_HDR_VER:
        TextMessage[2]
        ASYNC_TAG:
        TextMessage[1]
        ATTR_LIST:
        TextMessage[NAME=ora.TEST.dg^BTYPE=ora.diskgroup.type^BVERSION=11.2.0.4.0^B^A]
        CLIENT:
        TextMessage[]
        CLIENT_NAME:
        TextMessage[/u01/app/11.2.0/grid/bin/oracle]
        CLIENT_PID:
        TextMessage[15979]   
        CLIENT_PRIMARY_GROUP:
        TextMessage[oinstall]
        LOCALE:
        TextMessage[AMERICAN_AMERICA.AL32UTF8]
        NO_WAIT_TAG:
        TextMessage[1]
        QUEUE_TAG:
        TextMessage[1]
        RESOURCE:
        TextMessage[ora.TEST.dg]
]
...
2015-08-18 07:37:36.901: [UiServer][1180911936]{1:25306:6131} Container [ Name: UI_START
        API_HDR_VER:
        TextMessage[2]
        ASYNC_TAG:
        TextMessage[1]
        CLIENT:
        TextMessage[]
        CLIENT_NAME:
        TextMessage[/u01/app/11.2.0/grid/bin/oracle]
        CLIENT_PID:
        TextMessage[15979]
        CLIENT_PRIMARY_GROUP:
        TextMessage[oinstall]
        EVENT_TAG:
        TextMessage[1]
        HOST:
        TextMessage[racnode1]
        HOST_TAG:
        TextMessage[1]
        LOCALE:
        TextMessage[AMERICAN_AMERICA.AL32UTF8]
        NO_WAIT_TAG:
        TextMessage[1]
        QUEUE_TAG:
        TextMessage[1]
        RESOURCE:
        TextMessage[ora.TEST.dg^AUSR_ORA_OPI=true]
]
2015-08-18 07:37:36.901: [UiServer][1180911936]{1:25306:6131} Sending message to PE. ctx= 0x7f4b3808d0d0, Client PID: 15979
2015-08-18 07:37:36.976: [   CRSPE][1178810688]{1:25306:6130} Set LAST_SERVER to racnode1 for [ora.TEST.dg racnode1 1]
2015-08-18 07:37:36.976: [  CRSSEC][1178810688]{1:25306:6130} Exception: Authorizer checkPermission failed with id: grid/oinstall,/GI=0 and perm: x
2015-08-18 07:37:36.976: [   CRSPE][1178810688]{1:25306:6130} Register Resource Opora.TEST.dg] has failed:CRS-2566: User 'grid' does not have sufficient permissions to operate on resource 'ora.LISTENER.lsnr', which is part of the dependency specification.

2015-08-18 07:37:36.977: [   CRSPE][1178810688]{1:25306:6130} PE Command [ Register|Update Resource : ora.TEST.dg : 0x7f4b34307210 ] has completed
2015-08-18 07:37:36.977: [UiServer][1180911936]{1:25306:6130} Container [ Name: ORDER
        MESSAGE:
        TextMessage[CRS-2566: User 'grid' does not have sufficient permissions to operate on resource 'ora.LISTENER.lsnr', which is part of the dependency specification.]
        MSGTYPE:
        TextMessage[1]
        OBJID:
        TextMessage[ora.TEST.dg]
        WAIT:
        TextMessage[0]
]
2015-08-18 07:37:36.977: [ COMMCRS][1180911936]clscsendx: (0x7f4b30020f10) Connection not active

2015-08-18 07:37:36.977: [UiServer][1180911936]{1:25306:6130} CS(0x7f4b3004e7b0)Error sending msg over socket.6
2015-08-18 07:37:36.977: [   CRSPE][1178810688]{1:25306:6130} UI Command [Register|Update Resource : ora.TEST.dg : 0x7f4b34307210] is replying to sender.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.