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 O
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 。
广告![ThinkPHP5快速开发企业站点[全程实录]](https://img.php.cn/upload/course/000/000/068/6253d918a3ce7278.png)
收藏
收藏
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
918
