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)
Thanks for the welcome.
DB version is 220.127.116.11.0
Server is AIX 6
I look into those docs now. Any fix how to restore?
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.
Can some one please help me out here... I am running out of time for this...
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.