Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem adding single ASM disk on Windows (ora-15018, ora-15072)

644807Jan 30 2010 — edited Jan 30 2010
Hi all

I really thought it would be a simple enough process of adding a single ASM disk (no redundancy) but unfortunately I have hit a bit of a wall with the following:
ORA-15018: diskgroup cannot be created
ORA-15072: command requires at least 1 failure groups, discovered only 0

I have done everything as per official guideline (below); plus have looked all over for a solution. I am not sure if there is a missing step somewhere. I would definitely appreciate any help. FYI, my system specs are:
Windows 2008 Server Standard SP2
ORACLE 11.1.0.7.0



C:\Users\dwh.admin>diskpart
DISKPART> automount enable
Automatic mounting of new volumes enabled.
DISKPART> exit

<-------------restarted server---------------------->

DISKPART> list disk
Disk ### Status Size Free Dyn Gpt
Disk 0 Online 932 GB 0 B
Disk 1 Online 932 GB 0 B *

DISKPART> list volume
Volume ### Ltr Label Fs Type Size Status Info
Volume 0 C NTFS Partition 293 GB Healthy System
Volume 1 D NTFS Partition 293 GB Healthy
Volume 2 E NTFS Partition 346 GB Healthy
Volume 3 RAW Partition 931 GB Healthy

DISKPART> select Disk 1
Disk 1 is now the selected disk.

DISKPART> list partition
Partition ### Type Size Offset
Partition 1 Reserved 128 MB 17 KB
Partition 2 Primary 931 GB 129 MB

<-------------created ASM instance using asmtoolg (GUI)---------------------->

<-------------stamped disk for ASM using asmtoolg (GUI)---------------------->

C:\Users\dwh.admin>D:\app\dwh.admin\product\11.1.0\db_1\BIN\asmtool -list
NTFS \Device\Harddisk0\Partition1 300000M
NTFS \Device\Harddisk0\Partition2 300000M
NTFS \Device\Harddisk0\Partition3 353867M
ORCLDISKDATA1 \Device\Harddisk1\Partition2 953740M

C:\Users\dwh.admin>set ORACLE_SID=+ASM
C:\Users\dwh.admin> sqlplus / as sysdba
SQL> alter system set asm_diskstring='\\.\ORCLDISKDATA*' scope=spfile;

SQL> startup force;
SQL> show parameter asm_diskstring;
NAME TYPE VALUE
asm_diskstring string \\.\ORCLDISKDATA*

SQL> select state, header_status, substr(name, 1, 16) name, free_mb, substr(path,1,20) path from v$asm_disk;
STATE HEADER_STATU NAME FREE_MB PATH
NORMAL UNKNOWN 0 \\.\ORCLDISKDATA1


SQL> create diskgroup DG1 EXTERNAL REDUNDANCY DISK '\\.\ORCLDISKDATA1';
create diskgroup DG1 EXTERNAL REDUNDANCY DISK '\\.\ORCLDISKDATA1'
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15072: command requires at least 1 failure groups, discovered only 0
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 27 2010
Added on Jan 30 2010
1 comment
3,433 views