USING SCHEDULER TO EXPORT --> FAILURE
623940Feb 19 2008 — edited Feb 19 2008I've used the scheduler to export, and it's been running fine until recently. My export script:
declare
h1 NUMBER;
begin
begin
h1 := dbms_datapump.open(operation => 'EXPORT',
job_mode => 'FULL',
job_name => 'FULLDUMP_EXPORT_ORAPROD3',
version => 'COMPATIBLE');
end;
begin
dbms_datapump.set_parallel(handle => h1, degree => 1);
end;
utl_file.fremove(location => 'DATA_PUMP_DIR',filename => 'FULL_EXPORT_ORAPROD3.DMP');
begin
dbms_datapump.add_file(handle => h1,
filename => 'FULL_EXPORT_ORAPROD3.LOG',
directory => 'DATA_PUMP_DIR',
filetype => 3);
end;
begin
dbms_datapump.set_parameter(handle => h1,
name => 'KEEP_MASTER',
value => 0);
end;
begin
dbms_datapump.add_file(handle => h1,
filename => 'FULL_EXPORT_ORAPROD3.DMP',
directory => 'DATA_PUMP_DIR',
filetype => 1);
end;
/*
begin
dbms_datapump.set_parameter(handle => h1,
name => 'FLASHBACK_TIME',
value => 'TO_TIMESTAMP (to_char(sysdate,''dd.mm.yyyy HH24:MI:SS''),''dd.mm.yyyy HH24:MI:SS'')');
end;
*/
begin
dbms_datapump.set_parameter(handle => h1,
name => 'INCLUDE_METADATA',
value => 1);
end;
begin
dbms_datapump.set_parameter(handle => h1,
name => 'DATA_ACCESS_METHOD',
value => 'AUTOMATIC');
end;
begin
dbms_datapump.set_parameter(handle => h1,
name => 'ESTIMATE',
value => 'BLOCKS');
end;
begin
dbms_datapump.start_job(handle => h1,
skip_current => 0,
abort_step => 0);
end;
begin
dbms_datapump.detach(handle => h1);
end;
end;
One day I got some scheduler error messages, but eventually the job went fine, today on the other hand nothing works.
The error message:
ORA-39065: unexpected master process exception in RECEIVE
ORA-39078: unable to dequeue message for agent MCP from queue "KUPC$C_1_20080219101504"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 558
ORA-25253: listen failed, queue SYS.KUPC$C_1_20080219101504 is not enabled for dequeue
Job "PBX"."FULLDUMP_EXPORT_ORAPROD3" stopped due to fatal error at 10:19:01
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-39081: failed to unsubscribe agent KUPC$A_1_20080219101510 from queue "KUPC$C_1_20080219101504"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1742
ORA-04031: unable to allocate 376 bytes of shared memory ("streams pool","unknown object","streams pool","kwqbsinfy:cco")
ORA-06512: at line 1
ORA-06512: at "SYS.KUPC$QUEUE_INT", line 277
ORA-06512: at "SYS.KUPW$WORKER", line 1312
ORA-39079: unable to enqueue message DG,KUPC$C_1_20080219101504,KUPC$A_1_20080219101510,MCP,144,Y
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPC$QUE_INT", line 913
ORA-04031: unable to allocate 1048 bytes of shared memory ("streams pool","unknown object","streams pool","kgqbt_alloc_block")
ORA-06512: at line 2
I've even tried to export a small system by writing C:\Documents and Settings\Administrator>expdp system/xxxxx directory=data_pump_dir logfile=oraprod3_fullexport.log dumpfile=oraprod3_dump.dmp schemas=test
The error message:
Connected to: Oracle Database 10g Release 10.2.0.3.0 - 64bit Production
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYSTEM
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_20080219120327" and "KUPC$S_1_20080
219120327" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1580
ORA-04031: unable to allocate 56 bytes of shared memory ("streams pool","unknown
object","streams pool","fixed allocation callback")
Has anyone encountered this problem?
Best regards
Jarle