Oracle 11g Release 2 for Windows was just released this month. With the availability of the grid infrastructure in this version, I plan to install it on my Windows 7 desktop to see what it can do even if it is just on stand alone environment.
In order for database to use Automatic Storage Management (ASM), it requires the Grid Infrastructure. In addition to ASM, Grid Infrastructure will also provide Oracle Restart to manage the Oracle processes (database, listener, and ASM).
One of the first issues I’ve encountered is the new requirement that the clusterware files (OCR & Voting) must be on ASM. I have to admit even though I’ve done ASM on Solaris and Linux before, but never on Windows. Since this is mandatory, I will give it a try. And since I will use ASM for clusterware files, I plan to use it for database data files as well.
In order to use ASM, I’m required to provide the unformatted (raw) basic disks. I plan to use the existing disks without adding new physical ones. Fortunately in Windows 7, I can use the disk management (diskmgmt.msc) tool to shrink volume and create a new logical disk from claimed space. Note that you may have multiple physical disks on your machine, but ASM supports and recognizes only logical drives on the Basic disk (not Dynamic disk). Click here if you’re interested in differences between Basic and Dynamic disks.
Once data volume is shrunk, I can create a new volume and then a logical drive. The new drive must not be formatted or having a drive letter assigned to it. Here is the guidelines from Oracle document on “create disk partitions”.
To use ASM with direct attached storage or SAN, the disks must be stamped with a header. This can be accomplished by using either asmtool (command-line version) or asmtoolg (GUI version). Since we will install Oracle grid infrastructure in interactive mode, the asmtoolg will be called during the configuration. Somehow, if I tried to launch the asmtoolg outside Oracle grid infrastructure installation, I always encountered error with no disks found. However, within the Oracle grid infrastructure installation, there is no issue.
In general, the installation went well. I’ve encountered few issues which I’ve documented them in the documents below. The snapshots of steps here are for educational purpose only.
Windows 7 – Disk Preparation for ASM
Oracle 11g R2 Grid Infrastructure for Standalone Server Installation on Windows
Oracle 11g R2 Software Installation for Single Instance Database on Windows
Oracle 11g R2 Database Creation using ASM on Windows
August 4th, 2010 9:27 pm
can you explain more about ASMCA please
August 4th, 2010 11:09 pm
The ASMCA (Oracle ASM Configuration Assistant) is just a stand-alone tool supporting installation and configuration of Oracle ASM instances, disk groups, volumes, and Oracle ACFS File System.
You can find out more details about ASMCA from here.
August 5th, 2010 11:07 am
in Oracle 11g R2 Database Creation using ASM on Windows explain i conldn’t find my raw partition
and it is ask my to to enter sys and asmsnmp password
August 5th, 2010 12:21 pm
I assume you went the disk preparation step already. Please note that you must use the Basic disk (not Dynamic one). You can view what types of disks from Disk Management Snap-in tool.
Ittichai
August 5th, 2010 12:29 pm
no i went to ask you about how to config ASMCA first page appare to my password and Disk group
for server parameter file on button Specify Disk group
August 5th, 2010 1:09 pm
I’m not quite sure I understand your scenario here. Please see page 9 of the last document whether or not that may apply to your case.
August 5th, 2010 7:33 pm
can you see this image to explain my problem
http://www.mediafire.com/?b36ouj7djbi8o4d
http://www.mediafire.com/?b36ouj7djbi8o4d
August 5th, 2010 7:37 pm
http://www.mediafire.com/i/?5yqwaw47jnc8mps
August 6th, 2010 1:11 pm
Did you do the disk preparation using BASIC disks in the 1st document? And did you stamp disks in the 2nd document? If you did, at least you should see DATA diskgroup (storing Grid data).
August 6th, 2010 4:14 pm
yes i did but i think the problem to strat the ASM instant
August 7th, 2010 4:37 pm
Mr. ittichai i solve my problem i format my computer and try again successfully now i have another problem with listener you said ‘ Click OK. If you receive this error, this means that listener is not listening for +ASM. Exit now then configure listener and run dbca again’ how to configure the listener.