This content has been marked as final. Show 9 replies
Welcome to the forums !
Pl post database and OS versions. Pl see these MOS Docs
ORA-31623 When Submitting a Datapump Job (Doc ID 308388.1)
OERR: ORA-31623 a job is not attached to this session via the specified handle (Doc ID 288670.1)
UDE-31623 Error with Data Pump Export (Doc ID 1080775.1)
Srini -- thanks for your quick response. I have gone through the docs. please see my comments below. And let me know how to proceed with this
1. ORA-31623 When Submitting a Datapump Job (Doc ID 308388.1)
I can see all the comp are in valid status. i think this Doc is not useful for my issue
SELECT comp_name, status, version FROM dba_registry;
Oracle Workspace Manager,VALID,18.104.22.168.0
Oracle Database Catalog Views,VALID,22.214.171.124.0
Oracle Database Packages and Types,VALID,126.96.36.199.0
2. OERR: ORA-31623 a job is not attached to this session via the specified handle (Doc ID 288670.1)
Help me in hOw to find and use a valid job?
3. UDE-31623 Error with Data Pump Export (Doc ID 1080775.1)
STREAMS POOL SIZE is not Zero, also it was working fine until this morning without any errors.
I have no idea if this will work, but after looking at the bug I wonder if you named your datapump job if it would work. Try adding this to your command:
job_name = my_job
This will create the datapump job with a name of my_job. It will also create a table that it uses while the job is running.
The failure that I see happening is that the table that needs to be created (which is defaulted) can't be created. I don't know if it partially exists or what is going on, so I wonder if you try to use a different name if it will work.
If you try it, let us know one way or the other.
How exactly can I attach to terminated session?
What is the status of this problem?
It can be easily reproduced by importing data via datapump and hitting CTRL+C during import.
impdp system/X@orcl SCHEMAS=myshema DIRECTORY=MYBACKUP DUMPFILE=ORA11_DP.dmp LOGFILE=IMPDP_1
Any consequent impdp calls end up with this error:
UDI-31623: 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 3263
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4488
ORA-06512: at line 1
in my test case following error appeared in alert log:
Wed Feb 27 18:55:30 2013
Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_ora_28115096.trc (incident=2635):
ORA-04031: unable to allocate 56 bytes of shared memory ("streams pool","unknown object","streams pool","fixed allocation callback")
Incident details in: /u01/app/oracle/diag/rdbms/orcl/ORCL/incident/incdir_2635/ORCL_ora_28115096_i2635.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
So, streams_pool_size was not set.