ORA-00031: session marked for kill ORACLE 报错 故障修复 远程处理

文档解释

ORA-00031: session marked for kill

Cause: The session specified in an ALTER SYSTEM KILL SESSION command cannot be killed immediately (because it is rolling back or blocked on a network operation), but it has been marked for kill. This means it will be killed as soon as possible after its current uninterruptable operation is done.

Action: No action is required for the session to be killed, but further executions of the ALTER SYSTEM KILL SESSION command on this session may cause the session to be killed sooner.

.’
‘.

ORA-00031: Session marked for kill

这个错误代码表示您当前的会话已被标记为结束。

常见案例：当您试图连接到数据库时，如果您的会话已被标记为结束，则可能会出现此错误。这通常是由另一个数据库管理员使用ALTER SYSTEM DISCONNECT SESSION命令执行的。

解决方法：

1. 等待一段时间，直到您的会话被自动结束。
2. 重新连接到数据库。

请注意，在结束会话时，请根据您的情况谨慎选择解决方法，因为可能会导致数据丢失。

. ‘