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.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google