ORA-31623 When Submitting a Datapump Job [ID 308388.1]

3882人阅读 评论(0) 收藏 举报

ORA-31623 When Submitting a Datapump Job [ID 308388.1]


Modified 24-SEP-2010     Type PROBLEM     Status PUBLISHED


In this Document

Applies to:

Oracle Server - Enterprise Edition - Version: to - Release: 10.1 to 10.2
Information in this document applies to any platform.


When we are trying to take an export using datapump utility we are getting the following errors:

UDE-00008: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2315
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3185
ORA-06512: at line 1


For submitting an export job with datapump utility, we use queues, streams and java objects.
SQL tracing confirms that.

If we see any component is not valid in the database, we will see these errors.
By querying dba_registry we find the different component and their status.

SELECT comp_name, status, version
FROM dba_registry;


We can validate different components in the database by running $ORACLE_HOME/rdbms/admin/catpatch.sql via SQL*Plus:

spool catpatch.log
connect / as sysdba
shutdown immediate
startup migrate
SELECT comp_name, version, status
FROM dba_registry;
spool off

If you are on 10g Release 2, then perform:

connect / as sysdba
spool dictreload.log
startup restrict
alter system set shared_pool_size = 512M scope=spfile;
alter system set java_pool_size = 150M scope=spfile;
alter system set aq_tm_processes = 1 scope=spfile;
alter system set cluster_database = false scope=spfile; -- If on RAC
shutdown immediate
startup upgrade
spool off
alter system set cluster_database = true scope=spfile; -- If on RAC
shutdown immediate


NOTE:330138.1 - catpatch.sql Has Been Renamed to c1002000.sql For 10gR2 Database





Blog http://blog.csdn.net/tianlesoftware

网上资源: http://tianlesoftware.download.csdn.net


DBA1 群:62697716(); DBA2 群:62697977()

DBA3 群:62697850   DBA 超级群:63306533;    

聊天 群:40132017



* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    CNDBA 社区
    • 2015年8月18日,CNDBA社区正式上线测试,欢迎来CNDBA社区学习交流!
    • 网址:www.cndba.cn
    • 访问:11635157次
    • 积分:113619
    • 等级:
    • 排名:第5名
    • 原创:1004篇
    • 转载:86篇
    • 译文:2篇
    • 评论:2098条
    Dave's Links
    Oracle 组织
    • 安徽DBA俱乐部,俱乐部整合安徽地区的IT资源,现有成员已经包含安徽大部分IT公司,俱乐部除了资讯信息分享之外,也会定期举行线下活动。欢迎安徽地区的DBA 加入.

      QQ群:363076776 安徽DBA俱乐部/ahdba.com ,备注,加群必须注明籍贯,该群只对安徽地区开放。

    • 网址:www.ahdba.com
    CNDBA 交流QQ群

    • 注意:加群必须注明表空间和数据文件关系
    • 不要重复加群
    • ----------------------
    • CNDBA_1: 62697850 (2k群,大量空闲)
    • CNDBA_2: 62697716(满)
    • CNDBA_3: 283816689
    • CNDBA_4: 391125754
    • CNDBA_5: 104207940(满)
    • CNDBA_6: 62697977
    • CNDBA_7: 142216823(满)