Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: expdp NOT working in 2 Node RAC 10gR2 Database ..........Error ORA-31623: a job is not attached to this session via the specified handle

RE: expdp NOT working in 2 Node RAC 10gR2 Database ..........Error ORA-31623: a job is not attached to this session via the specified handle

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Thu, 25 Jan 2007 23:37:12 +0530
Message-ID: <BBD944BCAC3AB4499DFBAFB1D8AF3020027CA903@BLRKECMSG11.ad.infosys.com>

Folks

On a 2 Node RAC 10gR2 Database, expdp is NOT working.

$ expdp system/<passwd>

Export: Release 10.2.0.2.0 - 64bit Production on Thursday, 25 January, 2007 21:41:41

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP and Data Mining options

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 2745

ORA-06512: at "SYS.DBMS_DATAPUMP", line 3712

ORA-06512: at line 1

As per metalink Doc ID: 308388.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.

Solution

SQL> startup migrate

SQL> @?/rdbms/admin/catpatch.sql

SQL> @?/rdbms/admin/utlrp.sql

SQL> SELECT comp_name, version, status FROM dba_registry;

ACTION ?/rdbms/admin/utlrp.sql has been Run, whereafter following SELECT command still shows 10 Objects belonging to PUBLIC & SYS as INVALID & the ORA-31623 Error continues to occur.

Qs - Since $ORACLE_HOME/rdbms/admin/catpatch.sql is NOT present, can catalog.sql , catproc.sql be safely RE-Run in a Working 2 instance RAC Database from 1 of the RAC instances?

Thanks indeed

Received on Thu Jan 25 2007 - 12:07:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US