This content has been marked as final. Show 10 replies
What is the size of your 11.1 database? 11g Express edition has a limitation, you cannot store more than 11GB of data.1 person found this helpful
Did you get any other error along with teh above mentioned error?
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 188.8.131.52.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 184.108.40.206.0 - Productio
ORA-39006: internal error
ORA-39213: Metadata processing is not available
Edited by: Michel77 on Mar 25, 2013 10:41 PM
The size may not matter for that error but it does matter for licensing compliance. If you will be storing more than 11g , you will be out of compliance.1 person found this helpful
Ca you run this and check the status of all the components1 person found this helpful
select comp_name, version, status from dba_registry;
Yes it could be possible to do expdp/impdp.1 person found this helpful
Use the below query and check all invalid objects.
All the invalidated objects has to be recompiled using catproc.sql before expdp.
SQL> SELECT comp_id, version, status FROM dba_registry;
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 220.127.116.11 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 18.104.22.168.0 VALID
Oracle Text 22.214.171.124.0 VALID
Oracle Database Catalog Views 126.96.36.199.0 INVALID
Oracle Database Packages and Types 188.8.131.52.0 VALID
JServer JAVA Virtual Machine LOADING
Any further idea ?
Thanks a lot in advance,
Hi,1 person found this helpful
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