ASM installation on Windows

This article also assumes you are using Oracle version 11g Release 2 -specifically, 11.2.0.4. That is the latest version of Oracle available for general free download at the time of writing, and if it’s not the version you are using, I suggest that you upgrade immediately. I should add that I am using and describing the 32-bit version of Oracle 11g, and have no idea whether the 64-bit version works similarly or not at all!

In this article, as well as simulating a 6GB ASM array (which will require 6GB of free disk space), I’m going to show you how to convert a pre-existing database that is stored on a traditional file system into one that uses ASM exclusively. That is an important capability of Oracle’s RMAN tool, and the instructions therefore apply equally to Linux and Unix users as to Windows ones. I will also show you how to get Enterprise Manager to administer and monitor your ASM array -and that again is something that applies equally to all ASM users, not just Windows ones.

Creating Oracle Database manually

1.Set ORACLE_SID

cmd > set ORACLE_SID=ORA10

 

2. Creating an Oracle Service.

cmd>oradim -new -sid %SID_NAME% -intpwd MYSECRETPASSWORD -startmode M

Oracle also creates a password file under oracle home.

3. Connect to sqlplus.

SQL > Startup nomount;

4. Create Database.

create database ora10
 logfile group 1 ('D:\oracle\databases\ora10\redo1.log') size 10M,
 group 2 ('D:\oracle\databases\ora10\redo2.log') size 10M,
 group 3 ('D:\oracle\databases\ora10\redo3.log') size 10M
 character set WE8ISO8859P1
 national character set utf8
 datafile 'D:\oracle\databases\ora10\system.dbf' 
 size 50M
 autoextend on 
 next 10M maxsize unlimited
 extent management local
 sysaux datafile 'D:\oracle\databases\ora10\sysaux.dbf' 
 size 10M
 autoextend on 
 next 10M 
 maxsize unlimited
 undo tablespace undo
 datafile 'D:\oracle\databases\ora10\undo.dbf'
 size 10M
 default temporary tablespace temp
 tempfile 'D:\oracle\databases\ora10\temp.dbf'
 size 10M;

 

5. Run the scripts:

Catalog.sql and Catproc.sql