Oracle single instance ASM
Problem
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service
======================================================
export ORACLE_HOME=/u000/app/grid export ORACLE_SID=+ASM sqlplus “/as sysasm” SQL*Plus: Release 11.2.0.1.0 Production on Fri Mar 5 11:14:29 2010 Copyright (c) 1982, 2009, 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
Solution
[oracle@oel5u4-+ASM bin] ./crsctl start resource ora.cssd CRS-2672: Attempting to start ‘ora.cssd’ on ‘oel5u4’ CRS-2679: Attempting to clean ‘ora.diskmon’ on ‘oel5u4’ CRS-2681: Clean of ‘ora.diskmon’ on ‘oel5u4’ succeeded CRS-2672: Attempting to start ‘ora.diskmon’ on ‘oel5u4’ CRS-2676: Start of ‘ora.diskmon’ on ‘oel5u4’ succeeded CRS-2676: Start of ‘ora.cssd’ on ‘oel5u4’ succeeded If you face the following error CRS-4535: Cannot communicate with Cluster Ready Services CRS-4000: Command Start failed, or completed with errors. Then run crsctl start res ora.crsd –init [oracle@oel5u4-+ASM bin] ./crs_stat -t Name Type Target State Host ———————————————————— ora.DATA.dg ora….up.type OFFLINE OFFLINE ora.FRA.dg ora….up.type OFFLINE OFFLINE ora….ER.lsnr ora….er.type ONLINE ONLINE oel5u4 ora.asm ora.asm.type OFFLINE OFFLINE ora.cssd ora.cssd.type ONLINE ONLINE oel5u4 ora.diskmon ora….on.type ONLINE ONLINE oel5u4 ora.orcl.db ora….se.type OFFLINE OFFLINE [oracle@oel5u4-+ASM bin] sqlplus / as sysasm SQL*Plus: Release 11.2.0.1.0 Production on Mon May 7 10:42:02 2012 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ASM instance started Total System Global Area 284565504 bytes Fixed Size 1336036 bytes Variable Size 258063644 bytes ASM Cache 25165824 bytes ASM diskgroups mounted If you Still face the following error CRS-4639: Could not contact Oracle High Availability Services CRS-4000: Command Status failed, or completed with errors. Then by root user run the following perl /u000/app/grid/crs/install/rootcrs.pl -verbose -deconfig –force /u000/app/grid/root.sh /u000/app/grid/perl/bin/perl -I/u000/app/grid/perl/lib -I/u000/app/grid/crs/install /u000/app/grid/crs/install/roothas.pl Then run the following using oracle user ./crsctl start resource ora.cssd