Re: Export datapump has stopped woring
From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Tue, 18 May 2010 01:53:00 -0700 (PDT)
Message-ID: <d46c9459-9cbe-484d-b67f-def665f7c768_at_l6g2000vbo.googlegroups.com>
On May 18, 6:37 am, zigzagdna <zigzag..._at_yahoo.com> wrote:
> My export datapum was working for months, but now it fails
> consistently in a few minutes after it starts with follwing errors. I
> haved searched google and metalink and do not see any jobs in
> data_pump_jobs and did cleanup of the master tables as per metalink
> NOTE:336014.1, yet problem remains. Any help will be appreciated,
>
> ORA-31626: job does not exist
> ORA-31637: cannot create job SYS_EXPORT_SCHEMA_02 for user SYSTEM
> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
> ORA-06512: at "SYS.KUPV$FT", line 1487
> ORA-39062: error creating master process DM00
> ORA-31613: Master process DM00 failed during startup.
> ### When was the last known good backup taken? ###
> A few days ago
> ### What type of backup is it? ###
> Export.
> ### Which tool, if any, was used to perform the backup? ###
> Operating System.
Date: Tue, 18 May 2010 01:53:00 -0700 (PDT)
Message-ID: <d46c9459-9cbe-484d-b67f-def665f7c768_at_l6g2000vbo.googlegroups.com>
On May 18, 6:37 am, zigzagdna <zigzag..._at_yahoo.com> wrote:
> My export datapum was working for months, but now it fails
> consistently in a few minutes after it starts with follwing errors. I
> haved searched google and metalink and do not see any jobs in
> data_pump_jobs and did cleanup of the master tables as per metalink
> NOTE:336014.1, yet problem remains. Any help will be appreciated,
>
> ORA-31626: job does not exist
> ORA-31637: cannot create job SYS_EXPORT_SCHEMA_02 for user SYSTEM
> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
> ORA-06512: at "SYS.KUPV$FT", line 1487
> ORA-39062: error creating master process DM00
> ORA-31613: Master process DM00 failed during startup.
> ### When was the last known good backup taken? ###
> A few days ago
> ### What type of backup is it? ###
> Export.
> ### Which tool, if any, was used to perform the backup? ###
> Operating System.
What's in the DM00 trace? There should be one since DM00 process failed.
Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Received on Tue May 18 2010 - 03:53:00 CDT