Shulou(Shulou.com)06/01 Report--

Construction of RAC by Oracle 11gR2 (2)-- configuring shared Storage

System environment:

Operating system: RedHat EL5

Cluster: Oracle GI (Grid Infrastructure)

Oracle: Oracle 11.2.0.1.0

As shown in the figure: RAC system architecture

Oracle RAC is a DataBase that can be accessed through multiple Instance, and each node has an Instance. All Instance have read and write access to the shared storage, and can store Datafile, controlfile, redolog, spfile, archive log and other files on the shared storage.

RAC shared storage can generally use OCFS and ASM mode, Oracle recommends the preferred ASM storage mode.

Configure RAC shared storage (all nodes)

1 、 First of all, install the ASM driver software [root@node1] # uname-aLinux node1 2.6.18-194.el5 # 1 SMP Tue Mar 16 21:52:43 EDT 2010 i686 i686 i386 GNU/Linux [root@node1 asm] # ls-ltotal 236 ls-ltotal 236 under linux to install the ASM driver software [root@node1] # i686 i386 [root@node1 asm] # ls-ltotal 236 Musashi-1,500 130018 May 9 2012 oracleasm-2.6.18-194.el5-2.0.5-1.el5.i686.rwxrafure rwxrafure-1,500 13929 Apr 11 2010 oracleasmlib-2. 0.4-1.el5.i386.rpmMurrwxrMurray-1500500 85382 Apr 11 2010 oracleasm-support-2.1.3-1.el5.i386.rpm installation software should match the kernel of the system And 32-bit kernel to choose i386 rpm i686 warning 64-bit package [root@node1 asm] # rpm-ivh * warning: oracleasm-2.6.18-194.el5-2.0.5-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159 recording. # [100%] 1:oracleasm-support # [33%] 2:oracleasm-2.6.18-194.el# # # [67%] 3:oracleasmlib # 2. Create a shared disk partition [root@node1 asm] # fdisk-lDisk / dev/sdb: 22.7 GB 22769827840 bytes255 heads, 63 sectors/track 2768 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System/dev/sdb1 1125 1004031 83 Linux/dev/sdb2 1262768 21229897 + 5 Extended/dev/sdb5 126250 1004031 83 Linux/dev/sdb6 251,375 1004031 83 Linux/dev/sdb7 376 874 4008186 83 Linux/dev/sdb8 875 1373 4008186 83 Linux/dev/sdb9 1374 1872 4008186 83 Linux/dev/sdb10 1873 2371 4008186 83 Linux/dev/sdb11 2372 2496 1004031 83 Linux/dev/sdb12 2497 2621 1004031 83 Linux/dev / sdb13 2622 2768 1180746 83 Linux ASM DISK can be established through Linux partitions or raw devices! 3. Establish ASM DISK [root@node1 soft] # service oracleasm configureConfiguring the Oracle ASM library driver.This will configure the on-boot properties of the Oracle ASM librarydriver. The following questions will determine whether the driver isloaded on boot and what permissions it will have. The current valueswill be shown in brackets ('[]'). Hitting without typing ananswer will keep that current value. Ctrl-C will abort.Default user to own the driver interface []: gridDefault group to own the driver interface []: asmadminStart Oracle ASM library driver on boot (YPao) [n]: yScan for Oracle ASM disks on boot (YPIO) [y]: Writing Oracle ASM library driver configuration: doneInitializing the Oracle ASMLib driver: [OK] Scanning the system for Oracle ASMLib disks: [OK] [root@node1 soft] # create oracleasm disk: [root@node1 soft] # service oracleasmUsage: / Etc/init.d/oracleasm {start | stop | restart | enable | disable | configure | createdisk | deletedisk | querydisk | listdisks | scandisks | status} [root@node1 soft] # service oracleasm createdisk OCR_VOTE1 / dev/sdb1Marking disk "OCR_VOTE1" as an ASM disk: [OK] [root@node1 soft] # service oracleasm createdisk OCR_VOTE2 / dev/sdb5Marking disk "OCR_VOTE2" as an ASM disk: [OK] [root@node1 soft] # service oracleasm createdisk OCR_VOTE3 / dev/sdb6Marking disk "OCR_VOTE3" as an ASM disk: [OK] 11G RAC stores ocr and vote disk in ASM diskgroup management If you need 3 disks to build a normal redundancy: [root@node1 soft] # service oracleasm createdisk ASM_DATA1 / dev/sdb7Marking disk "ASM_DATA1" as an ASM disk: [OK] [root@node1 soft] # service oracleasm createdisk ASM_DATA2 / dev/sdb8Marking disk "ASM_DATA2" as an ASM disk: [OK] ASM_DATA1 ASM_DATA2 is used to set up diskgroup [root@node1 soft] # service oracleasm createdisk ASM_RCY1 / dev/sdb9Marking disk "ASM_RCY1" as an ASM disk for storing database: [OK] [root@node1 soft] # service oracleasm createdisk ASM_RCY2 / dev/sdb10Marking disk "ASM_RCY2" as an ASM disk: [OK] ASM_RCY1 ASM_RCY2 is used to create diskgroup [root@node1 soft] # service oracleasm listdisksASM_DATA1ASM_DATA2ASM_RCY1ASM_RCY2OCR_VOTE1OCR_VOTE2OCR_VOTE3 to store recovery area on other nodes: [root@node2 asm] # service oracleasm scandisksScanning the system for Oracle ASMLib disks: [OK] [root@node2 asm] # service oracleasm listdisksASM_DATA1ASM_DATA2ASM_RCY1ASM_RCY2OCR_VOTE1OCR_VOTE2OCR_VOTE3

@ at this point, the shared storage configuration under RAC is complete!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.