Configure ASM on Running Oracle11g Database RAC Setup on Windows 2003

Posted on 2011-10-16
Last Modified: 2012-08-14
Hi experts

Kindly I need your help

I have Running Oracle11g Database RAC Setup on Windows 2003 (Production and Life setup) with 2 nodes node1 and node2
I have SAN storage G, H and O sharing node1 and node2 on RAC setup
I need to configure ASM... can any body direct me please step by step

Question by:Haidar1
    LVL 5

    Expert Comment


    PFA the document containing configuration steps

    hope this helps. ASMinstall.doc
    LVL 5

    Expert Comment

    Attaching the file again, in correct format ASMinstall.doc

    Author Comment

    Thanks Rinil ,, But the steps you provide in the attached document, is how to enable ASM when you careate the Database,

    My quesion completely different ,, because I am changing from file system to ASM , I  have database is created using FS not I need to use ASM there is several steps should be there, I hope somebody can help....


    LVL 6

    Accepted Solution

    First of all you have to create ASM instance. Fill up the diskgroups, and make it visible from the database you already have in filesystem's files.

    Once you'll have the ASM instance ready, you will be able to move it easely using dbca.

    The steps are the following:
    - Get the disks ready. Format them to be labeled by asmlib.

    fdisk /dev/sda
    Command (m for help): u
    Changing display/entry units to sectors
    Command (m for help): n
    Command action
    e extended
    p primary partition (1-4)
    Partition number (1-4): 1
    First sector (61-1048575, default 61): 2048
    Last sector or +size or +sizeM or +sizeK (2048-1048575, default 1048575): 
    Using default value 1048575
    Command (m for help): w
    The partition table has been altered!
    Calling ioctl() to re-read partition table.
    Syncing disks. 

    Open in new window

    - Update the partition table of all servers using

    Open in new window

    - Install asmlib packages


    download the lastest versions that fit with the kernel code version here:

    and download the ones that exactly match the kernel version shown executing uname -r (linux)
    [groundwork@nagios ~]$ uname –r

    Open in new window

    - Install the packages

    # rpm -ivh oracleasm-support-2.1.3-1.el5x86_64.rpm \
    oracleasmlib-2.0.4-1.el5.x86_64.rpm \

    Open in new window

    - Configure ASMlib

    #/etc/init.d/oracleasm configure
    Configuring the Oracle ASM library driver.
    This will configure the on-boot properties of the Oracle ASM library driver. The following questions will determine whether the driver is loaded on boot and what permissions it will have. The current values will be shown in brackets ('[]'). Hitting <ENTER> without typing an answer will keep that current value. Ctrl-C will
    Default user to own the driver interface []: [b]grid[/b]
    Default group to own the driver interface []: [b]asmdba[/b]
    Start Oracle ASM library driver on boot (y/n) [n]:[b] y[/b]
    Scan for Oracle ASM disks on boot (y/n) [y]:[b] y[/b]
    Writing Oracle ASM library driver configuration: done
    Initializing the Oracle ASMLib driver: [b][ OK ][/b]
    Scanning the system for Oracle ASMLib disks: [b][ OK ][/b]

    Open in new window

    - Label the disks

    # /usr/sbin/oracleasm createdisk OCR_VOTE01 /dev/sda1
    # /usr/sbin/oracleasm createdisk OCR_VOTE02 /dev/sdb1
    # /usr/sbin/oracleasm createdisk OCR_VOTE03 /dev/sdc1
    # /usr/sbin/oracleasm createdisk ASMDATA01 /dev/sdd1
    # /usr/sbin/oracleasm createdisk ASMDATA02 /dev/sde1
    # /usr/sbin/oracleasm createdisk ASMDATA03 /dev/sdf1
    # /usr/sbin/oracleasm createdisk ASMDATA04 /dev/sdg1

    Open in new window

    - Scan disks from all servers (if you have more than one)

    # /usr/sbin/oracleasm listdisks
    # /usr/sbin/oracleasm scandisks
    Scanning system for ASM disks [ OK ]

    Open in new window

    - Execute dbca to create a new ASM instance.

    - After that, you will be able to migrate the filesystem database to ASM using the following documentation:

    Hope it helps!

    LVL 3

    Assisted Solution


    I have attached the document that I used to migrate from file system to ASM. It's for Linux though, but the general steps are similar. You can also refer to metalink note: 252219.1


    Author Closing Comment

    Thanks every body for your support.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now