How to fix the Oracle error ORA-15504: cannot start workload capture because instance string not present in RESTRICTED SESSION mode?

In this post, you’ll learn more about the Oracle ErrorORA-15504: cannot start workload capture because instance string not present in RESTRICTED SESSION mode with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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.

How to fix the Error ORA-15504: cannot start workload capture because instance string not present in RESTRICTED SESSION mode ?

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

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