EM 12c: Enterprise Manager 12c Cloud Control AWR WareHouse Transfer Job CAW_TRANSFER fails with Error: Failed to create .zip, exit code:  error: [No such file or directory]
(Doc ID 2274555.1)
Last updated on APRIL 11, 2018
Applies to:Enterprise Manager for Oracle Database - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
The Enterprise Manager (EM) 18.104.22.168 Cloud Control AWR WareHouse Transfer Job (CAW_TRANSFER) fails with the following error:
Failed to create 4A5151222F795D1AE0532A207C0A38F0.zip, exit code:  error: [No such file or directory]
(The error above error followed 14 zip warnings: name not matched: ... for each of the 14 *.dmp files waiting for transfer.)
Running the following SQL query on the AWR WH Repository DB results in data pump errors:
select m.target_name, error_msg, to_char(m.end_time, 'Mon dd, hh24:mi:ss'),
log_file from dbsnmp.caw_load_errors e, dbsnmp.caw_load_metadata m
where e.dump_id = m.dump_id and m.status = 4 order by m.end_time;
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "<AWR-WH param 'dest_dir'>/<dump file name>" for read
(where the file path/name is very long)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!