热门标签 | HotTags
当前位置:  开发笔记 > 数据库 > 正文

impdpfailwithORA-31623

impdpfailwithORA-31623FYI:DataPumpimportandexportjobusequeues,streamsandjavaobjects.Ifweseeanyjob

impdp fail with ORA-31623 FYI: Data Pump import and export job use queues, streams and java objects. If we see any job

impdp fail with ORA-31623

FYI:

Data Pump import and export job use queues, streams and java objects.

If we see any job component is invalid (e.g. dbms_java, queue dictionary scripts not run, rdbms/admin/utlrp.sql not run) we may see the ORA-31623 error.

The ORA-31623 can also happens if you are not current with patches (running catupgrd.sql and/or catpatch.sql ), see MOSC for details.

To troubleshoot the ORA-31623 error, look for entries in dba_registry where “status=”invalid” and check dba_objects for object that are granted owned by SYS that are invalid.

解决思路:

1.查看alert。log,还需要具体分析日志。

2. 流池可能没有分配内存

select * from v$sgainfo; 确认 streams_pool_size 是否为零

alter system set streams_pool_size = 10M scope=spfile; 注意该密令要生效需从启数据库

确认是否有组件失效?:

SELECT comp_name, status, version FROM dba_registry;

3. Oracle bug 。

推荐阅读:

ORA-01172、ORA-01151错误处理

ORA-00600 [2662]错误解决

ORA-01078 和 LRM-00109 报错解决方法

ORA-00471 处理方法笔记

ORA-00314,redolog 损坏,或丢失处理方法

ORA-00257 归档日志过大导致无法存储的解决办法


推荐阅读
author-avatar
蓜甪紸甪1995
这个家伙很懒,什么也没留下!
PHP1.CN | 中国最专业的PHP中文社区 | DevBox开发工具箱 | json解析格式化 |PHP资讯 | PHP教程 | 数据库技术 | 服务器技术 | 前端开发技术 | PHP框架 | 开发工具 | 在线工具
Copyright © 1998 - 2020 PHP1.CN. All Rights Reserved | 京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有