OCP Blog
Super DBA
ORA-01078 ORA-29701 error during startup ASM
by Vazha Mantua Monday, January 16, 2012 11:48 AM

Good Day,

Today we resolve problem with error ORA-01078 and ORA-29701 while starting ASM , Oracle release 11gR2.

-bash-3.2$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jan 16 11:22:15 2012

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

 

1.First of all check services by command

crs_stat –t

Than try start services manually by command:

crsctl start resource ora.cssd

-bash-3.2$ crsctl start resource ora.cssd
CRS-2672: Attempting to start 'ora.cssd' on 'Test'
CRS-2679: Attempting to clean 'ora.diskmon' on 'Test'
CRS-2681: Clean of 'ora.diskmon' on 'Test' succeeded
CRS-2672: Attempting to start 'ora.diskmon' on 'Test'
CRS-2676: Start of 'ora.diskmon' on 'Test' succeeded
CRS-2676: Start of 'ora.cssd' on 'Test' succeeded

2.Now try to start ASM instance

-bash-3.2$ export ORACLE_SID=+ASM
-bash-3.2$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jan 16 11:26:08 2012

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
ORA-15110: no diskgroups mounted

3.Finally mount disk group : Find problematic diskgroup with statement:

select name, state, type from v$asm_diskgroup

SQL> alter diskgroup DATA mount;

Comments (4) -

5/12/2012 8:48:44 PM #

Personalized Promo Items

<a href=""></a>
Its really great information from you. i read the post and got very helpful information. Thanks

Personalized Promo Items United States

6/6/2012 7:02:51 AM #

Iraqi Dinar

You must know, your article goes to the center of the issue. Your pellucidity leaves me wanting to know more. Allow me to forthwith grab your feed to keep up to date with your web site. Saying thanks is simply my little way of saying what a masterpiece for a special resource. Accept my dearest wishes for your inflowing publication.

Iraqi Dinar United Kingdom

6/22/2012 12:54:33 AM #

Custom Challenge Coins

came onto your blog while focusing just slightly submits nice strategy for text i will be bookmarking at once seize your complete rises.

Custom Challenge Coins United States

8/2/2012 9:37:50 AM #

attorney internet marketing

I just found your site and want to say what an enjoyable time to looking through this post thanks for share, i hope you will share more posts like this.

attorney internet marketing United States

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Filter by APML

Calendar

<<  October 2017  >>
MoTuWeThFrSaSu
2526272829301
2345678
9101112131415
16171819202122
23242526272829
303112345

View posts in large calendar

TextBox