Add disk in a diskgroup

[root@oracleDBlinux.domain.com ~]# which oracleasm

/usr/sbin/oracleasm

[root@oracleDBlinux.domain.com ~]# /usr/sbin/oracleasm listdisks

DATA001

DATA002

DATA003

[root@oracleDBlinux.domain.com ~]# /usr/sbin/oracleasm listdisks | xargs oracleasm querydisk -p |grep /dev/emcpwr

/dev/emcpwra1: LABEL="DATA001" TYPE="oracleasm"

/dev/emcpwrb1: LABEL="DATA002" TYPE="oracleasm"

/dev/emcpwrc1: LABEL="DATA003" TYPE="oracleasm"

 [root@oracleDBlinux.domain.com ~]# lvmdiskscan |grep /dev/emcpwr

  /dev/emcpwra1 [     802.48 GiB]

  /dev/emcpwrb1 [     802.48 GiB]

  /dev/emcpwrc1 [     802.48 GiB]

  /dev/emcpwrd1 [     802.48 GiB] ----------------------------------------------> Not added in any asm disk

[root@oracleDBlinux.domain.com ~]#  cat /proc/partitions |grep emcpwr

 120       32  841466880 emcpwrc

 120       33  841460571 emcpwrc1

 120        0  841466880 emcpwra

 120        1  841460571 emcpwra1

 120       16  841466880 emcpwrb

 120       17  841460571 emcpwrb1

 120       48  841466880 emcpwrd

 120       49  841460571 emcpwrd1

[root@oracleDBlinux.domain.com ~]# /usr/sbin/oracleasm createdisk DATA004 /dev/emcpwrd1

Device "/dev/emcpwrd1" is already labeled for ASM disk ""

Solution :

[root@oracleDBlinux.domain.com ~]# /usr/sbin/oracleasm renamedisk /dev/emcpwrd1 DATA004

WARNING: Changing the label of an disk marked for ASM is a very dangerous

         operation.  If this is really what you mean to do, you must

         ensure that all Oracle and ASM instances have ceased using

         this disk.  Otherwise, you may LOSE DATA.

If you are really sure you wish to change the label and are sure that

all of your Oracle and ASM instances have ceased using the disk,

rerun this command with the '-f' option.

[root@oracleDBlinux.domain.com ~]# /usr/sbin/oracleasm renamedisk -f /dev/emcpwrd1 DATA004

Writing disk header: done

Instantiating disk "DATA004": done

[root@oracleDBlinux.domain.com ~]#

[root@oracleDBlinux.domain.com ~]# /usr/sbin/oracleasm listdisks

DATA001

DATA002

DATA003

DATA004

sqlplus / as sysasm 

SQL> ALTER DISKGROUP FRA ADD DISK 'ORCL:DATA004' REBALANCE POWER 2 WAIT ;

ALTER DISKGROUP FRA ADD DISK '/dev/emcpwrd1' REBALANCE POWER 2 WAIT

*

ERROR at line 1:

ORA-15032: not all alterations performed

ORA-15031: disk specification '/dev/emcpwrd1' matches no disks

ORA-15025: could not open disk "/dev/emcpwrd1"

ORA-27041: unable to open file

Linux-x86_64 Error: 13: Permission denied

Additional information: 42

Additional information: 1

Additional information: 1

chmod 660 /dev/emcpwrd1

chown grid:oinstall /dev/emcpwrd1

SQL> ALTER DISKGROUP FRA ADD DISK '/dev/emcpwrd1' REBALANCE POWER 2 WAIT ;

ALTER DISKGROUP FRA ADD DISK '/dev/emcpwrd1' REBALANCE POWER 2 WAIT

*

ERROR at line 1:

ORA-15032: not all alterations performed

ORA-15031: disk specification '/dev/emcpwrd1' matches no disks

ORA-15014: path '/dev/emcpwrd1' is not in the discovery set

SELECT NVL(a.name, '[CANDIDATE]') disk_group_name , b.path disk_file_path , b.name disk_file_name

    FROM v$asm_diskgroup a RIGHT OUTER JOIN v$asm_disk b USING (group_number)

    ORDER BY a.name;

DISK_GROUP_NAME                DISK_FILE_PATH              DISK_FILE_NAME

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

DATA                           ORCL:DATA001                DATA001

DATA                           ORCL:DATA002                DATA002

FRA                            ORCL:DATA003                DATA003

[CANDIDATE]                    ORCL:DATA004

SQL> create pfile='/home/grid/pfile.ora' from spfile ;

File created.

SQL> ! cat /home/grid/pfile.ora

+ASM.__oracle_base='/u01/app/grid'#ORACLE_BASE set from in memory value

*.asm_diskgroups='DATA','FRA'

*.asm_diskstring='ORCL:DATA003,ORCL:DATA002,ORCL:DATA001'

*.asm_power_limit=1

*.large_pool_size=12M

*.remote_login_passwordfile='EXCLUSIVE'

alter system set asm_diskstring='ORCL:DATA003,ORCL:DATA002,ORCL:DATA001,ORCL:DATA004' sid='*'  ; ---This  will not work

alter system set asm_diskstring='/dev/emcpwr*' sid='*'  ; ---this will not work 

SQL> alter system set asm_diskstring='ORCL:DATA003,ORCL:DATA002,ORCL:DATA001,ORCL:DATA004' sid='*'  ;

alter system set asm_diskstring='ORCL:DATA003,ORCL:DATA002,ORCL:DATA001,ORCL:DATA004' sid='*'

*

ERROR at line 1:

ORA-02097: parameter cannot be modified because specified value is invalid

ORA-15014: path 'ORCL:DATA001' is not in the discovery set

SQL> ALTER DISKGROUP FRA ADD DISK 'ORCL:DATA004' REBALANCE POWER 2 WAIT ;

Diskgroup altered.

SQL> select name , total_mb/1024 , free_mb/1024 from v$asm_diskgroup ;

NAME                           TOTAL_MB/1024 FREE_MB/1024

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

FRA                               1604.95703   1585.57031

DATA                              1604.95703   577.573242

SQL>

SQL> SELECT NVL(a.name, '[CANDIDATE]') disk_group_name , b.path disk_file_path , b.name disk_file_name

    FROM v$asm_diskgroup a RIGHT OUTER JOIN v$asm_disk b USING (group_number)

    ORDER BY a.name;  2    3

Disk Group Name Path              File Name

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

DATA            ORCL:DATA001      DATA001

                ORCL:DATA002      DATA002

FRA             ORCL:DATA003      DATA003

                ORCL:DATA004      DATA004