How to fix the Oracle error ORA-15027: active use of diskgroup “string” precludes its dismount?

In this post, you’ll learn more about the Oracle ErrorORA-15027: active use of diskgroup “string” precludes its dismount with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-15027: active use of diskgroup “string” precludes its dismount

Reason for the Error ORA-15027: active use of diskgroup “string” precludes its dismount

An ALTER DISKGROUP … DISMOUNT command specified a diskgroup which had clients with open files in the diskgroup. Diskgroups cannot be dismounted until all open files in the diskgroup are closed.

How to fix the Error ORA-15027: active use of diskgroup “string” precludes its dismount ?

You can fix this error in Oracle by following the below steps

Stop all clients that are using this diskgroup and retry the ALTER DISKGROUP … DISMOUNT command. Query the V$ASM_CLIENT fixed view in an ASM instance or use ASMCMD LSOF to list active clients.