EM 12c: AWR Warehouse Source Database has Null Value for Directory Parameter

(Doc ID 2075341.1)

Last updated on DECEMBER 16, 2015

Applies to:

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


Configuration: Enterprise Manager 12c (OMS w/ EM Repository DB), where AWR WareHouse (AWR-WH)
is configured in a Repository DB, and Target RAC has EM Agent w/ Database Plug-in.

Two RAC DBs have been added from this RAC Target to the AWR-WH, but uploads all fail with DataPump errors: 

(Job Run: CAW_RUN_ETL_NOW_1445613952030 >  Task: extractAWR  >   Step: SQL Script)

SQL*Plus: Release Production on Fri Oct 23 13:12:49 2015
SQL> BEGIN dbsnmp.mgmt_caw_extract.run_job_now; END;
ERROR at line 1:
ORA-20115: datapump export encountered error:
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39145: directory object parameter must be specified and non-null
ORA-06512: at "DBSNMP.MGMT_CAW_EXTRACT", line 535
Disconnected from Oracle Database 11g Enterprise Edition Release - 64bit Production

 Running DataPump directly:

%>cat export_options.par

%>expdp parfile=export_options.par

Export: Release - Production on Wed Oct 28 15:14:32 2015
Connected to: Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation



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