EM 12c: Enterprise Manager 12c Cloud Control AWR WareHouse Transfer Job CAW_TRANSFER fails with Error: Failed to create .zip, exit code: [12] error: [No such file or directory] (Doc ID 2274555.1)

Last updated on JUNE 08, 2017

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.5.0 and later
Information in this document applies to any platform.

Symptoms

The Enterprise Manager (EM) 12.1.0.5 Cloud Control AWR WareHouse Transfer Job (CAW_TRANSFER) fails with the following error:

Failed to create 4A5151222F795D1AE0532A207C0A38F0.zip, exit code: [12] 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)

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms