ORA-15504: cannot start workload capture because instance string not present in RESTRICTED SESSION mode ORACLE 报错 故障修复 远程处理

文档解释

ORA-15504: cannot start workload capture because instance string not present in RESTRICTED SESSION mode

Cause: The NO_RESTART_MODE option in DBMS_WORKLOAD_CAPTURE.START_CAPTURE was FALSE, therefore all the active instances were expected to be in the RESTRICTED SESSION mode.

Action: Start all instances using STARTUP RESTRICT or execute ALTER SYSTEM ENABLE RESTRICTED SESSION on all active instances before issuing DBMS_WORKLOAD_CAPTURE.START_CAPTURE.

ORA-15504：由于实例字符串没有出现在RESTRICTED SESSION模式中，因此无法启动工作负载捕获。

官方解释

常见案例

一般处理方法及步骤

1）启动SQL Plus并连接到您的数据库。

2）然后输入以下命令以退出RESTRICTED SESSION模式：ALTER SYSTEM SET RESTRICTED_SESSION=FALSE;

3）最后，从控制台或者SQL Plus session尝试启动Workload Capture。