The configuration of ASM in Oracle RAC can be implemented in two ways: raw and asmlib. Raw is recommended for actual maintenance.
There are two ways to use raw: Multipath and udev. On the RedHat platform, refer:
RedHat 5.4 + ASM + raw + Oracle 10g RAC installation documentation
Http://blog.csdn.net/tianlesoftware/article/details/5872593
RedHat 5.4 Oracle 10g RAC openfiler + multipath + raw + ASM installation document
Http://blog.csdn.net/tianlesoftware/article/details/6048792
For asmlib, refer:
Raw + asm rac installation document
Http://blog.csdn.net/tianlesoftware/article/details/5332909
In this article, let's take a look at the udev configuration in the oraclelinux system.
Reference:
Http://www.oracle-base.com/articles/linux/UdevScsiRulesConfigurationInOracleLinux5and6.php
Http://www.oracle-base.com/articles/11g/OracleDB11gR2RACInstallationOnOracleLinux6UsingVirtualBox.php
My experimental platform here is oraclelinux 6.1 + virtual box.
Oraclevirtual box installation instructions
Http://blog.csdn.net/tianlesoftware/article/details/6826389
I. Preparations 1.1 create a shared Disk
Use the virtualbox command to create the image. Shut down the VM before creating the VM.
1.1.1 create a shared directory sharedisk:
F: \ vbox \ sharedisk
1.1.2 create virtual Media
C: \ Users \ administrator. David Dai> CDF: \ vbox \ sharedisk
C: \ Users \ administrator. David Dai> F:
F: \ vbox \ sharedisk> vboxmanage createhd -- filename asm01.vdi -- size 5120 -- format VDI -- variant fixed
0%... 10%... 20%... 30%... 40%... 50%... 60%... 70%... 80%... 90%... 100%
Disk image created. UUID: 83552343-5254-4fe0-8f4d-949389a4d528
F: \ vbox \ sharedisk> vboxmanage createhd -- filename asm02.vdi -- size 5120 -- format VDI -- variant fixed
0%... 10%... 20%... 30%... 40%... 50%... 60%... 70%... 80%... 90%... 100%
Disk image created. UUID: b96d5ecb-168a-4eaf-851e-0f21961dae4e
F: \ vbox \ sharedisk> vboxmanage createhd -- filename asm03.vdi -- size 5120 -- format VDI -- variant fixed
0%... 10%... 20%... 30%... 40%... 50%... 60%... 70%... 80%... 90%... 100%
Disk image created. UUID: fd7bba6c-9530-433f-a7e0-24d470ba1fb9
F: \ vbox \ sharedisk> vboxmanage createhd -- filename asm04.vdi -- size 5120 -- format VDI -- variant fixed
0%... 10%... 20%... 30%... 40%... 50%... 60%... 70%... 80%... 90%... 100%
Disk image created. UUID: 3239ed0d-bd0b-4124-a389-db21ecbb15db
1.1.3 match the virtual media to the Virtual Machine
F: \ vbox \ sharedisk> vboxmanage storageattach oralinuxrac1 -- storagectl "SATA controller" -- Port 1 -- device 0 -- type HDD -- medium asm01.vdi -- mtype retriable
F: \ vbox \ sharedisk> vboxmanage storageattach oralinuxrac1 -- storagectl "SATA controller" -- Port 2 -- device 0 -- type HDD -- medium asm02.vdi -- mtype retriable
F: \ vbox \ sharedisk> vboxmanage storageattach oralinuxrac1 -- storagectl "SATA controller" -- Port 3 -- device 0 -- type HDD -- medium asm03.vdi -- mtype retriable
F: \ vbox \ sharedisk> vboxmanage storageattach oralinuxrac1 -- storagectl "SATA controller" -- Port 4 -- device 0 -- type HDD -- medium asm04.vdi -- mtype retriable
Notes:
(1) controller name
What I wrote here is: "SATA controller", because my VM is displayed in Chinese, such:
In English, the name must be written as "SATA controller", for example:
F: \ vbox \ sharedisk> vboxmanagestorageattach oralinuxrac1 -- storagectl "SATA controller" -- Port 1 -- device 0 -- type HDD -- medium asm04.vdi -- mtype retriable
(2) storageattach corresponds to the name of the VM displayed in the VM.
(3) to add a disk to another node, you only need to change the Virtual Machine name here. For example:
F: \ vbox \ sharedisk> vboxmanagestorageattach oralinuxrac2 -- storagectl "SATA controller" -- Port 1 -- device 0 -- typehdd -- medium asm04.vdi -- mtype retriable
1.1.4 configure virtual media sharing. You can also perform this operation on the vbox interface. Here, use the command
This information will be recorded in the file header of each virtual disk file. Therefore, you do not need to set it as shared when other files are used.
F: \ vbox \ sharedisk> vboxmanage modifyhdasm01.vdi -- type retriable
F: \ vbox \ sharedisk> vboxmanage modifyhdasm02.vdi -- type retriable
F: \ vbox \ sharedisk> vboxmanage modifyhdasm03.vdi -- type retriable
F: \ vbox \ sharedisk> vboxmanage modifyhdasm04.vdi -- type retriable
1.2 format shared media
Start the VM and perform formatting.
[Root @ Rac1 ~] # Cd/dev
[Root @ Rac1 Dev] # ls SD *
SDA sda1 sda2 sda3 SDB SDC SDD SDE
-- SDB, SDC, SDD, and SDE here are the virtual media we have added.
[Root @ Rac1 Dev] # fdisk-l
Disk/dev/SDA: 16.1 GB, 16106127360 bytes
255 heads, 63 sectors/track, 1958 Cylinders
Units = cylinders of 16065*512 = 8225280 bytes
Sector size (logical/physical): 512 bytes/512 bytes
I/O size (minimum/optimal): 512 bytes/512 bytes
Disk identifier: 0x0008dd19
Device boot start end blocks ID system
/Dev/sda1 × 1 26 204800 83 Linux
Partition 1 does not end on cylinderboundary.
/Dev/sda2 26 154 1024000 82 Linux swap/Solaris
Partition 2 does not end on cylinderboundary.
/Dev/sda3 154 1959 14498816 83 Linux
Disk/dev/SDB: 5368 MB, 5368709120 bytes
255 heads, 63 sectors/track, 652 Cylinders
Units = cylinders of 16065*512 = 8225280 bytes
Sector size (logical/physical): 512 bytes/512 bytes
I/O size (minimum/optimal): 512 bytes/512 bytes
Disk identifier: 0x00000000
Disk/dev/SDB doesn' t contain a validpartition table
Disk/dev/SDC: 5368 MB, 5368709120 bytes
255 heads, 63 sectors/track, 652 Cylinders
Units = cylinders of 16065*512 = 8225280 bytes
Sector size (logical/physical): 512 bytes/512 bytes
I/O size (minimum/optimal): 512 bytes/512 bytes
Disk identifier: 0x00000000
Disk/dev/SDC doesn' t contain a validpartition table
Disk/dev/SDD: 5368 MB, 5368709120 bytes
255 heads, 63 sectors/track, 652 Cylinders
Units = cylinders of 16065*512 = 8225280 bytes
Sector size (logical/physical): 512 bytes/512 bytes
I/O size (minimum/optimal): 512 bytes/512 bytes
Disk identifier: 0x00000000
Disk/dev/SDD doesn't contain a validpartition table
Disk/dev/SDE: 5368 Mbit/s, 5368709120 bytes
255 heads, 63 sectors/track, 652 Cylinders
Units = cylinders of 16065*512 = 8225280 bytes
Sector size (logical/physical): 512 bytes/512 bytes
I/O size (minimum/optimal): 512 bytes/512 bytes
Disk identifier: 0x00000000
Disk/dev/SDE doesn't contain a validpartition table
[Root @ Rac1 Dev] #
Start formatting media:
[Root @ Rac1 Dev] # fdisk/dev/SDB
Device contains neither a valid dospartition table, Nor Sun, SGI or OSF disklabel
Building a new dos disklabel with diskidentifier 0xbe1b86b0.
Changes will remain in memory only, untilyou decide to write them.
After that, of course, the previous contentwon't be recoverable.
Warning: Invalid flag 0x0000 of partitiontable 4 will be corrected by W (RITE)
Warning: DOS-compatible mode is deprecated. It's stronugly recommended
Switch off the mode (command 'C') and change display units
Sectors (command 'U ').
Command (M for help): n
Command action
E extended
P primary partition (1-4)
P
Partition Number (1-4): 1
First cylinder (1-652, default 1 ):
Using default value 1
Last cylinder, + cylinders or + size {K, M, g} (1-652, default 652 ):
Using default value 652
Command (M for help): W
The partition table has been altered!
Calling IOCTL () to re-read partition table.
Syncing disks.
[Root @ Rac1 Dev] #
Repeat the preceding operations to format the remaining three media.
Verification:
[Root @ Rac1 Dev] # ls SD *
SDA sda1 sda2 sda3 SDB sdb1 SDC sdc1 SDD sdd1 SDE sde1
[Root @ Rac1 Dev] # fdisk-l
Disk/dev/SDA: 16.1 GB, 16106127360 bytes
255 heads, 63 sectors/track, 1958 Cylinders
Units = cylinders of 16065*512 = 8225280 bytes
Sector size (logical/physical): 512 bytes/512 bytes
I/O size (minimum/optimal): 512 bytes/512 bytes
Disk identifier: 0x0008dd19
Device boot start end blocks ID system
/Dev/sda1 × 1 26 204800 83 Linux
Partition 1 does not end on cylinderboundary.
/Dev/sda2 26 154 1024000 82 Linux swap/Solaris
Partition 2 does not end on cylinderboundary.
/Dev/sda3 154 1959 14498816 83 Linux
Disk/dev/SDB: 5368 MB, 5368709120 bytes
255 heads, 63 sectors/track, 652 Cylinders
Units = cylinders of 16065*512 = 8225280 bytes
Sector size (logical/physical): 512 bytes/512 bytes
I/O size (minimum/optimal): 512 bytes/512 bytes
Disk identifier: 0xbe1b86b0
Device boot start end blocks ID system
/Dev/sdb1 1 652 5237158 + 83 Linux
Disk/dev/SDC: 5368 MB, 5368709120 bytes
255 heads, 63 sectors/track, 652 Cylinders
Units = cylinders of 16065*512 = 8225280 bytes
Sector size (logical/physical): 512 bytes/512 bytes
I/O size (minimum/optimal): 512 bytes/512 bytes
Disk identifier: 0x52c60017
Device boot start end blocks ID system
/Dev/sdc1 1 652 5237158 + 83 Linux
Disk/dev/SDD: 5368 MB, 5368709120 bytes
255 heads, 63 sectors/track, 652 Cylinders
Units = cylinders of 16065*512 = 8225280 bytes
Sector size (logical/physical): 512 bytes/512 bytes
I/O size (minimum/optimal): 512 bytes/512 bytes
Disk identifier: 0xb3564300
Device boot start end blocks ID system
/Dev/sdd1 1 652 5237158 + 83 Linux
Disk/dev/SDE: 5368 Mbit/s, 5368709120 bytes
255 heads, 63 sectors/track, 652 Cylinders
Units = cylinders of 16065*512 = 8225280 bytes
Sector size (logical/physical): 512 bytes/512 bytes
I/O size (minimum/optimal): 512 bytes/512 bytes
Disk identifier: 0x688384a0
Device boot start end blocks ID system
/Dev/sde1 1 652 5237158 + 83 Linux
You have new mail in/var/spool/mail/root
[Root @ Rac1 Dev] #
2. Configure udev
2.1 determine the SCSI ID
In Oracle Linux 5, run the following command:
#/Sbin/scsi_id-g-u-s/block/sdb/sdb1
SATA_VBOX_HARDDISK_VBd306dbe0-df3367e3 _
#/Sbin/scsi_id-g-u-s/block/SDC/sdc1
SATA_VBOX_HARDDISK_VB46dec7e0-192e8000 _
#/Sbin/scsi_id-g-u-s/block/SDD/sdd1
SATA_VBOX_HARDDISK_VBce8c63bb-ac67a172 _
#/Sbin/scsi_id-g-u-s/block/SDE/sde1
SATA_VBOX_HARDDISK_VB7437a3b7-95b199cd _
#
Here, the-s option is unavailable in Oracle Linux 6, and the environment here is also oraclelinux 6, so use the command below:
[Root @ Rac1 Dev] #/sbin/scsi_id-g-u/dev/sdb1
1ata_vbox_harddisk_vb83552343-28d5a489
[Root @ Rac1 Dev] #/sbin/scsi_id-g-u/dev/sdc1
1ata_vbox_harddisk_vbb96d5ecb-4eae1d96
[Root @ Rac1 Dev] #/sbin/scsi_id-g-u/dev/sdd1
1ata_vbox_harddisk_vbfd7bba6c-b91fba70
[Root @ Rac1 Dev] #/sbin/scsi_id-g-u/dev/sde1
1ata_vbox_harddisk_vb3239ed0d-db15bbec
2.2 create and configure the udevrules File
[Root @ Rac1 rules. d] # Touch/etc/udev/rules. d/99-oracle-asmdevices.rules
Add the following content:
Kernel = "SD? 1 ", bus =" SCSI ", program ="/sbin/scsi_id-g-u/dev/$ name ", result =" 1ata_vbox_harddisk_vb83552343-28d5a489 ", name = "asm-disk1", owner = "oracle", group = "dba", mode = "0660"
Kernel = "SD? 1 ", bus =" SCSI ", program ="/sbin/scsi_id-g-u/dev/$ name ", result =" 1ata_vbox_harddisk_vbb96d5ecb-4eae1d96 ", name = "asm-disk2", owner = "oracle", group = "dba", mode = "0660"
Kernel = "SD? 1 ", bus =" SCSI ", program ="/sbin/scsi_id-g-u/dev/$ name ", result =" 1ata_vbox_harddisk_vbfd7bba6c-b91fba70 ", name = "asm-disk3", owner = "oracle", group = "dba", mode = "0660"
Kernel = "SD? 1 ", bus =" SCSI ", program ="/sbin/scsi_id-g-u/dev/$ name ", result =" 1ata_vbox_harddisk_vb3239ed0d-db15bbec ", name = "asm-disk4", owner = "oracle", group = "dba", mode = "0660"
2.3 load updated block device partition tables.
#/Sbin/partprobe/dev/sdb1
#/Sbin/partprobe/dev/sdc1
#/Sbin/partprobe/dev/sdd1
#/Sbin/partprobe/dev/sde1
2.4 restart udev
[Root @ Rac1 Dev] # start_udev
Starting udev: [OK]
2.5 check the relationship and permissions of the shared Device
[Root @ Rac1 rules. d] # cd/dev
[Root @ Rac1 Dev] # ls-Al ASM-disk *
BRW-RW ----. 1 Oracle DBA 8, 17 Apr 6 asm-disk1
BRW-RW ----. 1 Oracle DBA 8, 33 APR 6 asm-disk2
BRW-RW ----. 1 Oracle DBA 8, 49 APR 6 asm-disk3
BRW-RW ----. 1 Oracle DBA 8, 65 APR 6 18:04 asm-disk4
Now the configuration is complete. In the ASM configuration, the asm_diskstring parameter points to '/dev/ASM-disk.
Bytes -------------------------------------------------------------------------------------------------------
All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!
Skype: tianlesoftware
Email: tianlesoftware@gmail.com
Blog: http://www.tianlesoftware.com
WEAVER: http://weibo.com/tianlesoftware
Twitter: http://twitter.com/tianlesoftware
Facebook: http://www.facebook.com/tianlesoftware
LinkedIn: http://cn.linkedin.com/in/tianlesoftware
------- Add a group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, reject the application ----
Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)
Super DBA group: 63306533 (full); dba4 group: 83829929 dba5 group: 142216823
Dba6 group: 158654907 dba7 group: 172855474 DBA group: 104207940