鸿 网 互 联 www.68idc.cn

当前位置 : 服务器租用 > 数据库 > mysql > >

Redhat 5.5 Oracle 10g 文件系统单实例迁移至ASM实战

来源:互联网 作者:佚名 时间:2014-04-25 07:14
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 <ENTER> withouttyping an

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

linux

网友评论
<