OCP Blog
Super DBA
ORA-15027: active use of diskgroup precludes its dismount
by Vazha Mantua Thursday, November 24, 2011 10:33 PM

Good Day,

Today We discuss about Error:ORA-15027: active use of diskgroup precludes its dismount.This error occurred  we I tried to  drop disk group on ASM instance (version 11GR2).

Cause of this error is that ASM spfile is located on Diskgroup

Solution:

In that case you need to create a pfile from the spfile and then startup the ASM instance using the pfile.

1.Find location of AMS spfile with command SQL> show parameter spfile

2.Create pfile from spfile

3.Start ASM instance with pfile, for Example SQL> startup pfile=$ORACLE_HOME/dbs/init+ASM.ora

4.Drop Diskgroup

Good Luck!

Tags:

Comments (3) -

1/7/2012 4:58:26 PM #

Orya Jan

I love oracle and I am developing from more than 3 years!

Orya Jan United States

1/14/2012 2:25:58 PM #

Villas for Rent in Italy

Such a great article giving some great information genuinely explaining some of the key things which you need to be aware of in particular about the part relating to getting some couseling prior to getting a loan, so many people don't even consider it.

Villas for Rent in Italy United States

6/20/2012 2:34:40 PM #

Diminished Value

In that case you need to create a pfile from the spfile and then startup the ASM instance using the pfile.

Diminished Value United Kingdom

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Filter by APML

Calendar

<<  September 2018  >>
MoTuWeThFrSaSu
272829303112
3456789
10111213141516
17181920212223
24252627282930
1234567

View posts in large calendar

TextBox