How to fix the Oracle error ORA-15028: ASM file ‘string’ not dropped; currently being accessed?

In this post, you’ll learn more about the Oracle ErrorORA-15028: ASM file ‘string’ not dropped; currently being accessed with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-15028: ASM file ‘string’ not dropped; currently being accessed

Reason for the Error ORA-15028: ASM file ‘string’ not dropped; currently being accessed

An attempt was made to drop an ASM file, but the file was being accessed by one or more clients and therefore could not be dropped.

How to fix the Error ORA-15028: ASM file ‘string’ not dropped; currently being accessed ?

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

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