ORA-15505 error when replay.

ORA-15505 error when replay.

分类： ORACLE11G 2010-12-27 14:40 65人阅读 评论(0) 举报

Encourter the error when do the replay.

Use the EM first.

EM did not say anything wrong but do nothing.

Then try the command line and got the error.

ORA-15505: 由于实例 1 在访问目录 "E:/app/Henrybaiwentao/dbcapture" 时遇到错误.

It means the directory should be empty but I put a script under the directory.

Em is simple but it is hard when troubleshooting.

SQL> ed
已写入 file afiedt.buf

  1  BEGIN
  2   DBMS_WORKLOAD_CAPTURE.START_CAPTURE (
  3   name => 'capture_by_Henry',
  4   dir => 'DBCAPTURE',
  5   duration => 600);
  6*  END;
SQL> /
BEGIN
*
第 1 行出现错误:
ORA-15505: 由于实例 1 在访问目录 "E:/app/Henrybaiwentao/dbcapture" 时遇到错误,
因此无法启动工作量捕获
ORA-06512: 在 "SYS.DBMS_WORKLOAD_CAPTURE", line 811
ORA-06512: 在 line 2

Deleted all files under E:/app/Henrybaiwentao/dbcapture .
SQL> /

PL/SQL 过程已成功完成。

SQL>