Re: Disk addition to diskgroup

Posted by satish on Nov 09, 2021; 6:26am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Disk-addition-to-diskgroup-tp10404p10405.html

CREATE DISKGROUP TEST123 EXTERNAL REDUNDANCY DISK 'ORCL:DATADISK9';
CREATE DISKGROUP TEST123 EXTERNAL REDUNDANCY DISK 'ORCL:DATADISK9'
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15031: disk specification 'ORCL:DATADISK9' matches no disks


SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[griduat@erpuatdb1 ~]$ cd /dev/oracleasm/disks/
[griduat@erpuatdb1 disks]$ ls
ARCH01 ARCH05 DATA04 DATA08 DATA12 DATA16 DATA20 DATA24 OCRVOTEDISK3 REDO1DISK1 REDO1DISK4 REDO1DISK8 REDO2DISK2 REDO2DISK6
ARCH02 DATA01 DATA05 DATA09 DATA13 DATA17 DATA21 DATA25 OCRVOTEDISK4 REDO1DISK10 REDO1DISK5 REDO1DISK9 REDO2DISK3 REDO2DISK7
ARCH03 DATA02 DATA06 DATA10 DATA14 DATA18 DATA22 OCRVOTEDISK1 OCRVOTEDISK5 REDO1DISK2 REDO1DISK6 REDO2DISK1 REDO2DISK4 REDO2DISK8
ARCH04 DATA03 DATA07 DATA11 DATA15 DATA19 DATA23 OCRVOTEDISK2 OCRVOTEDISK6 REDO1DISK3 REDO1DISK7 REDO2DISK10 REDO2DISK5 REDO2DISK9
[griduat@erpuatdb1 disks]$ sqlplus "/as sysasm";

SQL*Plus: Release 12.1.0.2.0 Production on Tue Nov 9 11:50:42 2021

Copyright (c) 1982, 2014, Oracle. All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL>
SQL> CREATE DISKGROUP TEST123 EXTERNAL REDUNDANCY DISK '/dev/oracleasm/disks/DATA09';
CREATE DISKGROUP TEST123 EXTERNAL REDUNDANCY DISK '/dev/oracleasm/disks/DATA09'
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15031: disk specification '/dev/oracleasm/disks/DATA09' matches no disks
ORA-15014: path '/dev/oracleasm/disks/DATA09' is not in the discovery set


SQL>
SQL> sho parameter dis

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string OCRVOTE1, REDO1ADG, REDO1BDG,
FRADG, REDO2ADG, REDO2BDG, DAT
ADG
asm_diskstring string ORCL:*
SQL>