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 bytes255 heads, 63 sectors/track, 1305 cylindersUnits = 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 -lDisk /dev/sda: 16.1 GB, 16106127360 bytes255 heads, 63 sectors/track, 1958 cylindersUnits = 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 bytes255 heads, 63 sectors/track, 1305 cylindersUnits = 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 configureConfiguring the Oracle ASMlibrary driver. This will configure theon-boot properties of the Oracle ASM librarydriver. The following questions will determinewhether the driver isloaded on boot and whatpermissions it will have. The currentvalueswill be shown in brackets（"[]"）. Hitting <ENTER> withouttyping ananswer will keep that currentvalue. Ctrl-C will abort. Default user to own thedriver interface []: oracleDefault group to own thedriver interface []: oinstallStart Oracle ASM library driveron boot （y/n） [y]: yScan for Oracle ASM disks onboot （y/n） [y]: yWriting Oracle ASM librarydriver configuration: doneInitializing 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 listdisksV0L1V0L2 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 inittabStartup 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. sourceCSS is active on all nodes.Oracle CSS service is installed and running underinit（1M） [oracle@source ~]$ ps -ef|grep oracleroot 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.orainstance_type=asmlarge_pool_size=12mremote_login_passwordfile=exclusiveasm_diskstring=background_dump_dest=/u01/oracle/admin/+ASM/bdumpcore_dump_dest=/u01/oracle/admin/+ASM/cdumpuser_dump_dest=/u01/oracle/admin/+ASM/udump 创建ASM密码文件：orapwd file=orapw+ASM entries=5 password=oracle

修改Oracle 11g账户密码过期时间Redhat 5.5 Oracle RAC 数据库从10.2.0.1升级到 10.2.0.5相关资讯 ORACLE 10G Oracle asm Oracle 10g ASM

Oracle 10g（10.2.0.4）升级到10.2.0 （04月10日）
Oracle中的ASM文化（08/20/2015 20:51:26）
Oracle 10g 一主多备的搭建技巧（07/31/2015 15:31:51）

Oracle ASM异常dismount磁盘组（04月10日）
Oracle 10g实现只读表的N种方法（08/05/2015 10:54:35）
Oracle 10g中约束与列属性NULLABLE （03/07/2015 19:22:46）

本文评论查看全部评论（0）