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

原创 2011年01月14日 17:02:00

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


 

Modified 24-SEP-2010     Type PROBLEM     Status PUBLISHED

 

In this Document
  Symptoms
  Cause
  Solution
  References


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

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

 

 

 

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

QQ:492913789

Email:ahdba@qq.com

Blog: http://www.cndba.cn/dave 


网上资源: 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表空间和数据文件的关系,否则拒绝申请

ORA-31623: a job is not attached to this session via the specified handle

在使用Oracel Datapump API时碰到ORA-31623(a job is not attached to this session via the specified handle)错误...

ORA-24300 When Configuring GC Agent to monitor 11g ASM [ID 977472.1]

ORA-24300 When Configuring GC Agent to monitor 11g ASM [ID 977472.1]   修改时间 05-OCT-2...

RAC ASM instances crash with ORA-29702 when multiple ASM instances start(ed) [ID 733262.1]

RAC ASM instances crash with ORA-29702 when multiple ASM instances start(ed) [ID 733262.1] ...

ORA-3214 When Creating a Tablespace [ID 153869.1]

SQL> Create temporary tablespace temp02 tempfile '/oracle/oradata/tjcshow/temp02.dbf' size 1M; Crea...

ORA-31693, ORA-02354 and ORA-01555 with Export Datapump (Doc ID 1580798.1)

今天开发邮件回来说备份报错: ORA-31693: Table data object "YCDATA"."T_MESSAGESYNC_HIS" failed to load/unload and...

oracle 11gR2 ORA-31626: job does not exist 和ORA-31687: error creating worker process with worker id

  Oracle 11gR2 imdp 报错如下:  Import: Release 11.2.0.1.0 - Production on Mon May 3 16:25:17 2010Copyrig...

IMPDP 时遇 ORA-31623、ORA-06512 错误解决一例

今天将一个测试库中的数据导到另一个测试库中,遇到了ORA-31623和ORA-06512错误,以下是大致过程的记录 源库为10.2.0.3 64bit,目标库为新装的11.2.0.4 64bit,采用...

Export/Import DataPump Parameter ACCESS_METHOD[ID 552424.1]

Export/Import DataPump Parameter ACCESS_METHOD - How to Enforce a Method of Loading and Unloading Da...

导出/导入DataPump参数TRACE - 如何诊断Oracle数据泵(文档 ID 286496.1)

导出/导入DataPump参数TRACE - 如何诊断Oracle数据泵(文档 ID 286496.1) 1、介绍 在Oracle10g中,我们引入了新的数据库实用程序Export Data Pu...

How To Diagnose And Troubleshoot Import Or Datapump Import Hung Scenarios [ID 795034.1]

 How To Diagnose And Troubleshoot Import Or Datapump Import Hung Scenarios [ID 795034.1] Modified 10...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:ORA-31623 When Submitting a Datapump Job [ID 308388.1]
举报原因:
原因补充:

(最多只允许输入30个字)