David Dai -- Focus on Oracle

The important thing in life is to have a great aim ,and the determination to attain it!

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

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://www.cndba.cn/dave 

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


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

DBA3 群:62697850   DBA 超级群:63306533;    

聊天 群:40132017


版权声明: https://blog.csdn.net/tianlesoftware/article/details/6139542
个人分类: Oracle Troubleshooting
上一篇IBM pSeries AIX System Administration -- 系统备份、恢复和可用性
下一篇IBM HACMP 系列 -- 基础知识
想对作者说点什么? 我来说一句