Oracle errors in Data Pump log files
- Article Type: General
- Product: Aleph
- Product Version: 18.01
Description:
While doing the exporting step using the Oracle Data Pump, we encountered the following Oracle errors:
ORA-39127: unexpected error from call to local_str := SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA('Z91_ID1','UTK01','TEXTINDEXMETHODS','CTXSYS',10.02.00.00.00,newblock,0)
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 268
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 4770
And (abc50 is the $usr_library):
ORA-31693: Table data object "ABC50"."Z00P" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01555: snapshot too old: rollback segment number with name "" too small
ORA-22924: snapshot too old
We have already found a Knowledge Base incident related to the ORA-39127 error and will perform the recommended steps. As for these other errors, will they pose problems down the road?
We are continuing with the import step of the Data Pump.
Resolution:
See KB's 16384-14929 and 16384-306 in regard to the 'TEXTINDEXMETHODS','CTXSYS' error.
KB 8192-2519 discusses "ORA-01555: snapshot too old: rollback segment ..." As suggested there, you could try running the export at a time when the z00p is not being updated. KB 16384-14146 talks about sources of z00p updates.
If these don't help, you could increase the undo tablespace size ... or just ignore the error and re-run p_publish_04 to recreate the z00p once you are on v20.
[From site:]
We will re-run p_publish_04 once we are up in v.20.
- Article last edited: 10/8/2013