Creating ASM disk group in Windows
Windows 2008 + Oracle RAC 10.2.0.4
WARNING : At ASM there is a limit (independent of the OS, but other than Exadata) – You can not use drives larger than 2 TB (2,097,152 MB). Otherwise, when you create a disk group, you get an error message:
ORA-15018: diskgroup can not be created
ORA-15099: disk XXX is larger than
maximum size of 2,097,152 MBs
To create an ASM disk group you need:
– On the drive is connected to the operating system, create a blank, unformatted partition (drive letter assigned to it is not necessary if it is assigned automatically – it must be removed).
– Create a new disk group (on disk should stand stamp, but it can be done once during the creation of the group).
Create a partition on the Windows
You can do this either through the GUI or the command line. For ASM is recommended to create extended partitions (extended). From GUI (GUI) to create an extended partition does not work, so you have to use the command line tool diskpart.
WARNING : On one disk MBR, you can create up to four primary partitions (GPT disk to no such restriction.)
So Server Manager look at the wheels which have not yet created partition.
Create a partition on the Windows using the GUI Computer Management (Server Manager)
Run the utility Computer Management ( Server Manager ) – Disk Management ( Disk Management ) to right click on an empty space on the disc (Unallocated) and select the menu New Simple Volume ( New Simple Volume ). In this case, a A primary partition ( Primary Partition ).
Automatically selects the entire disk, but can be isolated and part of it.
WARNING : It is not necessary to assign disks for ASM no letters!
Format disk is not necessary, on it there should be no file system, ie, it must be RAW.
Check again that everything is properly selected. Press Finish .
After creating a primary partition disks Server Manager will look like this:
Creating a partition on the disk using the Windows command line (diskpart.exe)
Run diskpart and give the following commands.
– Run diskpart
c: & gt; diskpart.exe
– Get the list of drives in the system
DISKPART & gt; list disk
– Select from a list of one particular disc
DISKPART & gt; select disk 24
– Create an extended partition on it (the entire disk)
DISKPART & gt; create partition extended
if you want to limit the size of the partition, then the team should be such size is specified in megabytes
DISKPART & gt; create partition extended size = 1024
– Create a logical partition
DISKPART & gt; create partition logical
After creating a logical partition disks Server Manager will look like this:
Check drive letters on other nodes
WARNING : If you have configured RAC. When you create partitions on a single node, you do not assign letters to the newly formatted partition, but Windows on another node, automatically tries to assign a drive letter to this section. So you need to go through all the nodes and remove the designated letter.
On the other nodes run the utility Computer Management ( Server Manager ) – Disk Management ( Disk Management ) and perform Refresh ( Refresh ).
There will be a window with the question of whether to format the new drives – you need to press Cancel ( Cancel ).
Right-click on a blank disk and select the menu Change Drive Letter and Paths .
Press Remove .
Confirm delete letters by pressing Yes .
Creating ASM disk group
ASM disk group can be created using the utility Database Configuration Assistant (This utility lets you immediately when creating the disk group affix stamp on the disks that will be included in this group).
From ASM_HOME or GRID_HOME run – Database Configuration Assistant .
If you have a RAC configuration in the list will display all nodes (servers) where you installed ASM. You must select all of the nodes.
Enter the password for the SYS user ASM (specified when ASM, the default is typically oracle).
In this example, already have created disk groups. They can add drives. But we create another completely new group, so click Create New .
Enter the group name and select the level of data redundancy. High and Normal – a redundancy that is provided by ASM, ie the same data is written in parallel to several disks. In this example, select External , ie, using ASM redundancy is not guaranteed. It is provided by RAID.
If you do not have RAID is highly recommended to select High or Normal .
Here, in the list of drives have not yet seen a single disk, because they have not yet set the mark (stamp) – you need to put it, click Stamp Disks .
Enter the prefix matches the name of the group (in this example – DATA2) and select the drives that will be included in this disk group.
Select disks, press OK .
Wait until the process is complete.
All. The disk group is created.