Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Does Oracle 11g Express Edition 11.2.0.0 support the impdp utility ?

593460Mar 25 2013 — edited Apr 20 2013
Hi,

We are trying to import an Oracle dump within a Express Edition, without success. We got the error message: ORA-39213: Metadata processing is not available.

A) Source data base: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0
B) Target data base: Oracle Database 11g Express Edition Release 11.2.0.2.0

Searching for solution led us to following forum entries:

1. http://kmpdba.wordpress.com/2012/05/02/ora-39213-metadata-processing-is-not-available/ Cause: DBMS_METADATA_UTIL package does not successfully ran. Solution: to install (among others) SQL> @$ORACLE_HOME/javavm/install/initjvm.sql
2. But: there is no @$ORACLE_HOME/javavm/install/initjvm.sql scrript -> http://www.oracle.com/us/products/database/enterprise-edition/comparisons/index.html -> Oracle 11g EX does not support java

Questions:

a) Does support Oracle 11g EX the impdp utility at all ?
b) How would it be possible to import the above mentioned dump from (A) into (B) ?

Thanks in advance,

Michel
This post has been answered by Richard Harrison . on Mar 26 2013
Jump to Answer

Comments

Robin Chatterjee

First of the only way you woud have this is if you extracted the rpms from a exadata storage server patch and manually applied them or if it is indeed an exadata storage server. In the former case it is a violation of your license agreement to do so.

you can find out if the Storage software is installed by seeing if you can execute cellcli ...

this is not a sure shot way but cellcli should not be there without the storage software installed.

The best way to ensure its removed - reinstall a standard linux distro like oracel linux redhat or centos...

Jjun.Tan

Hi Nitzan,

To check if the exadata software is installed, you can use "rpm -qa | grep -i exa".

1st thing first however, its the job of Oracle's ACS to get it installed and setup everything for you, including all the necessary software. Hence, if you're just checking then its fine.

2nd, the beauty of Exadata lies in the Storage software for the offloading capabilities, hence why would you even remove it?

3rd, things will break if you forcefully remove the software, and be prepared to engage Oracle for the service required to get it back.

For the storage servers, its almost a black box, any seek Oracle's opinion via a SR before doing anything. If you're re-purposing this box because it's old and out-dated, then you're better off re-imaging the entire OS for a cleaner machine.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 18 2013
Added on Mar 25 2013
#database-key-features, #export-import-sql-loader-external-tables
10 comments
5,349 views