HELIOS BLOG

Helios Database Journey

ORA-01078 ORA-29701 error during startup ASM

I hit this error during try to start my asm instance

I am working standalone  Oracle 11.2.0.1 database wiht ASM option on AIX 6.1. I hit below error after i reboot my server.

$export ORACLE_SID=+ASM
$sqlplus "/as sysasm"
SQL> startup
 ORA-01078: failure in processing system parameters
 ORA-29701: unable to connect to Cluster Synchronization Service

I checked services by using:

$crs_stat –t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.asm        ora.asm.type   OFFLINE   OFFLINE
ora.cssd       ora.cssd.type  ONLINE    OFFLINE
ora.diskmon    ora....on.type ONLINE    OFFLINE

Than i am going to start ora.cssd services

crsctl start resource ora.cssd

Than i run below command:

$crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.asm        ora.asm.type   OFFLINE   OFFLINE   oracle
ora.cssd       ora.cssd.type  ONLINE    ONLINE    oracle
ora.diskmon    ora....on.type ONLINE    ONLINE    oracle
$ sqlplus "/as sysasm"
SQL> startup
ORA-00099: warning: no parameter file specified for ASM instance
ASM instance started
Total System Global Area  283930624 bytes
Fixed Size                  2206088 bytes
Variable Size             256558712 bytes
ASM Cache                  25165824 bytes
ORA-15110: no diskgroups mounted
SQL> select group_number, name, total_mb, free_mb, state from v$asm_diskgroup;
GROUP_NUMBER                NAME                             TOTAL_MB    FREE_MB       STATE   
 ------------      --------------------------------          ----------  ---------     ----
 0                 ORADATA                                    0           0           DISMOUNTED
SQL> alter diskgroup ORAODM mount;
Diskgroup altered.

Issue solved

Hope it helps

,
Gunes Erol adlı kullanıcının avatarı

Posted by:

Gunes Erol

http://apex.oracle.com/pls/otn/f?p=19297:4:1668120596920607::NO:4:P4_ID:4160

“ORA-01078 ORA-29701 error during startup ASM” öğesine 7 yanıt

  1. sandeep Avatar
    sandeep

    That was great !!

    I was wondering where I lost the diskgroups.. this saved me

    Cevapla
    1. Gunes Erol Avatar
      Gunes Erol

      Hi Sandeep;

      Nice to hear it 😉

      Cevapla
  2. AB Avatar
    AB

    same thing happened to me – followed steps above – solved problem

    Thanks,
    AB

    Cevapla
    1. Gunes Erol Avatar
      Gunes Erol

      Hi AB;

      Nice to hear your issue is also solved 😉

      Regards
      Gunes

      Cevapla
  3. Daniel Chris Avatar
    Daniel Chris

    Hey
    Thank you that really helped.
    Just wondering for every restart we need to run it.
    Can we just put this command in a script after setting the oracle_sid to ASM ?
    Just ignore if i don’t make sense ! am new buddy.

    Cevapla
    1. Gunes Erol Avatar
      Gunes Erol

      You may use script or you can make this steps manually, it depends you my friend 😉

      Regards
      Gunes

      Cevapla
  4. sreedhar Avatar
    sreedhar

    Thanks forHelios..it greatly helped me in resolving my issue..

    Regards,
    Sreedhar.

    Cevapla

Yorum bırakın