impdp fail with ora 31623

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 ), seeMOSC 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 。