 Posted 6/14/2010 11:11:15 AM
|
|
|
|
| ora error ORA-39125 and ORA-04063 during export for transportable tablespace I'm using the Oracle Enterprise Manager (browser is IE) to create a tablespace transport file. Maintenance...Transport Tablespaces uses the wizard to walk me through each step. The job gets created and submitted.
The 'Prepare' and 'Convert Datafile(s)' job steps complete successfully. The Export step fails with the following error. Can anyone shed some light on this for me?
Thank you in advance!
=======================================================
Output Log
Export: Release 10.2.0.2.0 - Production on Sunday, 03 September, 2006 19:31:34
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Username:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "SYS"."GENERATETTS000024": SYS/******** AS SYSDBA dumpfile=EXPDAT_GENERATETTS000024.DMP directory=EM_TTS_DIR_OBJECT transport_tablespaces=SIEBEL job_name=GENERATETTS000024 logfile=EXPDAT.LOG
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [TABLE_STATISTICS]
ORA-04063: view "SYS.KU$_IOTABLE_VIEW" has errors
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
2CF48130 14916 package body SYS.KUPW$WORKER
2CF48130 6300 package body SYS.KUPW$WORKER
2CF48130 2340 package body SYS.KUPW$WORKER
2CF48130 6861 package body SYS.KUPW$WORKER
2CF48130 1262 package body SYS.KUPW$WORKER
2CF0850C 2 anonymous block
Job "SYS"."GENERATETTS000024" stopped due to fatal error at 19:31:44
|
|
|
Posted 6/14/2010 11:11:39 AM
|
|
|
|
I think I may have found my own answer.
The SQL for the view SYS.KU$_IOTABLE_VIEW refers to an Object Type of SYS.KU$_IOTABLE_T. That object type did not exist in my installation.
I attached to another server of the same version of 10g, did a DESC of SYS.KU$_IOTABLE_T, copied and pasted it into the query window in SQL Developer (logged in as SYS), and executed it.
The object type SYS.KU$_IOTABLE_T was created.
The view SYS.KU$_IOTABLE_VIEW no longer returned errors.
The Export step of creating a tablespace transport file worked.
This appears to have solved the problem.
|
|
|
Posted 6/14/2010 11:12:11 AM
|
|
|
|
| Thanks for the post!
I have a similar problem in any operation of ExportDP after upgrade 10.2.0.3 with Patch7, like this
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [PROCACT_SCHEMA:"DBP_YBOLDIREV"]
ORA-04063: view "SYS.KU$_CLUSTER_VIEW" has errors
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6255
The problem is resolved.
After the research I have a reason of my problem in some view - XDB.XDB$RESOURCE - table or view does not exist
With the run the SQL scripts in rdbms/admin - catqm.sql the user XDB with it's own object was created.
|
|
|
Posted 6/14/2010 11:13:42 AM
|
|
|
|
I'm doing a full database export using datapump in Oracle 10.2.0. Last time it ran, I got the following message:
Starting "SYS"."MISASTOR_EXPORT":
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS while calling DBMS_METADATA.FETCH_XML_CLOB []
ORA-31642: the following SQL statement fails:
BEGIN "SYS"."DBMS_RULE_EXP_RULES".SCHEMA_CALLOUT(:1,0,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-01950: no privileges on tablespace 'TREVLAC'
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
21AFE878 14916 package body SYS.KUPW$WORKER
21AFE878 6300 package body SYS.KUPW$WORKER
21AFE878 9120 package body SYS.KUPW$WORKER
21AFE878 1880 package body SYS.KUPW$WORKER
21AFE878 6861 package body SYS.KUPW$WORKER
21AFE878 1262 package body SYS.KUPW$WORKER
21B49F18 2 anonymous block
Job "SYS"."MISASTOR_EXPORT" stopped due to fatal error at 15:00:09
Any ideas would I need to look at to determine what would have caused this?
|
|
|
Posted 6/14/2010 11:14:01 AM
|
|
|
|
The worker process that is running this job does not have sufficiant permissions to run - specifically the TREVLAC table is denied access. Try running the job as a admin and see if the error duplicates - if it does you may be out of space for that partition space.
If it does not - that would confirm the suspect permission issue.
|
|
|
Posted 6/14/2010 11:16:46 AM
|
|
|
|
Run $ORACLE_HOME/rdbms/admin - catqm.sql
>> ORA-39125: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS
The SQL for the view SYS.KU$_IOTABLE_VIEW refers to an Object Type of SYS.KU$_IOTABLE_T.
That object type may not exist in your installation because you did not run catqm.sql . . .
|
|
|
|