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 12.1.0.6.0 and later
Information in this document applies to any platform.

Symptoms

Configuration: Enterprise Manager 12c (OMS 12.1.0.4 w/11.2.0.3 EM Repository DB), where AWR WareHouse (AWR-WH)
is configured in a 12.1.0.2 Repository DB, and Target 11.2.0.3 RAC has 12.1.0.4 EM Agent w/12.1.0.6 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 11.2.0.3.0 Production on Fri Oct 23 13:12:49 2015
...
SQL> BEGIN dbsnmp.mgmt_caw_extract.run_job_now; END;
*
ERROR at line 1:
ORA-20139: ERRORS DURING EXTRACT:
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 11.2.0.3.0 - 64bit Production

 Running DataPump directly:

%>cat export_options.par
SCHEMAS=SYS
DIRECTORY=CAW_EXTR
DUMPFILE=test.dmp
LOGFILE=test.log
CONTENT=METADATA_ONLY

%>expdp parfile=export_options.par

Export: Release 11.2.0.3.0 - Production on Wed Oct 28 15:14:32 2015
...
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 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

 

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