GI version 12.1.0.2.0
I am not able to create ASM diskgroup with the Normal redundancy from the SQL prompt and I was able to create the disk group with the External redundancy .Please see below
[oracle@localhost ~]$ /usr/sbin/oracleasm listdisks
DATA01
DATA02
DATA03
DATA04
DATA05
DATA06
DATA07
DATA08
DATA09
DATA10
SQL> select path,header_status from v$asm_disk;
PATH HEADER_STATU
-------------------------------------------------- ------------
ORCL:DATA09 FORMER
ORCL:DATA07 FORMER
ORCL:DATA06 FORMER
ORCL:DATA08 FORMER
ORCL:DATA10 FORMER
ORCL:DATA05 FORMER
ORCL:DATA03 FORMER
ORCL:DATA02 FORMER
ORCL:DATA04 FORMER
ORCL:DATA01 MEMBER
10 rows selected.
SQL> CREATE DISKGROUP data_m NORMAL REDUNDANCY FAILGROUP fg1 disk 'ORCL:DATA04' name data04, 'ORCL:DATA05' name data05, FAILGROUP fg2 disk 'ORCL:DATA06' name data06,
'ORCL:DATA10' name data10; 2
3 * ERROR at line 3:
ORA-15106: missing or invalid operating system disk locator string
I am able to create the Diskgroups with the External redundancy by using the same disks
SQL> CREATE DISKGROUP asm_datan external REDUNDANCY disk 'ORCL:DATA04' name data04;
Diskgroup created.
SQL> CREATE DISKGROUP asm_datan1 external REDUNDANCY disk 'ORCL:DATA05' name data05;
Diskgroup created.
SQL> CREATE DISKGROUP asm_datan2 external REDUNDANCY disk 'ORCL:DATA06' name data06;
Diskgroup created.
SQL> CREATE DISKGROUP asm_datan3 external REDUNDANCY disk 'ORCL:DATA10' name data10;
Diskgroup created.
Interestingly from ASMCA I am able to create the disk group with the Normal redundancy but not able to create from SQL prompt . Please help