Redhat 5.5 上安装11.2.0.3 Grid Infrastructure 的时候,安装的时候选择的是“ Install Grid Infrastructure Software Only”。安装完之后,使用asmca配置
(或者:
asmca -silent -configureASM -sysAsmPassword oracle -asmsnmpPassword oracle -diskString '/dev/raw/raw*' -diskGroupName DATADG -disk '/dev/raw/raw1' -redundancy EXTERNAL
)ASM实例的时候报错,报错信息如下:
Error while detecting Oracle Grid Infrastructure. ASMCA needs Oracle Grid Infrastructure to configure ASM.
解决的方法:
使用root用户
export $ORACLE_HOME=/u01/app/11.2.0/grid/
---$ORACLE_HOME/perl/bin/perl -I$ORACLE_HOME/perl/lib -I$ORACLE_HOME/crs/install $ORACLE_HOME/crs/install/roothas.pl
[root@testora grid]# perl/bin/perl -I /u01/app/11.2.0/grid/perl/lib/ -I /u01/app/11.2.0/grid/crs/install/ /u01/app/11.2.0/grid/crs/install/root
rootcrs.pl roothas.pl rootofs.sh
[root@testora grid]# perl/bin/perl -I /u01/app/11.2.0/grid/perl/lib/ -I /u01/app/11.2.0/grid/crs/install/ /u01/app/11.2.0/grid/crs/install/roothas.pl
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
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 testora successfully pinned.
Adding Clusterware entries to inittab
testora 2013/07/30 13:54:49 /u01/app/11.2.0/grid/cdata/testora/backup_20130730_135449.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server
[root@testora grid]#
重启这个节点
[grid@testora ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 30 13:59:18 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service
SQL> exit
Disconnected
[grid@testora ~]$ asmcmd
Connected to an idle instance.
ASMCMD> lsdg
ASMCMD-8102: no connection to ASM; command requires ASM to run
ASMCMD> exit
[grid@testora ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.cssd ora.cssd.type OFFLINE OFFLINE
ora.diskmon ora....on.type OFFLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE testora
ora.ons ora.ons.type OFFLINE OFFLINE
发现ora.cssd进程没有启动
并查看ora.cssd的配置信息
[grid@testora ~]$ crs_stat -p ora.cssd
NAME=ora.cssd
TYPE=ora.cssd.type
ACTION_SCRIPT=
ACTIVE_PLACEMENT=0
AUTO_START=never
CHECK_INTERVAL=30
DESCRIPTION="Resource type for CSSD"
FAILOVER_DELAY=0
FAILURE_INTERVAL=3
FAILURE_THRESHOLD=5
HOSTING_MEMBERS=
PLACEMENT=balanced
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=600
START_TIMEOUT=600
STOP_TIMEOUT=900
UPTIME_THRESHOLD=1m
可以看到auto_start 为never,并没有开机自启动,设置为开机自启动
[grid@testora ~]$ crsctl modify resource "ora.cssd" -attr "AUTO_START=1"
[grid@testora ~]$
[grid@testora ~]$ crs_stat -p ora.cssd
NAME=ora.cssd
TYPE=ora.cssd.type
ACTION_SCRIPT=
ACTIVE_PLACEMENT=0
AUTO_START=1
CHECK_INTERVAL=30
DESCRIPTION="Resource type for CSSD"
FAILOVER_DELAY=0
FAILURE_INTERVAL=3
FAILURE_THRESHOLD=5
HOSTING_MEMBERS=
PLACEMENT=balanced
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=600
START_TIMEOUT=600
STOP_TIMEOUT=900
UPTIME_THRESHOLD=1m
重启HAS服务:
[grid@testora ~]$ crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'testora'
CRS-2673: Attempting to stop 'ora.evmd' on 'testora'
CRS-2677: Stop of 'ora.evmd' on 'testora' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'testora' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[grid@testora ~]$ crsctl start has
CRS-4123: Oracle High Availability Services has been started.
[grid@testora ~]$ crsctl check has
CRS-4638: Oracle High Availability Services is online
[grid@testora ~]$ 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 testora
ora.ons ora.ons.type OFFLINE OFFLINE
[grid@testora ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 30 14:11:48 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-00099: warning: no parameter file specified for ASM instance
ASM instance started
Total System Global Area 283930624 bytes
Fixed Size 2227664 bytes
Variable Size 256537136 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted
SQL> shutdown immediate
ORA-15100: invalid or missing diskgroup name
ORA-15100: invalid or missing diskgroup name
ASM instance shutdown
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[grid@testora ~]$ asmca -silent -configureASM -sysAsmPassword oracle -asmsnmpPassword oracle -diskString '/dev/raw/raw*' -diskGroupName DATADG -disk '/dev/raw/raw1' -redundancy EXTERNAL
ASM created and started successfully.
Disk Group DATADG created successfully.
那么就实现了新建asm 实例并且添加diskgroup盘。