ASM盘组空间不足。
[oracle@Linux117 ~]$ id
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1200(dba),1300(asmdba),1400(oper)
[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 511993 6 0 6 0 N DATA/
[oracle@Linux117 ~]$ id
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1200(dba),1300(asmdba),1400(oper)
[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, 2009, Oracle. All rights reserved.
Connected to:
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 performed
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 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 56444 0 56444 0 N DATA/