Monday, November 11, 2013

ORA-01078,ORA-29701 errors while starting standalone ASM on 12c


Error:

[grid@cloud1 ohasd]$ sqlplus "/as sysasm"

SQL*Plus: Release 12.1.0.1.0 Production on Mon Nov 11 08:17:49 2013

Copyright (c) 1982, 2013, 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


Solution 1:

 execute below command as root user

$GRID_HOME/localconfig reset


Solution 2:

start cssd daemon as root user

[root@cloud1 bin]# ./crsctl start resource ora.cssd
CRS-2672: Attempting to start 'ora.cssd' on 'cloud1'
CRS-2672: Attempting to start 'ora.diskmon' on 'cloud1'
CRS-2676: Start of 'ora.diskmon' on 'cloud1' succeeded
CRS-2676: Start of 'ora.cssd' on 'cloud1' succeeded
[root@cloud1 bin]#

then start asm instance

[grid@cloud1 ohasd]$ sqlplus "/as sysasm"

SQL*Plus: Release 12.1.0.1.0 Production on Mon Nov 11 08:20:11 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ASM instance started

Total System Global Area 1135747072 bytes
Fixed Size                  2297344 bytes
Variable Size            1108283904 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted

No comments: