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
阅读全文
0 0
- ORA-19505 与 ORA-39126
- ORACLE impdp或expdp与ORA-31693&ORA-31640&ORA-19505&ORA-27037
- listener.ora与 tnsnames.ora
- ORA-19504与ORA-27038
- ORA-16014 与 ORA-00312
- ORA-01034 与ORA-01034
- ORA
- ora
- expdp ora-31640 ora-19505
- listener.ora 与 tnsnames.ora 及 sqlnet.ora
- ora-00604与ORA-12705问题
- INSERT与ORA-00936、ORA-00928
- USING与 ORA-25154 ,ORA-01748
- ORA-07445与ORA-00108错误
- ORA-1157与ORA-01110错误实践
- ORA-01157与ORA-01110错误解决
- ORA-1157与ORA-01110错误实践
- ORA-32017与ORA-02095:修改db_block_size
- 那些年错过的蓝桥杯
- 第八周项目二__顺序串算法
- (转载)Mybatis结合Oracle的foreach insert批量插入
- Spring AOP编程
- 上传图片能在HTML页面显示预览
- ORA-19505 与 ORA-39126
- Linux容器虚拟技术LXC简明手册
- 使用Verilog HDL语言实现4位超前进位加法器
- Linux常用命令
- 报错: Access restriction:The type JPEGCodec is not accessible due to restriction on required library
- GPS坐标转换为百度坐标,百度坐标的转换,原始坐标转百度坐标
- Eclipse
- Python——嵌套列表,根据第k维进行排序
- Boost算法库——搜索算法(Boyer-Moore Search)