- 浏览: 960718 次
- 性别:
- 来自: 杭州
文章分类
最新评论
-
孤星119:
好熟悉的数据库字段啊, 上家公司做的项目每天都跟这些字段打招呼 ...
Oracle exp compress参数引起的空间浪费 -
itspace:
quxiaoyong 写道遇到个问题,网上一搜,全他妈这篇文章 ...
数据库连接错误ORA-28547 -
quxiaoyong:
遇到个问题,网上一搜,全他妈这篇文章。你转来转去的有意思吗?
数据库连接错误ORA-28547 -
hctech:
关于version count过高的问题,不知博主是否看过ey ...
某客户数据库性能诊断报告 -
itspace:
invalid 写道写的不错,我根据这个来安装,有点理解错误了 ...
AIX 配置vncserver
在以前的redhat版本中,系统通过/etc/sysconfig/rawdevices配置raw的控制文件,通过/etc/init.d/rawdevices来管理raw设备的启动和关闭。
redhat5正规的方法是通过udev来管理raw。裸设备绑定的重启命令为start_udev
今天在数据库检查过程中碰到一客户,没有在系统启动过程实现裸设备自动绑定。简单做下记录,以便不时之需。
[root@wms01 dbcheck]# more /etc/redhat-release
CentOS release 5.2 (Final)
wms:
[root@wms01 ~]# cd /dev/raw
[root@wms01 raw]# ls -rtl
total 0
crw-rw---- 1 root oinstall 162, 19 Aug 8 14:29 raw19
crwxr-xr-x 1 oracle oinstall 162, 12 Aug 8 14:29 raw12
crwxr-xr-x 1 oracle oinstall 162, 13 Aug 8 14:29 raw13
crwxr-xr-x 1 oracle oinstall 162, 5 Nov 17 13:54 raw5
crwxr-xr-x 1 oracle oinstall 162, 7 Nov 17 13:54 raw7
crwxr-xr-x 1 oracle oinstall 162, 4 Nov 17 13:54 raw4
crw-r--r-- 1 oracle oinstall 162, 20 Nov 17 13:54 raw20
crwxr-xr-x 1 oracle oinstall 162, 2 Nov 17 13:54 raw2
crwxr-xr-x 1 oracle oinstall 162, 3 Nov 17 13:54 raw3
crwxr-xr-x 1 oracle oinstall 162, 9 Nov 17 13:54 raw9
crwxr-xr-x 1 oracle oinstall 162, 8 Nov 17 13:54 raw8
crwxr-xr-x 1 oracle oinstall 162, 6 Nov 17 13:54 raw6
crwxr-xr-x 1 oracle oinstall 162, 11 Nov 17 13:54 raw11
crwxr-xr-x 1 oracle oinstall 162, 10 Nov 17 13:54 raw10
[root@wms01 raw]# raw -qa
/dev/raw/raw2: bound to major 253, minor 27
/dev/raw/raw3: bound to major 253, minor 19
/dev/raw/raw4: bound to major 253, minor 28
/dev/raw/raw5: bound to major 253, minor 29
/dev/raw/raw6: bound to major 253, minor 8
/dev/raw/raw7: bound to major 253, minor 9
/dev/raw/raw8: bound to major 253, minor 10
/dev/raw/raw9: bound to major 253, minor 11
/dev/raw/raw10: bound to major 253, minor 12
/dev/raw/raw11: bound to major 253, minor 13
/dev/raw/raw12: bound to major 253, minor 14
/dev/raw/raw13: bound to major 253, minor 15
/dev/raw/raw19: bound to major 253, minor 33
/dev/raw/raw20: bound to major 253, minor 31
[root@wms01 dev]# ls -rtl |grep 253
brw------- 1 root root 253, 0 Aug 8 14:27 root
brw-rw---- 1 root root 253, 9 Aug 8 14:28 dm-9
brw-rw---- 1 root root 253, 10 Aug 8 14:28 dm-10
brw-rw---- 1 root root 253, 11 Aug 8 14:28 dm-11
brw-rw---- 1 root root 253, 12 Aug 8 14:28 dm-12
brw-rw---- 1 root root 253, 13 Aug 8 14:28 dm-13
brw-rw---- 1 root root 253, 14 Aug 8 14:28 dm-14
brw-rw---- 1 root root 253, 15 Aug 8 14:28 dm-15
brw-rw---- 1 root root 253, 16 Aug 8 14:28 dm-16
brw-rw---- 1 root root 253, 17 Aug 8 14:28 dm-17
brw-rw---- 1 root root 253, 18 Aug 8 14:28 dm-18
brw-rw---- 1 root root 253, 19 Aug 8 14:28 dm-19
brw-rw---- 1 root root 253, 22 Aug 8 14:28 dm-22
brw-rw---- 1 root root 253, 20 Aug 8 14:28 dm-20
brw-rw---- 1 root root 253, 24 Aug 8 14:28 dm-24
brw-rw---- 1 root root 253, 21 Aug 8 14:28 dm-21
brw-rw---- 1 root root 253, 23 Aug 8 14:28 dm-23
brw-rw---- 1 root root 253, 26 Aug 8 14:28 dm-26
brw-rw---- 1 root root 253, 27 Aug 8 14:28 dm-27
brw-rw---- 1 root root 253, 28 Aug 8 14:28 dm-28
brw-rw---- 1 root root 253, 29 Aug 8 14:28 dm-29
brw-rw---- 1 root root 253, 31 Aug 8 14:28 dm-31
brw-rw---- 1 root root 253, 30 Aug 8 14:28 dm-30
brw-rw---- 1 root root 253, 32 Aug 8 14:28 dm-32
brw-rw---- 1 root root 253, 33 Aug 8 14:28 dm-33
brw-rw---- 1 root root 253, 8 Aug 8 14:28 dm-8
brw-rw---- 1 root root 253, 25 Aug 8 14:28 dm-25
SQL> col name for a20
SQL> col path for a20
SQL> select name,path from v$asm_disk;
NAME PATH
-------------------- --------------------
/dev/raw/raw20
/dev/raw/raw19
LOGASM1_0001 /dev/raw/raw13
LOGASM1_0000 /dev/raw/raw12
DGASM1_0009 /dev/raw/raw11
DGASM1_0008 /dev/raw/raw10
DGASM1_0007 /dev/raw/raw9
DGASM1_0006 /dev/raw/raw8
DGASM1_0005 /dev/raw/raw7
DGASM1_0004 /dev/raw/raw6
DGASM1_0003 /dev/raw/raw5
NAME PATH
-------------------- --------------------
DGASM1_0002 /dev/raw/raw4
DGASM1_0001 /dev/raw/raw3
DGASM1_0000 /dev/raw/raw2
14 rows selected.
[oracle@wms01 ~]$ crsctl query css votedisk
0. 0 /dev/raw/raw20
located 1 votedisk(s).
[oracle@wms01 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 2
Total space (kbytes) : 1027888
Used space (kbytes) : 4600
Available space (kbytes) : 1023288
ID : 2049410580
Device/File Name : /dev/raw/raw19
Device/File integrity check succeeded
Device/File not configured
Cluster registry integrity check succeeded
[oracle@wms01 dbs]$ more init+ASM1.ora
##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################
###########################################
# Cluster Database
###########################################
cluster_database=true
###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=/oracle/admin/+ASM/bdump
core_dump_dest=/oracle/admin/+ASM/cdump
user_dump_dest=/oracle/admin/+ASM/udump
###########################################
# Miscellaneous
###########################################
instance_type=asm
###########################################
# Pools
###########################################
large_pool_size=12M
###########################################
# Security and Auditing
###########################################
remote_login_passwordfile=exclusive
asm_power_limit=5
asm_diskgroups='DGASM1','LOGASM1'
asm_diskstring='/dev/raw/*'
+ASM2.instance_number=2
+ASM1.instance_number=1
最终配置
/home/oracle/dbcheck/60-raw.rules
# This file and interface are deprecated.
# Applications needing raw device access should open regular
# block devices with O_DIRECT.
#
# 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/raw2 %M %m"
# to bind /dev/raw/raw2 to the device with major 8, minor 1.
[root@wms01 dbcheck]# vi 60-raw.rules
# This file and interface are deprecated.
# Applications needing raw device access should open regular
# block devices with O_DIRECT.
#
# 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/raw2 %M %m"
# to bind /dev/raw/raw2 to the device with major 8, minor 1.
ACTION=="add",KERNEL=="dm-27",RUN+="/bin/raw /dev/raw/raw2 %N"
ACTION=="add",KERNEL=="dm-19",RUN+="/bin/raw /dev/raw/raw3 %N"
ACTION=="add",KERNEL=="dm-28",RUN+="/bin/raw /dev/raw/raw4 %N"
ACTION=="add",KERNEL=="dm-29",RUN+="/bin/raw /dev/raw/raw5 %N"
ACTION=="add",KERNEL=="dm-8",RUN+="/bin/raw /dev/raw/raw6 %N"
ACTION=="add",KERNEL=="dm-9",RUN+="/bin/raw /dev/raw/raw7 %N"
ACTION=="add",KERNEL=="dm-10",RUN+="/bin/raw /dev/raw/raw8 %N"
ACTION=="add",KERNEL=="dm-11",RUN+="/bin/raw /dev/raw/raw9 %N"
ACTION=="add",KERNEL=="dm-12",RUN+="/bin/raw /dev/raw/raw10 %N"
ACTION=="add",KERNEL=="dm-13",RUN+="/bin/raw /dev/raw/raw11 %N"
ACTION=="add",KERNEL=="dm-14",RUN+="/bin/raw /dev/raw/raw12 %N"
ACTION=="add",KERNEL=="dm-15",RUN+="/bin/raw /dev/raw/raw13 %N"
ACTION=="add",KERNEL=="dm-33",RUN+="/bin/raw /dev/raw/raw19 %N"
ACTION=="add",KERNEL=="dm-31",RUN+="/bin/raw /dev/raw/raw20 %N"
KERNEL=="raw[2-13]", OWNER="oracle", GROUP="oinstall", MODE="755"
KERNEL=="raw[19]", OWNER="root", GROUP="oinstall", MODE="660"
KERNEL=="raw[20]", OWNER="oracle", GROUP="oinstall", MODE="644"
erp:
[root@erp01 ~]# cd /dev/raw
[root@erp01 raw]# ls -rtl
total 0
crwxr-xr-x 1 oracle oinstall 162, 23 Apr 7 2010 raw23
crwxr-xr-x 1 oracle oinstall 162, 18 Nov 17 14:27 raw18
crwxr-xr-x 1 oracle oinstall 162, 17 Nov 17 14:27 raw17
crwxr-xr-x 1 oracle oinstall 162, 12 Nov 17 14:27 raw12
crw-rw---- 1 root oinstall 162, 2 Nov 17 14:27 raw2
crwxr-xr-x 1 oracle oinstall 162, 8 Nov 17 14:27 raw8
crwxr-xr-x 1 oracle oinstall 162, 14 Nov 17 14:27 raw14
crwxr-xr-x 1 oracle oinstall 162, 19 Nov 17 14:27 raw19
crwxr-xr-x 1 oracle oinstall 162, 21 Nov 17 14:27 raw21
crwxr-xr-x 1 oracle oinstall 162, 16 Nov 17 14:27 raw16
crwxr-xr-x 1 oracle oinstall 162, 13 Nov 17 14:27 raw13
crwxr-xr-x 1 oracle oinstall 162, 11 Nov 17 14:27 raw11
crwxr-xr-x 1 oracle oinstall 162, 15 Nov 17 14:27 raw15
crwxr-xr-x 1 oracle oinstall 162, 9 Nov 17 14:27 raw9
crwxr-xr-x 1 oracle oinstall 162, 7 Nov 17 14:27 raw7
crwxr-xr-x 1 oracle oinstall 162, 20 Nov 17 14:27 raw20
crw-r--r-- 1 oracle oinstall 162, 3 Nov 17 14:27 raw3
crwxr-xr-x 1 oracle oinstall 162, 22 Nov 17 14:27 raw22
crwxr-xr-x 1 oracle oinstall 162, 10 Nov 17 14:27 raw10
[root@erp01 raw]# raw -qa
/dev/raw/raw2: bound to major 253, minor 25
/dev/raw/raw3: bound to major 253, minor 27
/dev/raw/raw7: bound to major 253, minor 29
/dev/raw/raw8: bound to major 253, minor 30
/dev/raw/raw9: bound to major 253, minor 31
/dev/raw/raw10: bound to major 253, minor 32
/dev/raw/raw11: bound to major 253, minor 33
/dev/raw/raw12: bound to major 253, minor 34
/dev/raw/raw13: bound to major 253, minor 35
/dev/raw/raw14: bound to major 253, minor 36
/dev/raw/raw15: bound to major 253, minor 37
/dev/raw/raw16: bound to major 253, minor 8
/dev/raw/raw17: bound to major 253, minor 9
/dev/raw/raw18: bound to major 253, minor 10
/dev/raw/raw19: bound to major 253, minor 11
/dev/raw/raw20: bound to major 253, minor 12
/dev/raw/raw21: bound to major 253, minor 13
/dev/raw/raw22: bound to major 253, minor 7
/dev/raw/raw23: bound to major 253, minor 14
root@erp01 dev]# ls -rtl |grep 253
brw------- 1 root root 253, 0 Sep 13 2009 root
brw-rw---- 1 root root 253, 8 Sep 13 2009 dm-8
brw-rw---- 1 root root 253, 9 Sep 13 2009 dm-9
brw-rw---- 1 root root 253, 10 Sep 13 2009 dm-10
brw-rw---- 1 root root 253, 11 Sep 13 2009 dm-11
brw-rw---- 1 root root 253, 12 Sep 13 2009 dm-12
brw-rw---- 1 root root 253, 13 Sep 13 2009 dm-13
brw-rw---- 1 root root 253, 14 Sep 13 2009 dm-14
brw-rw---- 1 root root 253, 15 Sep 13 2009 dm-15
brw-rw---- 1 root root 253, 16 Sep 13 2009 dm-16
brw-rw---- 1 root root 253, 18 Sep 13 2009 dm-18
brw-rw---- 1 root root 253, 17 Sep 13 2009 dm-17
brw-rw---- 1 root root 253, 19 Sep 13 2009 dm-19
brw-rw---- 1 root root 253, 20 Sep 13 2009 dm-20
brw-rw---- 1 root root 253, 22 Sep 13 2009 dm-22
brw-rw---- 1 root root 253, 21 Sep 13 2009 dm-21
brw-rw---- 1 root root 253, 24 Sep 13 2009 dm-24
brw-rw---- 1 root root 253, 23 Sep 13 2009 dm-23
brw-rw---- 1 root root 253, 25 Sep 13 2009 dm-25
brw-rw---- 1 root root 253, 28 Sep 13 2009 dm-28
brw-rw---- 1 root root 253, 27 Sep 13 2009 dm-27
brw-rw---- 1 root root 253, 26 Sep 13 2009 dm-26
brw-rw---- 1 root root 253, 29 Sep 13 2009 dm-29
brw-rw---- 1 root root 253, 30 Sep 13 2009 dm-30
brw-rw---- 1 root root 253, 32 Sep 13 2009 dm-32
brw-rw---- 1 root root 253, 33 Sep 13 2009 dm-33
brw-rw---- 1 root root 253, 34 Sep 13 2009 dm-34
brw-rw---- 1 root root 253, 35 Sep 13 2009 dm-35
brw-rw---- 1 root root 253, 36 Sep 13 2009 dm-36
brw-rw---- 1 root root 253, 37 Sep 13 2009 dm-37
brw-rw---- 1 root root 253, 7 Sep 13 2009 dm-7
brw-rw---- 1 root root 253, 31 Sep 13 2009 dm-31
SQL> col name for a20
SQL> col path for a20
SQL> select name,path from v$asm_disk;
NAME PATH
-------------------- --------------------
/dev/raw/raw3
/dev/raw/raw2
LOGASM1_0001 /dev/raw/raw23
LOGASM1_0000 /dev/raw/raw22
DGASM1_0011 /dev/raw/raw21
DGASM1_0010 /dev/raw/raw20
DGASM1_0009 /dev/raw/raw19
DGASM1_0008 /dev/raw/raw18
DGASM1_0007 /dev/raw/raw17
DGASM1_0006 /dev/raw/raw16
DGASM1_0005 /dev/raw/raw15
NAME PATH
-------------------- --------------------
DGASM1_0004 /dev/raw/raw14
DGASM1_0003 /dev/raw/raw13
DGASM1_0002 /dev/raw/raw12
DGASM1_0001 /dev/raw/raw11
DGASM1_0000 /dev/raw/raw10
DGASM1_0014 /dev/raw/raw9
DGASM1_0013 /dev/raw/raw8
DGASM1_0012 /dev/raw/raw7
19 rows selected.
[oracle@erp01 dbs]$ more init+ASM1.ora
##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################
###########################################
# Cluster Database
###########################################
cluster_database=true
###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=/oracle/admin/+ASM/bdump
core_dump_dest=/oracle/admin/+ASM/cdump
user_dump_dest=/oracle/admin/+ASM/udump
###########################################
# Miscellaneous
###########################################
instance_type=asm
###########################################
# Pools
###########################################
large_pool_size=12M
###########################################
# Security and Auditing
###########################################
remote_login_passwordfile=exclusive
asm_power_limit=5
asm_diskgroups='DGASM1','LOGASM1'
asm_diskstring='/dev/raw/raw*'
+ASM2.instance_number=2
+ASM1.instance_number=1
[oracle@erp01 dbs]$ crsctl query css votedisk
0. 0 /dev/raw/raw3
located 1 votedisk(s).
[oracle@erp01 dbs]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 2
Total space (kbytes) : 1027888
Used space (kbytes) : 4588
Available space (kbytes) : 1023300
ID : 499063683
Device/File Name : /dev/raw/raw2
Device/File integrity check succeeded
Device/File not configured
Cluster registry integrity check succeeded
最终配置
/home/oracle/dbcheck/60-raw.rules
ACTION=="add",KERNEL=="dm-25",RUN+="/bin/raw /dev/raw/raw2 %N"
ACTION=="add",KERNEL=="dm-27",RUN+="/bin/raw /dev/raw/raw3 %N"
ACTION=="add",KERNEL=="dm-29",RUN+="/bin/raw /dev/raw/raw7 %N"
ACTION=="add",KERNEL=="dm-30",RUN+="/bin/raw /dev/raw/raw8 %N"
ACTION=="add",KERNEL=="dm-31",RUN+="/bin/raw /dev/raw/raw9 %N"
ACTION=="add",KERNEL=="dm-32",RUN+="/bin/raw /dev/raw/raw10 %N"
ACTION=="add",KERNEL=="dm-33",RUN+="/bin/raw /dev/raw/raw11 %N"
ACTION=="add",KERNEL=="dm-34",RUN+="/bin/raw /dev/raw/raw12 %N"
ACTION=="add",KERNEL=="dm-35",RUN+="/bin/raw /dev/raw/raw13 %N"
ACTION=="add",KERNEL=="dm-36",RUN+="/bin/raw /dev/raw/raw14 %N"
ACTION=="add",KERNEL=="dm-37",RUN+="/bin/raw /dev/raw/raw15 %N"
ACTION=="add",KERNEL=="dm-8",RUN+="/bin/raw /dev/raw/raw16 %N"
ACTION=="add",KERNEL=="dm-9",RUN+="/bin/raw /dev/raw/raw17 %N"
ACTION=="add",KERNEL=="dm-10",RUN+="/bin/raw /dev/raw/raw18 %N"
ACTION=="add",KERNEL=="dm-11",RUN+="/bin/raw /dev/raw/raw19 %N"
ACTION=="add",KERNEL=="dm-12",RUN+="/bin/raw /dev/raw/raw20 %N"
ACTION=="add",KERNEL=="dm-13",RUN+="/bin/raw /dev/raw/raw21 %N"
ACTION=="add",KERNEL=="dm-7",RUN+="/bin/raw /dev/raw/raw22 %N"
ACTION=="add",KERNEL=="dm-14",RUN+="/bin/raw /dev/raw/raw23 %N"
KERNEL=="raw[7-23]",OWNER="oracle", GROUP="oinstall", MODE="755"
KERNEL=="raw[2]", OWNER="root", GROUP="oinstall", MODE="660"
KERNEL=="raw[3]", OWNER="oracle", GROUP="oinstall", MODE="644"
redhat5正规的方法是通过udev来管理raw。裸设备绑定的重启命令为start_udev
今天在数据库检查过程中碰到一客户,没有在系统启动过程实现裸设备自动绑定。简单做下记录,以便不时之需。
[root@wms01 dbcheck]# more /etc/redhat-release
CentOS release 5.2 (Final)
wms:
[root@wms01 ~]# cd /dev/raw
[root@wms01 raw]# ls -rtl
total 0
crw-rw---- 1 root oinstall 162, 19 Aug 8 14:29 raw19
crwxr-xr-x 1 oracle oinstall 162, 12 Aug 8 14:29 raw12
crwxr-xr-x 1 oracle oinstall 162, 13 Aug 8 14:29 raw13
crwxr-xr-x 1 oracle oinstall 162, 5 Nov 17 13:54 raw5
crwxr-xr-x 1 oracle oinstall 162, 7 Nov 17 13:54 raw7
crwxr-xr-x 1 oracle oinstall 162, 4 Nov 17 13:54 raw4
crw-r--r-- 1 oracle oinstall 162, 20 Nov 17 13:54 raw20
crwxr-xr-x 1 oracle oinstall 162, 2 Nov 17 13:54 raw2
crwxr-xr-x 1 oracle oinstall 162, 3 Nov 17 13:54 raw3
crwxr-xr-x 1 oracle oinstall 162, 9 Nov 17 13:54 raw9
crwxr-xr-x 1 oracle oinstall 162, 8 Nov 17 13:54 raw8
crwxr-xr-x 1 oracle oinstall 162, 6 Nov 17 13:54 raw6
crwxr-xr-x 1 oracle oinstall 162, 11 Nov 17 13:54 raw11
crwxr-xr-x 1 oracle oinstall 162, 10 Nov 17 13:54 raw10
[root@wms01 raw]# raw -qa
/dev/raw/raw2: bound to major 253, minor 27
/dev/raw/raw3: bound to major 253, minor 19
/dev/raw/raw4: bound to major 253, minor 28
/dev/raw/raw5: bound to major 253, minor 29
/dev/raw/raw6: bound to major 253, minor 8
/dev/raw/raw7: bound to major 253, minor 9
/dev/raw/raw8: bound to major 253, minor 10
/dev/raw/raw9: bound to major 253, minor 11
/dev/raw/raw10: bound to major 253, minor 12
/dev/raw/raw11: bound to major 253, minor 13
/dev/raw/raw12: bound to major 253, minor 14
/dev/raw/raw13: bound to major 253, minor 15
/dev/raw/raw19: bound to major 253, minor 33
/dev/raw/raw20: bound to major 253, minor 31
[root@wms01 dev]# ls -rtl |grep 253
brw------- 1 root root 253, 0 Aug 8 14:27 root
brw-rw---- 1 root root 253, 9 Aug 8 14:28 dm-9
brw-rw---- 1 root root 253, 10 Aug 8 14:28 dm-10
brw-rw---- 1 root root 253, 11 Aug 8 14:28 dm-11
brw-rw---- 1 root root 253, 12 Aug 8 14:28 dm-12
brw-rw---- 1 root root 253, 13 Aug 8 14:28 dm-13
brw-rw---- 1 root root 253, 14 Aug 8 14:28 dm-14
brw-rw---- 1 root root 253, 15 Aug 8 14:28 dm-15
brw-rw---- 1 root root 253, 16 Aug 8 14:28 dm-16
brw-rw---- 1 root root 253, 17 Aug 8 14:28 dm-17
brw-rw---- 1 root root 253, 18 Aug 8 14:28 dm-18
brw-rw---- 1 root root 253, 19 Aug 8 14:28 dm-19
brw-rw---- 1 root root 253, 22 Aug 8 14:28 dm-22
brw-rw---- 1 root root 253, 20 Aug 8 14:28 dm-20
brw-rw---- 1 root root 253, 24 Aug 8 14:28 dm-24
brw-rw---- 1 root root 253, 21 Aug 8 14:28 dm-21
brw-rw---- 1 root root 253, 23 Aug 8 14:28 dm-23
brw-rw---- 1 root root 253, 26 Aug 8 14:28 dm-26
brw-rw---- 1 root root 253, 27 Aug 8 14:28 dm-27
brw-rw---- 1 root root 253, 28 Aug 8 14:28 dm-28
brw-rw---- 1 root root 253, 29 Aug 8 14:28 dm-29
brw-rw---- 1 root root 253, 31 Aug 8 14:28 dm-31
brw-rw---- 1 root root 253, 30 Aug 8 14:28 dm-30
brw-rw---- 1 root root 253, 32 Aug 8 14:28 dm-32
brw-rw---- 1 root root 253, 33 Aug 8 14:28 dm-33
brw-rw---- 1 root root 253, 8 Aug 8 14:28 dm-8
brw-rw---- 1 root root 253, 25 Aug 8 14:28 dm-25
SQL> col name for a20
SQL> col path for a20
SQL> select name,path from v$asm_disk;
NAME PATH
-------------------- --------------------
/dev/raw/raw20
/dev/raw/raw19
LOGASM1_0001 /dev/raw/raw13
LOGASM1_0000 /dev/raw/raw12
DGASM1_0009 /dev/raw/raw11
DGASM1_0008 /dev/raw/raw10
DGASM1_0007 /dev/raw/raw9
DGASM1_0006 /dev/raw/raw8
DGASM1_0005 /dev/raw/raw7
DGASM1_0004 /dev/raw/raw6
DGASM1_0003 /dev/raw/raw5
NAME PATH
-------------------- --------------------
DGASM1_0002 /dev/raw/raw4
DGASM1_0001 /dev/raw/raw3
DGASM1_0000 /dev/raw/raw2
14 rows selected.
[oracle@wms01 ~]$ crsctl query css votedisk
0. 0 /dev/raw/raw20
located 1 votedisk(s).
[oracle@wms01 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 2
Total space (kbytes) : 1027888
Used space (kbytes) : 4600
Available space (kbytes) : 1023288
ID : 2049410580
Device/File Name : /dev/raw/raw19
Device/File integrity check succeeded
Device/File not configured
Cluster registry integrity check succeeded
[oracle@wms01 dbs]$ more init+ASM1.ora
##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################
###########################################
# Cluster Database
###########################################
cluster_database=true
###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=/oracle/admin/+ASM/bdump
core_dump_dest=/oracle/admin/+ASM/cdump
user_dump_dest=/oracle/admin/+ASM/udump
###########################################
# Miscellaneous
###########################################
instance_type=asm
###########################################
# Pools
###########################################
large_pool_size=12M
###########################################
# Security and Auditing
###########################################
remote_login_passwordfile=exclusive
asm_power_limit=5
asm_diskgroups='DGASM1','LOGASM1'
asm_diskstring='/dev/raw/*'
+ASM2.instance_number=2
+ASM1.instance_number=1
最终配置
/home/oracle/dbcheck/60-raw.rules
# This file and interface are deprecated.
# Applications needing raw device access should open regular
# block devices with O_DIRECT.
#
# 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/raw2 %M %m"
# to bind /dev/raw/raw2 to the device with major 8, minor 1.
[root@wms01 dbcheck]# vi 60-raw.rules
# This file and interface are deprecated.
# Applications needing raw device access should open regular
# block devices with O_DIRECT.
#
# 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/raw2 %M %m"
# to bind /dev/raw/raw2 to the device with major 8, minor 1.
ACTION=="add",KERNEL=="dm-27",RUN+="/bin/raw /dev/raw/raw2 %N"
ACTION=="add",KERNEL=="dm-19",RUN+="/bin/raw /dev/raw/raw3 %N"
ACTION=="add",KERNEL=="dm-28",RUN+="/bin/raw /dev/raw/raw4 %N"
ACTION=="add",KERNEL=="dm-29",RUN+="/bin/raw /dev/raw/raw5 %N"
ACTION=="add",KERNEL=="dm-8",RUN+="/bin/raw /dev/raw/raw6 %N"
ACTION=="add",KERNEL=="dm-9",RUN+="/bin/raw /dev/raw/raw7 %N"
ACTION=="add",KERNEL=="dm-10",RUN+="/bin/raw /dev/raw/raw8 %N"
ACTION=="add",KERNEL=="dm-11",RUN+="/bin/raw /dev/raw/raw9 %N"
ACTION=="add",KERNEL=="dm-12",RUN+="/bin/raw /dev/raw/raw10 %N"
ACTION=="add",KERNEL=="dm-13",RUN+="/bin/raw /dev/raw/raw11 %N"
ACTION=="add",KERNEL=="dm-14",RUN+="/bin/raw /dev/raw/raw12 %N"
ACTION=="add",KERNEL=="dm-15",RUN+="/bin/raw /dev/raw/raw13 %N"
ACTION=="add",KERNEL=="dm-33",RUN+="/bin/raw /dev/raw/raw19 %N"
ACTION=="add",KERNEL=="dm-31",RUN+="/bin/raw /dev/raw/raw20 %N"
KERNEL=="raw[2-13]", OWNER="oracle", GROUP="oinstall", MODE="755"
KERNEL=="raw[19]", OWNER="root", GROUP="oinstall", MODE="660"
KERNEL=="raw[20]", OWNER="oracle", GROUP="oinstall", MODE="644"
erp:
[root@erp01 ~]# cd /dev/raw
[root@erp01 raw]# ls -rtl
total 0
crwxr-xr-x 1 oracle oinstall 162, 23 Apr 7 2010 raw23
crwxr-xr-x 1 oracle oinstall 162, 18 Nov 17 14:27 raw18
crwxr-xr-x 1 oracle oinstall 162, 17 Nov 17 14:27 raw17
crwxr-xr-x 1 oracle oinstall 162, 12 Nov 17 14:27 raw12
crw-rw---- 1 root oinstall 162, 2 Nov 17 14:27 raw2
crwxr-xr-x 1 oracle oinstall 162, 8 Nov 17 14:27 raw8
crwxr-xr-x 1 oracle oinstall 162, 14 Nov 17 14:27 raw14
crwxr-xr-x 1 oracle oinstall 162, 19 Nov 17 14:27 raw19
crwxr-xr-x 1 oracle oinstall 162, 21 Nov 17 14:27 raw21
crwxr-xr-x 1 oracle oinstall 162, 16 Nov 17 14:27 raw16
crwxr-xr-x 1 oracle oinstall 162, 13 Nov 17 14:27 raw13
crwxr-xr-x 1 oracle oinstall 162, 11 Nov 17 14:27 raw11
crwxr-xr-x 1 oracle oinstall 162, 15 Nov 17 14:27 raw15
crwxr-xr-x 1 oracle oinstall 162, 9 Nov 17 14:27 raw9
crwxr-xr-x 1 oracle oinstall 162, 7 Nov 17 14:27 raw7
crwxr-xr-x 1 oracle oinstall 162, 20 Nov 17 14:27 raw20
crw-r--r-- 1 oracle oinstall 162, 3 Nov 17 14:27 raw3
crwxr-xr-x 1 oracle oinstall 162, 22 Nov 17 14:27 raw22
crwxr-xr-x 1 oracle oinstall 162, 10 Nov 17 14:27 raw10
[root@erp01 raw]# raw -qa
/dev/raw/raw2: bound to major 253, minor 25
/dev/raw/raw3: bound to major 253, minor 27
/dev/raw/raw7: bound to major 253, minor 29
/dev/raw/raw8: bound to major 253, minor 30
/dev/raw/raw9: bound to major 253, minor 31
/dev/raw/raw10: bound to major 253, minor 32
/dev/raw/raw11: bound to major 253, minor 33
/dev/raw/raw12: bound to major 253, minor 34
/dev/raw/raw13: bound to major 253, minor 35
/dev/raw/raw14: bound to major 253, minor 36
/dev/raw/raw15: bound to major 253, minor 37
/dev/raw/raw16: bound to major 253, minor 8
/dev/raw/raw17: bound to major 253, minor 9
/dev/raw/raw18: bound to major 253, minor 10
/dev/raw/raw19: bound to major 253, minor 11
/dev/raw/raw20: bound to major 253, minor 12
/dev/raw/raw21: bound to major 253, minor 13
/dev/raw/raw22: bound to major 253, minor 7
/dev/raw/raw23: bound to major 253, minor 14
root@erp01 dev]# ls -rtl |grep 253
brw------- 1 root root 253, 0 Sep 13 2009 root
brw-rw---- 1 root root 253, 8 Sep 13 2009 dm-8
brw-rw---- 1 root root 253, 9 Sep 13 2009 dm-9
brw-rw---- 1 root root 253, 10 Sep 13 2009 dm-10
brw-rw---- 1 root root 253, 11 Sep 13 2009 dm-11
brw-rw---- 1 root root 253, 12 Sep 13 2009 dm-12
brw-rw---- 1 root root 253, 13 Sep 13 2009 dm-13
brw-rw---- 1 root root 253, 14 Sep 13 2009 dm-14
brw-rw---- 1 root root 253, 15 Sep 13 2009 dm-15
brw-rw---- 1 root root 253, 16 Sep 13 2009 dm-16
brw-rw---- 1 root root 253, 18 Sep 13 2009 dm-18
brw-rw---- 1 root root 253, 17 Sep 13 2009 dm-17
brw-rw---- 1 root root 253, 19 Sep 13 2009 dm-19
brw-rw---- 1 root root 253, 20 Sep 13 2009 dm-20
brw-rw---- 1 root root 253, 22 Sep 13 2009 dm-22
brw-rw---- 1 root root 253, 21 Sep 13 2009 dm-21
brw-rw---- 1 root root 253, 24 Sep 13 2009 dm-24
brw-rw---- 1 root root 253, 23 Sep 13 2009 dm-23
brw-rw---- 1 root root 253, 25 Sep 13 2009 dm-25
brw-rw---- 1 root root 253, 28 Sep 13 2009 dm-28
brw-rw---- 1 root root 253, 27 Sep 13 2009 dm-27
brw-rw---- 1 root root 253, 26 Sep 13 2009 dm-26
brw-rw---- 1 root root 253, 29 Sep 13 2009 dm-29
brw-rw---- 1 root root 253, 30 Sep 13 2009 dm-30
brw-rw---- 1 root root 253, 32 Sep 13 2009 dm-32
brw-rw---- 1 root root 253, 33 Sep 13 2009 dm-33
brw-rw---- 1 root root 253, 34 Sep 13 2009 dm-34
brw-rw---- 1 root root 253, 35 Sep 13 2009 dm-35
brw-rw---- 1 root root 253, 36 Sep 13 2009 dm-36
brw-rw---- 1 root root 253, 37 Sep 13 2009 dm-37
brw-rw---- 1 root root 253, 7 Sep 13 2009 dm-7
brw-rw---- 1 root root 253, 31 Sep 13 2009 dm-31
SQL> col name for a20
SQL> col path for a20
SQL> select name,path from v$asm_disk;
NAME PATH
-------------------- --------------------
/dev/raw/raw3
/dev/raw/raw2
LOGASM1_0001 /dev/raw/raw23
LOGASM1_0000 /dev/raw/raw22
DGASM1_0011 /dev/raw/raw21
DGASM1_0010 /dev/raw/raw20
DGASM1_0009 /dev/raw/raw19
DGASM1_0008 /dev/raw/raw18
DGASM1_0007 /dev/raw/raw17
DGASM1_0006 /dev/raw/raw16
DGASM1_0005 /dev/raw/raw15
NAME PATH
-------------------- --------------------
DGASM1_0004 /dev/raw/raw14
DGASM1_0003 /dev/raw/raw13
DGASM1_0002 /dev/raw/raw12
DGASM1_0001 /dev/raw/raw11
DGASM1_0000 /dev/raw/raw10
DGASM1_0014 /dev/raw/raw9
DGASM1_0013 /dev/raw/raw8
DGASM1_0012 /dev/raw/raw7
19 rows selected.
[oracle@erp01 dbs]$ more init+ASM1.ora
##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################
###########################################
# Cluster Database
###########################################
cluster_database=true
###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=/oracle/admin/+ASM/bdump
core_dump_dest=/oracle/admin/+ASM/cdump
user_dump_dest=/oracle/admin/+ASM/udump
###########################################
# Miscellaneous
###########################################
instance_type=asm
###########################################
# Pools
###########################################
large_pool_size=12M
###########################################
# Security and Auditing
###########################################
remote_login_passwordfile=exclusive
asm_power_limit=5
asm_diskgroups='DGASM1','LOGASM1'
asm_diskstring='/dev/raw/raw*'
+ASM2.instance_number=2
+ASM1.instance_number=1
[oracle@erp01 dbs]$ crsctl query css votedisk
0. 0 /dev/raw/raw3
located 1 votedisk(s).
[oracle@erp01 dbs]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 2
Total space (kbytes) : 1027888
Used space (kbytes) : 4588
Available space (kbytes) : 1023300
ID : 499063683
Device/File Name : /dev/raw/raw2
Device/File integrity check succeeded
Device/File not configured
Cluster registry integrity check succeeded
最终配置
/home/oracle/dbcheck/60-raw.rules
ACTION=="add",KERNEL=="dm-25",RUN+="/bin/raw /dev/raw/raw2 %N"
ACTION=="add",KERNEL=="dm-27",RUN+="/bin/raw /dev/raw/raw3 %N"
ACTION=="add",KERNEL=="dm-29",RUN+="/bin/raw /dev/raw/raw7 %N"
ACTION=="add",KERNEL=="dm-30",RUN+="/bin/raw /dev/raw/raw8 %N"
ACTION=="add",KERNEL=="dm-31",RUN+="/bin/raw /dev/raw/raw9 %N"
ACTION=="add",KERNEL=="dm-32",RUN+="/bin/raw /dev/raw/raw10 %N"
ACTION=="add",KERNEL=="dm-33",RUN+="/bin/raw /dev/raw/raw11 %N"
ACTION=="add",KERNEL=="dm-34",RUN+="/bin/raw /dev/raw/raw12 %N"
ACTION=="add",KERNEL=="dm-35",RUN+="/bin/raw /dev/raw/raw13 %N"
ACTION=="add",KERNEL=="dm-36",RUN+="/bin/raw /dev/raw/raw14 %N"
ACTION=="add",KERNEL=="dm-37",RUN+="/bin/raw /dev/raw/raw15 %N"
ACTION=="add",KERNEL=="dm-8",RUN+="/bin/raw /dev/raw/raw16 %N"
ACTION=="add",KERNEL=="dm-9",RUN+="/bin/raw /dev/raw/raw17 %N"
ACTION=="add",KERNEL=="dm-10",RUN+="/bin/raw /dev/raw/raw18 %N"
ACTION=="add",KERNEL=="dm-11",RUN+="/bin/raw /dev/raw/raw19 %N"
ACTION=="add",KERNEL=="dm-12",RUN+="/bin/raw /dev/raw/raw20 %N"
ACTION=="add",KERNEL=="dm-13",RUN+="/bin/raw /dev/raw/raw21 %N"
ACTION=="add",KERNEL=="dm-7",RUN+="/bin/raw /dev/raw/raw22 %N"
ACTION=="add",KERNEL=="dm-14",RUN+="/bin/raw /dev/raw/raw23 %N"
KERNEL=="raw[7-23]",OWNER="oracle", GROUP="oinstall", MODE="755"
KERNEL=="raw[2]", OWNER="root", GROUP="oinstall", MODE="660"
KERNEL=="raw[3]", OWNER="oracle", GROUP="oinstall", MODE="644"
发表评论
-
参加Oracle勒索病毒防范专题培训会议
2019-09-27 17:15 4242019年7月22日,受邀参加Oracle勒索病毒防范专题培训 ... -
selinux引起的ftp故障
2011-10-18 13:11 1452linux开通gssftp之后,客户端连接linux出现以下问 ... -
vmware 网卡hostonly模式不能ping的问题
2010-12-01 11:58 2195因测试需要,开启虚拟机,网卡为hostonly模式,启动之后不 ... -
linux 5 x64上安装基础软件的一些错误修复
2010-11-25 12:23 1779因项目需要,以下为linux as 5 上安装基础软件时一些错 ... -
linux gcc rpm包安装过程
2010-11-25 12:02 4159系统中发现gcc未安装,以下为gcc安装过程中的依赖包 引用[ ... -
linux lvm创建文件系统
2010-11-25 12:00 1682以下仅为安装记录 1、创建lv 引用[root@Linux ~ ... -
oci8
2010-09-10 17:30 1709[dbra@shenjp ruby-oci8-1.0.7]$ ... -
OCI安装错误记录(二)
2010-07-31 15:22 1827由于Oracle 11g R2 X64在windo ... -
OCI安装错误记录(一)
2010-07-28 09:36 5888主机环境: WINDOWS 2008 X64+ORACLE 1 ... -
sudo安装错误/usr/bin/ld: cannot find -lpam
2010-05-10 17:10 4311centos 5.1版本为 引用[root@rztest su ... -
linux dmidecode 查看硬件信息
2010-03-03 11:21 2164在linux平台可以利用命令dmidecode查看硬件信息,以 ... -
linux 修改时区
2009-12-24 14:46 3400一、修改时区 1、查看当前使用的时区,可以看到当前系统使用美 ... -
linux 划分文件系统
2009-12-24 09:58 1134linux版本为 引用[root@hzmc ~]# uname ... -
tar压缩使用方法
2009-12-10 16:47 2186为了方便用户在打包解包的同时可以压缩或解压文件,tar提供了一 ... -
linux 共享内存段研究
2009-12-09 14:11 5412无论是在unix或者是linux都有命令查看主机共享内存段的使 ... -
Linux显示网卡流量
2009-09-03 14:24 2210Linux操作系统版本为: 引用[root@hzmc tmp] ... -
linux 绑定模式分别为冗余和均衡负载时信息显示
2009-08-19 16:46 1253linux绑定网卡在《linux as 4 bond网卡绑定》 ... -
linux as 4 bond网卡绑定
2009-08-19 15:48 2143理论不赘述,简而言之,网卡绑定就是多张网卡逻辑上作为一张网卡用 ... -
xinetd: unrecognized service
2009-08-17 10:21 13418linux xinetd 服务不能启动: [root@capa ... -
Linux RPM包简介
2009-08-16 15:56 2036安装rpm包十分便捷,省去了很多编译过程,但是很多情况下,我们 ...
相关推荐
Redhat7 Udev绑定(DM multipath)多路径设备
第5章 裸设备管理 34 第6章 修改逻辑卷名称 37 第7章 修改/etc/sysctl.conf文件中的系统参数,加入如下: 38 第8章 路由配置信息 39 第9章 LVM基础信息查询 40 第10章 光纤口状态查询 41 第11章 更改主机相关IP 42 附:...
Linux 下单个磁盘最多可以有多少个分区? 15 个. 3 个主分区 + 1 个扩展分区 + 11 个逻辑分区. 建议的分区方法是: 先分 3 个主分区,第四个分区为扩展分区,然后在扩展分区中再分成 ...注意,裸设备不要绑定在扩展分区上.
1、 安装环境 1 ...2.8 绑定裸设备 5 2.9 配置本地yum源 6 3、 安装CRS 6 3.1 安装过程 6 3.2 常见问题 14 4、 安装数据库 15 4.1 安装数据库软件 15 4.2 配置Oracle NET 20 4.3 DBCA建库 24
2.10 UDEV绑定裸设备 21 三、GRID基础包安装 22 3.1 介质上传及安装检查 22 3.2 执行安装 23 3.3 安装警告 28 四、DATABASE 软件包安装 29 4.1 上传介质 29 4.2 执行安装 29 五、PATCH安装 33 六、创建ASM磁盘组 33 ...
非常详细的oracle rac教程 ...2.9 UDEV绑定裸设备 8 2.10 验证硬件和操作系统设置 9 3、安装GRID 25 4、创建ASM磁盘组 40 5、安装数据库软件 42 6、建库 48 7、验证服务 57 8、相关问题 57 8.1 ora-12545 57
4.1.1 使用raw命令将原始设备绑定到块设备 71 4.1.2 原始设备性能 72 4.1.3 使用dd命令确定连续I/O速度 73 4.1.4 使用sar和iostat测量磁盘性能 74 4.1.5 理解测试性能时I/O块大小的重要性 75 4.1.6 时间...
2.9 设置绑定裸设备 2.10 添加ASM磁盘 2.11 创建SSH信任关系 2.12 配置两节点时钟同步(NTP) 2.13 配置 HANGCHECK-TIMER (两节点执行) 2.14 编辑ORACLE用户环境变量 2.15 上传安装包并解压 三.开始安装ORACLE 10...
随着手机、智能手表等便携式设备的普及,用户对 GUI 的要求越来越高,嵌入式系统对高性能、高可靠性、低功耗、美观炫酷的 GUI 的需求也越来越迫切,ZLG开源 GUI 引擎 AWTK 应运而生。AWTK 全称为 Toolkit AnyWhere,...
" " " " " " " " " " " " " " " " " " " " " " " " " " " " "架构要求 " " " "采用裸金属架构,无需绑定操作系统即可搭建虚拟化平台 " " "虚拟化内核基于KVM底层开发 " " "虚拟化架构平台下的计算虚拟化、存储虚拟...
" " " " " " " " " " " " " " " " " " " " " " " " " " " " "架构要求 " " " "采用裸金属架构,无需绑定操作系统即可搭建虚拟化平台 " " "虚拟化内核基于KVM底层开发 " " "虚拟化架构平台下的计算虚拟化、存储虚拟...
为了提高IPTV系统工作稳定性,秒开网络推出的IPTV服务器软件本身是一个专业OS系统(基于LINUX开发),需要安装在一台裸机上,而IPTV用户端软件一般都是基于安卓平台的一个应用级的APP软件。 无论是IPTV服务器软件...
2.4 LINUX 线程核绑定 .............................................................................................................................. 6 2.4.1 核亲和性绑定 ..................................
此时可能是RAC两个节点对并发裸设备的访问有问题,此时考虑: (1)停掉两个节点的CRS。 (2)两个节点先同时去激活并发VG,然后再激活VG。 (3)重新启动CRS。 对于11gR2的GI问题 分析$GRID_HOME/log/nodename...