ORA-31636: session is already attached to job string for user string ORACLE 报错 故障修复 远程处理

文档解释

ORA-31636: session is already attached to job string for user string

Cause: The session executing the attach is already attached to the specified job.

Action: Select a different job or create a new session.

。

ORA-31636报错是指会话已经附加到某一用户设定的作业。

官方解释

ORA-31636: session is already attached to job string for user string

Cause: A session was already attached to the specified job for the specified user.

Action: Detach the existing session before attempting to attach the new one.

常见案例

此错误通常发生在客户端尝试与既有的会话附加到用户设定的作业时。

一般处理方法及步骤

要正确处理这个错误，首先需要在尝试绑定新作业之前从已存在的会话中解除绑定。可以使用Oracle扩展构建语言中的DBMS_SCHEDULER.STOP_JOB方法来停止作业，然后重新调用DBMS_SCHEDULER.RUN_JOB来在会话中启动作业。