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 DECEMBER 13, 2019

Applies to:

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


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
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
;;; Exception encountered in AWR_LOAD

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


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

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