日期:2014-05-16  浏览次数:20511 次

单实例ASM无法创建磁盘组问题处理

问题现象:

        在单实例数据库上安装好了Oracle GridInfrastructure 11gR2用于standby数据库创建ASM使用,但是在通过grid用户登录执行ASMCA命令后出来Create ASM GUI界面,简单配置后执行create ASM 的过程中报错:Oracle Grid Infrastructure is not configured properly.ASMCA needOracle Grid Infrastructure to configure ASM.详细见如下:


 























问题分析:

         从上面的问题我们可以很清晰的看到是因为ASMCA无法连接到OracleGrid Infrastructure而导致无法创建。

 

问题处理:

1、  检查has进程是否起来

2、  重新执行/DBSoft/11.2.4/grid/crs/install/roothas.pl起has进程

3、  重新执行asmca创建asm即可。

 

步骤如下:

1、检查has进程是否起来

[root@standby~]# ps -ef|grep has
root     13139    1  0 15:08 ?        00:00:00 /bin/sh /etc/init.d/init.ohasdrun
root     13235 13186  0 15:10 pts/4    00:00:00 grep has
[root@standby~]#

2、重新执行/DBSoft/11.2.4/grid/crs/install/roothas.pl

 

[root@standby~]# /DBSoft/11.2.4/grid/crs/install/roothas.pl
Usingconfiguration parameter file: /DBSoft/11.2.4/grid/crs/install/crsconfig_params
Creating tracedirectory
User ignoredPrerequisites during installation
LOCAL ADD MODE
Creating OCRkeys for user 'grid', privgrp 'oinstall'..
Operationsuccessful.
LOCAL ONLY MODE
Successfullyaccumulated necessary OCR keys.
Creating OCRkeys for user 'root', privgrp 'root'..
Operationsuccessful.
CRS-4664: Nodestandby successfully pinned.
AddingClusterware entries to inittab

standby     2011/06/10 14:49:51    /DBSoft/11.2.4/grid/cdata/standby/backup_20110610_144951.olr
Successfullyconfigured Oracle Grid Infrastructure for a Standalone Server
[root@standby~]#


3、再次检查has进程状态,及crs状态。

[grid@standby install]$ ps -ef|grep ha
root     2735   227  0 Jun09 ?        00:00:00 [kmpath_handlerd]
root    13139     1  0 15:08 ?        00:00:00 /bin/sh /etc/init.d/init.ohasdrun
grid    14323     1  0 16:04 ?        00:00:00/DBSoft/11.2.4/grid/bin/ohasd.bin reboot
grid    14539 13294  0 16:05 pts/4    00:00:00 grep ha



[grid@standby~]$ crs_stat -t
Name           Type           Target    State    Host       
------------------------------------------------------------
ora.cssd      ora.cssd.type  ONLINE    OFFLINE              
ora.diskmon    ora....on.typeOFFLINE   OFFLINE              
ora.evmd      ora.evm.type   ONLINE    ONLINE   standby    
ora.ons       ora.ons.type   OFFLINE   OFFLINE               


4、  再次执行创建asmca 创建ASM实例成功