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

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

阅读量：4210 次

发布时间：2019-05-26

本文共 2122 字，大约阅读时间需要 7 分钟。

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: 10.1.0.2 to 10.2.0.3 - Release: 10.1 to 10.2

Information in this document applies to any platform.

Symptoms

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

Cause

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;

Solution

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

startup

References

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

------------------------------------------------------------------------------

QQ:492913789

Email:ahdba@qq.com

Blog:

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

相关视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx

DBA1 群：62697716(满); DBA2 群：62697977(满)

DBA3 群：62697850 DBA 超级群：63306533;

聊天群：40132017

--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请

你可能感兴趣的文章

Sending Simple Data to Other Apps

查看>>

Receiving Simple Data from Other Apps

查看>>

进程调度API之sleep_on_spinunlock

查看>>

进程调度API之preempt_count_add/preempt_count_sub

查看>>

kptr_restrict 来控制/proc/kallsyms 是否显示symbol的地址

utils/function_cmd_scp.sh

查看>>

utils/pkg_list.sh

查看>>

utils/pkg_list_update.py

查看>>

中断API之set_handle_irq

查看>>

中断API之__tasklet_hi_schedule

查看>>

libvirt的file injection

查看>>

中断API之__tasklet_hi_schedule_first

查看>>

中断API之__tasklet_schedule