利用隐藏参数_asm_allow_only_raw_disks创建ASM环境

原创 2012年03月30日 13:46:35

[root@Oracle ~]# fdisk -l

Disk /dev/sda: 8589 MB, 8589934592 bytes
255 heads, 63 sectors/track, 1044 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *         132        1044     7333672+  83  Linux
/dev/sda2               1         131     1052226   82  Linux swap / Solaris

Partition table entries are not in disk order

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          56      449788+  83  Linux
/dev/sdb2              57        2489    19543072+  83  Linux

Disk /dev/sdc: 1073 MB, 1073741824 bytes
255 heads, 63 sectors/track, 130 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System
/dev/sdc1               1         130     1044193+  83  Linux

Disk /dev/sdd: 1073 MB, 1073741824 bytes
255 heads, 63 sectors/track, 130 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System
/dev/sdd1               1         130     1044193+  83  Linux

Disk /dev/sde: 1073 MB, 1073741824 bytes
255 heads, 63 sectors/track, 130 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System
/dev/sde1               1         130     1044193+  83  Linux

Disk /dev/sdf: 1073 MB, 1073741824 bytes
255 heads, 63 sectors/track, 130 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System
/dev/sdf1               1         130     1044193+  83  Linux
[root@Oracle ~]#

[root@Oracle ~]# /u01/app/oracle/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 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.
        oracle
CSS is active on all nodes.
Oracle CSS service is installed and running under init(1M)

[root@Oracle ~]$cd /dev
[root@Oracle ~]$chown oracle.oinstall sdc1
[root@Oracle ~]$chown oracle.oinstall sdd1
[root@Oracle ~]$chown oracle.oinstall sde1
[root@Oracle ~]$chown oracle.oinstall sdf1

[oracle@Oracle ~]$ vim /u01/app/oracle/product/10.2.0/db_1/dbs/init+ASM.ora

instance_type=asm
asm_diskstring='/dev/sd*'


~
~
<oracle/product/10.2.0/db_1/dbs/init+ASM.ora" 2L, 44C written
[oracle@Oracle dev]$ export ORACLE_SID=+ASM
[oracle@Oracle dev]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 30 12:56:40 2012

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL>

SQL> create spfile from pfile;

File created.
SQL> select path,header_status from v$asm_disk;

no rows selected
SQL> shutdown immediate
ORA-15100: invalid or missing diskgroup name


ASM instance shutdown
SQL> startup nomount
ASM instance started

Total System Global Area  125829120 bytes
Fixed Size                  2019000 bytes
Variable Size              98644296 bytes
ASM Cache                  25165824 bytes
SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/app/oracle/product/10.2.0
                                                 /db_1/dbs/spfile+ASM.ora
SQL>
SQL> alter system set "_asm_allow_only_raw_disks"=false scope=spfile sid='*';

System altered.

SQL> shutdown immediate
ORA-15100: invalid or missing diskgroup name


ASM instance shutdown
SQL> startup nomount
ASM instance started

Total System Global Area  125829120 bytes
Fixed Size                  2019000 bytes
Variable Size              98644296 bytes
ASM Cache                  25165824 bytes
SQL>
SQL> select path,header_status,library,total_mb,free_mb from v$asm_disk;

PATH
--------------------------------------------------------------------------------
HEADER_STATU LIBRARY
------------ ----------------------------------------------------------------
  TOTAL_MB    FREE_MB
---------- ----------
/dev/sdf1
MEMBER       System
      1019          0

/dev/sdc1
CANDIDATE    System
      1019          0

PATH
--------------------------------------------------------------------------------
HEADER_STATU LIBRARY
------------ ----------------------------------------------------------------
  TOTAL_MB    FREE_MB
---------- ----------

/dev/sdd1
MEMBER       System
      1019          0

/dev/sde1
MEMBER       System

PATH
--------------------------------------------------------------------------------
HEADER_STATU LIBRARY
------------ ----------------------------------------------------------------
  TOTAL_MB    FREE_MB
---------- ----------
      1019          0


SQL>

SQL> create diskgroup raw_dg normal redundancy failgroup
raw1 disk
'/dev/sdf1' name raw1_disk1,
'/dev/sdc1' name raw1_disk2
failgroup
raw2 disk
'/dev/sdd1' name raw_2disk1,
'/dev/sde1' name raw2_disk2;

Diskgroup created.

SQL>
SQL> select path,header_status,library,total_mb,free_mb from v$asm_disk;

