Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › ORA-15003 diskgroup ORADATA already mounted in anoth ...
发新帖
Maclean Liu(刘相兵

2135

积分

502

好友

184

主题

ORA-15003 diskgroup ORADATA already mounted in another lock name space

1#
发表于 2012-3-8 23:32:53 | 查看: 16046| 回复: 3
网友提问, Question:

在安装 Solaris 上的 11.2.0.1 Grid Infrastructure时，在第二个节点上运行 运行root.sh 出现了 以下错误：

ORA-15018 diskgroup cannot be created
ORA-15017 diskgroup ORADATA cannot be mounted
ORA-15003 diskgroup ORADATA already mounted in another lock name space

root.sh运行失败
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/zh-hans/emergency-services

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638  QQ: 47079569   
2#
发表于 2012-3-8 23:33:56
ODM Finding:
  1. root.sh Fails on the First Node for 11gR2 GI Installation

  3. Applies to:
  4. Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
  5. Information in this document applies to any platform.
  6. Symptoms
  7. 2 node cluster, first time installing 11gR2 Grid Infrastructure, root.sh fails on the first node.

  9. $GI_HOME/cfgtoollogs/crsconfig/rootcrs_<node1>.log shows:
  10. 2010-07-24 23:29:36: Configuring ASM via ASMCA
  11. 2010-07-24 23:29:36: Executing as oracle: /opt/grid/bin/asmca -silent -diskGroupName OCR -diskList ORCL:VOTING_DISK1,ORCL:VOTING_DISK2,ORCL:VOTING_DISK3 -redundancy NORMAL -configureLocalASM
  12. 2010-07-24 23:29:36: Running as user oracle: /opt/grid/bin/asmca -silent -diskGroupName OCR -diskList ORCL:VOTING_DISK1,ORCL:VOTING_DISK2,ORCL:VOTING_DISK3 -redundancy NORMAL -configureLocalASM
  13. 2010-07-24 23:29:36: Invoking "/opt/grid/bin/asmca -silent -diskGroupName OCR -diskList ORCL:VOTING_DISK1,ORCL:VOTE_DISK2,ORCL:VOTE_DISK3 -redundancy NORMAL -configureLocalASM" as user "oracle"
  14. 2010-07-24 23:29:53:Configuration failed, see logfile for details

  16. Per $ORACLE_BASE/cfgtoollogs/asmca/asmca-<date>.log shows asmca failed with error:

  18. ORA-15018 diskgroup cannot be created
  19. ORA-15017 diskgroup OCR_VOTING_DG cannot be mounted
  20. ORA-15003 diskgroup OCR_VOTING_DG already mounted in another lock name space

  22. This is a new installation, the disks used by ASM are not shared on any other cluster system.
  23. Changes
  24. New installation.
  25. Cause
  26. The problem is caused by root.sh was run on two nodes at similar time (3 second difference) rather than it is finished on node 1 first before running it on node 2.

  28. On node 2, file $GI_HOME/cfgtoollogs/crsconfig/rootcrs_<node2>.log exist. Checking the content:

  30. 2010-07-24 23:29:39: Configuring ASM via ASMCA
  31. 2010-07-24 23:29:39:
  32. Executing as oracle: /opt/grid/bin/asmca -silent -diskGroupName OCR
  33. -diskList ORCL:VOTING_DISK1,ORCL:VOTING_DISK2,ORCL:VOTING_DISK3
  34. -redundancy NORMAL -configureLocalASM
  35. 2010-07-24 23:29:39: Running
  36. as user oracle: /opt/grid/bin/asmca -silent -diskGroupName OCR
  37. -diskList ORCL:VOTING_DISK1,ORCL:VOTING_DISK2,ORCL:VOTING_DISK3
  38. -redundancy NORMAL -configureLocalASM
  39. 2010-07-24 23:29:39:
  40. Invoking "/opt/grid/bin/asmca -silent -diskGroupName OCR -diskList
  41. ORCL:VOTING_DISK1,ORCL:VOTE_DISK2,ORCL:VOTE_DISK3 -redundancy NORMAL
  42. -configureLocalASM" as user "oracle"
  43. 2010-07-24 23:29:55:Configuration failed, see logfile for details

  45. It has similar content, the only difference is its time started 3 seconds later than the first node. This indicates root.sh were running at similar time on both nodes rather than finishing on 1st node before running on 2nd node.

  47. The root.sh on 2nd node also created +ASM1 instance ( as it also appears it is the first node to run root.sh), it mounted the same diskgroup, lead to the first +ASM1 on node 1 complain:
  48. ORA-15003 diskgroup OCR_VOTING_DG already mounted in another lock name space
  49. Solution
  50. 1. Deconfig the Grid Infrastructure without removing binaries, refer to note 942166.1 for details.

  52. 2. Rerun root.sh on each node sequentially. Only starts root.sh on the 2nd node when it completes on the 1st node.

  54. After this, root.sh completes successfully and CRS daemon are up.
复制代码

回复 只看该作者 道具 举报

3#
发表于 2012-3-8 23:37:16
The problem is caused by root.sh was run on two nodes at similar time (3 second difference) rather than it is finished on node 1 first before running it on node 2.

这可能由于 第二个节点上的root.sh 没有等第一个节点上的完成后就开始运行了， 2个节点的root.sh 在几秒内先后运行引起的。

参考以下文档清理 GI 后重新运行 root.sh
How to recover from root.sh on 11.2 Grid Infrastructure Failed http://www.oracledatabase12g.com ... ructure-failed.html

回复 只看该作者 道具 举报

4#
发表于 2013-6-20 22:34:39
我今天安装11.2.0.3也遇到了类似的情况。按照大师的方法，解决啦。
我在节点2执行root.sh时报如下错误：
[root@hqhdb2 ~]# /u01/app/grid/11.2.0/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/grid/11.2.0

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/grid/11.2.0/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
OLR initialization - successful
Adding Clusterware entries to upstart
CRS-2672: Attempting to start 'ora.mdnsd' on 'hqhdb2'
CRS-2676: Start of 'ora.mdnsd' on 'hqhdb2' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'hqhdb2'
CRS-2676: Start of 'ora.gpnpd' on 'hqhdb2' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'hqhdb2'
CRS-2672: Attempting to start 'ora.gipcd' on 'hqhdb2'
CRS-2676: Start of 'ora.gipcd' on 'hqhdb2' succeeded
CRS-2676: Start of 'ora.cssdmonitor' on 'hqhdb2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'hqhdb2'
CRS-2672: Attempting to start 'ora.diskmon' on 'hqhdb2'
CRS-2676: Start of 'ora.diskmon' on 'hqhdb2' succeeded
CRS-2676: Start of 'ora.cssd' on 'hqhdb2' succeeded

Disk Group OCRVOTING creation failed with the following message:
ORA-15018: diskgroup cannot be created
ORA-15017: diskgroup "OCRVOTING" cannot be mounted
ORA-15003: diskgroup "OCRVOTING" already mounted in another lock name space


Configuration of ASM ... failed
see asmca logs at /u01/app/oracle/cfgtoollogs/asmca for details
Did not succssfully configure and start ASM at /u01/app/grid/11.2.0/crs/install/crsconfig_lib.pm line 6763.
/u01/app/grid/11.2.0/perl/bin/perl -I/u01/app/grid/11.2.0/perl/lib -I/u01/app/grid/11.2.0/crs/install /u01/app/grid/11.2.0/crs/install/rootcrs.pl execution failed
解决办法：
[root@hqhdb1 install]# pwd
/u01/app/grid/11.2.0/crs/install
./rootcrs.pl -deconfig

重新运行，Ok啦
[root@hqhdb2 ~]# /u01/app/grid/11.2.0/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/grid/11.2.0

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/grid/11.2.0/crs/install/crsconfig_params
User ignored Prerequisites during installation
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'hqhdb2'
CRS-2676: Start of 'ora.cssdmonitor' on 'hqhdb2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'hqhdb2'
CRS-2672: Attempting to start 'ora.diskmon' on 'hqhdb2'
CRS-2676: Start of 'ora.diskmon' on 'hqhdb2' succeeded
CRS-2676: Start of 'ora.cssd' on 'hqhdb2' succeeded

ASM created and started successfully.

Disk Group OCRVOTING mounted successfully.

clscfg: -install mode specified
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Successful addition of voting disk 56219a1d9aca4fb2bf52a52f80cecd18.
Successful addition of voting disk 1f573a7e1e394feebf772efe808287b0.
Successful addition of voting disk 45d8b7e6ec984ffdbf1906262a2e3c3e.
Successfully replaced voting disk group with +OCRVOTING.
CRS-4266: Voting file(s) successfully replaced
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
1. ONLINE   56219a1d9aca4fb2bf52a52f80cecd18 (/dev/asm-diskf) [OCRVOTING]
2. ONLINE   1f573a7e1e394feebf772efe808287b0 (/dev/asm-diskg) [OCRVOTING]
3. ONLINE   45d8b7e6ec984ffdbf1906262a2e3c3e (/dev/asm-diskh) [OCRVOTING]
Located 3 voting disk(s).
CRS-2672: Attempting to start 'ora.asm' on 'hqhdb2'
CRS-2676: Start of 'ora.asm' on 'hqhdb2' succeeded
CRS-2672: Attempting to start 'ora.OCRVOTING.dg' on 'hqhdb2'
CRS-2676: Start of 'ora.OCRVOTING.dg' on 'hqhdb2' succeeded
CRS-2672: Attempting to start 'ora.registry.acfs' on 'hqhdb2'
CRS-2676: Start of 'ora.registry.acfs' on 'hqhdb2' succeeded
Configure Oracle Grid Infrastructure for a Cluster ... succeeded

感谢大师！！

回复 只看该作者 道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-29 03:17 , Processed in 0.048380 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569