ASM:挂载分区组的时候出错

lozity

我顶！！！！

bosonmaster

原帖由 Arraywrjcs8086 于 2006-3-8 09:22 发表
我在安装RAC，使用2个节点（LINUX1，LINUX2），但是当我在LIUNX2上运行DBCA创建数据库的时候去出现了ORA-15063错误，详细的错误如下：
could not mount the diskgroup on remote node linux1 using connection service linux1:21521+ASM1.Ensure that the listener is running on this node and the asm istance is registered to the listener.receive follow errors:
ORA-15032:NOT ALL ALTERATION PERFORMED
ORA-15063:ASM DISCOVERED ON INSUFFICIENT NUMBER OF DISK FOR DISKGROUP "ORCL_DATA1"
在运行DBCA的LINUX2上DISKGROUP有MOUNT上去，但是LINUX1上去挂载不上去，这是怎么回事呢？

检查下你的服务启动情况还有。。就是你的磁盘权限？是否是ORACLE用户

bosonmaster

还有如果你检查权限没问题的话，看下ASM_DISKSTRING这个参数。设置的对不？ORA-15063: ASM discovered an insufficient number of disks for diskgroup "string"
Cause: ASM was unable to find a sufficient number of disks belonging to the diskgroup to continue the operation.
Action: Check that the disks in the diskgroup are present and functioning, that the owner of the ORACLE binary has read/write permission to the disks, and that the ASM_DISKSTRING initialization parameter has been set correctly. Verify that ASM discovers the appropriate disks by querying V$ASM_DISK from the ASM instance

lozity

谢谢楼上的dx，今天晚上刚刚看到，但是还是不行：

[root@pejoy ~]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3
VOL4
[root@pejoy ~]# /etc/init.d/oracleasm status
Checking if ASM is loaded: [  OK  ]
Checking if /dev/oracleasm is mounted: [  OK  ]
[root@pejoy ~]# ps -ef|grep ocssd
root      4011     1  0 22:56 ?        00:00:00 /bin/su -l oracle -c sh -c 'cd /opt/oracle/product/10.2.0.1/log/pejoy/cssd;  ulimit -c unlimited; exec /opt/oracle/product/10.2.0.1/bin/ocssd '
oracle    4860  4011  0 22:57 ?        00:00:00 /opt/oracle/product/10.2.0.1/bin/ocssd.bin
root      5083  5032  0 23:11 pts/1    00:00:00 grep ocssd
[root@pejoy ~]# su - oracle
[oracle@pejoy ~]$ export ORACLE_SID=+ASM
[oracle@pejoy ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jan 13 23:12:59 2008

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


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

SQL> set linesize 1000   
SQL> show parameter string

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
asm_diskstring                       string                 ORCL:VOL*

帮助里面说的： Check that the disks in the diskgroup are present and functioning, that the owner of the ORACLE binary has read/write permission to the disks
要如何检查呢？我的ASM是用块设备的啊……

wujiandaoa

顶下楼主，我在虚拟机上做实验也遇到这个问题了，请教有什么好的解决方法

cyzhang1983_cu

可以试试:
1：重启所有应用
crs_stop -all
crs_start -all
2:重装ASM

cc59

1.确定能访问到os级别的disk

2. 确定参数设置正确

3.asm 数据没有被损坏,这个可以通过kfed来观察.