Home » RDBMS Server » Server Utilities » expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780 (Oracle 10.2.0.1)
expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780 [message #621430] Wed, 13 August 2014 05:27 Go to next message
superuser
Messages: 15
Registered: August 2014
Junior Member
I have DB called wtwora, iam trying to export databse with expdp.


I created proper user:

create user myuser identified by somepassword;
grant connect,dba,resource,exp_full_database,imp_full_database to myuser;
create or replace directory DMP as 'F:\DMP\';
grant read, write on directory DMP to myuser;


Then iam checking what schemas i want to export:
select username from dba_users;

Then i am making export:
expdp myuser@wtwora directory=DMP dumpfile=wtwora.dmp logfile=wtwora.log schemas=WTWORA,SIMONE


And it fails with in 490GB (databse have 1.8TB):

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while ca

lling DBMS_METADATA.FETCH_XML_CLOB [TABLE_DATA:"WTWORA"."TELWIN_IMPORT"]

ORA-31642: the following SQL statement fails:

BEGIN "SYS"."DBMS_CDC_EXPDP".SCHEMA_CALLOUT(:1,1,1,'10.02.00.01.00'); END;

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86

ORA-06512: at "SYS.DBMS_METADATA", line 907

ORA-21780: Maximum number of object durations exceeded.

 

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105

ORA-06512: at "SYS.KUPW$WORKER", line 6241

 

----- PL/SQL Call Stack -----

  object      line object

  handle    number  name

000000036A7D9CB8     14916  package body SYS.KUPW$WORKER

000000036A7D9CB8      6300 package body SYS.KUPW$WORKER

000000036A7D9CB8      2340 package body SYS.KUPW$WORKER

000000036A7D9CB8      6861 package body SYS.KUPW$WORKER

000000036A7D9CB8      1262 package body SYS.KUPW$WORKER

000000036BC1DEF0 2  anonymous block

 

Job "MYUSER"."SYS_EXPORT_SCHEMA_04" stopped due to fatal error at 12:22:05



Can someone help me?

[Updated on: Wed, 13 August 2014 05:31]

Report message to a moderator

Re: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780 [message #621434 is a reply to message #621430] Wed, 13 August 2014 05:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ORA-21780: Maximum number of object durations exceeded.
 *Cause:  This typically happens if there is infinite recursion in the PL/SQL
          function that is being executed.
 *Action: User should alter the recursion condition in order to prevent
          infinite recursion.

You have to tell (show) us on what expdp was woeking. Post more of your log file.

Re: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780 [message #621435 is a reply to message #621430] Wed, 13 August 2014 05:47 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Quote:

ORA-21780:
Maximum number of object durations exceeded.
Cause: This typically happens if there is infinite recursion in the PL/SQL function that is being executed.
Action: User should alter the recursion condition in order to prevent infinite recursion.


What else is going on on the database? I suspect a bug. If you must stay on 10gR2, patch to 10.2.0.5

HTH
-g
Re: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780 [message #621437 is a reply to message #621435] Wed, 13 August 2014 06:02 Go to previous messageGo to next message
superuser
Messages: 15
Registered: August 2014
Junior Member
this is backup databse, so no one clinet is connected.

There is also many error like this in log: "Table data object "WTWORA"."T2S_MODYFIKACJE_UZYTKOWNIKOW" failed to load/unload and is being skipped due to error:"
More log (i deleted some logs lookng like this ". . exported "WTWORA"."AR_000503_2009" 0 KB 0 rows":

More info here


[LF applied [spoiler] tags]

[Updated on: Wed, 13 August 2014 06:30] by Moderator

Report message to a moderator

Re: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780 [message #621438 is a reply to message #621437] Wed, 13 August 2014 06:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What is the version of expdp?
Is 10.2.0.1 the version of the database or expdp?
Please post the first 15 lines of export log.
Also post the result of:
select * from v$version;

Re: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780 [message #621439 is a reply to message #621435] Wed, 13 August 2014 06:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
gazzag wrote on Wed, 13 August 2014 12:47
What else is going on on the database? I suspect a bug. If you must stay on 10gR2, patch to 10.2.0.5

HTH
-g


Do you always just suspect a bug and ask for a patch apply without making any investigation?
Don't you think it is better to first investigate to know exactly what happened before talking about a bug?

>>> HTH
No it will not help in any way.

Re: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780 [message #621441 is a reply to message #621439] Wed, 13 August 2014 06:32 Go to previous messageGo to next message
superuser
Messages: 15
Registered: August 2014
Junior Member
This is 10.2.0.1.
I made expdp on others servers with another databases on 10.2.0.1 and it worked ok. I have problem only with this.
First 15 lines of log:
Export: Release 10.2.0.1.0 - 64bit Production on Sunday, 10 August, 2014 23:30:47

Copyright (c) 2003, 2005, Oracle.  All rights reserved.
;;; 
Connected to: Oracle Database 10g Release 10.2.0.1.0 - 64bit Production
Starting "MYUSER"."SYS_EXPORT_SCHEMA_04":  myuser/********@wtwora directory=DMP dumpfile=wtwora.dmp logfile=wtwora.log schemas=WTWORA,SIMONE 
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 1036. GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "WTWORA"."AR_056277_2010"                   278.0 MB 7126050 rows
. . exported "WTWORA"."AR_056277_2009"                   171.7 MB 4402411 rows
. . exported "WTWORA"."AR_056279_2010"                   95.47 MB 2446654 rows

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.1.0 - 64bit Production
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 64-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

Re: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780 [message #621456 is a reply to message #621441] Wed, 13 August 2014 08:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Check alert?log file if you have any ORA-0060 or ORA-7445 error.
Did you use or change the parallelism during the export?

Re: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780 [message #621517 is a reply to message #621456] Thu, 14 August 2014 00:19 Go to previous messageGo to next message
superuser
Messages: 15
Registered: August 2014
Junior Member
Yesterday i tried make export once again.
Still the same errors in the middle of the log:

. . exported "WTWORA"."AR_033104_2010"                   6.309 MB  179605 rows
. . exported "WTWORA"."AR_033104_2011"                   6.312 MB  179666 rows
. . exported "WTWORA"."AR_033104_2012"                   6.329 MB  180195 rows
. . exported "WTWORA"."AR_033104_2013"                   6.313 MB  179702 rows
. . exported "WTWORA"."AR_033105_2009"                   6.296 MB  179243 rows
ORA-31693: Table data object "WTWORA"."AR_033105_2010" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-00604: error occurred at recursive SQL level 3
ORA-21780: Maximum number of object durations exceeded.
ORA-06512: at "SYS.DBMS_METADATA", line 1546
ORA-06512: at "SYS.DBMS_METADATA", line 1583
ORA-06512: at "SYS.DBMS_METADATA", line 1891
ORA-06512: at "SYS.DBMS_METADATA", line 3806
ORA-06512: at "SYS.DBMS_METADATA", line 4502
ORA-06512: at line 1 
ORA-31693: Table data object "WTWORA"."AR_033105_2011" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-00604: error occurred at recursive SQL level 3
ORA-21780: Maximum number of object durations exceeded.
ORA-06512: at "SYS.DBMS_METADATA", line 1546
ORA-06512: at "SYS.DBMS_METADATA", line 1583
ORA-06512: at "SYS.DBMS_METADATA", line 1891
ORA-06512: at "SYS.DBMS_METADATA", line 3806
ORA-06512: at "SYS.DBMS_METADATA", line 4502
ORA-06512: at line 1 
ORA-31693: Table data object "WTWORA"."AR_033105_2012" failed to load/unload and is being skipped due to error:


In alert log are:
Wed Aug 13 14:50:07 2014
Thread 1 advanced to log sequence 127
  Current log# 9 seq# 127 mem# 0: O:\ORACLE\PRODUCT\10.2.0\ORADATA\WTWORA\REDO9.LOG
Wed Aug 13 15:43:27 2014
Thread 1 advanced to log sequence 128
  Current log# 8 seq# 128 mem# 0: O:\ORACLE\PRODUCT\10.2.0\ORADATA\WTWORA\REDO8.LOG
Wed Aug 13 16:56:03 2014
Thread 1 advanced to log sequence 129
  Current log# 10 seq# 129 mem# 0: O:\ORACLE\PRODUCT\10.2.0\ORADATA\WTWORA\REDO10.LOG
Wed Aug 13 18:22:22 2014
Thread 1 advanced to log sequence 130
  Current log# 9 seq# 130 mem# 0: O:\ORACLE\PRODUCT\10.2.0\ORADATA\WTWORA\REDO9.LOG
Wed Aug 13 21:00:00 2014
Unable to restore resource manager plan to '':
ORA-02097: Message 2097 not found; No message file for product=RDBMS, facility=ORA
ORA-00439: Message 439 not found; No message file for product=RDBMS, facility=ORA; arguments: [Database resource manager]

I do nothing when expdp is running.

[Updated on: Thu, 14 August 2014 00:21]

Report message to a moderator

Re: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780 [message #621524 is a reply to message #621517] Thu, 14 August 2014 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You should first fix the error on your instnace (I don't know nor say it is related to your problem but it should be done):
- set ORACLE_SID in the environment of the OS account that starts the instance (to avoid the "Message not found" messages and maybe some other problems)
- remove resource_manager_plan parameter from your init.ora or spfile
- restart the instance

Before restart, check and post all other ORA- errors in your alert.log maybe there are other things to fix.

Re: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780 [message #621530 is a reply to message #621524] Thu, 14 August 2014 01:19 Go to previous messageGo to next message
superuser
Messages: 15
Registered: August 2014
Junior Member
done:
1) checked pfile - there is no parameter resource_manager_plan:
wtwora.__db_cache_size=6928990208
wtwora.__java_pool_size=16777216
wtwora.__large_pool_size=16777216
wtwora.__shared_pool_size=5251268608
wtwora.__streams_pool_size=0
*.audit_file_dest='o:\oracle\product\10.2.0/admin/WTWORA/adump'
*.background_dump_dest='o:\oracle\product\10.2.0/admin/WTWORA/bdump'
*.compatible='10.2.0.1.0'
*.control_files='o:\oracle\product\10.2.0/oradata/WTWORA/\control01.ctl','o:\oracle\product\10.2.0/oradata/WTWORA/\control02.ctl','o:\oracle\product\10.2.0/oradata/WTWORA/\control03.ctl'
*.core_dump_dest='o:\oracle\product\10.2.0/admin/WTWORA/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='WTWORA'
*.db_recovery_file_dest_size=107374182400
*.db_recovery_file_dest='O:\oracle\product\10.2.0/flash_recovery_area'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=WTWORAXDB)'
*.job_queue_processes=10
*.nls_language='POLISH'
*.nls_territory='POLAND'
*.open_cursors=300
*.pga_aggregate_target=1276116992
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_max_size=12582912000#internally adjusted
*.sga_target=12582912000
*.streams_pool_size=0
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS2'
*.user_dump_dest='o:\oracle\product\10.2.0/admin/WTWORA/udump'


2) set oracle_sid
3) started instance
4) made:
SQL> ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = '';
ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ''
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00439: feature not enabled: Database resource manager

5) shutdown immediate
6) startup open
Re: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780 [message #621547 is a reply to message #621530] Thu, 14 August 2014 03:09 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Message XXXX not found; No message file for product=RDBMS, facility=ORA


Usually means ORACLE_HOME is incorrectly set at the O/S level.

HTH
-g
Re: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780 [message #621551 is a reply to message #621547] Thu, 14 August 2014 04:25 Go to previous messageGo to next message
superuser
Messages: 15
Registered: August 2014
Junior Member
I checked, and oracle_home wasnt set.
Now i did:
C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN>echo %oracle_home%
%oracle_home%

C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN>set oracle_home=C:\oracle\product\10.2.0\db_1

C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN>echo %oracle_home%
C:\oracle\product\10.2.0\db_1


Also i checkd invalid object:
select owner, count(*) from DBA_OBJECTS where status='INVALID' group by owner;

There was 19 invalid objets in PUBLIC. I ran utlrp.sql and now there is no invalid objects.
Should i try now expdp?
Re: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780 [message #621552 is a reply to message #621551] Thu, 14 August 2014 04:41 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
In Windows, ORACLE_HOME will be set in the registry under HKEY_LOCAL_MACHINE\Software\Oracle
Re: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780 [message #621553 is a reply to message #621552] Thu, 14 August 2014 04:44 Go to previous messageGo to next message
superuser
Messages: 15
Registered: August 2014
Junior Member
yes, i checkd oracle_home in regedit in path that u wrote and set exactly the same in cmd.
Re: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780 [message #623536 is a reply to message #621553] Thu, 11 September 2014 05:24 Go to previous messageGo to next message
superuser
Messages: 15
Registered: August 2014
Junior Member
Problem solved by using classical exp instead expdp.
Re: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780 [message #623539 is a reply to message #621439] Thu, 11 September 2014 05:32 Go to previous message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
On the basis that this has taken almost a month so far and is still not properly resolved, yes. We pay a lot for Oracle support.
Previous Topic: ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD
Next Topic: TKPROF output
Goto Forum:
  


Current Time: Thu Mar 28 08:09:51 CDT 2024