Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

USING SCHEDULER TO EXPORT --> FAILURE

623940Feb 19 2008 — edited Feb 19 2008
I'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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2008
Added on Feb 19 2008
7 comments
8,953 views