PATH
--------------------------------------------------------------------------------
HEADER_STATU LIBRARY
------------ ----------------------------------------------------------------
  TOTAL_MB    FREE_MB
---------- ----------
/dev/sdf1
MEMBER       System
      1019        989

/dev/sde1
MEMBER       System
      1019        994

PATH
--------------------------------------------------------------------------------
HEADER_STATU LIBRARY
------------ ----------------------------------------------------------------
  TOTAL_MB    FREE_MB
---------- ----------

/dev/sdd1
MEMBER       System
      1019        991

/dev/sdc1
MEMBER       System

PATH
--------------------------------------------------------------------------------
HEADER_STATU LIBRARY
------------ ----------------------------------------------------------------
  TOTAL_MB    FREE_MB
---------- ----------
      1019        996


SQL>
SQL> select name,block_size,allocation_unit_size,state,type,total_mb,free_mb,usable_file_mb from v$asm_diskgroup
  2  /

NAME                           BLOCK_SIZE ALLOCATION_UNIT_SIZE STATE
------------------------------ ---------- -------------------- -----------
TYPE     TOTAL_MB    FREE_MB USABLE_FILE_MB
------ ---------- ---------- --------------
RAW_DG                               4096              1048576 MOUNTED
NORMAL       4076       3970           1475


SQL>

相关文章推荐

ASM在操作系统中创建一个RAW

sgcrm5*sgcrm5-/home/oracle >lsvg datavg VOLUME GROUP: datavg VG IDENTIFIER:...
  • rgb_rgb
  • rgb_rgb
  • 2012年06月25日 23:59
  • 615

Adding / Dropping Disks From a ASM Disk Group

磁盘组  Adding / Dropping Disks From a ASM Disk Group by Jeff Hunter, Sr. Database Administrator ...
  • cc_dba
  • cc_dba
  • 2014年09月20日 23:08
  • 418

RAC环境创建表空间,ASM磁盘组缺少”+“号引发的故障

RAC环境创建表空间,ASM磁盘组缺少”+“号引发的故障 环境介绍: OS:suse linux 11 Grid:11.2.0.4 Oracle db:11.2.0.4 ASM存储 4节点RAC ...
  • con596
  • con596
  • 2014年12月27日 14:47
  • 738

在windows中搭建虚拟ASM环境创建Oracle 10G数据库

本文分四部分,1,创建虚拟的ASM磁盘,2在虚拟的ASM磁盘上创建数据库,3,asmcmd工具,4为磁盘组增加磁盘 第一部分:创建虚拟的ASM磁盘:(本例中Oracle安装在D:\oracle\pr...
  • kkdelta
  • kkdelta
  • 2012年01月11日 20:37
  • 1493

linux上实战raw+asm+rman

  • 2011年12月03日 10:13
  • 320KB
  • 下载

存储技术SAN、NAS、NFS、DAS、RAW、文件系统、ASM、Exadata、HDFS、LVM、RAID、LUN、Samba

http://blog.csdn.net/luke_wang/article/details/72850055 SAN (Storage Area Network) 存储区域网。 SAN是指通...

RAW+ASM 的RAC 安装文档

原文 http://blog.csdn.net/tianlesoftware/article/details/5332909     oraclelibrarydatabaselinux内核...

ORACLE 11G R2 RAC+Mutilpath+RAW+ASM+Silent+AddNode+DG 完全安装详解 (一)

1. LINUX 不同 SERVER 发行版之间的差异(SUSE 11 SP4 为核心) 2. 裸设备 RAW 绑定 3. 环境变量、环境依赖 4. 生产环境下的常用设置 5. 脚本格式,复制即用...

RAW+ASM 的RAC 安装文档

有关RAC 的一些概念性和原理性的知识, 请参考我的blog: http://blog.csdn.net/tianlesoftware/archive/2010/02/27/5331067.aspx...

ORACLE 11G R2 RAC+Mutilpath+RAW+ASM+Silent+AddNode+DG 完全安装详解 (四)

1. LINUX 不同 SERVER 发行版之间的差异(SUSE 11 SP4 为核心) 2. 裸设备 RAW 绑定 3. 环境变量、环境依赖 4. 生产环境下的常用设置 5. 脚本格式,复制即用...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:利用隐藏参数_asm_allow_only_raw_disks创建ASM环境
举报原因:
原因补充:

(最多只允许输入30个字)