Home » RDBMS Server » Server Utilities » ORA-39125,ORA-31600 during expdp
ORA-39125,ORA-31600 during expdp [message #175143] Thu, 01 June 2006 00:33 Go to next message
cecilialeeus
Messages: 3
Registered: May 2006
Location: newark, ca
Junior Member
Hi,

Thanks to Frank N's pointer. I was able to make some
more progress, but then run into the following.
Not sure why?

Thanks in advance for your help.

Cecilia
===
SQL> execute sys.dbms_tts.transport_set_check ('o_0', true);

PL/SQL procedure successfully completed.

SQL> select * from sys.transport_set_violations;

no rows selected

SQL> alter tablespace o_0 read only;

Tablespace altered.

SQL> create or replace directory my_dir as '/export/home/oracle';

Directory created.



expdp system/manager directory=my_dir dumpfile=tools.dmp transport_tablespaces=o_0 transport_full_check=y logfile=exp_o.log

Export: Release 10.2.0.1.0 - 64bit Production on Thursday, 01 June, 2006 0:59:25

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, OLAP and Data Mining options
Starting "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01": system/******** directory=my_dir dumpfile=tools.dmp transport_tablespaces=o_0 transport_full_check=y logfile=exp_o.log
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD while calling DBMS_METADATA.OPEN 10.2.0.0.0 []
ORA-31600: invalid input value TRANSPORTABLE_EXPORT for parameter OBJECT_TYPE in function OPEN

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6235

----- PL/SQL Call Stack -----
object line object
handle number name
46afc6a68 14916 package body SYS.KUPW$WORKER
46afc6a68 6300 package body SYS.KUPW$WORKER
46afc6a68 5077 package body SYS.KUPW$WORKER
46afc6a68 1926 package body SYS.KUPW$WORKER
46afc6a68 6861 package body SYS.KUPW$WORKER
46afc6a68 1262 package body SYS.KUPW$WORKER
4666b4dc8 2 anonymous block

Job "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" stopped due to fatal error at 00:59:30
Re: ORA-39125,ORA-31600 during expdp [message #505033 is a reply to message #175143] Thu, 28 April 2011 22:00 Go to previous messageGo to next message
mzainal
Messages: 50
Registered: March 2010
Location: Malaysia
Member
Any solution for this topic? I had similar problem. Already run initmeta.sql.
Re: ORA-39125,ORA-31600 during expdp [message #505056 is a reply to message #505033] Fri, 29 April 2011 00:57 Go to previous messageGo to next message
Michel Cadot
Messages: 59822
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is your Oracle version?
What is your OS?
Copy and paste what you did and got.

Regards
Michel
Re: ORA-39125,ORA-31600 during expdp [message #505070 is a reply to message #505056] Fri, 29 April 2011 02:36 Go to previous messageGo to next message
mzainal
Messages: 50
Registered: March 2010
Location: Malaysia
Member
DB ver: Oracle DB 10.2.0.4 ver Linux 86-64
OS Ver: Red Hat AS 4.6 64bit.
Re: ORA-39125,ORA-31600 during expdp [message #505071 is a reply to message #505070] Fri, 29 April 2011 02:37 Go to previous messageGo to next message
Michel Cadot
Messages: 59822
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Copy and paste what you did and got.

Regards
Michel
Re: ORA-39125,ORA-31600 during expdp [message #505072 is a reply to message #505070] Fri, 29 April 2011 02:42 Go to previous messageGo to next message
mzainal
Messages: 50
Registered: March 2010
Location: Malaysia
Member
This error i got:
[oracle@dboracle ~]$ expdp system/bpmksm2011 full=y directory=test_dir dumpfile=unidev-full02.dm
p logfile=unidev-log01.log

Export: Release 10.2.0.4.0 - 64bit Production on Saturday, 27 November, 2010 16:30:30

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_FULL_02":  system/******** full=y directory=test_dir dumpfile=unid
ev-full02.dmp logfile=unidev-log01.log
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 21.56 MB
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METAD
ATA.FETCH_XML_CLOB [TABLE_DATA:"SYSMAN"."MGMT_DIROBJ_USERS_HOTLIST"]
ORA-01157: cannot identify/lock data file 203 - see DBWR trace file
ORA-01110: data file 203: '/u03/app/oracle/product/10.2.0/oradata/unidev/TISTEMP01.dbf'

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6313

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0xde2b7180     15032  package body SYS.KUPW$WORKER
0xde2b7180      6372  package body SYS.KUPW$WORKER
0xde2b7180      2396  package body SYS.KUPW$WORKER
0xde2b7180      6944  package body SYS.KUPW$WORKER
0xde2b7180      1314  package body SYS.KUPW$WORKER
0xde285610         2  anonymous block

Job "SYSTEM"."SYS_EXPORT_FULL_02" stopped due to fatal error at 16:30:40


Try expdp using startup mount now.

[Updated on: Fri, 29 April 2011 03:10] by Moderator

Report message to a moderator

Re: ORA-39125,ORA-31600 during expdp [message #505074 is a reply to message #505072] Fri, 29 April 2011 02:51 Go to previous message
mzainal
Messages: 50
Registered: March 2010
Location: Malaysia
Member
Step:

1. SQL> startup mount
2. SQL> alter database open;

Works for me.
Previous Topic: IMP-00017: following statement failed with ORACLE error 1950
Next Topic: Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Goto Forum:
  


Current Time: Sat Nov 29 03:00:40 CST 2014

Total time taken to generate the page: 0.08196 seconds