The space of the ASM disk group is insufficient.
[Oracle @ linux117 ~] $ ID
Uid = 1101 (Oracle) gid = 1000 (oinstall) groups = 1000 (oinstall), 1200 (DBA), 1300 (asmdba), 1400 (region)
[Oracle @ linux117 ~] $ 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 6 0 6 0 n data/
[Oracle @ linux117 ~] $ ID
Uid = 1101 (Oracle) gid = 1000 (oinstall) groups = 1000 (oinstall), 1200 (DBA), 1300 (asmdba), 1400 (region)
[Oracle @ linux117 ~] $. Oraenv
Oracle_sid = [orcl]? + ASM
The Oracle base for ORACLE_HOME =/u01/APP/11.2.0/grid is/u01/APP/Oracle
[Oracle @ linux117 ~] $ Sqlplus/As sysdba
SQL * Plus: Release 11.2.0.1.0 production on Thu Aug 30 10:56:33 2012
Copyright (c) 1982,200 9, Oracle. All rights reserved.
Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the Automatic Storage Management Option
SQL> select status from V $ instance;
Status
------------
Started
SQL> alter diskgroup data add disk 'orcl: vdisk2 ';
Alter diskgroup data add disk 'orcl: vdisk2'
*
Error at line 1:
ORA-15032: not all alterations saved med
ORA-15260: Permission denied on ASM disk group
SQL> shutdown immediate;
ORA-01031: insufficient privileges
SQL> select * from V $ asm_diskgroup;
1 Data 512 4096
1048576 mounted extern 511993 6 0
511987 0 6 0
11.2.0.0.0
10.1.0.0.0 n
SQL> select path from V $ asm_disk;
Orcl: vdisk2
Orcl: vdisk1
[Oracle @ linux117 ~] $ Su-grid
[Grid @ linux117 ~] $ ID
Uid = 1100 (GRID) gid = 1000 (oinstall) groups = 1000 (oinstall), 1100 (asmadmin), 1200 (DBA), 1300 (asmdba), 1301 (asmoper)
SQL> Conn/As sysasm
Connected.
SQL> alter diskgroup data add disk 'orcl: vdisk2 ';
Diskgroup altered.
SQL>
--------------------------------------------------------------------------------
Udid
----------------------------------------------------------------
Product create_da mount_dat repair_timer reads
------------------------------------------------------------------------
Writes read_errs write_errs read_time write_time bytes_read bytes_written
-------------------------------------------------------------------------
P hash_value hot_reads hot_writes hot_bytes_read hot_bytes_written cold_reads
------------------------------------------------------------------------
Cold_writes cold_bytes_read cold_bytes_written v sector_size failgro
---------------------------------------------------------------
SQL> set head off
SQL>/
0 0 0 3915934782 closed candidate online
Normal unknown
ASM library-generic Linux, version 2.0.4 (kabi_v2) 221183
0 0 0 0
Vdisk2
Orcl: vdisk2
0
0
N 512 regular
1 0 16777216 3915934781 cached Member Online
Normal unknown
ASM library-generic Linux, version 2.0.4 (kabi_v2) 511993
511993 6 0 511987 vdisk1
Vdisk1 vdisk1
Orcl: vdisk1
16-apr-12 28-aug-12 0 384822
224042 0 0 875.256 1803.663 2.7934e + 10 2725892096
3076181572 0 0 0 381455
134792 2.7920e + 10 2360324096 n 512 regular
SQL> alter diskgroup data add disk 'orcl: vdisk2 ';
SQL> exit
[Oracle @ linux117 ~] $ 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 733176 0 56444 0 n data/