Part IV – Fixing the Mess
When the 10g installer completes you will have an Oracle 10g install, a Clusterware Service and no database.
With the logical 32GB partition now stamped for ASM, it is now possible to use DBCA to create a new empty database, and DBCA will allow you to specify ASM as the storage medium, whereupon DBCA will also create the ASM instance for you.
However by default on Windows 7 this process will fail, with errors in the Clusterware Service.
Part III – Stamping the Logical Disk
Okay, so we partitioned the disk and we installed Oracle 10g. We now need to stamp our 32GB logical partition for ASM to use. To do this Oracle provides a helpful tool called asmtoolg.exe in the Oracle Home bin directory.
Launching this under Windows 7 results in the following:
Part II – Installing Oracle 10gR2
I had a spare Windows 7 32-bit PC with a 300GB SATA hard disk and this surplus hardware is what I wanted to use to create my ASM sandbox. My initial thought was to download and install Oracle 11gR2 for Windows 32-bit, but this is not an option. When trying to use DBCA to create a database using ASM, the assistant helpfully informs you:
Cannot use ASM for database storage due to following reason: Grid infrastructure or Clusterware home not found. ASM should be running under this home
This is due to Oracle removing Clusterware support in the Windows 32-bit release:
Part I – Partition the Disk
Once upon a time when you purchased Oracle software, they gave you something called a manual. A lot in fact, I fondly remember an entire bookshelf of Oracle 7.1 manuals back when I worked for BP.
Later Oracle decided to save themselves the money, and you the shelf space, and started shipping documentation on CD.
Now everything is online which is both a blessing and a curse.
the gruffdba 