Getting ASM to work
I'm new to using ASM disks. The server is Windows 2003 R2 64 Bit, database is 11.2.0.3. I have two raw partitions and I can see the diskgroups in the ASM instance:E:\11.2.0\grid\BIN>asmcmd
ASMCMD> ls -l
State Type Rebal Name
MOUNTED EXTERN N DATA/
MOUNTED EXTERN N FLASH/
ASMCMD>
SQL> select name from v$asm_diskgroup;
NAME
------------------------------
DATA
FLASH
SQL>
So everything seems ok on the ASM instance side. However when I try and create a small tablespace on the other database I get:
SQL> create tablespace testasm datafile size 1m;
create tablespace testasm datafile size 1m
*
ERROR at line 1:
ASMCMD> ls -l
State Type Rebal Name
MOUNTED EXTERN N DATA/
MOUNTED EXTERN N FLASH/
ASMCMD>
SQL> select name from v$asm_diskgroup;
NAME
------------------------------
DATA
FLASH
SQL>
So everything seems ok on the ASM instance side. However when I try and create a small tablespace on the other database I get:
SQL> create tablespace testasm datafile size 1m;
create tablespace testasm datafile size 1m
*
ERROR at line 1:
0