Prev: Teradata DBA , Richmond, VA
Next: oracle 11g takes much longer to start
From: zigzagdna on 17 May 2010 22:37
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.
From: ddf on 17 May 2010 22:51
On May 17, 10:37 pm, zigzagdna <zigzag...(a)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.

You have checked the database for invalid objects?


David Fitzjarrell
From: Vladimir M. Zakharychev on 18 May 2010 04:53
On May 18, 6:37 am, zigzagdna <zigzag...(a)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
 | 
Pages: 1
Prev: Teradata DBA , Richmond, VA
Next: oracle 11g takes much longer to start