[root@std u01]# fdisk -lDisk /dev/sda: 42.9 GB, 42949672960 bytes255 heads, 63 sectors/track, 5221 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes   Device Boot      Start         End      Blocks   Id  System/dev/sda1   *           1        4698    37736653+  83  Linux/dev/sda2            4699        5220     4192965   82  Linux swap / SolarisDisk /dev/sdb: 2147 MB, 2147483648 bytes255 heads, 63 sectors/track, 261 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes   Device Boot      Start         End      Blocks   Id  SystemDisk /dev/sdc: 2147 MB, 2147483648 bytes255 heads, 63 sectors/track, 261 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes   Device Boot      Start         End      Blocks   Id  SystemDisk /dev/sdd: 2147 MB, 2147483648 bytes255 heads, 63 sectors/track, 261 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes   Device Boot      Start         End      Blocks   Id  SystemDisk /dev/sde: 2147 MB, 2147483648 bytes255 heads, 63 sectors/track, 261 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes   Device Boot      Start         End      Blocks   Id  System

[root@std u01]# fdisk /dev/sdbCommand (m for help): nCommand action   e   extended   p   primary partition (1-4)pPartition number (1-4): 1First cylinder (1-261, default 1): Using default value 1Last cylinder or +size or +sizeM or +sizeK (1-261, default 261): Using default value 261Command (m for help): wThe partition table has been altered!Calling ioctl() to re-read partition table.Syncing disks.

[root@std u01]# ll /dev/sd*brw-r----- 1 root disk 8,  0 Jan 30 09:10 /dev/sdabrw-r----- 1 root disk 8,  1 Jan 30 09:10 /dev/sda1brw-r----- 1 root disk 8,  2 Jan 30 09:10 /dev/sda2brw-r----- 1 root disk 8, 16 Jan 30 13:30 /dev/sdbbrw-r----- 1 root disk 8, 17 Jan 30 13:30 /dev/sdb1brw-r----- 1 root disk 8, 32 Jan 30 13:37 /dev/sdcbrw-r----- 1 root disk 8, 33 Jan 30 13:37 /dev/sdc1brw-r----- 1 root disk 8, 48 Jan 30 13:38 /dev/sddbrw-r----- 1 root disk 8, 49 Jan 30 13:38 /dev/sdd1brw-r----- 1 root disk 8, 64 Jan 30 13:39 /dev/sdebrw-r----- 1 root disk 8, 65 Jan 30 13:39 /dev/sde1

[root@std u01]# vi /etc/sysconfig/rawdevices [root@std u01]# cat /etc/sysconfig/rawdevices # raw device bindings# format:  <rawdev> <major> <minor>#          <rawdev> <blockdev># example: /dev/raw/raw1 /dev/sda1#          /dev/raw/raw2 8 5/dev/raw/raw1  /dev/sdb1/dev/raw/raw2  /dev/sdc1/dev/raw/raw3  /dev/sdd1/dev/raw/raw4  /dev/sde1[root@std u01]# service rawdevices restartAssigning devices:            /dev/raw/raw1  -->   /dev/sdb1/dev/raw/raw1:  bound to major 8, minor 17           /dev/raw/raw2  -->   /dev/sdc1/dev/raw/raw2:  bound to major 8, minor 33           /dev/raw/raw3  -->   /dev/sdd1/dev/raw/raw3:  bound to major 8, minor 49           /dev/raw/raw4  -->   /dev/sde1/dev/raw/raw4:  bound to major 8, minor 65done[root@std u01]# raw -qa/dev/raw/raw1:  bound to major 8, minor 17/dev/raw/raw2:  bound to major 8, minor 33/dev/raw/raw3:  bound to major 8, minor 49/dev/raw/raw4:  bound to major 8, minor 65

