ORA-29701,ORA-01078

Hi Guy's,

Our Test server was abnormally shutdown when i restarted my ASM instance its showing ORA-29701,ORA-01078

and it starts working when i restarted the ASM from services and HAS service using 'CRSCTL' in Windows.



C:\Windows\system32>set oracle_sid=+asm

C:\Windows\system32>sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 29 11:34:05 2018
Copyright (c) 1982, 2011, 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
Disconnected

C:\Windows\system32> crsctl enable has
CRS-4622: Oracle High Availability Services autostart is enabled.

C:\Windows\system32>crsctl start has
CRS-4123: Oracle High Availability Services has been started.


C:\Windows\system32>crs_stat -t

Name                           Type               Target                State               Host
-------------------------------------------------------------------------------------------------
ora.DATA.dg        ora....up.type        ONLINE           ONLINE        moinit-pc
ora.DATA1.dg      ora....up.type        ONLINE           ONLINE        moinit-pc
ora....ER.lsnr        ora....er.type         ONLINE           ONLINE       moinit-pc
ora.asm                 ora.asm.type        ONLINE          ONLINE       moinit-pc
ora.cssd                ora.cssd.type        ONLINE          ONLINE       moinit-pc
ora.evmd              ora.evm.type         ONLINE           ONLINE       moinit-pc
ora.kkprod.db      ora....se.type          ONLINE           ONLINE       moinit-pc
ora.ons                 ora.ons.type           OFFLINE        OFFLINE
ora.test.db            ora....se.type           ONLINE         ONLINE       moinit-pc
ora.tstrd.db           ora....se.type          ONLINE          ONLINE      moinit-pc



C:\Windows\system32> sqlplus / as sysasm

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option


SQL> select instance_name,status from v$instance;

INSTANCE_NAME        STATUS
---------------- --------------------------------
+asm                             STARTED



Happy Learning...