Fix ORA-15505: cannot start workload capture because instance 1 encountered errors

Error Description

Workload_caputre.start_capture failed with Fix ORA-15505: cannot start workload capture because instance 1 encountered errors

SQL> create directory WLDIR as '/export/prod_db/workload/’;

Directory Created

SQL> begin

  2   dbms_workload_capture.start_capture('Migration Test','WLDIR');

  3  end;

  4  /

ERROR at line 1:

ORA-15505: cannot start workload capture because instance 1 encountered errors

while accessing directory "/export/prod_db/workload/"

ORA-06512: at "SYS.DBMS_WORKLOAD_CAPTURE", line 1179

ORA-06512: at line 2

Solution Description:

To run this start_capture procedure the directory must be empty. Remove all the files from the directory and run the procedure again. This will resolve the error.