expdp导出时报错ORA-39002、ORA-39070、ORA-29283、ORA-06512

系统：rhel 6.5

数据库：oracle 11.2.0.4

环境：单实例asm.

问题描述：expdp导出时报错ORA-39002、ORA-39070、ORA-29283、ORA-06512，如下所示：

异常原因：

异常场景中导出目录被设置在磁盘组，oracle用户不具有该目录权限.

解决方案：

将oracle用户的家目录作为导出目录(说明：以下为测试结果).

SQL> create directory oggdump as '/home/oracle/';

Directory created.
[oracle@leo ~]$ expdp \'/ as sysdba\' directory=oggdump dumpfile=exp%U.dmp logfile=exp.log full=y FILESIZE=50m

Export: Release 12.1.0.2.0 - Production on Mon Aug 15 20:46:30 2022

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "SYS"."SYS_EXPORT_FULL_01":  "/******** AS SYSDBA" directory=oggdump dumpfile=exp%U.dmp logfile=exp.log full=y FILESIZE=50m 
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 36.5 MB
……
Master table "SYS"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_FULL_01 is:
  /home/oracle/exp01.dmp
Job "SYS"."SYS_EXPORT_FULL_01" successfully completed at Mon Aug 15 20:47:44 2022 elapsed 0 00:01:14

[oracle@leo ~]$ expdp \'/ as sysdba\' directory=oggdump dumpfile=exp%U.dmp logfile=exp.log full=y FILESIZE=50m compression=all parallel=8

Export: Release 12.1.0.2.0 - Production on Mon Aug 15 20:50:12 2022

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "SYS"."SYS_EXPORT_FULL_01":  "/******** AS SYSDBA" directory=oggdump dumpfile=exp%U.dmp logfile=exp.log full=y FILESIZE=50m compression=all parallel=8 
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 36.5 MB
. . exported "APEX_030200"."WWV_MIG_FORMS"                   0 KB       0 rows
……
Master table "SYS"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_FULL_01 is:
  /home/oracle/exp01.dmp
  /home/oracle/exp02.dmp
  /home/oracle/exp03.dmp
  /home/oracle/exp04.dmp
  /home/oracle/exp05.dmp
  /home/oracle/exp06.dmp
  /home/oracle/exp07.dmp
Job "SYS"."SYS_EXPORT_FULL_01" successfully completed at Mon Aug 15 20:51:18 2022 elapsed 0 00:01:06
复制

结论：成功执行，生产环境也是如此解决此异常的.