[root@std u01]# cd /dev/raw[root@std raw]# ll total 0crw------- 1 root root 162, 1 Jan 30 13:42 raw1crw------- 1 root root 162, 2 Jan 30 13:42 raw2crw------- 1 root root 162, 3 Jan 30 13:42 raw3crw------- 1 root root 162, 4 Jan 30 13:42 raw4[root@std raw]# chown oracle:dba raw*[root@std raw]# lltotal 0crw------- 1 oracle dba 162, 1 Jan 30 13:42 raw1crw------- 1 oracle dba 162, 2 Jan 30 13:42 raw2crw------- 1 oracle dba 162, 3 Jan 30 13:42 raw3crw------- 1 oracle dba 162, 4 Jan 30 13:42 raw4

[root@std raw]# cat /etc/rc.local |grep chownchown oracle:dba /dev/raw/raw[1-4][root@std raw]# 

[root@std u01]# uname -raLinux std 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:43 EDT 2010 i686 i686 i386 GNU/Linux[root@std u01]# ll oracleasm*-rw-r--r-- 1 root root 130018 Jul 24  2013 oracleasm-2.6.18-194.el5-2.0.5-1.el5.i686.rpm-rw-r--r-- 1 root root 130966 Jul 24  2013 oracleasm-2.6.18-194.el5debug-2.0.5-1.el5.i686.rpm-rw-r--r-- 1 root root   2844 Jul 24  2013 oracleasm-2.6.18-194.el5-debuginfo-2.0.5-1.el5.i686.rpm-rw-r--r-- 1 root root 130595 Jul 24  2013 oracleasm-2.6.18-194.el5PAE-2.0.5-1.el5.i686.rpm-rw-r--r-- 1 root root 128392 Jul 24  2013 oracleasm-2.6.18-194.el5xen-2.0.5-1.el5.i686.rpm-rw-r--r-- 1 root root  13929 Jul 24  2013 oracleasmlib-2.0.4-1.el5.i386.rpm-rw-r--r-- 1 root root  85303 Jul 24  2013 oracleasm-support-2.1.8-1.el5.i386.rpm[root@std u01]# rpm -ivh oracleasm*    --这些包之前我们以安装过warning: oracleasm-2.6.18-194.el5-2.0.5-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159Preparing...                ########################################### [100%]        package oracleasm-support-2.1.8-1.el5.i386 is already installed        package oracleasm-2.6.18-194.el5xen-2.0.5-1.el5.i686 is already installed        package oracleasm-2.6.18-194.el5-2.0.5-1.el5.i686 is already installed        package oracleasm-2.6.18-194.el5debug-2.0.5-1.el5.i686 is already installed        package oracleasm-2.6.18-194.el5-debuginfo-2.0.5-1.el5.i686 is already installed        package oracleasm-2.6.18-194.el5PAE-2.0.5-1.el5.i686 is already installed        package oracleasmlib-2.0.4-1.el5.i386 is already installed

[root@std u01]# /etc/init.d/oracleasm configureConfiguring the Oracle ASM library driver.This will configure the on-boot properties of the Oracle ASM librarydriver. The following questions will determine whether the driver isloaded on boot and what permissions it will have. The current valueswill be shown in brackets (‘[]‘). Hitting <ENTER> without typing ananswer will keep that current value. Ctrl-C will abort.Default user to own the driver interface [ ]:oracleDefault group to own the driver interface [ ]:oinstallStart Oracle ASM library driver on boot (y/n) [y]:Scan for Oracle ASM disks on boot (y/n) [y]:Writing Oracle ASM library driver configuration: doneInitializing the Oracle ASMLib driver:                    [ OK ]Scanning the system for Oracle ASMLib disks:              [ OK ][root@std u01]# lsmod |grep asmoracleasm              46356  1 

[root@std u01]# su - oracle[oracle@std ~]$ cd $ORACLE_HOME/dbs[oracle@std dbs]$ mkdir -p $ORACLE_BASE/admin/+ASM/{b,c,u}dump[oracle@std dbs]$ touch init+ASM.ora[oracle@std dbs]$ vi init+ASM.ora [oracle@std dbs]$ cat init+ASM.ora *.asm_diskstring=‘/dev/raw/raw*‘*.instance_type=‘asm‘*.large_pool_size=24M*.remote_login_passwordfile=‘SHARED‘*.background_dump_dest=‘/u02/app/admin/+ASM/bdump‘*.core_dump_dest=‘/u02/app/admin/+ASM/cdump‘*.user_dump_dest=‘/u02/app/admin/+ASM/bdump‘[oracle@std dbs]$ 

