Oracle Error ORA-15503: cannot startup instance when procedures in “DBMS_WORKLOAD_CAPTURE” or “DBMS_WORKLOAD_REPLAY” are in the middle of their execution

Oracle Error Message

ORA-15503: cannot startup instance when procedures in “DBMS_WORKLOAD_CAPTURE” or “DBMS_WORKLOAD_REPLAY” are in the middle of their execution

Reason for the Error

The new instance could not be started because the database was executing a procedure in either the DBMS_WORKLOAD_CAPTURE or DBMS_WORKLOAD_REPLAY package.

Solution

Start the new instance after such procedures in the given packages have finished execution.