VMWARE+RedHat4u4+Oracle10g RAC 请教

ph19840216

安装顺序：

OS(Linux AS 4U4)---clusterware---vipca---安装数据库软件Oracle 10g--dbca建库


单节点运行dbca

1.选择oracle real application clusters database

2.选择configure automatic storage management

3.选择2个节点

4.填写ASM管理密码以及实例的参数文件类型

5.提示dbca将创建并启动ASM实例

6.进入创建磁盘组界面，创建磁盘组完毕，最后一列 state 显示的是MOUNTED(1/2)

点击mount  会报以下错误，个人感觉是rac1只能连接+ASM1,rac2只能连接+ASM2


附件：

[oracle@rhel2 ~]$ srvctl status asm -n rhel2
ASM instance +ASM2 is running on node rhel2.

[oracle@rhel2 ~]$ srvctl status asm -n rhel1
ASM instance +ASM1 is running on node rhel1.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
[oracle@rhel1 ~]$ export ORACLE_SID=+ASM1
[oracle@rhel1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 25 13:03:49 2009

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, Real Application Clusters, OLAP and Data Mining options

SQL> show parameter asm

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
asm_diskgroups                       string                 DATA, FLASHBACK, ARCH1, ARCH2
asm_diskstring                       string                 /dev/oracleasm/disks/*
asm_power_limit                      integer                1

[oracle@rhel1 ~]$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    rhel1
ora....L1.lsnr application    ONLINE    ONLINE    rhel1
ora.rhel1.gsd  application    ONLINE    ONLINE    rhel1
ora.rhel1.ons  application    ONLINE    ONLINE    rhel1
ora.rhel1.vip  application    ONLINE    ONLINE    rhel1
ora....SM2.asm application    ONLINE    ONLINE    rhel2
ora....L2.lsnr application    ONLINE    ONLINE    rhel2
ora.rhel2.gsd  application    ONLINE    ONLINE    rhel2
ora.rhel2.ons  application    ONLINE    ONLINE    rhel2
ora.rhel2.vip  application    ONLINE    ONLINE    rhel2

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

[oracle@rhel2 ~]$ export ORACLE_SID=+ASM2
[oracle@rhel2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 25 13:07:32 2009

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, Real Application Clusters, OLAP and Data Mining options


SQL> show parameter asm

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
asm_diskgroups                       string                 DATA, FLASHBACK, ARCH1
asm_diskstring                       string                 /dev/oracleasm/disks/*
asm_power_limit                      integer                1


[oracle@rhel2 admin]$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    rhel1
ora....L1.lsnr application    ONLINE    ONLINE    rhel1
ora.rhel1.gsd  application    ONLINE    ONLINE    rhel1
ora.rhel1.ons  application    ONLINE    ONLINE    rhel1
ora.rhel1.vip  application    ONLINE    ONLINE    rhel1
ora....SM2.asm application    ONLINE    ONLINE    rhel2
ora....L2.lsnr application    ONLINE    ONLINE    rhel2
ora.rhel2.gsd  application    ONLINE    ONLINE    rhel2
ora.rhel2.ons  application    ONLINE    ONLINE    rhel2
ora.rhel2.vip  application    ONLINE    ONLINE    rhel2



请教下 这个问题是怎么回事。。。多谢指教

blue_stone

2个节点上的listener起来了么?

asm使用的磁盘, 裸设备的属主改成oracle了么？　

ph19840216

[oracle@rhel1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 25-MAR-2009 14:17:29

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_RHEL1
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                25-MAR-2009 14:05:07
Uptime                    0 days 0 hr. 12 min. 22 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/oracle/product/10.2.0/db/network/admin/listener.ora
Listener Log File         /oracle/oracle/product/10.2.0/db/network/log/listener_rhel1.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.10.103)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.10.101)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
  Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "LSExtProc" has 1 instance(s).
  Instance "LSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully




[oracle@rhel2 ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 25-MAR-2009 14:18:02

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_RHEL2
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                25-MAR-2009 14:04:50
Uptime                    0 days 0 hr. 13 min. 12 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/oracle/product/10.2.0/db/network/admin/listener.ora
Listener Log File         /oracle/oracle/product/10.2.0/db/network/log/listener_rhel2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.10.104)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.10.102)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
  Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Service "LSExtProc" has 1 instance(s).
  Instance "LSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


注：
raw5 ---  ARCH1
raw6 ---  ARCH2
raw7 ---  FLASHBACK
raw8 ---  DATA
raw9-raw13用于OCR和投票
raw9 和 raw10 在rhel1节点上装完clusterware 执行root.sh的时候 属主由oracleinstall变为了rootinstall

[oracle@rhel1 ~]$ ls -la /dev/raw/raw*
crw-r-----  1 root   oinstall 162, 10 Mar 25 09:14 /dev/raw/raw10
crw-r--r--  1 oracle oinstall 162, 11 Mar 25 09:14 /dev/raw/raw11
crw-r--r--  1 oracle oinstall 162, 12 Mar 25 09:14 /dev/raw/raw12
crw-r--r--  1 oracle oinstall 162, 13 Mar 25 09:14 /dev/raw/raw13
crwxr-xr-x  1 oracle oinstall 162,  5 Mar 25 09:14 /dev/raw/raw5
crwxr-xr-x  1 oracle oinstall 162,  6 Mar 25 09:14 /dev/raw/raw6
crwxr-xr-x  1 oracle oinstall 162,  7 Mar 25 09:14 /dev/raw/raw7
crwxr-xr-x  1 oracle oinstall 162,  8 Mar 25 09:14 /dev/raw/raw8
crw-r-----  1 root   oinstall 162,  9 Mar 25 09:14 /dev/raw/raw9


[oracle@rhel2 ~]$ ls -la /dev/raw/raw*
crwxr-xr-x  1 oracle oinstall 162, 10 Mar 25 14:02 /dev/raw/raw10
crwxr-xr-x  1 oracle oinstall 162, 11 Mar 25 14:02 /dev/raw/raw11
crwxr-xr-x  1 oracle oinstall 162, 12 Mar 25 14:02 /dev/raw/raw12
crwxr-xr-x  1 oracle oinstall 162, 13 Mar 25 14:02 /dev/raw/raw13
crwxr-xr-x  1 oracle oinstall 162,  5 Mar 25 14:02 /dev/raw/raw5
crwxr-xr-x  1 oracle oinstall 162,  6 Mar 25 14:02 /dev/raw/raw6
crwxr-xr-x  1 oracle oinstall 162,  7 Mar 25 14:02 /dev/raw/raw7
crwxr-xr-x  1 oracle oinstall 162,  8 Mar 25 14:02 /dev/raw/raw8
crwxr-xr-x  1 oracle oinstall 162,  9 Mar 25 14:02 /dev/raw/raw9

blue_stone

节点2的属主为什么没变呢

使用sqlplus登录到asm, 用命令mount一下磁盘组, 看看有什么错误

ph19840216

小弟刚入门，不知怎么用命令行mount磁盘组？

比如我在rhel1上   执行下列命令？
export  ORACLE_SID=+ASM1
sqlplus  /   as  sysdba
SQL>

ph19840216

自己顶下，网上很多帖子讨论这种错误，但都没有好的解决方法

报错为：
could not mount the diskgroup on remote node rhel2 using connection service rhel2:21521+ASM2.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 "DATA"