How to fix the Oracle error ORA-15097: cannot SHUTDOWN ASM instance with connected client (process string)?

In this post, you’ll learn more about the Oracle ErrorORA-15097: cannot SHUTDOWN ASM instance with connected client (process string) with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-15097: cannot SHUTDOWN ASM instance with connected client (process string)

Reason for the Error ORA-15097: cannot SHUTDOWN ASM instance with connected client (process string)

A SHUTDOWN command was issued to an ASM instance that had one or more connected clients.

How to fix the Error ORA-15097: cannot SHUTDOWN ASM instance with connected client (process string) ?

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

Stop all clients that are using this ASM instance and retry the SHUTDOWN command. Alternatively, use the SHUTDOWN ABORT command. Note that issuing the SHUTDOWN ABORT command to an ASM instance results in abormal termination of all RDBMS instances connected to that ASM instance. One of the active clients has been listed in the error message. Query the V$ASM_CLIENT fixed view in an ASM instance or use ASMCMD LSOF to list all active clients.