RE: RE : datapump errors
- To: "Bertrand Guillaumin" <bertrand.guillaumin@xxxxxxxxxx>, <Richard.Goulet@xxxxxxxxxxx>
- Date: Fri, 4 Dec 2009 14:39:35 -0000
This does seem to have been the issue. I had to increase sga_target and then
increase the stream pool from 0.
Datapump then worked OK.
Not sure why this was suddenly required. Have restarted database and am
monitoring memory.
John Dunn
Sefas Innovation Limited.
Tel: + 44 (0) 117 373 6122
P Please consider the environment before printing this email
-----Original Message-----
From: Bertrand Guillaumin [mailto:bertrand.guillaumin@xxxxxxxxxx]
Sent: 04 December 2009 14:28
To: Richard.Goulet@xxxxxxxxxxx; John Dunn
Subject: RE : datapump errors
Hi,
Also I have seen problems when the streams_pool_size is 0 and sga management is
AUTO(use of sga_target).
The SGA is full and cannot make space for the stream pool. Maybe increasing
streams_pool_size will resolve your problem.
B.Guillaumin
DBA Consultant
DIGORA
________________________________________
De : oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] de la part
de Goulet, Richard [Richard.Goulet@xxxxxxxxxxx] Date d'envoi : vendredi 4
décembre 2009 15:11 À : JDunn@xxxxxxxxx; oracle-l digest users Objet : RE:
datapump errors
Take a look in dba_datapump_jobs. The job may still be in there and even if
it's not really functioning you can't start a new job by the same name till you
clear this one. Sometimes connecting with impdp/expdp and attaching to the job
will allow you to kill it, but sometimes it's already dead, just the master
table, which has the same name as the job, hasn't been deleted yet. Simply
drop that table and it should clear up nicely.
Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of John Dunn
Sent: Friday, December 04, 2009 6:32 AM
To: oracle-l digest users
Subject: datapump errors
I have run datapump on a regular basis on the same schema but now get the
errors below:
There have been no database upgrades or anything
Any ideas?
Connected to: Oracle Database 10g Release 10.2.0.1.0 - 64bit Production
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_SQL_FILE_FULL_01 for user PRODUCER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 600
ORA-39080: failed to create queues "KUPC$C_1_20091204112459" and "KUPC$S_1_20091
204112459" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1555
ORA-04031: unable to allocate 376 bytes of shared memory ("streams pool","unknow
n object","streams pool","kwqbsinfy:cco")
--
//www.freelists.org/webpage/oracle-l
Other related posts:
