视频1 视频21 视频41 视频61 视频文章1 视频文章21 视频文章41 视频文章61 推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37 推荐39 推荐41 推荐43 推荐45 推荐47 推荐49 关键词1 关键词101 关键词201 关键词301 关键词401 关键词501 关键词601 关键词701 关键词801 关键词901 关键词1001 关键词1101 关键词1201 关键词1301 关键词1401 关键词1501 关键词1601 关键词1701 关键词1801 关键词1901 视频扩展1 视频扩展6 视频扩展11 视频扩展16 文章1 文章201 文章401 文章601 文章801 文章1001 资讯1 资讯501 资讯1001 资讯1501 标签1 标签501 标签1001 关键词1 关键词501 关键词1001 关键词1501 专题2001
手动创建Oracle10gASM磁盘组
2020-11-09 11:54:00 责编:小采
文档


准备环境:Oracle 10g 联机文档、已经配置10g数据库软件的主机、oracleasm library rpm包、2块5GB硬盘1、 查看本机磁盘信息[roo

准备环境:

Oracle 10g 联机文档、已经配置10g数据库软件的主机、oracleasm library rpm包、2块5GB硬盘

1、 查看本机磁盘信息

[root@shiyueasm~]# fdisk -l

Disk/dev/sda: 16.1 GB, 16106127360 bytes

255 heads,63 sectors/track, 1958 cylinders

Units =cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System

/dev/sda1 * 307 1958 13269690 83 Linux

/dev/sda2 1 306 2457913+ 82 Linux swap

Partitiontable entries are not in disk order

Disk/dev/sdb: 10.7 GB, 10737418240 bytes

255heads, 63 sectors/track, 1305 cylinders

Units =cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System

/dev/sdb1 * 1 1305 10482381 83 Linux

Disk/dev/sdc: 5368 MB, 5368709120 bytes

255heads, 63 sectors/track, 652 cylinders

Units =cylinders of 16065 * 512 = 8225280 bytes

Disk/dev/sdc doesn't contain a valid partition table

Disk/dev/sdd: 5368 MB, 5368709120 bytes

255heads, 63 sectors/track, 652 cylinders

Units =cylinders of 16065 * 512 = 8225280 bytes

Disk /dev/sdd doesn't contain a validpartition table

2、 对新添加的2块磁盘进行分区

[root@shiyueasm~]# fdisk /dev/sdc

Devicecontains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel

Buildinga new DOS disklabel. Changes will remain in memory only,

until youdecide to write them. After that, of course, the previous

contentwon't be recoverable.

Warning:invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

Command(m for help): n

Commandaction

e extended

p primary partition (1-4)

p

Partitionnumber (1-4): 1

Firstcylinder (1-652, default 1):

Usingdefault value 1

Lastcylinder or +size or +sizeM or +sizeK (1-652, default 652):

Usingdefault value 652

Command(m for help): w

Thepartition table has been altered!

Callingioctl() to re-read partition table.

Syncingdisks.

[root@shiyueasm~]# fdisk /dev/sdd

Devicecontains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel

Buildinga new DOS disklabel. Changes will remain in memory only,

until youdecide to write them. After that, of course, the previous

contentwon't be recoverable.

Warning:invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

Command(m for help): n

Commandaction

e extended

p primary partition (1-4)

p

Partitionnumber (1-4): 1

Firstcylinder (1-652, default 1):

Usingdefault value 1

Lastcylinder or +size or +sizeM or +sizeK (1-652, default 652):

Usingdefault value 652

Command(m for help): w

Thepartition table has been altered!

Callingioctl() to re-read partition table.

Syncing disks.

3、 上传 oracle asmlibrary rpm包并对上传的包进行安装

[root@shiyueasmu01]# cd asm\ rpm\ for\ rhel4.0/

[root@shiyueasmasm rpm for rhel4.0]# ll

total 236

-rw-r--r-- 1 root root 129218 Apr 29 2010oracleasm-2.6.9-42.ELsmp-2.0.3-1.i686.rpm

-rw-r--r-- 1 root root 13105 Apr 29 2010oracleasmlib-2.0.4-1.el4.i386.rpm

-rw-r--r-- 1 root root 82542 Apr 29 2010oracleasm-support-2.1.3-1.el4.i386.rpm

[root@shiyueasmasm rpm for rhel4.0]# rpm -ivh *

warning:oracleasmlib-2.0.4-1.el4.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516

Preparing... ########################################### [100%]

1:oracleasm-support ########################################### [ 33%]

2:oracleasm-2.6.9-42.ELsm########################################### [67%]

3:oracleasmlib ########################################### [100%]

4、 配置ASM驱动

[root@shiyueasm~]# /etc/init.d/oracleasm configure

Configuringthe Oracle ASM library driver.

This willconfigure the on-boot properties of the Oracle ASM library

driver. The following questions will determinewhether the driver is

loaded onboot and what permissions it will have. The current values

will beshown in brackets ('[]'). Hitting without typing an

answerwill keep that current value. Ctrl-Cwill abort.

Defaultuser to own the driver interface []: oracle

Defaultgroup to own the driver interface []: oinstall

StartOracle ASM library driver on boot (y/n) [n]: y

Scan forOracle ASM disks on boot (y/n) [y]:

WritingOracle ASM library driver configuration: done

Initializingthe Oracle ASMLib driver: [ OK ]

Scanning the system for Oracle ASMLibdisks: [ OK ]

5、 创建ASM磁盘组

[root@shiyueasm~]# /etc/init.d/oracleasm createdisk VOL01 '/dev/sdc1'

Markingdisk "VOL02" as an ASM disk: [ OK ]

[root@shiyueasm~]# /etc/init.d/oracleasm createdisk VOL02 '/dev/sdd1'

Marking disk "VOL01" as anASM disk: [ OK ]

6、 手动创建磁盘组参数文件

[oracle@shiyueasm~]$ cd $ORACLE_HOME/dbs

[oracle@shiyueasmdbs]$ ll

total 48

-rw-r--r-- 1 oracle oinstall 934 May 26 10:52 db.sql

-rw-rw---- 1 oracle oinstall 1544 May 26 10:32 hc_shiyue.dat

-rw-r----- 1 oracle oinstall 12920 May 3 2001initdw.ora

-rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora

-rw-r--r-- 1 oracle oinstall 996 May 26 10:31 initshiyue.ora

-rw-rw---- 1 oracle oinstall 24 May 26 10:52 lkSHIYUE

-rw-r----- 1 oracle oinstall 1536 May 26 10:32 orapwshiyue

[oracle@shiyueasm dbs]$ viinit+ASM.ora

asm_diskstring=''

background_dump_dest=/u01/admin/shiyueasm/bdump

core_dump_dest=/u01/admin/shiyueasm/cdump

user_dump_dest=/u01/admin/shiyueasm/udump

instance_type='asm'

large_pool_size=20m

remote_login_passwordfile='shared'

7、 创建相关目录

[oracle@shiyueasm~]$ mkdir -p /u01/admin/shiyueasm/bdump

[oracle@shiyueasm~]$ mkdir -p /u01/admin/shiyueasm/cdump

[oracle@shiyueasm ~]$ mkdir -p/u01/admin/shiyueasm/udump

8、 切换至ASM实例

[oracle@shiyueasm ~]$ export ORACLE_SID=+ASM

下载本文
显示全文
专题