EM13c: Export Job Fails When Executed From Cluster Database

刘泽宇

现象：
NOTE: The document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
When trying to export data using EM13c, from cluster database, the export job fails.

The following steps are used to start the export job:

1. From cluster database homepage, select "Schema" ->"Database Export Import" -> "Export to Export Files"
2. Log in database as system user and select "Table" and set Host Credentials.
3. Select "Add" and select one of the table. For example, SCOTT.EMP.
4. On "Export: Options" page, set Directory Object for log file.
5. On "Export: Files" page, set Directory Object for export file.
6. Enter job name and submit job.

Error message when browser locale is English:

ORA-39002: invalid operation
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file
"<FILESYSTEM_PATH>/oracle/product/12.1.0/rdbms/log/EXPDAT01.DMP" for read
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory Additional information: 3
Error message when browser locale is Japanese:

Execute Failed: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 18
ORA-06512: at line 44 (DBD ERROR: OCIStmtExecute)

改动：
expdp tried from EM 13c.

原因：
The issue is under investigation in Bug 27871608 - From Cloud Control, Export fails against Cluster DB.

处理方法：
Until Bug 27871608 is fixed, start the DataPump export from command line instead of EM 13c.