ORA-27037

最新推荐文章于 2023-02-09 13:25:04 发布

1ihj2015

最新推荐文章于 2023-02-09 13:25:04 发布

阅读量2.3k

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle toos

本文链接：https://blog.youkuaiyun.com/itdba/article/details/41960847

Oracle toos 专栏收录该内容

9 篇文章

订阅专栏

本文讨论了在使用Oracle GoldenGate进行数据库迁移过程中遇到的ORA-31684和ORA-31693错误，以及如何通过排查文件问题并关闭并行加载来解决该问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

解决问题思路靠经验

ORA-31684: Object type USER:"IOGSMDBA" already exists

ORA-31693: Table data object "IOGSMDBA"."ERR_CDR_GSM":"P20141210" failed to load/unload and is being skipped due to error:
ORA-31640: unable to open dump file "/opt/oracle/ogg/datapump/exphj_cps_IOGSMDBA01_01.dmp" for read
ORA-19505: failed to identify file "/opt/oracle/ogg/datapump/exphj_cps_IOGSMDBA01_01.dmp"
ORA-27037: unable to obtain file status
ORA-31693: Table data object "IOGSMDBA"."ERR_CDR_GSM":"P20141117" failed to load/unload and is being skipped due to error:
ORA-31640: unable to open dump file "/opt/oracle/ogg/datapump/exphj_cps_IOGSMDBA01_02.dmp" for read
ORA-19505: failed to identify file "/opt/oracle/ogg/datapump/exphj_cps_IOGSMDBA01_02.dmp"
ORA-27037: unable to obtain file status

起初怀疑是文件有问题：

userid='/ as sysdba'
DIRECTORY=ggpump
dumpfile=exphj_cps_IOGSMDBA01_%u.dmp
logfile=impexphj_cps_IOGSMDBA01.log
parallel=4
SCHEMAS=IOGSMDBA

后来关掉parallel=4 并行就可以了！！