The following are the errors seen during tablespace creation in an Oracle DB with ASM.
NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::perform: Performing Inline Action Command: CREATE TABLESPACE “RRWEBC_IAS_WEBCENTER” EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO DATAFILE ‘+DATA’ SIZE 250M AUTOEXTEND ON NEXT 250M MAXSIZE UNLIMITED
2010-02-09 23:27:35.187 ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: ORA-01119: error in creating database file ‘+DATA’
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15041: diskgroup space exhausted
The related disk group could have run out of space, due to more number of tablespaces, in this case there were 84. Firstly look for space, and appropriately cleanup some of them or just new disks.
select NAME, OS_MB, TOTAL_MB, FREE_MB from v$asm_disk;
drop tablespace <NAME> including contents and datafiles;
To Increase Disk Space:
alter diskgroup DISK1 rebalance power 11;
alter diskgroup DISK2 add disk ‘path’;
alter diskgroup test_dg add disk ‘/dev/hdb10′,’/dev/hdb11’;