This content has been marked as final. Show 10 replies
The size does not matter. We used a few days ago the old version of dump. The new one doesn't work.
The whoel message queue:
Export: Release 220.127.116.11.0 - Production on Mo Mrz 25 22:05:06 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Express Edition Release 18.104.22.168.0 - Productio
ORA-39006: internal error
ORA-39213: Metadata processing is not available
Edited by: Michel77 on Mar 25, 2013 10:41 PM
It looks ike datapump has somehow got corrupted in some way. You can reload it in 11.2 by running:
@?/rdbms/admin/catproc.sql as SYS (get all connections stopped first).
I don;t really use XE but I don;t see why datapump wouldn't work - some feature/function may be disabled but the core functionality should be there.
Sounds like the messing xsl files issue here: Upgrade from XE10 to XE11
execute sys.dbms_metadata_util.load_stylesheets;and see if you get the missing xsl files error.
The XSL files are not distributed with Oracle 11g XE, but seems to be pre-loaded in the default database created by the installer. If you try to create your own database it wont have the stylesheets loaded and you'll need the xsl files to load them up.
The quick solution will be to copy the 180 xsl files from an Oracle 22.214.171.124 Enterprise to your Oracle 11g installation ($ORACLE_HOME/rdbms/xml/xsl/) and load the stylesheets.
it was done:
1) copy jvm and XML directories from an Oracle J2EE Installation
2) installing jvm using @$ORACLE_HOME/javavm/install/initjvm.sql - no success
3) reloding datapump with @?/rdbms/admin/catproc.sql as SYS (get all connections stopped first)
4) showing result by select comp_name, version, status from dba_registry:
Oracle Application Express4.0.2.00.09 VALID
Oracle XML Database 126.96.36.199.0 VALID
Oracle Text 188.8.131.52.0 VALID
Oracle Database Catalog Views 184.108.40.206.0 INVALID
Oracle Database Packages and Types 220.127.116.11.0 VALID
JServer JAVA Virtual Machine LOADING
Any further idea ?
Thanks a lot in advance,
Java inside the database never used to be supported for XE (not sure if that changed recently) so I'd deinstall whatever java it managed to create as it seems to be in an odd state anyway. Once that has gone re-run catproc.sql again.
Once you have done both of those check what objects are invalid in the sys schema - hopefully none. If there are none just try datapump again - if there are some please let us know what is still invalid.
the issue has been solved as follows:
1) the missing XSL Directory was copied from an Oracle EE Installation (179 files)
2) kupostdt.xsl was copied from here: Re: Upgrade from XE10 to XE11
3) stylesheets have been loaded by execute sys.dbms_metadata_util.load_stylesheets;
Thanks a lot for all of you !
Edited by: Michel77 on Apr 20, 2013 10:43 PM