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!

ORA-31613 while importing a tablespace to another database

779322Jun 29 2010 — edited Jan 7 2011
Hi everyone,

I 'am trying to import a tablespace to another database. Both databases reside on the same machine and OS.
In the alert log it tells me that error details have been dumped to DM00 trace (without trace file #).
And i counldn't find any DM00 trace.
Have anybody faced this type of error?
Any help would be much appreciated.





OS
==============
[oracle->ndev]/home/oracle>uname -a
HP-UX ndev B.11.11 U 9000/800 768551785 unlimited-user license








problem
=================
[oracle->ndev]/u01/app/oracle/product/10.2.0111>impdp system/******** dumpfile=fhdanything.dmp directory=data_pump_dir transport_datafiles=/u01/app/oracle/oradata/test01/trans/example01.dbf,/u01/app/oracle/oradata/test01/trans/users01.dbf

Import: Release 10.2.0.1.0 - 64bit Production on Tuesday, 29 June, 2010 14:29:49

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning and Data Mining options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_IMPORT_TRANSPORTABLE_01 for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1193
ORA-39062: error creating master process DM00
ORA-31613: Master process DM00 failed during startup.










trace
===============
QMNC started with pid=22, OS id=9358
kupprdp: master process DM00 started with pid=22, OS id=9363
to execute - SYS.KUPM$MCP.MAIN('SYS_IMPORT_TRANSPORTABLE_01', 'USER1', 'KUPC$C_1_20100629140744', 'KUPC$S_1_20100629140744', 0);
Tue Jun 29 14:07:47 2010
Process DM00 died, see its trace file
Tue Jun 29 14:11:52 2010
The value (30) of MAXTRANS parameter ignored.
Starting background process QMNC
QMNC started with pid=23, OS id=10178
kupprdp: master process DM00 started with pid=23, OS id=10180
to execute - SYS.KUPM$MCP.MAIN('SYS_IMPORT_TRANSPORTABLE_01', 'USER1', 'KUPC$C_1_20100629141152', 'KUPC$S_1_20100629141152', 0);
Tue Jun 29 14:11:55 2010
Process DM00 died, see its trace file
The value (30) of MAXTRANS parameter ignored.
Starting background process QMNC
QMNC started with pid=23, OS id=10395
kupprdp: master process DM00 started with pid=23, OS id=10397
to execute - SYS.KUPM$MCP.MAIN('SYS_IMPORT_TRANSPORTABLE_01', 'USER1', 'KUPC$C_1_20100629141304', 'KUPC$S_1_20100629141304', 0);
Tue Jun 29 14:13:06 2010
Process DM00 died, see its trace file
The value (30) of MAXTRANS parameter ignored.
Starting background process QMNC
QMNC started with pid=23, OS id=11265
kupprdp: master process DM00 started with pid=23, OS id=11267
to execute - SYS.KUPM$MCP.MAIN('SYS_IMPORT_TRANSPORTABLE_01', 'SYSTEM', 'KUPC$C_1_20100629141736', 'KUPC$S_1_20100629141736', 0);
Tue Jun 29 14:17:39 2010
Process DM00 died, see its trace file
Tue Jun 29 14:22:19 2010
The value (30) of MAXTRANS parameter ignored.
Starting background process QMNC
QMNC started with pid=22, OS id=12194
kupprdp: master process DM00 started with pid=22, OS id=12196
to execute - SYS.KUPM$MCP.MAIN('SYS_IMPORT_TRANSPORTABLE_01', 'SYSTEM', 'KUPC$C_1_20100629142219', 'KUPC$S_1_20100629142219', 0);
Tue Jun 29 14:22:22 2010
Process DM00 died, see its trace file
Tue Jun 29 14:28:00 2010
Restarting dead background process QMNC
QMNC started with pid=22, OS id=13345
The value (30) of MAXTRANS parameter ignored.
Starting background process QMNC
QMNC started with pid=23, OS id=13740
kupprdp: master process DM00 started with pid=23, OS id=13745
to execute - SYS.KUPM$MCP.MAIN('SYS_IMPORT_TRANSPORTABLE_01', 'SYSTEM', 'KUPC$C_1_20100629142950', 'KUPC$S_1_20100629142950', 0);
Tue Jun 29 14:29:53 2010
Process DM00 died, see its trace file
Tue Jun 29 14:35:19 2010
Restarting dead background process QMNC
QMNC started with pid=14, OS id=14755
Tue Jun 29 14:40:28 2010
Restarting dead background process QMNC
QMNC started with pid=25, OS id=15789
Tue Jun 29 14:45:40 2010
Restarting dead background process QMNC
QMNC started with pid=23, OS id=16815
Tue Jun 29 14:50:53 2010
Restarting dead background process QMNC
QMNC started with pid=14, OS id=17810
Tue Jun 29 14:56:05 2010
Restarting dead background process QMNC
QMNC started with pid=14, OS id=18773
Tue Jun 29 15:01:17 2010
Restarting dead background process QMNC
QMNC started with pid=18, OS id=19880
Tue Jun 29 15:06:32 2010
Restarting dead background process QMNC
QMNC started with pid=18, OS id=20881
Tue Jun 29 15:11:45 2010
Restarting dead background process QMNC
QMNC started with pid=14, OS id=21941
Tue Jun 29 15:17:00 2010
Restarting dead background process QMNC
QMNC started with pid=14, OS id=23101
Tue Jun 29 15:22:12 2010
Restarting dead background process QMNC
QMNC started with pid=14, OS id=24080
Tue Jun 29 15:27:21 2010
Restarting dead background process QMNC
QMNC started with pid=18, OS id=25041

Edited by: user9217274 on Jun 29, 2010 5:35 AM

Edited by: user9217274 on Jun 29, 2010 5:36 AM

Edited by: user9217274 on Jun 29, 2010 5:38 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2011
Added on Jun 29 2010
12 comments
3,652 views