AWR Warehouse Snapshot Uploads Fail with "ORA-27041: unable to open file" Permission Denied (Doc ID 2249683.1)

Last updated on APRIL 06, 2017

Applies to:

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

Symptoms

AWR snapshots of target databases are not getting uploaded to the Central Warehouse.
Checking the job output shows the errors:

ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "<agent_inst>/awr_t/1_4AB0686C90C8D5EBE05321278A0A785D_2334838841_22_28.dmp" for
read
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
;;; DBMS_DATAPUMP.ADD_FILE(dump file)
;;; Exception encountered in AWR_LOAD


-  The target database is configured in the AWR repository to use the 'oracle' OS user.

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