请达人指点：在dbca建库时无法mount 节点2个磁盘组

ochef

一直都是在用RAW设备从来没有用过ASM，因此在家里做了一下实验：
环境：vmware server + RHEL 4.7 64bit + oracle 10.2.0.1 64bit
装了多少次clusterware不记得了，这次从安装clusterware，oracle软件都没有问题，但到了创建数据库的时候发现节点2不能mount磁盘组，

google了一下，没有找到问题的根源，也看到PUB上也有类似的问题但最终还是没有解决，在此请达人帮忙看一下，下面是一些相关信息：
1.二个节点的asm实例都启动了
RAC01:
Ps –ef |grep asm
oracle  29651 1  0 11:07 ?  00:00:00 asm_pmon_+ASM1
oracle  29672 1  0 11:07 ?  00:00:00 asm_diag_+ASM1
oracle  29680 1  0 11:07 ?  00:00:00 asm_psp0_+ASM1
oracle  29682 1  0 11:07 ?  00:00:01 asm_lmon_+ASM1
oracle  29684 1  0 11:07 ?  00:00:00 asm_lmd0_+ASM1
oracle  29686 1  0 11:07 ?  00:00:00 asm_lms0_+ASM1
oracle  29690 1  0 11:07 ?  00:00:00 asm_mman_+ASM1
oracle  29692 1  0 11:07 ?  00:00:00 asm_dbw0_+ASM1
oracle  29694 1  0 11:07 ?  00:00:00 asm_lgwr_+ASM1
oracle  29696 1  0 11:07 ?  00:00:00 asm_ckpt_+ASM1
oracle  29698 1  0 11:07 ?  00:00:00 asm_smon_+ASM1
oracle  29700 1  0 11:07 ?  00:00:00 asm_rbal_+ASM1
oracle  29702 1  0 11:07 ?  00:00:00 asm_gmon_+ASM1
oracle  29729 1  0 11:07 ?  00:00:00 asm_lck0_+ASM1
oracle  29895 1  0 11:07 ?  00:00:00 /u01/oracle/product/10.2.0/db_1/bin/racgimondaemon ora.node1.ASM1.asm

RAC02:
[oracle@node2 bin]$ ps -ef|grep asm
oracle  11423 6680 0 11:08 pts/3 00:00:00 grepasm
oracle  24716 1 0 10:56 ? 00:00:00 asm_pmon_+ASM2
oracle  24718 1 0 10:56 ? 00:00:00 asm_diag_+ASM2
oracle  24720 1 0 10:56 ? 00:00:00 asm_psp0_+ASM2
oracle  24722 1 0 10:56 ? 00:00:01 asm_lmon_+ASM2
oracle  24724 1 0 10:56 ? 00:00:00 asm_lmd0_+ASM2
oracle  24726 1 0 10:56 ? 00:00:00 asm_lms0_+ASM2
oracle  24730 1 0 10:56 ? 00:00:00 asm_mman_+ASM2
oracle  24732 1 0 10:56 ? 00:00:00 asm_dbw0_+ASM2
oracle  24734 1 0 10:56 ? 00:00:00 asm_lgwr_+ASM2
oracle  24736 1 0 10:56 ? 00:00:00 asm_ckpt_+ASM2
oracle  24738 1 0 10:56 ? 00:00:00 asm_smon_+ASM2
oracle  24749 1 0 10:56 ? 00:00:00 asm_rbal_+ASM2
oracle  24761 1 0 10:56 ? 00:00:00 asm_gmon_+ASM2
oracle  24794 1 0 10:56 ? 00:00:00 asm_lck0_+ASM2
oracle  24862 1 0 10:56 ? 00:00:00 /u01/oracle/product/10.2.0/db_1/bin/racgimondaemon ora.node2.ASM2.asm

2.根据网上搜的一些信息，说与listener有关，以下是lister的状态
RAC01:
[oracle@node1 bin]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0- Production on 12-APR-2009 11:23:50
Copyright (c) 1991, 2005, Oracle.
All rights reserved.
Connecting to(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias        LISTENER
Version      TNSLSNR for Linux: Version 10.2.0.1.0- Production
Start Date   12-APR-2009 11:13:49
Uptime       0 days 0 hr. 10 min. 0 sec
Trace Level  off
Security     ON: Local OS Authentication
SNMP         OFF
Listener Parameter File
/u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File
/u01/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node1)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for thisservice...
Service "+ASM_XPT" has 1instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for thisservice...
The command completed successfully

RAC02:
[oracle@node2 bin]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0- Production on 12-APR-2009 11:11:11
Copyright (c) 1991, 2005, Oracle.
All rights reserved.
Connecting to(ADDRESS=(PROTOCOL=tcp)(HOST=node1)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias        LISTENER
Version      TNSLSNR for Linux: Version 10.2.0.1.0- Production
Start Date   12-APR-2009 11:01:30
Uptime       0 days 0 hr. 9 min. 41 sec
Trace Level  off
Security     ON: Local OS Authentication
SNMP         OFF
Listener Parameter File
/u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File
/u01/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node2)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).

Instance "+ASM2", status BLOCKED, has 1 handler(s) for thisservice...
Service "+ASM_XPT" has 1instance(s).

Instance "+ASM2", status BLOCKED, has 1 handler(s) for thisservice...
The command completed successfully

3.tnsping2个节点的listener都不通，不知道为什么，可能是真正原因所在，但ping 2节点的4个IP都是通的
[oracle@node1 bin]$ tnsping listener_node1
TNS PingUtility for Linux: Version 10.2.0.1.0 -Production on 12-APR-2009 11:23:29
Copyright (c) 1997, 2005, Oracle.
All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name

[oracle@node1 bin]$ tnsping listener_node1
TNS PingUtility for Linux: Version 10.2.0.1.0 -Production on 12-APR-2009 11:23:29
Copyright (c) 1997, 2005, Oracle.
All rights reserved.
Used parameter files:

TNS-03505: Failed to resolve name
主机的/etc/hsots文件检查也没有问题，
[oracle@node1 admin]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1       localhost
192.168.0.11    node1
192.168.0.12    node2
192.168.0.21    node1-vip
192.168.0.22    node2-vip
172.16.0.11     node1-priv
172.16.0.22     node2-priv

listener.ora内容如下：
[oracle@node1 admin]$ cat listener.ora
# listener.ora.node1 Network Configuration File: /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora.node1
# Generated by Oracle configuration tools.

LISTENER_NODE1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.11)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.11)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

LISTENER_NODE2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.22)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.12)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

[ 本帖最后由 ochef 于 2009-4-13 21:10 编辑 ]

guoq.lee

这个问题我也一直没解决，最后也没个答案
http://www.itpub.net/thread-1120678-1-1.html

max123567

升级到oracle 10.2.0.4  试试

ochef

to guoq.lee：刚刚看了你原来的那个帖子，看来这个问题很多人碰到过啊，呵呵

to max123567：周末休息再来整啊，照你说的先升级到10.2.0.4.0再DBCA看看是什么情况
谢谢二位了。

ochef

这个问题刚才解决了，说好上个星期六试着解决的，一个字：懒
其实很简单，往往在我们解决ORACLE问题的时候却忽视了最基本的问题，这个是我在VMware下做的实验，有一点很重要，就是共享存储设备，当初只把目光放在了ORACLE上，忘记了修改Node2上的虚拟机的配置文件，
disk.locking = "false"
加上了这个参数问题就解决了。
BTW：三思说过，在DBCA建库的时候关于远程监听参数处理方法
可以参考他的文章：
http://www.itpub.net/thread-1009235-1-1.html
或者Blog:
http://www.5ienet.com