itspace
- 浏览: 978557 次
- 性别:
- 来自: 杭州
-
文章分类
最新评论
-
孤星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 5112019年7月22日，受邀参加Oracle勒索病毒防范专题培训 ... -
selinux引起的ftp故障
2011-10-18 13:11 1489linux开通gssftp之后，客户端连接linux出现以下问 ... -
vmware 网卡hostonly模式不能ping的问题
2010-12-01 11:58 2261因测试需要，开启虚拟机，网卡为hostonly模式，启动之后不 ... -
linux 5 x64上安装基础软件的一些错误修复
2010-11-25 12:23 1812因项目需要，以下为linux as 5 上安装基础软件时一些错 ... -
linux gcc rpm包安装过程
2010-11-25 12:02 4197系统中发现gcc未安装，以下为gcc安装过程中的依赖包 引用[ ... -
linux lvm创建文件系统
2010-11-25 12:00 1714以下仅为安装记录 1、创建lv 引用[root@Linux ~ ... -
oci8
2010-09-10 17:30 1783[dbra@shenjp ruby-oci8-1.0.7]$ ... -
OCI安装错误记录（二）
2010-07-31 15:22 1863由于Oracle 11g R2 X64在windo ... -
OCI安装错误记录（一）
2010-07-28 09:36 5977主机环境： WINDOWS 2008 X64+ORACLE 1 ... -
sudo安装错误/usr/bin/ld: cannot find -lpam
2010-05-10 17:10 4385centos 5.1版本为 引用[root@rztest su ... -
linux dmidecode 查看硬件信息
2010-03-03 11:21 2234在linux平台可以利用命令dmidecode查看硬件信息，以 ... -
linux 修改时区
2009-12-24 14:46 3427一、修改时区 1、查看当前使用的时区，可以看到当前系统使用美 ... -
linux 划分文件系统
2009-12-24 09:58 1161linux版本为 引用[root@hzmc ~]# uname ... -
tar压缩使用方法
2009-12-10 16:47 2221为了方便用户在打包解包的同时可以压缩或解压文件，tar提供了一 ... -
linux 共享内存段研究
2009-12-09 14:11 5453无论是在unix或者是linux都有命令查看主机共享内存段的使 ... -
Linux显示网卡流量
2009-09-03 14:24 2250Linux操作系统版本为： 引用[root@hzmc tmp] ... -
linux 绑定模式分别为冗余和均衡负载时信息显示
2009-08-19 16:46 1283linux绑定网卡在《linux as 4 bond网卡绑定》 ... -
linux as 4 bond网卡绑定
2009-08-19 15:48 2178理论不赘述，简而言之，网卡绑定就是多张网卡逻辑上作为一张网卡用 ... -
xinetd: unrecognized service
2009-08-17 10:21 13448linux xinetd 服务不能启动： [root@capa ... -
Linux RPM包简介
2009-08-16 15:56 2096安装rpm包十分便捷，省去了很多编译过程，但是很多情况下，我们 ...
相关推荐
【Linux裸设备相关命令】 裸设备在Linux操作系统中是指没有经过文件系统格式化的特殊字符设备，通常用于数据库等需要高效I/O性能的应用场景，比如Oracle数据库的数据文件。它们可以直接访问硬件，绕过操作系统内核...
2. Udev：Udev是Linux系统中的设备管理机制。它可以自动检测和管理系统中的设备，包括磁盘、网络接口、USB设备等。Udev可以根据设备的属性和类型来执行相应的动作，例如加载驱动程序、设置权限等。 3. Udev规则文件...
在RHEL5上安装Oracle RAC的过程中，裸设备的使用是一项关键的技术，它能提供更高的I/O性能并减少操作系统对数据库I/O操作的开销。以下是对整个安装过程的详细阐述： 1. **Redhat 5 安装注意事项**： - 在RHEL5环境...
5. **绑定裸设备**： 使用`losetup`命令将逻辑卷与裸设备关联，例如创建名为`/dev/oracle/data`的裸设备： ``` losetup /dev/oracle/data /dev/mapper/vg_db-lv_data ``` 6. **改变裸设备的属主和访问权限**： ...
01157: cannot identify/lock data file 5 - see DBWR trace file”和“ORA-01110: data file 5: '/dev/raw/raw18'”是Oracle数据库常见的错误代码，表明数据库无法识别或锁定数据文件5，该文件通常是一个裸设备，...
在Linux系统中，创建和管理裸设备通常涉及到以下几个步骤： 1. **创建目录和节点**： 首先需要创建一个用于存放裸设备的目录，比如`/dev/raw`，然后使用`mknod`命令创建设备节点，例如`/dev/raw/raw1`。设备节点的...
这一步需要编辑 `/etc/sysconfig/rawdevices` 文件，定义裸设备的绑定关系，例如： ```shell # rawdevice bindings # format: rawdev majorminor # rawdev blockdev # example: /dev/raw/raw1 /dev/sdd1 /dev...
第5章 裸设备管理 34 第6章 修改逻辑卷名称 37 第7章 修改/etc/sysctl.conf文件中的系统参数,加入如下: 38 第8章 路由配置信息 39 第9章 LVM基础信息查询 40 第10章 光纤口状态查询 41 第11章 更改主机相关IP 42 附:...
- **分区与裸设备绑定**：使用`fdisk`对新增磁盘进行分区，并将分区绑定成裸设备。 - **启动裸设备服务**：通过`servicerawdevicesrestart`命令启动裸设备服务。 - **格式化分区**：使用`mkfs.ext3`命令对仲裁盘与...
- 检查裸设备绑定。 - 分别对仲裁分区和数据分区进行格式化。 5. 创建挂载点，挂载数据盘： - 创建目录，如`/apache`。 - 使用`mount`命令挂载数据分区。 6. 重启系统。 7. 安装集群软件并配置： - 验证裸设备...
1. **使用SCSI_ID绑定裸设备** - 首先，需要通过`scsi_id -g -s /block/<device>`命令获取每个裸设备的SCSI_ID。例如，对于设备`sdb`，可以通过命令`scsi_id -g -s /block/sdb`获取其SCSI_ID，假设为`3600a0b...
Linux 下单个磁盘最多可以有多少个分区? 15 个. 3 个主分区 + 1 个扩展分区 + 11 个逻辑分区. 建议的分区方法是: 先分 3 个主分区,第四个分区为扩展分区,然后在扩展分区中再分成 ...注意,裸设备不要绑定在扩展分区上.
为了在系统启动时自动加载裸设备，我们需要将设备映射写入 `/etc/sysconfig/rawdevices` 文件，例如： ``` vi rawdevices ``` 添加内容：`/dev/raw/raw1 /dev/sdb2` ### 4. 创建设备链接 生成设备链接可以帮助我们...
此外，如果需要挂载裸设备，可以在`/etc/sysconfig/rawdevices`中定义绑定关系，并启动`rawdevices`服务以实现开机自启动。通过`raw -qa`命令可以查看裸设备的绑定状态。 总的来说，Linux系统下管理IBM V7000存储...
- **GNBD**: 一种通过网络访问裸块设备的协议，主要用于KVM等虚拟化环境中。 **1.6 网络电源开关** - 通过网络信号远程控制服务器电源的技术，如IPMI(Intelligent Platform Management Interface)等。 **1.7 高级...
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 ...