Redhat 5.5 Oracle 10g 文件系统单实例迁移至ASM实战
Redhat 5.5 Oracle 10g 文件系统单实例迁移至ASM实战
RedHat 5.5 Oracle 10g 文件系统单实例迁移至ASM实战
1.安装ASMlib RPM包:
rpm -ivhoracleasm-support-2.1.7-1.el5.i386.rpm
rpm -ivh oracleasm-2.6.18-194.el5-2.0.5-1.el5.i686.rpm
rpm -ivhoracleasmlib-2.0.4-1.el5.i386.rpm
2.建立分区：
[root@source ~]# fdisk -l /dev/sdb
Disk /dev/sdb: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdb1 1 730 5863693+ 83 Linux
/dev/sdb2 731 1305 4618687+ 83 Linux
fdisk /dev/sdb（详细步骤省略,两个分区各5G）
partprobe /dev/sdb
[root@source ~]# 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 * 1 25 200781 83 Linux
/dev/sda2 26 1894 15012742+ 83 Linux
/dev/sda3 1895 1958 514080 82 Linux swap / Solaris
Disk /dev/sdb: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdb1 1 730 5863693+ 83 Linux
/dev/sdb2 731 1305 4618687+ 83 Linux
3.配置ASM:
[root@source ~]#/etc/init.d/oracleasm configure
Configuring the Oracle ASMlibrary driver.
This will configure theon-boot properties of the Oracle ASM library
driver. The following questions will determinewhether the driver is
loaded on boot and whatpermissions it will have. The currentvalues
will be shown in brackets('[]'). Hitting
answer will keep that currentvalue. Ctrl-C will abort.
Default user to own thedriver interface []: oracle
Default group to own thedriver interface []: oinstall
Start Oracle ASM library driveron boot (y/n) [y]: y
Scan for Oracle ASM disks onboot (y/n) [y]: y
Writing Oracle ASM librarydriver configuration: done
Initializing the OracleASMLib driver: [ OK ]
Scanning the system forOracle ASMLib disks: [ OK ]
/etc/init.d/oracleasmconfigure
/etc/init.d/oracleasm createdisk V0L1/dev/sdb1
/etc/init.d/oracleasm createdisk V0L2/dev/sdb2
[root@source ~]#/etc/init.d/oracleasm listdisks
V0L1
V0L2
4.配置css进程（配置好后，进程开机启动）：
[root@source bin]# /u01/oracle/product/10.2.0/bin/localconfigadd
/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.
source
CSS is active on all nodes.
Oracle CSS service is installed and running underinit(1M)
[oracle@source ~]$ ps -ef|grep oracle
root 4751 1 0 10:18 ? 00:00:00 /bin/su -l oracle -c sh -c 'cd/u01/oracle/product/10.2.0/log/source/cssd; ulimit -c unlimited; exec /u01/oracle/product/10.2.0/bin/ocssd '
oracle 4843 4751 0 10:19 ? 00:00:00/u01/oracle/product/10.2.0/bin/ocssd.bin
5.配置ASM实例：
创建ASM实例参数文件，，添加相关参数：
[oracle@source ~]$ cd /u01/oracle/product/10.2.0/dbs/
[oracle@source dbs]$ touch init+ASM.ora
[oracle@source dbs]$ vim init+ASM.ora
instance_type=asm
large_pool_size=12m
remote_login_passwordfile=exclusive
asm_diskstring=
background_dump_dest=/u01/oracle/admin/+ASM/bdump
core_dump_dest=/u01/oracle/admin/+ASM/cdump
user_dump_dest=/u01/oracle/admin/+ASM/udump
创建ASM密码文件：
orapwd file=orapw+ASM entries=5 password=oracle