Linux安装单实例Oracle11g ASM

[root@asm ~]# fdisk -l

Disk /dev/sda: 42.9 GB, 42949672960 bytes
255 heads, 63 sectors/track, 5221 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1          13      104391   83  Linux
/dev/sda2              14        5221    41833260   8e  Linux LVM

Disk /dev/sdb: 21.4 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System
/dev/sdb1               1         974     7823623+  83  Linux
/dev/sdb2             975        1948     7823655   83  Linux

root@asm ~]# fdisk /dev/sdb

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
         switch off the mode (command 'c') and change display units to
         sectors (command 'u').
----------输入m 查看帮助
Command (m for help): m
Command action
   a   toggle a bootable flag
   b   edit bsd disklabel
   c   toggle the dos compatibility flag
   d   delete a partition
   l   list known partition types
   m   print this menu
   n   add a new partition
   o   create a new empty DOS partition table
   p   print the partition table
   q   quit without saving changes
   s   create a new empty Sun disklabel
   t   change a partition's system id
   u   change display/entry units
   v   verify the partition table
   w   write table to disk and exit
   x   extra functionality (experts only)
-------------输入p查看
Command (m for help): p

Disk /dev/sdb: 21.5 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0xf9f81f26

   Device Boot      Start         End      Blocks   Id  System
-----------输入n新建分区（e是扩展分区，p是主要分区）
Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)

-----------创建主分区，输入分区号1，设置大小+8G
p
Partition number (1-4): 1
First cylinder (1-2610, default 1): 
Using default value 1
Last cylinder, +cylinders or +size{K,M,G} (1-2610, default 2610): +8G

Command (m for help): p

Disk /dev/sdb: 21.5 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0xf9f81f26

   Device Boot      Start         End      Blocks   Id  System
/dev/sdb1               1        1045     8393931   83  Linux

Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
p
Partition number (1-4): 2
First cylinder (1046-2610, default 1046): 
Using default value 1046
Last cylinder, +cylinders or +size{K,M,G} (1046-2610, default 2610): +8G       

Command (m for help): p

Disk /dev/sdb: 21.5 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0xf9f81f26

   Device Boot      Start         End      Blocks   Id  System
/dev/sdb1               1        1045     8393931   83  Linux
/dev/sdb2            1046        2090     8393962+  83  Linux
-----------输入w保存
Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.

WARNING: Re-reading the partition table failed with error 16: Device or resource busy.
The kernel still uses the old table. The new table will be used at
the next reboot or after you run partprobe(8) or kpartx(8)
Syncing disks.

[root@asm ~]# more /etc/udev/rules.d/60-raw.rules
# Enter raw device bindings here.
#
# An example would be:
#   ACTION=="add", KERNEL=="sda", RUN+="/bin/raw /dev/raw/raw1 %N"
# to bind /dev/raw/raw1 to /dev/sda, or
#   ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="1", RUN+="/bin/raw /dev/raw/raw
2 %M %m"
# to bind /dev/raw/raw2 to the device with major 8, minor 1.

ACTION=="add", KERNEL=="sdb1", RUN+="/bin/raw /dev/raw/raw1 %N"
ACTION=="add", KERNEL=="sdb2", RUN+="/bin/raw /dev/raw/raw2 %N"
KERNEL=="raw*", OWNER="grid" GROUP="dba", MODE="0660"

[root@asm ~]# ls /dev/raw
raw1  raw2

