ITPub博客

首页 > Linux操作系统 > Linux操作系统 > redhat AS5 下安装oracle的三种存储方式

redhat AS5 下安装oracle的三种存储方式

原创 Linux操作系统 作者:lingsam 时间:2013-06-20 01:14:03 0 删除 编辑
Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE1.  文件系统

   #fdisk /dev/sda  划分区sda2

   #mkdir /backup

   #mount /dev/sda2 /backup

2.  ASM

(1)     根据内核版本(uname -r)安装asm包

oracleasm-support-2.1.7-1.el5.ia64.rpm

oracleasmlib-2.0.4-1.el5.ia64.rpm

oracleasm-2.6.18-8.el5-2.0.4-1.el5.i686.rpm  (与内核版本有关)

(2)     确认selinux关闭

#vi  /etc/sysconfig/selinux  修改 selinux=disable

否则配置ASM会失败

(3)     配置ASM用户及版本信息

#/etc/init.d/oracleasm configure

输入用户和组名  (oracle ,oinstall)

(4)     创建ASM磁盘组

方法1:

1>创建文件

#dd if=/dev/zero f=/backup/oradata/asm/sdd1 bs=1M count=300

#dd if=/dev/zero f=/backup/oradata/asm/sdd2 bs=1M count=300

2>将文件虚拟成循环设备

#/sbin/losetup /dev/loop1 /backup/oradata/asm/sdd1

#/sbin/losetup /dev/loop2 /backup/oradata/asm/sdd2

3>创建asm磁盘组

#/etc/init.d/oracleasm createdisk  VOL1  /dev/loop1

#/etc/init.d/oracleasm createdisk  VOL2  /dev/loop2

方法2:

#fdisk /dev/sdb   新创建设备文件/dev/sdb1

#/etc/init.d/oracleasm createdisk  vol_sdb1  /dev/sdb1

方法3:

#fdisk  /dev/sdb 创建分区sdb2,sdb3,类型为8e(lvm);sdb5为正常类型

#vi /etc/sysconfig/rawdevices  添加:(其中sdb2已加入vgdata中)

/dev/raw/raw2  /dev/sdb2

/dev/raw/raw3  /dev/sdb3

/dev/raw/raw5  /dev/sdb5

#chkconfig rawdevices on

#partprobe

       #service rawdevices restart   重起raw服务,识别raw

       #raw –qa

       #raw /dev/raw/raw2 0 0 删除raw2

 

#vi /etc/rc.d/init.d/rawdevices  的start处的assign_raw下添加:

Sleep 3

Chown –R oracle:oinstall /dev/raw/

 

 

创建的磁盘组会在/dev/oracleasm/disks下生成。

(5)     设置ASM自启动

#vi /etc/rc.local  添加如下内容:

/sbin/losetup /dev/loop1 /backup/oradata/asm/sdd1

/sbin/losetup /dev/loop2 /backup/oradata/asm/sdd2

oracleasm scandisks

(6)     配置css服务

#/u01/db/bin/localconfig add

检查css服务

#more /etc/inittab

h1:35:respawn:/etc/init.d/init.cssd run >/dev/null 2>&1

#ps –ef|grep css

(7)     D

3.  裸设备(raw)

以下方法使用于redhat 5之后:

(1)     分区

#fdisk  /dev/sdc   分区sdc5-sdc15,sdc2(sdc5 200M,其余50M)

(2)     修改文件vi /etc/udev/rules.d/60-raw.rules

#添加映射关系及权限

ACTION=="add", KERNEL=="sdc5", RUN+="/bin/raw /dev/raw/raw6 %N"

ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="37",RUN+="/bin/raw /dev/raw/raw6 %M %m"

ACTION=="add", KERNEL=="sdc6", RUN+="/bin/raw /dev/raw/raw7 %N"

ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="38",RUN+="/bin/raw /dev/raw/raw7 %M %m"

ACTION=="add", KERNEL=="sdc7", RUN+="/bin/raw /dev/raw/raw8 %N"

ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="39",RUN+="/bin/raw /dev/raw/raw8 %M %m"

ACTION=="add", KERNEL=="sdc8", RUN+="/bin/raw /dev/raw/raw9 %N"

ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="40",RUN+="/bin/raw /dev/raw/raw9 %M %m"

ACTION=="add", KERNEL=="sdc9", RUN+="/bin/raw /dev/raw/raw10 %N"

ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="41",RUN+="/bin/raw /dev/raw/raw10 %M %m"

ACTION=="add", KERNEL=="sdc10", RUN+="/bin/raw /dev/raw/raw11 %N"

ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="42",RUN+="/bin/raw /dev/raw/raw11 %M %m"

ACTION=="add", KERNEL=="sdc11", RUN+="/bin/raw /dev/raw/raw12 %N"

ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="43",RUN+="/bin/raw /dev/raw/raw12 %M %m"

ACTION=="add", KERNEL=="sdc12", RUN+="/bin/raw /dev/raw/raw13 %N"

ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="44",RUN+="/bin/raw /dev/raw/raw13 %M %m"

ACTION=="add", KERNEL=="sdc13", RUN+="/bin/raw /dev/raw/raw14 %N"

ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="45",RUN+="/bin/raw /dev/raw/raw14 %M %m"

ACTION=="add", KERNEL=="sdc14", RUN+="/bin/raw /dev/raw/raw15 %N"

ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="46",RUN+="/bin/raw /dev/raw/raw15 %M %m"

ACTION=="add", KERNEL=="sdc15", RUN+="/bin/raw /dev/raw/raw16 %N"

ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="47",RUN+="/bin/raw /dev/raw/raw16 %M %m"

ACTION=="add", KERNEL=="sdc2", RUN+="/bin/raw /dev/raw/raw17 %N"

ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="34",RUN+="/bin/raw /dev/raw/raw17 %M %m"

KERNEL=="raw*", WNER="oracle", GROUP="dba", MODE="660"

(3)     新建立文件 dbca_raw.conf

system = /u01/oradata/raw/system

sysaux = /u01/oradata/raw/sysaux

undotbs1= /u01/oradata/raw/undotbs1

temp = /u01/oradata/raw/temp

users = /u01/oradata/raw/users

spfile = /u01/oradata/raw/spfile

control1 = /u01/oradata/raw/control01

control2 = /u01/oradata/raw/control02

control3 = /u01/oradata/raw/control03

redo1_1 = /u01/oradata/raw/redo01

redo1_2 = /u01/oradata/raw/redo02

redo1_2 = /u01/oradata/raw/redo03

(4)     建立链接

   #ln -s /dev/raw/raw6 /u01/oradata/raw/system

#ln -s /dev/raw/raw7 /u01/oradata/raw/sysaux

#ln -s /dev/raw/raw8 /u01/oradata/raw/undotbs1

#ln -s /dev/raw/raw9 /u01/oradata/raw/temp

#ln -s /dev/raw/raw10 /u01/oradata/raw/users

#ln -s /dev/raw/raw11 /u01/oradata/raw/spfile

#ln -s /dev/raw/raw12 /u01/oradata/raw/control01

#ln -s /dev/raw/raw13 /u01/oradata/raw/control02

#ln -s /dev/raw/raw14 /u01/oradata/raw/control03

#ln -s /dev/raw/raw15 /u01/oradata/raw/redo01

#ln -s /dev/raw/raw16 /u01/oradata/raw/redo02

#ln -s /dev/raw/raw17 /u01/oradata/raw/redo03

(5)     重启服务

#start_udev

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26764468/viewspace-764360/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: 物化视图-学习篇
请登录后发表评论 登录
全部评论

注册时间:2012-03-06

最新文章