AWR Warehouse Snapshot Uploads Fail with "ORA-27041: unable to open file" Permission Denied
Last updated on APRIL 06, 2017
Applies to:Enterprise Manager for Oracle Database - Version 22.214.171.124.0 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 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.
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