关于10g RAC下的asm图形化界面创建磁盘组ora-15032和ora-15063问题
现在有个AIX6.1+oracle 10g RAC(10.2.0.5)+ASM的环境 crs_stat -t显示状态正常 上面也已经运行有实例了 因现在需再创建个数据库实例 需要建个ASM磁盘组 现在我在使用dbca创建JKKK磁盘组时报错了（磁盘是裸磁盘） 错误信息如图 点击OK后发现只挂在一边 ASM2上未挂载 B节点上查看加入JKKK磁盘组的磁盘大小显示为0 A节点上查看加入JKKK磁盘组的磁盘大小显示为正常大小 请各位大神拯救啊 采用的是何种裸磁盘给出 2个节点上的 dd 信息 ，如果是裸pv ，给出lsattr 信息 ALLSTARS_ORACLE 发表于 2014-10-22 14:52 static/image/common/back.gif
采用的是何种裸磁盘
给出 2个节点上的 dd 信息 ，如果是裸pv ，给出lsattr 信息 ...
就是存储磁盘映射给主机 主机这边只对hdisk添加权限和属性 然后在asm图形化界面下发现 您说的dd信息查看命令是什么啊 dd不是用来测磁盘信息的吗 lsattr信息你是要只看加入JKKK磁盘组的磁盘信息吗
dd 命令尝试在2个节点上 写该磁盘，lsattr 你对应的磁盘 ALLSTARS_ORACLE 发表于 2014-10-22 15:11 static/image/common/back.gif
dd 命令尝试在2个节点上 写该磁盘，lsattr 你对应的磁盘
p740a:/>lsattr -El hdisk18
PCM PCM/friend/fcpother Path Control Module False
PR_key_value none Persistant Reserve Key Value True
algorithm fail_over Algorithm True
clr_q no Device CLEARS its Queue on error True
dist_err_pcnt 0 Distributed Error Percentage True
dist_tw_width 50 Distributed Error Sample Time True
hcheck_cmd inquiry Health Check Command True
hcheck_interval 60 Health Check Interval True
hcheck_mode nonactive Health Check Mode True
location Location Label True
lun_id 0x10000000000000 Logical Unit Number ID False
lun_reset_spt yes LUN Reset Supported True
max_coalesce 0x40000 Maximum Coalesce Size True
max_retry_delay 60 Maximum Quiesce Time True
max_transfer 0x80000 Maximum TRANSFER Size True
node_name 0x5006016088604a18 FC Node Name False
pvid none Physical volume identifier False
q_err yes Use QERR bit True
q_type simple Queuing TYPE True
queue_depth 8 Queue DEPTH True
reassign_to 120 REASSIGN time out value True
reserve_policy single_path Reserve Policy True
rw_timeout 30 READ/WRITE time out value True
scsi_id 0x10100 SCSI ID False
start_timeout 60 START unit time out value True
timeout_policy fail_path Timeout Policy True
unique_id 352136006016046503900EA485A61C722E41106RAID 503DGCfcp Unique device identifier False
ww_name 0x5006016808604a18 FC World Wide Name False
p740a:/>
p740a:/>dd if=/dev/rhdisk18 of=/tmp/rhdisk18-test bs=1024k count=20
20+0 records in.
20+0 records out.
p740a:/>ls -al /tmp|grep rhdisk
-rw-r--r-- 1 root system 20971520 Oct 22 15:15 rhdisk18-test
p740a:/>
lsattr -El hdisk18
PCM PCM/friend/fcpother Path Control Module False
PR_key_value none Persistant Reserve Key Value True
algorithm fail_over Algorithm True
clr_q no Device CLEARS its Queue on error True
dist_err_pcnt 0 Distributed Error Percentage True
dist_tw_width 50 Distributed Error Sample Time True
hcheck_cmd inquiry Health Check Command True
hcheck_interval 60 Health Check Interval True
hcheck_mode nonactive Health Check Mode True
location Location Label True
lun_id 0x10000000000000 Logical Unit Number ID False
lun_reset_spt yes LUN Reset Supported True
max_coalesce 0x40000 Maximum Coalesce Size True
max_retry_delay 60 Maximum Quiesce Time True
max_transfer 0x80000 Maximum TRANSFER Size True
node_name 0x5006016088604a18 FC Node Name False
pvid none Physical volume identifier False
q_err yes Use QERR bit True
q_type simple Queuing TYPE True
queue_depth 8 Queue DEPTH True
reassign_to 120 REASSIGN time out value True
reserve_policy single_path Reserve Policy True
rw_timeout 30 READ/WRITE time out value True
scsi_id 0x10100 SCSI ID False
start_timeout 60 START unit time out value True
timeout_policy fail_path Timeout Policy True
unique_id 352136006016046503900EA485A61C722E41106RAID 503DGCfcp Unique device identifier False
ww_name 0x5006016808604a18 FC World Wide Name False
p740b:/>bootinfo -s hdisk18
0
p740b:/>
p740b:/>dd if=/dev/rhdisk18 of=/tmp/rhdisk18-test bs=1024k count=20
dd: /dev/rhdisk18: The requested resource is busy.
p740b:/>dd if=/dev/rhdisk18 of=/tmp/rhdisk18-test bs=1024k count=20
dd: /dev/rhdisk18: The requested resource is busy.
p740b:/> 1、reserve_policy 可能存在问题
To enable simultaneous access to a disk device from multiple nodes, you must set the appropriate Object Data Manager (ODM) attribute listed in the following table to the value shown, depending on the disk type:
Disk Type Attribute Value
SSA or FAStT disks reserve_lock no
ESS, EMC, HDS, CLARiiON, or MPIO-capable disks reserve_policy no_reserve
To determine whether the attribute has the correct value, enter a command similar to the following on all cluster nodes for each disk device that you want to use:
# /usr/sbin/lsattr -E -l hdiskn
If the required attribute is not set to the correct value on any node, enter a command similar to one of the following on that node:
SSA and FAStT devices:
# /usr/sbin/chdev -l hdiskn -a reserve_lock=no
ESS, EMC, HDS, CLARiiON, and MPIO-capable devices:
# /usr/sbin/chdev -l hdiskn -a reserve_policy=no_reserve
http://docs.oracle.com/html/B10766_08/preaix.htm 2、
尝试读取rhdisk18 都报错
p740b:/>dd if=/dev/rhdisk18 of=/tmp/rhdisk18-test bs=1024k count=20
dd: /dev/rhdisk18: The requested resource is busy.
p740b:/>dd if=/dev/rhdisk18 of=/tmp/rhdisk18-test bs=1024k count=20
dd: /dev/rhdisk18: The requested resource is busy.
这里 提问者 搞错了，我们想搞清楚的是 rhdisk18是否能成功在2个节点上写入， 但显然 rhdisk18并不正常 ALLSTARS_ORACLE 发表于 2014-10-22 15:54 static/image/common/back.gif
2、
尝试读取rhdisk18 都报错
是这样的 我还没有进行图形化创建asm磁盘组之前 磁盘的状态和大小都是好的 我在节点A上创建后 在节点B上看对应磁盘组的磁盘容量就变成0了 你这盘是并发的吗？？ yhd_my 发表于 2014-10-22 18:52 static/image/common/back.gif
你这盘是并发的吗？？
是并发的啊 从存储映射过来的 又没有做什么设置 ALLSTARS_ORACLE 发表于 2014-10-22 15:54 static/image/common/back.gif
1、reserve_policy 可能存在问题
To enable simultaneous access to a disk device from multiple nodes ...
那原先他们见的ASM磁盘组的磁盘看见的reserve_policy显示的也是single_path哈
页:
[1]