ORA-19505 与 ORA-39126

来源:互联网 发布:网络作家收入作假 编辑:程序博客网 时间:2024/05/17 01:03

今天处理数据,遇到两个报错,记录于下
数据库版本:

CORE    12.1.0.2.0  Production21342624;24846605;OCW Interim patch for 2484660524340679;DATABASE BUNDLE PATCH: 12.1.0.2.161018 (24340679)OPatch succeeded.

小补丁是打到2016年十月份的

报错1:

ORA-19505: failed to identify file "/home/oracle/backup/rms_10.dmp"ORA-31617: unable to open dump file "/home/oracle/backup/rms_08.dmp" for writeORA-19505: failed to identify file "/home/oracle/backup/rms_08.dmp"ORA-31617: unable to open dump file "/home/oracle/backup/rms_11.dmp" for writeORA-19505: failed to identify file "/home/oracle/backup/rms_11.dmp"ORA-31617: unable to open dump file "/home/oracle/backup/rms_12.dmp" for writeORA-19505: failed to identify file "/home/oracle/backup/rms_12.dmp"ORA-31617: unable to open dump file "/home/oracle/backup/rms_09.dmp" for writeORA-19505: failed to identify file "/home/oracle/backup/rms_09.dmp"ORA-31617: unable to open dump file "/home/oracle/backup/rms_14.dmp" for write

这里是因为是rac环境,所以

加上参数
cluster=n

expdp system/****** parallel=15 directory=hdp schemas=rms dumpfile=rms_%U.dmp  logfile=rms.log 

报错2:

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.GATHER_PARSE_ITEMS [JAVA_SOURCE:"RMS"."oracle/retail/integration/services/consumer/DrillBackForwardUrlService/runtime/PingResponse_LiteralSerializer"] ORA-06502: PL/SQL: numeric or value error: character string buffer too small

这是提oracle support的一个问题,不过后来oracle support过期了 这个事情就不了了知了。可以认定为oracle 12c的一个bug

所以我只能过滤试试,再说我们也没有用到java_source这个东西

exclude=java_source

expdp system/****** parallel=15 directory=hdp schemas=rms dumpfile=rms_%U.dmp  cluster=n  logfile=rms.log exclude=java_source 
原创粉丝点击