Monday 29 August 2016

kupprdp: master process DM00 started


Alert log:
=======

kupprdp: master process DM00 started with pid=42, OS id=7353
         to execute - SYS.KUPM$MCP.MAIN('SYS_EXPORT_TABLE_01', 'S2', 'KUPC$C_1_20160821122303', 'KUPC$S_1_20160821122303', 0);
kupprdp: worker process DW01 started with worker id=1, pid=25, OS id=7355
         to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_TABLE_01', 'S2');

Solutions.
========

solution

SQL> select job_name,state from dba_datapump_jobs;

JOB_NAME                       STATE
—————————— ——————————
SYS_EXPORT_FULL_02             EXECUTING
SYS_EXPORT_FULL_01             NOT RUNNING

 correction on my instruction above:

– just take note on job_name and owner value.
– in SQLPlus execute DBMS_DATAPUMP.STOP_JOB as follows:
exec DBMS_DATAPUMP.STOP_JOB (DBMS_DATAPUMP.ATTACH(‘JOB_NAME’,’OWNER’,1.0)
– ‘1’ is to abort the job immediately
– ‘0’ is to remove the job from the job list so that it is not restartable

SQL> exec DBMS_DATAPUMP.STOP_JOB (DBMS_DATAPUMP.ATTACH(‘SYS_EXPORT_SCHEMA_01′,’SYSTEM’),1,0);

No comments: