ORA-15097: cannot SHUTDOWN ASM instance with connected client (process string) ORACLE 报错 故障修复 远程处理

文档解释

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

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

Action: 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.

这是一个Oracle ASM实例关闭错误，它包含一个连接的客户端（由“process string”标识）。

官方解释

ORA-15097在Oracle Database 12c和更高版本中已知发生。它给出了以下警告：

ORA-15097在试图停止ASM实例时出现，而当前仍有连接到该实例的客户端。

常见案例

ORA-15097通常发生在尝试关闭连接到ASM实例的客户端之前关闭ASM实例时。在这种情况下，在Oracle数据库后端还有与ASM实例的数据库连接。

一般处理方法及步骤

首先，您应该找出哪些客户端正在与ASM实例进行连接：

SQL> SELECT USERNAME,PROGRAM FROM V$SESSION WHERE AUDSID=’ASM_instance_name’;

接下来，您可以在客户端上关闭连接：

SQL> ALTER SYSTEM DISCONNECT SESSION ‘sid,serial#’ IMMEDIATE;

接下来，您可以关闭ASM实例：

SQL>SHUTDOWN IMMEDIATE;

香港美国云服务器首选树叶云，2H2G首月10元开通。
树叶云（shuyeidc.com）提供简单好用，价格厚道的香港/美国云服务器和独立服务器。IDC+ISP+ICP资质。ARIN和APNIC会员。成熟技术团队15年行业经验。