EM 12c: AWR Warehouse Source Database has Null Value for Directory Parameter
(Doc ID 2075341.1)
Last updated on JANUARY 18, 2023
Applies to:
Enterprise Manager for Oracle Database - Version 12.1.0.6.0 and laterInformation 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:
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
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 |
| References |