impdp fail with ORA-31623

impdp fail with ORA-31623FYI：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错误处理 http://www.linuxidc.com/Linux/2013-06/86529.htmORA-00600 [2662]错误解决 http://www.linuxidc.com/Linux/2013-06/86528.htmORA-01078 和 LRM-00109 报错解决方法 http://www.linuxidc.com/Linux/2012-07/66044.htmORA-00471 处理方法笔记 http://www.linuxidc.com/Linux/2013-09/90017.htmORA-00314,redolog 损坏，或丢失处理方法 http://www.linuxidc.com/Linux/2013-09/90646.htmORA-00257 归档日志过大导致无法存储的解决办法 http://www.linuxidc.com/Linux/2013-09/90594.htm更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12如何在Oracle 11g 中导出空表Oracle 11g RAC 中几个重要参数的解释相关资讯 ORA-31623 本文评论查看全部评论（0）