Enter Your Email

Enter your email address:

Delivered by FeedBurner

Custom Search

Wednesday, March 12, 2008

Oracle 11g :: Configuring ASM for Oracle 11g RDBMS

Setting up and configuring storage with ASM for Oracle 11g RDBMS
VMWare Version 1.0.8
Host Operating System: Windows XP – 32 Bit
Guest Operating System: OLE 4 (Update 5)
Oracle RDBMS Version:

1. Oracle Software should already installed on the server.

Click here -> For Step by step http://ravidba-oracle.blogspot.com/2008/07/oracle-11g-step-by-step-installation-on.html
2. Raw disks should already be formatted using fdisk and should be available to the server.

3. Disk Label should be created with ORACLE ASM LIB.

** Please download Oracle ASM Lib from OTN.
oracleasmlib-2.0.2-1.i386.rpm (or) you can configure this when you setup Linux by selecting
System Tools -> oracle oracleasm-2.6.9.. (driver for UP kernel).
[root@oracledb2 init.d]# ls -ltr oracleasm*
-rwxr-xr-x 1 root root 18114 Oct 24 2006 oracleasm
[root@oracledb2 init.d]# pwd
Usage: /etc/init.d/oracleasm {startstoprestartenabledisableconfigurecreatediskdeletediskquerydisklistdisksscandisksstatus}
For rest of the steps please follow the above URL to add the disks using oracleasm.
[root@oracledb2 init.d]# /etc/init.d/oracleasm listdisks
Once you have the disks in place, login as Oracle user and run DBCA
1. Select Configure Automatic Storage Management : Step 1 of 4 -> Click Next

2. A warning screen will appear. For ASM (Automatic Storage Management) the Oracle Cluster Synchronization Service (CSS) needs to be running. All you need to do is - login as a root user and run the localconfig reset from $ORACLE_HOME/bin directory, as shown in the below screen.

3. Open a termial / Putty section login as a root user, and execute localconfig reset from $ORACLE_HOME/bin.
Once you have the message "Oracle CSS service is installed and running under init" you can click "OK" at the warning screen.
4. Specify the password for the SYS user. (This is for ASM Instance).
7. I have missed few of the screens, you need to assign the Disk Group Name, assign the Volumes that we create before and select the redundancy. I created two Disk Group's.
spfiledb11g.ora => +DATA/DB11G/PARAMETERFILE/spfile.280.674840503
And the second group RECOVERYDEST/ for FLASH recovery area.
8. Mount the Disks - Click Mount All

9. Mounting Disk Groups...10. Disks are mounted, Next we create database.
Please refer my next post


  1. Anonymous9:42 AM

    what is the link to your next post?

  2. http://dba-onweb.blogspot.com/ Click here...for my next post and all posts

  3. Anonymous11:46 AM

    Dear Ravi,

    We are going through a problem while using the setup of oracle 11g release 2 which we downloaded from oracle.com. had a new server hardware with 6core and raid and 16gb ram. old server very slow. therefore looking forward to improve the total administration and use the benefits of new features of ASM.

    Getting lost with so many un-necessary information flying around on the web. Came accross your blog which seems to be helpful.

    Could you guide us to a successful setup of 11g.

    please note the screens shots above are not the same we get on r2 setup of 32\64bit.no idea why so?

    was looking for a checklist and simple chronological method of following the entire setup of oracle 11g with configurations of asm.

    looking forward to you help.
    thanks and best regards,


  4. Dear Ramesh, please provide your email. the above configuration is on 11gR1. Thanks

  5. Anonymous4:33 AM

    Nice blog

  6. Anonymous5:11 AM

    i want solution for my problem
    that is we r using sql in main server and we r using oracle in another two servers from sql to one of the oracle server we r using mapping and main problem is how to create redundancy between these two oracle servers and the operating system we r using is windows server 2008
    pls send me the solution as early as possible


Copyright © 2005 - 2008 DBA-ONWeb Technical blog. All rights reserved