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

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
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.

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer