oracle 11gR2 RAC root.sh 错误 ORA-15072 ORA-15018

zz/2024/4/19 23:56:11

 

       Oracle  11gR2 RAC 安装Clusterware 结束, 在第二个节点执行root.sh脚本的是报如下错误:

 

DiskGroup DATA1 creation failed with the following message:
ORA-15018: diskgroup cannot be created
ORA-15072: command requires at least 1 regular failure groups, discovered only 0

 

Oracle 的官网搜了一下, 相关解释如下

 

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms


While installing Oracle Grid Infrastructure with ASM, root.sh ran successfully in first node, but fails on the second node.

Error example

1. root.sh failed on second node with following errors
-------------------------------------------------------
DiskGroup DATA1 creation failed with the following message:
ORA-15018: diskgroup cannot be created
ORA-15072: command requires at least 1 regular failure groups, discovered only 0



Configuration of ASM failed, see logs for details

2. rootcrs_nodename.log
-----------------------
2010-02-03 13:40:43: Configuring ASM via ASMCA
2010-02-03 13:40:43: Executing as oracle: /u01/app/1120/grid/bin/asmca -silent -diskGroupName DATA1 -diskList ORCL:DATA1 -redundancy EXTERNAL -configureLocalASM
2010-02-03 13:40:43: Running as user oracle: /u01/app/1120/grid/bin/asmca -silent -diskGroupName DATA1 -diskList ORCL:DATA1 -redundancy EXTERNAL -configureLocalASM
2010-02-03 13:40:43: Invoking "/u01/app/1120/grid/bin/asmca -silent -diskGroupName DATA1 -diskList ORCL:DATA1 -redundancy EXTERNAL -configureLocalASM" as user "oracle"
2010-02-03 13:40:51: Configuration of ASM failed, see logs for details

3. On the 2nd node
/etc/oratab files shows +ASM1, rather than +ASM2

4. The following commands on the 2nd node show the ASM disk information correctly
/etc/init.d/oracleasm listdisks
/etc/init.d/oracleasm scandisks
ls -ltr /dev/oracleasm/disks

Cause


After configuring multipath disks on Linux x86-64, proper parameters have not been configured in /etc/sysconfig/oracleasm

 

 

Solution

 

On all nodes,
1. Modify the /etc/sysconfig/oracleasm with:
       ORACLEASM_SCANORDER="dm"
       ORACLEASM_SCANEXCLUDE="sd"
2. restart the asmlib by :
       # /etc/init.d/oracleasm restart
3. Run root.sh on the 2nd node

 

 

在这里要注意的事, 在运行root.sh 脚本的时候,会报如下错误:

 

Using configuration parameter file: /oracle/grid/crs/install/crsconfig_params
CRS is already configured on this node for crshome=0
Cannot configure two CRS instances on the same cluster.
Please deconfigure before proceeding with the configuration of new home.

 

因为之前已经运行过了。 我们需要把之前注册的信息 删除之后,在运行root.sh 脚本。 执行如下命令,删除节点注册信息:

       # /oracle/grid/crs/install/roothas.pl -delete -force -verbose

 

待删除完成后在执行,就不会报错了。

 

参考:

http://www.cnblogs.com/abenz/archive/2010/06/08/1754328.html

 

 

 

 

------------------------------------------------------------------------------

QQ: 492913789
Email:ahdba@qq.com
Blog:http://www.cndba.cn/dave 

网上资源: http://tianlesoftware.download.csdn.net

相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx

DBA1 群:62697716(); DBA2 群:62697977()

DBA3 群:62697850   DBA 超级群:63306533;    

聊天 群:40132017

--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请


http://www.ngui.cc/zz/2721258.html

相关文章

Oracle Data Guard ORA-16086: standby database does not contain available standby 处理方法

启动Data Guard 后, 查看同步情况: SQL> select error from v$archive_dest; ERROR ----------------------------------------------------------------- ORA-16086: standby database does not contain available standby log files ERROR ---…

Oracle Transparent Application Failover(TAF) 说明

前几天和一个朋友讨论到Oracle Net Services的高级特性的问题,就研究了下。 Oracle 官网上的说明参考: Enabling Advanced Features of Oracle Net Services http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/advcfg.htm#i473297 在这…

IBM AIX 5.3 系统管理 -- 监视和性能优化一

一. 监视文件系统增长 在 AIX 5L 系统上,管理员需要监视文件系统增长以防止文件系统装满。 基于“Berkeley 磁盘配额系统”(Berkeley Disk Quota System) 的磁盘配额系统提供了一种控制磁盘空间使用的有效方法。可以为各个用户或组定义配额系统,并且每…

IBM HACMP 系列 -- 基础知识

一. 什么是 HACMP(High Availability Cluster Multi-Processing) 1.1 高可用性 在当今的复杂环境中,为应用程序提供连续的服务是成功的 IT 实现的重要组成部分。高可用性屏蔽或消除计划内和计划外的系统和应用程序停机时间,是帮助为应用程序客户端提供…

浅谈 HACMP 心跳

一. 初识 HACMP 心跳 HACMP 软件主要监控 4 种故障:节点,网卡,网络,应用。其中前三种都是通过心跳来监控并产生事件响应的,我们可以看出使用 HACMP 集群,可谓玩的就是心跳。如果不了解心跳的过程和基本原理…

Oracle Golden Gate 简述

Oracle 在2009年收购了Golden Gate,之后Oracle 把Stream 的一些优点引入到了Golden Gate。 所以以后在数据复制这块,Oracle 肯定也是大力发展Golden Gate。 官网参考: http://www.oracle.com/us/corporate/Acquisitions/goldengate/index.h…

OEM 应用程序要求的数据库权限超出了您当前具有的权限 解决方法

当Oralce 访问OEM 出现如下错误时: 应用程序要求的数据库权限超出了您当前具有的权限 从如下2个方面检查: (1)给用户赋SELECT_CATALOG_ROLE grant SELECT_CATALOG_ROLE to user (2)DBSNMP,SYSMA…

RAC srvctl 命令报 libpthread.so.0 cannot open shared object file No such file or directory 解决方法

运行srvctl 命令报错: [oraclerac1 u01]$ srvctl remove asm -n rac1 /u01/app/oracle/product/10.2.0/db_1/jdk/jre/bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory 开始还觉…

How to copy a datafile from ASM to a file system not using RMAN

How to move a datafile from a file system to ASM http://blog.csdn.net/tianlesoftware/archive/2011/04/22/6342722.aspx How to move a datafile from ASM to the file system http://www.cndba.cn/Dave/article/817 步骤如下: 1. Log onto the ta…

How to Create Transportable Tablespaces Where the Source and Destination are ASM-Based

expdp/imp 的Transport_datafiles 在 之前的Blog里有实例,参考下面blog的3.12小节: Oracle expdp/impdp 使用示例 http://www.cndba.cn/Dave/article/1411 The purpose of this note is to describe the method to create transportable tablespaces(…