ITPub博客

首页 > Linux操作系统 > Linux操作系统 > VMware虚拟机搭建Linux Oracle 10g ASM环境

VMware虚拟机搭建Linux Oracle 10g ASM环境

原创 Linux操作系统 作者:dukewyh 时间:2012-07-09 09:35:10 0 删除 编辑
1.新增磁盘进行分区

这里我们将新增磁盘分成3部分:/dev/sdb1,/dev/sdb2,/dev/sdb3

[root@ocp db10g]# fdisk /dev/sdb
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.

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

Command (m for help): p

Disk /dev/sdb: 6442 MB, 6442450944 bytes
255 heads, 63 sectors/track, 783 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System

Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-783, default 1): 1
Last cylinder or +size or +sizeM or +sizeK (1-783, default 783): +2G

Command (m for help): p

Disk /dev/sdb: 6442 MB, 6442450944 bytes
255 heads, 63 sectors/track, 783 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System
/dev/sdb1               1         244     1959898+  83  Linux

Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
p
Partition number (1-4): 2
First cylinder (245-783, default 245):
Using default value 245
Last cylinder or +size or +sizeM or +sizeK (245-783, default 783): +2g

Command (m for help): p

Disk /dev/sdb: 6442 MB, 6442450944 bytes
255 heads, 63 sectors/track, 783 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System
/dev/sdb1               1         244     1959898+  83  Linux
/dev/sdb2             245         488     1959930   83  Linux

Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
p
Partition number (1-4): 3
First cylinder (489-783, default 489):
Using default value 489
Last cylinder or +size or +sizeM or +sizeK (489-783, default 783):
Using default value 783

Command (m for help): p

Disk /dev/sdb: 6442 MB, 6442450944 bytes
255 heads, 63 sectors/track, 783 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System
/dev/sdb1               1         244     1959898+  83  Linux
/dev/sdb2             245         488     1959930   83  Linux
/dev/sdb3             489         783     2369587+  83  Linux

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.

2.安装asm包

[root@ocp asm2.6.18.164-el5]# rpm -ivh oracleasm-support-2.1.7-1.el5.i386.rpm
warning: oracleasm-support-2.1.7-1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
   1:oracleasm-support      ########################################### [100%]
[root@ocp asm2.6.18.164-el5]# rpm -ivh oracleasm-2.6.18-164.el5-2.0.5-1.el5.i686.rpm
warning: oracleasm-2.6.18-164.el5-2.0.5-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
   1:oracleasm-2.6.18-164.el########################################### [100%]
[root@ocp asm2.6.18.164-el5]# rpm -ivh oracleasmlib-2.0.4-1.el5.i386.rpm        warning: oracleasmlib-2.0.4-1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
   1:oracleasmlib           ########################################### [100%]

3.初始化ASM

[root@ocp asm2.6.18.164-el5]# /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 without typing an
answer will keep that current value.  Ctrl-C will abort.

Default user to own the driver interface []: oracle
Default group to own the driver interface []: orainstall
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver:                     [  OK  ]
Scanning the system for Oracle ASMLib disks:               [  OK  ]

4.创建asm磁盘

[root@ocp asm2.6.18.164-el5]# /etc/init.d/oracleasm createdisk vol1 /dev/sdb1
Marking disk "vol1" as an ASM disk:                        [  OK  ]
[root@ocp asm2.6.18.164-el5]# /etc/init.d/oracleasm createdisk vol2 /dev/sdb2
Marking disk "vol2" as an ASM disk:                        [  OK  ]
[root@ocp asm2.6.18.164-el5]# /etc/init.d/oracleasm createdisk vol3 /dev/sdb3
Marking disk "vol3" as an ASM disk:                        [  OK  ]

列出所有asm磁盘

[root@ocp ~]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3

扫描asm磁盘

[root@ocp ~]# /etc/init.d/oracleasm scandisks
Scanning the system for Oracle ASMLib disks:               [  OK  ]

5.创建ASM实例

设置当前sid为asm

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

取一个pfile模板文件,并进行修改

[oracle@ocp ~]$ cat $ORACLE_HOME/dbs/init.ora |grep -v ^# >$ORACLE_HOME/dbs/init+ASM.ora
[oracle@ocp ~]$ mkdir /u01/oracle/admin/+ASM/{b,c,u}dump -p
[oracle@ocp ~]$ cd $ORACLE_HOME/dbs

修改初始化文件

[oracle@ocp dbs]$ vi init+ASM.ora

注意:这里需要删除原先的内容,新增以下内容:

asm_diskstring='ORCL:VOL*'
background_dump_dest='/u01/oracle/admin/+ASM/bdump'
user_dump_dest='/u01/oracle/admin/+ASM/udump'
instance_type='asm'
large_pool_size=30m
core_dump_dest='/u01/oracle/admin/+ASM/cdump'

6.创建密码文件,注意在dbs目录下

[oracle@ocp dbs]$ orapwd file=orapw+ASM password=oracle

7.启动css集群服务

[oracle@ocp dbs]$ exit
[root@ocp ~]# cd /u01/oracle/product/10gr2/db10g/bin
[root@ocp bin]# ./localconfig add
/etc/oracle does not exist. Creating it now.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized

Adding to inittab
Startup will be queued to init within 90 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
        ocp
CSS is active on all nodes.
Oracle CSS service is installed and running under init(1M)

8.启动asm实例
[root@ocp bin]# su - oracle
[oracle@ocp ~]$ export ORACLE_SID=+ASM
[oracle@ocp ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 7 14:17:19 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup
ASM instance started

Total System Global Area  104857600 bytes
Fixed Size                  1217956 bytes
Variable Size              78473820 bytes
ASM Cache                  25165824 bytes
ORA-15110: no diskgroups mounted

因为我们还没有进行磁盘组的分配,所以报错ORA-15110是正常的。

创建磁盘组
第一个我们是用来放数据文件的用的是normal方式
SQL> create diskgroup oradata normal redundancy disk 'ORCL:VOL1','ORCL:VOL2';

Diskgroup created.
这里我们是用来放闪回区的,选择为外部冗余的方式
SQL> create diskgroup fla external redundancy disk 'ORCL:VOL3' size 2G;

Diskgroup created.

查看一下我们的磁盘组
SQL> select GROUP_NUMBER,NAME,BLOCK_SIZE,STATE,TYPE from v$asm_diskgroup;

GROUP_NUMBER NAME                           BLOCK_SIZE      STATE       TYPE
------------ ------------------------------ ---------- ----------- ------
           1     ORADATA                              4096                            MOUNTED     NORMAL
           2     FLA                                         4096                             MOUNTED     EXTERN

ASM实例已经启动,这个时候我们就可以用DBCA来创建数据库了,唯一需要注意的是在选择数据文件和闪回区存放位置的时候设置一下


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

请登录后发表评论 登录
全部评论

注册时间:2011-04-12

  • 博文量
    28
  • 访问量
    82294