问题现象:
在单实例数据库上安装好了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.ohasd run
-
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
-
Using configuration parameter file: /DBSoft/11.2.4/grid/crs/install/crsconfig_params
-
Creating trace directory
-
User ignored Prerequisites during installation
-
LOCAL ADD MODE
-
Creating OCR keys for user \'grid\', privgrp \'oinstall\'..
-
Operation successful.
-
LOCAL ONLY MODE
-
Successfully accumulated necessary OCR keys.
-
Creating OCR keys for user \'root\', privgrp \'root\'..
-
Operation successful.
-
CRS-4664: Node standby successfully pinned.
-
Adding Clusterware entries to inittab
-
-
standby 2011/06/10 14:49:51 /DBSoft/11.2.4/grid/cdata/standby/backup_20110610_144951.olr
-
Successfully configured 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.ohasd run
-
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.type OFFLINE OFFLINE
-
ora.evmd ora.evm.type ONLINE ONLINE standby
-
ora.ons ora.ons.type OFFLINE OFFLINE
4、 再次执行创建asmca 创建ASM实例成功
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/20674423/viewspace-1131000/
,如需转载,请注明出处,否则将追究法律责任。