[grid@asm ~]$ ps -ef | grep  asm
avahi     3322     1  0 11:03 ?        00:00:00 avahi-daemon: running [asm.local]
grid     26982     1  0 12:51 ?        00:00:00 asm_pmon_+ASM
grid     26984     1  0 12:51 ?        00:00:00 asm_psp0_+ASM
grid     26986     1  0 12:51 ?        00:00:00 asm_vktm_+ASM
grid     26990     1  0 12:51 ?        00:00:00 asm_gen0_+ASM
grid     26992     1  0 12:51 ?        00:00:00 asm_diag_+ASM
grid     26994     1  0 12:51 ?        00:00:00 asm_dia0_+ASM
grid     26996     1  0 12:51 ?        00:00:00 asm_mman_+ASM
grid     26998     1  0 12:51 ?        00:00:00 asm_dbw0_+ASM
grid     27000     1  0 12:51 ?        00:00:00 asm_lgwr_+ASM
grid     27002     1  0 12:51 ?        00:00:00 asm_ckpt_+ASM
grid     27004     1  0 12:51 ?        00:00:00 asm_smon_+ASM
grid     27006     1  0 12:51 ?        00:00:00 asm_rbal_+ASM
grid     27008     1  0 12:51 ?        00:00:00 asm_gmon_+ASM
grid     27010     1  0 12:51 ?        00:00:00 asm_mmon_+ASM
grid     27012     1  0 12:51 ?        00:00:00 asm_mmnl_+ASM
grid     27081 27056  0 12:56 pts/4    00:00:00 grep asm

login as: grid
grid@192.168.100.203's password:
Last login: Wed Dec 11 12:36:47 2013 from 192.168.100.111
-----------这里面必须使用sysasm来登录而不能使用sysdba
[grid@asm ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 11 13:07:41 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option

SQL> set line 2000
SQL> set long 2000
---------查看磁盘状态，现在是两个裸设备Raw1和raw2，raw1已经被使用了创建griddg磁盘组了
SQL> select name,path from v$asm_disk;

NAME                           PATH
------------------------------ ------------------
                               /dev/raw/raw2
GRIDDG_0000                    /dev/raw/raw1


-----------查看磁盘组状态，可以看到griddg是mounted状态
SQL> select name ,state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
GRIDDG                         MOUNTED

[grid@asm ~]$ asmcmd
ASMCMD> help

            asmcmd [-V] [-v <errors>] [--privilege <s ysasm>] [-p] [command]
asmcmd_no_conn_str

        Starts asmcmd or executes the command

        asmcmd [-V] [-v <errors>] [--privilege <sysas m>] [-p] [command]

        The environment variables ORACLE_HOME and ORACLE_SID determine the
        instance to which the program connects, and ASMCMD establishes a
        bequeath connection to it, in the same manner as a SQLPLUS / AS
        SYSASM.  The user must be a member of the OSASM group.

        Specifying the -V option prints the asmcmd version number and
        exits immediately.

        Specifying the -v option prints extra information that can help
        advanced users diagnose problems.

        Specify the --privilege option to choose the type of connection. There a                                                                                                              re
        only two possibilities: connecting as SYSASM or as SYSDBA.
        The default value if this option is unspecified is SYSASM.

        Specifying the -p option allows the current directory to be displayed
        in the command prompt, like so:

        ASMCMD [+DATA/ORCL/CONTROLFILE] >

        [command] specifies one of the following commands, along with its
        parameters.

        Type "help [command]" to get help on a specific ASMCMD command.';

        commands:
        --------

        md_backup, md_restore

        lsattr, setattr

        cd, cp, du, find, help, ls, lsct, lsdg, lsof, mkalias
        mkdir, pwd, rm, rmalias

        chdg, chkdg, dropdg, iostat, lsdsk, lsod, mkdg, mount
        offline, online, rebal, remap, umount

        dsget, dsset, lsop, shutdown, spbackup, spcopy, spget
        spmove, spset, startup

        chtmpl, lstmpl, mktmpl, rmtmpl

        chgrp, chmod, chown, groups, grpmod, lsgrp, lspwusr, lsusr
        mkgrp, mkusr, orapwusr, passwd, rmgrp, rmusr

        volcreate, voldelete, voldisable, volenable, volinfo
        volresize, volset, volstat
</sysas></errors></s></errors>

[oracle@asm ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 11 17:58:29 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
+DATADG/orcl/datafile/system.260.833896429
+DATADG/orcl/datafile/sysaux.261.833896455
+DATADG/orcl/datafile/undotbs1.262.833896477
+DATADG/orcl/datafile/users.264.833896499