問題現象:
在單一實例資料庫上安裝好了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執行個體成功