• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1315
  • Last Modified:

Configure ASM on Running Oracle11g Database RAC Setup on Windows 2003

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

Thanks
0
Haidar1
Asked:
Haidar1
2 Solutions
 
RinilCommented:
hi,

PFA the document containing configuration steps



hope this helps. ASMinstall.doc
0
 
RinilCommented:
Attaching the file again, in correct format ASMinstall.doc
0
 
Haidar1Author Commented:
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....

Regards


0
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
Javier MoralesOracle DBACommented:
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)
p
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
#/sbin/partprobe

Open in new window


- Install asmlib packages

oracleasm-support-2.1.3-1.el5x86_64.rpm
oracleasmlib-2.0.4-1.el5.x86_64.rpm
oracleasm-2.6.18-92.1.17.0.2.el5-2.0.5-1.el5.x86_64.rpm

download the lastest versions that fit with the kernel code version here:
http://www.oracle.com/technetwork/topics/linux/asmlib/index-101839.html

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

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 \
oracleasm-2.6.18-92.1.17.0.2.el5-2.0.5-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
abort.

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

(example)
# /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
OCR_VOTE01
OCR_VOTE02
OCR_VOTE03
ASMDATA01
ASMDATA02
ASMDATA03
ASMDATA04

# /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:

http://download.oracle.com/docs/cd/B14117_01/server.101/b10734/rcmasm.htm


Hope it helps!
Javier

0
 
JPrzybyszewskiCommented:
Hi

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

Regards,
Jarek
Installation-of-Oracle-ASM-11gR2.docx
0
 
Haidar1Author Commented:
Thanks every body for your support.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now