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

Thanks Salem for the Advice

On a Working 2 instance RAC Database from 1 of the RAC instances, which of the following 2 is Advisable:-

1. - Can SQL> startup upgrade -> $ORACLE_HOME/rdbms/admin/catupgrd.sql be safely RE-Run?

This was already Run once previously from the 10gR2 NON-RAC Oracle Binaries Software when upgrading the respective Database from 9.2 & before conversion to RAC.

2) - Can catalog.sql, catproc.sql be safely RE-Run?

Cheers

From: Ghassan Salem [mailto:salem.ghassan_at_gmail.com]

Sent: Friday, January 26, 2007 2:28 PM

To: VIVEK_SHARMA

Subject: 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

in 10.2 the script is called catupgrd and not catpatch

On 1/25/07, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com > wrote:

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

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

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.

 Metalink

Solution

SQL> startup migrate

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

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

 ACTION by ME

 ?/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 instead be safely RE-Run in a Working 2 instance RAC Database from 1 of the RAC instances?

 Thanks indeed

• CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS*** -- http://www.freelists.org/webpage/oracle-l