手动创建Oracle 10g ASM磁盘组

准备环境：Oracle 10g 联机文档、已经配置10g数据库软件的主机、oracleasm library rpm包、2块5GB硬盘1、查看本机磁盘信息[root@shiyueasm~]# fdisk -l Disk/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 * 307 1958 13269690 83 Linux/dev/sda2 1 306 2457913+ 82 Linux swap Partitiontable entries are not in disk order Disk/dev/sdb: 10.7 GB, 10737418240 bytes255heads, 63 sectors/track, 1305 cylindersUnits =cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System/dev/sdb1 * 1 1305 10482381 83 Linux Disk/dev/sdc: 5368 MB, 5368709120 bytes255heads, 63 sectors/track, 652 cylindersUnits =cylinders of 16065 * 512 = 8225280 bytes Disk/dev/sdc doesn"t contain a valid partition table Disk/dev/sdd: 5368 MB, 5368709120 bytes255heads, 63 sectors/track, 652 cylindersUnits =cylinders of 16065 * 512 = 8225280 bytes Disk /dev/sdd doesn"t contain a validpartition table2、对新添加的2块磁盘进行分区[root@shiyueasm~]# fdisk /dev/sdcDevicecontains neither a valid DOS partition table, nor Sun, SGI or OSF disklabelBuildinga new DOS disklabel. Changes will remain in memory only,until youdecide to write them. After that, of course, the previouscontentwon"t be recoverable. Warning:invalid flag 0x0000 of partition table 4 will be corrected by w（rite） Command（m for help）: nCommandaction e extended p primary partition （1-4）pPartitionnumber （1-4）: 1Firstcylinder （1-652, default 1）: Usingdefault value 1Lastcylinder or +size or +sizeM or +sizeK （1-652, default 652）: Usingdefault value 652 Command（m for help）: wThepartition table has been altered！ Callingioctl（） to re-read partition table.Syncingdisks.[root@shiyueasm~]# fdisk /dev/sddDevicecontains neither a valid DOS partition table, nor Sun, SGI or OSF disklabelBuildinga new DOS disklabel. Changes will remain in memory only,until youdecide to write them. After that, of course, the previouscontentwon"t be recoverable. Warning:invalid flag 0x0000 of partition table 4 will be corrected by w（rite） Command（m for help）: nCommandaction e extended p primary partition （1-4）pPartitionnumber （1-4）: 1Firstcylinder （1-652, default 1）: Usingdefault value 1Lastcylinder or +size or +sizeM or +sizeK （1-652, default 652）: Usingdefault value 652 Command（m for help）: wThepartition table has been altered！ Callingioctl（） to re-read partition table.Syncing disks. 3、上传 oracle asmlibrary rpm包并对上传的包进行安装[root@shiyueasmu01]# cd asm rpm for rhel4.0/[root@shiyueasmasm rpm for rhel4.0]# lltotal 236-rw-r--r-- 1 root root 129218 Apr 29 2010oracleasm-2.6.9-42.ELsmp-2.0.3-1.i686.rpm-rw-r--r-- 1 root root 13105 Apr 29 2010oracleasmlib-2.0.4-1.el4.i386.rpm-rw-r--r-- 1 root root 82542 Apr 29 2010oracleasm-support-2.1.3-1.el4.i386.rpm[root@shiyueasmasm rpm for rhel4.0]# rpm -ivh *warning:oracleasmlib-2.0.4-1.el4.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516Preparing... ########################################### [100%] 1:oracleasm-support ########################################### [ 33%] 2:oracleasm-2.6.9-42.ELsm########################################### [67%] 3:oracleasmlib ########################################### [100%] 4、配置ASM驱动[root@shiyueasm~]# /etc/init.d/oracleasm configureConfiguringthe Oracle ASM library driver. This willconfigure the on-boot properties of the Oracle ASM librarydriver. The following questions will determinewhether the driver isloaded onboot and what permissions it will have. The current valueswill beshown in brackets （"[]"）. Hitting<ENTER> without typing ananswerwill keep that current value. Ctrl-Cwill abort. Defaultuser to own the driver interface []: oracleDefaultgroup to own the driver interface []: oinstallStartOracle ASM library driver on boot （y/n） [n]: yScan forOracle ASM disks on boot （y/n） [y]: WritingOracle ASM library driver configuration: doneInitializingthe Oracle ASMLib driver: [ OK ]Scanning the system for Oracle ASMLibdisks: [ OK ]5、创建ASM磁盘组[root@shiyueasm~]# /etc/init.d/oracleasm createdisk VOL01 "/dev/sdc1"Markingdisk "VOL02" as an ASM disk: [ OK ][root@shiyueasm~]# /etc/init.d/oracleasm createdisk VOL02 "/dev/sdd1"Marking disk "VOL01" as anASM disk: [ OK ]6、手动创建磁盘组参数文件[oracle@shiyueasm~]$ cd $ORACLE_HOME/dbs[oracle@shiyueasmdbs]$ lltotal 48-rw-r--r-- 1 oracle oinstall 934 May 26 10:52 db.sql-rw-rw---- 1 oracle oinstall 1544 May 26 10:32 hc_shiyue.dat-rw-r----- 1 oracle oinstall 12920 May 3 2001initdw.ora-rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora-rw-r--r-- 1 oracle oinstall 996 May 26 10:31 initshiyue.ora-rw-rw---- 1 oracle oinstall 24 May 26 10:52 lkSHIYUE-rw-r----- 1 oracle oinstall 1536 May 26 10:32 orapwshiyue[oracle@shiyueasm dbs]$ viinit+ASM.oraasm_diskstring=""background_dump_dest=/u01/admin/shiyueasm/bdumpcore_dump_dest=/u01/admin/shiyueasm/cdumpuser_dump_dest=/u01/admin/shiyueasm/udumpinstance_type="asm"large_pool_size=20mremote_login_passwordfile="shared"7、创建相关目录[oracle@shiyueasm~]$ mkdir -p /u01/admin/shiyueasm/bdump[oracle@shiyueasm~]$ mkdir -p /u01/admin/shiyueasm/cdump[oracle@shiyueasm ~]$ mkdir -p/u01/admin/shiyueasm/udump8、切换至ASM实例[oracle@shiyueasm ~]$ export ORACLE_SID=+ASM

Oracle笔记：dbca出错C [libnnz11.so+0x3c3a8]RedHat下MySQL 5.6 安装、维护相关资讯 Oracle教程

Oracle中纯数字的varchar2类型和（07/29/2015 07:20:43）
Oracle教程：Oracle中查看DBLink密（07/29/2015 07:16:55）
[Oracle] SQL*Loader 详细使用教程（08/11/2013 21:30:36）

Oracle教程：Oracle中kill死锁进程（07/29/2015 07:18:28）
Oracle教程：ORA-25153 临时表空间（07/29/2015 07:13:37）
Oracle教程之管理安全和资源（04/08/2013 11:39:32）

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