Thursday 21 February 2013

ORA-01078: failure in processing system parameters


Merhaba,

Bugün karşılaştığım bir hatanın çözümünü paylaşmak istiyorum.

Asm instance'ına bağlandıktan sonra,  startup komutunu verdiğimde,  db mount olamadı.

Çözümü crsctl servisinin start'ından geçiyor.

[oracle@ rom]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid 
[oracle@ rom]$ export ORACLE_SID=+ASM 
[oracle@ rom]$ sqlplus "/as sysasm" 

SQL*Plus: Release 11.2.0.1.0 Production on TH FEB 21 11:14:29 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 

Solutions:
[oracle@rom-+ASM bin] ./crsctl start resource ora.cssd
CRS-2672: Attempting to start 'ora.cssd' on 'rom'
CRS-2679: Attempting to clean 'ora.diskmon' on 'rom'
CRS-2681: Clean of 'ora.diskmon' on 'rom' succeeded
CRS-2672: Attempting to start 'ora.diskmon' on 'rom'
CRS-2676: Start of 'ora.diskmon' on 'rom' succeeded
CRS-2676: Start of 'ora.cssd' on 'rom' succeeded


Finish:

SQL> startup
ASM instance started

Total System Global Area  384565544 bytes
Fixed Size                  2336036 bytes
Variable Size             358063644 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted



No comments:

Post a Comment