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

<<  November 2017  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
27282930123
45678910

View posts in large calendar

TextBox