8 Replies Latest reply: Feb 23, 2014 6:26 PM by Aritra-Oracle RSS

Unable to Create ASM Diskgroup ORA-15020 and ORA-15018

user10341747 Newbie
Currently Being Moderated

Hello Team,

 

Unable to create ASM diskgroup with following error:

 

 

SQL> create diskgroup data_asm1 external redundancy disk '/dev/sdf*';

create diskgroup data_asm1 external redundancy disk '/dev/sdf*'

*

ERROR at line 1:

ORA-15018: diskgroup cannot be created

ORA-15020: discovered duplicate ASM disk "DATA_ASM1_0000"

 

ASM Diskstring

 

SQL> show parameter asm_diskstring

 

 

NAME                                 TYPE        VALUE

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

asm_diskstring                       string      /dev/oracleasm/disks/DISK*, /dev/sd*

 

Please let me know how to i solve this issue

 

Regards,

  • 1. Re: Unable to Create ASM Diskgroup ORA-15020 and ORA-15018
    Aritra-Oracle Journeyer
    Currently Being Moderated

    Hi ,

     

     

    SQL> create diskgroup data_asm1 external redundancy disk '/dev/sdf*';

    create diskgroup data_asm1 external redundancy disk '/dev/sdf*'

    *

    ERROR at line 1:

    ORA-15018: diskgroup cannot be created

    ORA-15020: discovered duplicate ASM disk "DATA_ASM1_0000"


    Does same /dev/sdf*device is labelled at ASMLIB label.

    If so ,does that ASMlib label is visible using below commands,


    $ kfod disks=all asm_diskstring='/dev/oracleasm/disks/DISK*'


    If so because of this same base device is getting discovered through two path resulting this issue.


    if you want to use ASMLIB ,


    + change ownership  of device /dev/sdf* to root:disk


    + create the diskgroup with ASMLIB label only,rather sd* device.


    Regards,

    Aritra

  • 2. Re: Unable to Create ASM Diskgroup ORA-15020 and ORA-15018
    user10341747 Newbie
    Currently Being Moderated

    Hello Aritra,

     

    Below is the output result of $ kfod disks=all asm_diskstring='/dev/oracleasm/disks/DISK*

     

    [oracle@rac3 bin]$ ./kfod disks=all asm_diskstring='/dev/oracleasm/disks/DISK*

    '

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

    Disk          Size Path                                     User     Group  

    ================================================================================

       1:      10236 Mb /dev/oracleasm/disks/DISK1               oracle   dba    

       2:      10236 Mb /dev/oracleasm/disks/DISK2               oracle   dba    

       3:      10236 Mb /dev/oracleasm/disks/DISK3               oracle   dba    

       4:       5114 Mb /dev/oracleasm/disks/DISK4               oracle   dba    

       5:       5114 Mb /dev/oracleasm/disks/DISK5               oracle   dba    

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

    ORACLE_SID ORACLE_HOME                                                         

    ================================================================================

         +ASM1 /u01/app/11.2.0/grid                                                

         +ASM2 /u01/app/11.2.0/grid                                                

    [oracle@rac3 bin]$

     

    Please let me know what to set for asm_diskstring. if i do below:

     

    =======================================================

    SQL> show parameter asm_diskstring

     

     

    NAME                                 TYPE        VALUE

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

    asm_diskstring                       string      /dev/oracleasm/disks/DISK*, /d

                                                     ev/sd*

    SQL> alter system set asm_diskstring='/dev/oracleasm/disks/DISK*' sid='*';

     

    System altered.

     

    SQL> show parameter asm_diskstring

     

     

    NAME                                 TYPE        VALUE

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

    asm_diskstring                       string      /dev/oracleasm/disks/DISK*

    SQL>

     

    SQL> create diskgroup grid external redundancy disk '/dev/sdf1';

    create diskgroup grid external redundancy disk '/dev/sdf1'

    *

    ERROR at line 1:

    ORA-15260: permission denied on ASM disk group

     

    OR

     

    SQL> create diskgroup grid external redundancy disk '/dev/oracleasm/DISK4';

    create diskgroup grid external redundancy disk '/dev/oracleasm/DISK4'

    *

    ERROR at line 1:

    ORA-15260: permission denied on ASM disk group

     

    SQL>

     

    ===============================================================

     

    [root@rac3 dev]# ls -lta sd*

    brw-r----- 1 root disk 8, 97 Feb 17 03:36 sdg1

    brw-r----- 1 root disk 8, 33 Feb 17 03:36 sdc1

    brw-r----- 1 root disk 8, 81 Feb 17 03:36 sdf1

    brw-r----- 1 root disk 8, 49 Feb 17 03:36 sdd1

    brw-r----- 1 root disk 8, 17 Feb 17 03:36 sdb1

    brw-r----- 1 root disk 8,  1 Feb 17 03:35 sda1

    brw-r----- 1 root disk 8,  0 Feb 17 03:34 sda

    brw-r----- 1 root disk 8,  2 Feb 17 03:34 sda2

    brw-r----- 1 root disk 8, 16 Feb 17 03:34 sdb

    brw-r----- 1 root disk 8, 32 Feb 17 03:34 sdc

    brw-r----- 1 root disk 8, 48 Feb 17 03:34 sdd

    brw-r----- 1 root disk 8, 64 Feb 17 03:34 sde

    brw-r----- 1 root disk 8, 80 Feb 17 03:34 sdf

    brw-r----- 1 root disk 8, 96 Feb 17 03:34 sdg

    [root@rac3 dev]#

     

     

    Regards,

  • 3. Re: Unable to Create ASM Diskgroup ORA-15020 and ORA-15018
    teits Journeyer
    Currently Being Moderated

    Hi

    Change the permission and owner of the block devices e.g

    #chown -R grid:asmadmin /dev/sdx

    #chown -R 660/dev/sdx

     

    HTH

    Tobi

  • 4. Re: Unable to Create ASM Diskgroup ORA-15020 and ORA-15018
    user10341747 Newbie
    Currently Being Moderated

    Hello teits,

     

    I have change the owner of the block devices to root:asmadmin with that I am able to create the diskgroup with external redundancy ...

    but when i wanted to add the diskgroup (grid) for OCR ,shows the following error:

     

    [root@rac3 dev]# ls -ltr sd*

    brw-r----- 1 root disk     8, 96 Feb 17 15:23 sdg

    brw-r----- 1 root disk     8, 80 Feb 17 15:23 sdf

    brw-r----- 1 root disk     8, 64 Feb 17 15:23 sde

    brw-r----- 1 root disk     8, 48 Feb 17 15:23 sdd

    brw-r----- 1 root disk     8, 32 Feb 17 15:23 sdc

    brw-r----- 1 root disk     8, 16 Feb 17 15:23 sdb

    brw-r----- 1 root disk     8,  2 Feb 17 15:23 sda2

    brw-r----- 1 root disk     8,  0 Feb 17 15:23 sda

    brw-r----- 1 root disk     8,  1 Feb 17 15:24 sda1

    brw-r----- 1 root disk     8, 49 Feb 17 15:25 sdd1

    brw-r----- 1 root disk     8, 17 Feb 17 15:25 sdb1

    brw-r----- 1 root disk     8, 33 Feb 17 15:25 sdc1

    brw------- 1 root asmadmin 8, 81 Feb 17 15:25 sdf1

    brw------- 1 root asmadmin 8, 97 Feb 17 15:25 sdg1

     

    [root@rac3 dev]# cd /u01/app/11.2.0/grid/bin/

    [root@rac3 bin]# ./ocrconfig -add +grid

    PROT-30: The Oracle Cluster Registry location to be added is not accessible

    [root@rac3 bin]#

     

    ===========================================

    CRSD.log

     

    2014-02-17 23:12:59.339: [  OCRASM][2814258064]proprasmdvch: Failed to open OCR location [+grid] error [26]

    2014-02-17 23:12:59.340: [  OCRRAW][2814258064]propriodvch: Error  [8] returned device check for [+grid]

    2014-02-17 23:12:59.340: [  OCRRAW][2814258064]dev_replace: master could not verify the new disk (8)

    [  OCRSRV][2814258064]proas_replace_disk: Failed in changing configurations in the Master 8

    2014-02-17 23:13:34.055: [UiServer][2570845072] S(0xc90c480): set Properties ( root,0xc931d80)

    2014-02-17 23:13:34.067: [UiServer][2572946320] processMessage called

    2014-02-17 23:13:34.068: [UiServer][2572946320] Sending message to PE. ctx= 0xc948010

    2014-02-17 23:13:34.070: [   CRSPE][2577148816] Processing PE command id=268. Description: [Stat Resource : 0xbc7b830]

    2014-02-17 23:13:34.070: [   CRSPE][2577148816] PE Command [ Stat Resource : 0xbc7b830 ] has completed

    2014-02-17 23:13:34.070: [   CRSPE][2577148816] UI Command [Stat Resource : 0xbc7b830] is replying to sender.

    2014-02-17 23:13:34.211: [UiServer][2572946320] Done for ctx=0xc948010

     

     

    [root@rac3 rac3]#

     

     

     

    Regards,

  • 5. Re: Unable to Create ASM Diskgroup ORA-15020 and ORA-15018
    Aritra-Oracle Journeyer
    Currently Being Moderated

    Hi,

     

    SQL> create diskgroup grid external redundancy disk '/dev/oracleasm/DISK4';

    create diskgroup grid external redundancy disk '/dev/oracleasm/DISK4'

    *

    ERROR at line 1:

    ORA-15260: permission denied on ASM disk group


    You need to run that command after logging as "/as sysasm"


    brw------- 1 root asmadmin 8, 81 Feb 17 15:25 sdf1

    brw------- 1 root asmadmin 8, 97 Feb 17 15:25 sdg1


    This failed as ownership of this device is root ,they should be under root:disk .


    If you are using asm_diskstring as /dev/oracleasm/DISK* ,then you should not use /dev/sdNn devices ,rather need to  use /dev/oracleasm/DISK* devices.

    Same is applicable any disk operation .


    Regards,

    Aritra

  • 6. Re: Unable to Create ASM Diskgroup ORA-15020 and ORA-15018
    teits Journeyer
    Currently Being Moderated

    Hi,

     

    check your +grid disk diskgroup status. show result

     

    1. $ crsctl status res ora.GRID.dg  OR $ crsctl status res ora.grid.dg

    Note the case sensitivity of crs resource

     

     

    2. run below as grid user. (need to set SID=+ASM? if not set already)

    ASMCMD> lsdg

     

     

    Tobi

  • 7. Re: Unable to Create ASM Diskgroup ORA-15020 and ORA-15018
    user10341747 Newbie
    Currently Being Moderated

    Hi Tobi,

     

    I checked the status of the res GRID.dg ... it was offline on second node. Logged on second node and checked the status of it viz:v$asm_diskgroup, it was dismount. I mounted it and then try to add the newly added diskgroup(+GRID) with OCR and viola it worked....

     

    ========================================================

     

    ora.GRID.dg

                   ONLINE  ONLINE       rac3                                       

                   OFFLINE OFFLINE      rac4                                       

     

    SQL> select group_number,name,state,type from v$asm_diskgroup;

     

     

    GROUP_NUMBER NAME                           STATE       TYPE

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

               1 DATA                           MOUNTED     EXTERN

               0 GRID                           DISMOUNTED

     

     

    SQL> alter diskgroup grid mount;

     

     

    Diskgroup altered.

     

     

    SQL>  select group_number,name,state,type from v$asm_diskgroup;

     

     

    GROUP_NUMBER NAME                           STATE       TYPE

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

               1 DATA                           MOUNTED     EXTERN

               2 GRID                           MOUNTED     EXTERN

     

    ==============================================

    ora.GRID.dg

                   ONLINE  ONLINE       rac3                                       

                   ONLINE  ONLINE       rac4                                       

     

    ===============================================

     

    [root@rac3 bin]# ./ocrcheck

    Status of Oracle Cluster Registry is as follows :

             Version                  :          3

             Total space (kbytes)     :     262120

             Used space (kbytes)      :       2804

             Available space (kbytes) :     259316

             ID                       :   48011651

             Device/File Name         :      +DATA

                                        Device/File integrity check succeeded

             Device/File Name         :      +grid

                                        Device/File integrity check succeeded

     

     

                                        Device/File not configured

     

     

                                        Device/File not configured

     

     

                                        Device/File not configured

     

     

             Cluster registry integrity check succeeded

     

     

             Logical corruption check succeeded

     

     

    ==========================================================================================

    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     20472    16263                0           16263              0             N  DATA/

    MOUNTED  EXTERN  N         512   4096  1048576      5114     4751                0            4751              0             N  GRID/

     

    ======================================================================================================

     

    Thank you very much, appreciated..

    Thank you Aritra .

     

    Guys you rock.

     

    Regards,

  • 8. Re: Unable to Create ASM Diskgroup ORA-15020 and ORA-15018
    Aritra-Oracle Journeyer
    Currently Being Moderated

    Hi,

     

    You are welcome...

     

    Regards,
    Aritra

Legend

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