[oracle@std dbs]$ orapwd file=orapw+ASM password=oracle1[oracle@std dbs]$ 

[oracle@std ~]# /u02/app/product/10.2.0/db_1/bin/localconfig add/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 initializedAdding 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.localhostCSS is active on all nodes.Oracle CSS service is installed and running under init(1M)

[oracle@std dbs]$ crsctl check cssCSS appears healthy[oracle@std dbs]$ crsctl check crsCSS appears healthyCannot communicate with CRSCannot communicate with EVM 

[oracle@std dbs]$ export ORACLE_SID=+ASM[oracle@std dbs]$ sqlplus ‘/as sysdba‘SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jan 30 14:34:00 2015Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.Connected to an idle instance.SQL> startupASM instance startedTotal System Global Area   96468992 bytesFixed Size                  1265984 bytesVariable Size              70037184 bytesASM Cache                  25165824 bytesORA-15110: no diskgroups mounted

SQL> create spfile from pfile;File created.SQL> shutdown abortASM instance shutdownSQL> startupASM instance startedTotal System Global Area   96468992 bytesFixed Size                  1265984 bytesVariable Size              70037184 bytesASM Cache                  25165824 bytesORA-15110: no diskgroups mountedSQL> show parameter spfileNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------spfile                               string      /u02/app/product/10.2.0/db_1/d                                                 bs/spfile+ASM.ora

SQL> select path from v$asm_disk;PATH--------------------------------------------------------------------------------/dev/raw/raw4/dev/raw/raw3/dev/raw/raw2/dev/raw/raw1

CREATE DISKGROUP diskgroup_name[ { HIGH | NORMAL | EXTERNAL } REDUNDANCY ][ FAILGROUP failgroup_name ]DISK [ NAME disk_name ] [ SIZE size_clause ] [ FORCE | NOFORCE ] ...;

SQL> create diskgroup DATA external redundancy  2  disk ‘/dev/raw/raw1‘,‘/dev/raw/raw2‘;Diskgroup created.SQL> create diskgroup FLA external redundancy  2  disk ‘/dev/raw/raw3‘,‘/dev/raw/raw4‘;Diskgroup created.SQL> select GROUP_NUMBER,NAME,TOTAL_MB,FREE_MB from v$asm_diskgroup;GROUP_NUMBER NAME                             TOTAL_MB    FREE_MB------------ ------------------------------ ---------- ----------           1 DATA                                 4094       4042           2 FLA                                  4094       4042

[oracle@std bdump]$ export ORACLE_SID=+ASM[oracle@std bdump]$ sqlplus ‘/as sysdba‘SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jan 30 15:21:00 2015Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> alter system register;System altered.

[oracle@std ~]$ lsnrctl statusLSNRCTL for Linux: Version 10.2.0.4.0 - Production on 30-JAN-2015 15:19:33Copyright (c) 1991, 2007, Oracle.  All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))STATUS of the LISTENER------------------------Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 10.2.0.4.0 - ProductionStart Date                30-JAN-2015 15:19:15Uptime                    0 days 0 hr. 0 min. 18 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Log File         /u02/app/product/10.2.0/db_1/network/log/listener.logListening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=std)(PORT=1521)))Services Summary...Service "+ASM" has 1 instance(s).  Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...Service "+ASM_XPT" has 1 instance(s).  Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...The command completed successfully

asm= (DESCRIPTION=   (ADDRESS= (PROTOCOL=tcp)(HOST=192.168.1.172)(PORT=1521))  (CONNECT_DATA=      (SERVICE_NAME=+ASM)     (UR=A)))

C:\Users\Administrator>sqlplus sys/oracle1@asm as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on 星期五 1月 30 15:27:08 2015Copyright (c) 1982, 2005, Oracle.  All rights reserved.连接到:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select group_number,name from v$asm_diskgroup;GROUP_NUMBER NAME------------ ------------------------------------------------------------           1 DATA           2 FLA