My Oracle Support Banner

EM 13.4 AWR: Upload Snapshot Now Failed With Error: 'ORA-20115: Data Pump import encountered error: ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation: path traverses a symlink [29433] ' (Doc ID 2701386.1)

Last updated on NOVEMBER 30, 2023

Applies to:

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

Symptoms

In Enterprise Manager (EM) Cloud Control , AWR Warehouse load fails with 'ORA-20115: Data Pump import encountered error: ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation: path traverses a symlink [29433]'
 

When manually run UPLOAD SNAPSHOT NOW it reported below errors:

SQL> Select * from CAW_LOAD_ERRORS;

DUMP_ID ERROR_MSG LOG_FILE
39 -20115: ORA-20115: Data Pump import encountered error: ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation: path traverses a symlink [29433] <agent_inst>/awr_stage/2_AC0852BB308917DCE053D988520AA651_78 606136_20812_20838.log
26 -20115: ORA-20115: Data Pump import encountered error: ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation: path traverses a symlink [29433] <agent_inst>/awr_stage/2_AB48FDD3C11A025CE053D988520AD2D4_78 606136_11295_11794.log
40 -20115: ORA-20115: Data Pump import encountered error: ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation: path traverses a symlink [29433] <agent_inst>/awr_stage/2_AC12F48957852658E053D988520A2BC3_78 606136_20839_20851.log

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.