首页 > 其他 > 详细

地图名词梳理

时间:2014-01-25 15:19:37      阅读:329      评论:0      收藏:0      [点我收藏+]


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 。

地图名词梳理

原文:http://blog.csdn.net/a49688448/article/details/18741211

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!