ORA-01078: failure in processing system parameters ORA-29701: unable to connect to Cluster Synchronization Service


-bash-3.2$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 30 11:22:15 2013
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

1.First of all check services by command
crs_stat –t
Than try start services manually by command:
crsctl start resource ora.cssd
-bash-3.2$ crsctl start resource ora.cssd 
CRS-2672: Attempting to start 'ora.cssd' on 'Test' 
CRS-2679: Attempting to clean 'ora.diskmon' on 'Test' 
CRS-2681: Clean of 'ora.diskmon' on 'Test' succeeded 
CRS-2672: Attempting to start 'ora.diskmon' on 'Test' 
CRS-2676: Start of 'ora.diskmon' on 'Test' succeeded 
CRS-2676: Start of 'ora.cssd' on 'Test' succeeded
2.Now try to start ASM instance
-bash-3.2$ export ORACLE_SID=+ASM 
-bash-3.2$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 30 11:26:08 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup 
ASM instance started
Total System Global Area 283930624 bytes 
Fixed Size 2212656 bytes 
Variable Size 256552144 bytes 
ASM Cache 25165824 bytes 
ORA-15110: no diskgroups mounted

3.Finally mount disk group : Find problematic diskgroup with statement:
select name, state, type from v$asm_diskgroup
SQL> alter diskgroup DATA mount;
Advertisements

2 comments

  1. Thnak you

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: