oracle 31640,【案例】Oracle报错ORA-39000 ORA-31640 ORA-27037的解决办法

最新推荐文章于 2024-10-05 15:25:14 发布

weixin_39589241

最新推荐文章于 2024-10-05 15:25:14 发布

阅读量1.9k

点赞数

文章标签： oracle 31640

当执行 DataPump 导出/导入时，Oracle 数据库可能出现 ORA-39000、ORA-31640 和 ORA-27037 错误。这些问题通常与 DataPump 导出文件的位置、权限或目录设置有关。解决方案包括删除并重新创建 Oracle 目录对象，确保指向新目录的 expdp/impdp 命令正确，并为执行数据泵操作的用户授予读写权限。

摘要由CSDN通过智能技术生成

【案例】Oracle报错ORA-39000 ORA-31640 ORA-27037的解决办法

时间:2016-10-25 21:27 来源:Oracle研究中心作者:HTZ 点击:

次

天萃荷净

Oracle研究中心案例分析：运维DBA反映在巡检Oracle数据库时发现alert日志文件中出现ORA-39000 ORA-31640 ORA-27037报错，结合MOS官方文档总结解决办法。

How to Prevent ORA-39000 ORA-31640 ORA-27037 Errors When Performing DataPump Export/Import (文档 ID 784566.1)

In this Document

Goal

Solution

References

APPLIES TO:

Oracle Database – Enterprise Edition – Version 10.2.0.1 and later

Information in this document applies to any platform.

***Checked for relevance on 22-Oct-2013***

GOAL

This article documents a resolution for errors ORA-39000, ORA-31640 and ORA-27037 when performing DataPump export/import.

DataPump Import can fail with the following errors:

Import: Release 10.2.0.1.0 – Production on Friday, 30 January, 2009 15:10:33

;;;

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production

With the Partitioning, OLAP and Data Mining options

ORA-39000: bad dump file specification

ORA-31640: unable to open dump file "/oracle/u01/app/oracle/oracle/product/10.2.0/db_2/admin/dpdump/expdat.dmp" for read

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

SOLUTION

The parameter DIRECTORY specifies the location to which the DataPump Export or Import is not properly created or having permission issues.

Drop and re-create a new oracle directory object and change the expdp/impdp command to point to the new directory to resolve this issue. You must have the DBA Privilege to create a Directory.

For example to create a directory object named expdp_dir located at /u01/backup/exports enter the