问题现象:
在单实例数据库上安装好了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实例成功