重庆思庄Oracle、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 146|回复: 0

[Oracle] EM13c: Export Job Fails When Executed From Cluster Database

[复制链接]
发表于 2024-6-16 18:22:14 | 显示全部楼层 |阅读模式
现象:
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.

回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2024-7-23 18:54 , Processed in 0.084032 second(s), 21 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表