My Oracle Support Banner

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

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.