配置安装ORacle10g ASM

最近学习安装Oracle10g ASM，期间有很多问题，记录一下，供初学者step by step.

 

红色的字是输入

 

查看内核版本：

[oracle@ocp oracle]$ cat /proc/version

Linux version 2.4.21-50.EL ([e-mail]) (gcc version 3.2.3 20030502 (Red Hat Linux 3.2.3-58)) #1 Tue May 8 17:26:44 EDT 2007

[oracle@ocp oracle]$

 

已经安装好了Oracle 10g 10.2.0.1

并在虚拟机上新添加了4个scsi硬盘设备

 

现在配置安装ASM

 

先要下载所需的三个包

安装：

$su –

# rpm -Uvh oracleasm-support-1.0.2-1.i386.rpm /

    oracleasm-lib-1.0.0-1.i386.rpm /

oracleasm-2.4.21-EL-1.0.0-1.i686.rpm

          

配置ASMLib：

# /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 []: dba

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

Fix permissions of Oracle ASM disks on boot (y/n) [y]: y

Writing Oracle ASM library driver configuration               [  OK  ]

Creating /dev/oracleasm mount point                       [  OK  ]

Loading module "oracleasm"                                [  OK  ]

Mounting ASMlib driver filesystem                           [  OK  ]

Scanning system for ASM disks                             [  OK  ]

 

 

以上操作将加载oracleasm.o驱动，并且mount上ASM文件系统，通过以下命令来手工加载ASMLib

# /etc/init.d/oracleasm enable

Writing Oracle ASM library driver configuration              [  OK  ]

Loading module "oracleasm"                               [  OK  ]

Mounting ASMlib driver filesystem                           [  OK  ]

Scanning system for ASM disks                            [  OK  ]

 

 

重新启动系统，确认ASMLib已经可以自动加载

#dmesg | grep oracleasm

ASM: oracleasmfs mounted with options: <defaults>

 

格式化磁盘

root@orahost01 dev]#fdisk 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): m
Command action
   a   toggle a bootable flag
   b   edit bsd disklabel
   c   toggle the dos compatibility flag
   d   delete a partition
   l   list known partition types
   m   print this menu
   n   add a new partition
   o   create a new empty DOS partition table
   p   print the partition table
   q   quit without saving changes
   s   create a new empty Sun disklabel
   t   change a partition's system id
   u   change display/entry units
   v   verify the partition table
   w   write table to disk and exit
   x   extra functionality (experts only)

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

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

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

这个时候系统中会出现一个sdb1这个设备文件

之后我们继续对sdc,sdd,sde以上面同样的方法来进行分区。

 

 

 

创建ASM磁盘

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

Marking disk "/dev/sdb" as an ASM disk [  OK  ]

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

Marking disk "/dev/sdc" as an ASM disk [  OK  ]

# /etc/init.d/oracleasm createdisk VOL3 /dev/sdd1

Marking disk "/dev/sdd" as an ASM disk [  OK  ]

#/etc/init.d/oracleasm createdisk VOL4 /dev/sde1

Marking disk "/dev/sde" as an ASM disk [  OK  ]

 

# /etc/init.d/oracleasm listdisks

VOL1

VOL2

VOL3

VOL4

 

 

需要注意的是如果是在RAC环境中呢，如果在一个节点添加了ASM磁盘，在其他节点上要用过scandisks命令来获得这种变化。
如：
[root@orahost01 dev]#/etc/init.d/oracleasm scandisks
Scanning system for ASM disks: [  OK  ]

就此ASM环境的物理基础就已经搭建成功.

 

用dbca创建数据库，一直到选择数据类型的画面以前都跟创建普通数据库没有区别。

dbca创建数据库的第6步，普通的数据库我们通常选择File System，而ASM类型的数据库我们则要选择“Automatic Storage Management”。

下一步，oracle将自动检查出已经加载的Diskgroup，在这个界面我们可以通过Create New按钮创建新的Diskgroup，也可以通过Add Disks按钮向当前的磁盘组中添加额外的磁盘，当然这些磁盘必须是先用oracleasm createdisk过的。

在数据文件的位置管理设定界面，通常应该使用OMF，由oracle自己管理数据文件的命名，这样才算是进一步解放了DBA对于物理存储方面的繁琐工作。

继续往下的步骤，跟创建普通数据库已经没有什么区别了。不再赘述。