Google it ....

Friday, January 25, 2013

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

startup of ASM instance failed with error:
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service

check services by command:
crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.DATA.dg    ora....up.type OFFLINE   OFFLINE      
ora....ER.lsnr ora....er.type ONLINE    ONLINE    oralnxt01   
ora....2C.lsnr ora....er.type ONLINE    ONLINE    oralnxt01   
ora.asm        ora.asm.type   OFFLINE   OFFLINE      
ora.cssd       ora.cssd.type  ONLINE    ONLINE    oralnxt01   
ora.diskmon    ora....on.type ONLINE    ONLINE    oralnxt01   
ora.orcl.db    ora....se.type OFFLINE   OFFLINE    

solution:
start services manually
crsctl start resource ora.cssd
CRS-2672: Attempting to start 'ora.cssd' on 'oralnxt01'
CRS-2679: Attempting to clean 'ora.diskmon' on 'oralnxt01'
CRS-2681: Clean of 'ora.diskmon' on 'oralnxt01' succeeded
CRS-2672: Attempting to start 'ora.diskmon' on 'oralnxt01'
CRS-2676: Start of 'ora.diskmon' on 'oralnxt01' succeeded
CRS-2676: Start of 'ora.cssd' on 'oralnxt01' succeeded

sqlplus / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jan 25 10:25:56 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
ASM diskgroups mounted


that's all. enjoy :)

No comments:

Post a Comment