Skip to Main Content

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

Sherry George

Hi Bhaskar,

Did you forgot to post the error message? Setting that parameter (to 1 or 2) allows OBIEE users to call database functions. Here is the documentation.

https://docs.oracle.com/middleware/1221/core/BIMIG/GUID-C2C5B43E-4BB9-4ED7-94DE-D262698DCF98.htm#BIMIG-GUID-C2C5B43E-4BB…

Edit: There shouldn't be any impact to existing reports (but you would know better in term's of security who needs what access). Also you cannot  do it through EM.

3427784

I was in the same boat a while back. I believe setting it at level 2 lets all users call database functions in OBIEE. If I find my reference from my notes, I'll post it over here.

User_1JG01

Sherry George,

sorry my bad

here you go

++++++++++++++++++++++++++++++++++++++++++++++++

Odbc driver returned an error (SQLExecDirectW).

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE. (HY000)
++++++++++++++++++++++++++++++++++++++++++++++++
Sherry George

ok, and did you confirm that the report that throws the error uses "Evaluate" in it's criteria? If so change the value of the param to 1 or 2 and test. Here is the 11g doc for the same.

https://docs.oracle.com/cd/E28280_01/bi.1111/e10541/configfileref.htm#BIESG417

The links  explain the usage and what the values mean and possible security vulnerabilities if  not set to zero.

Syedsalmancs110

Just to add to all above comments:

EVALUATE_SUPPORT_LEVEL value 1 or 2 meaning:

For value 1 Evaluate is supported for users with manageRepositories permission(it is assigned through application policies to an application role of which user is part of)

For value 2 Evaluate is supported for any user.

User_1JG01

Hi Sherry

thanks for your inputs, yes i have noticed EVALUATE function has been used across various fields in couple of reports

guess based on above definition also provided by Syed , i m thinking to go for

VALUATE_SUPPORT_LEVEL = 1;

So once i make these changes, should i have to request my IT team to restart the entire OBIEE servers or is  there anything that i could do from my end through EM/Console to have these changes reflected immediately

Please share your inputs

Regards:

Bhasker.V

Jsglp

Sherry George
Answer

Hi Bhaskar,

If you set the value to 1 then only  users with the manageRepositories permission will be able to run the reports. And normal bi user's doesn't have that permission. But if this is required only for users with that permission then set the value to 1 and restart BI services or if all users need to run reports with "Evaluate" in it, then set to 2 and restart services.And you can restart the services from EM.

Marked as Answer by User_1JG01 · Sep 27 2020
Syedsalmancs110

Make the change in NQSConfig.INI i.e. define EVALUATE_SUPPORT_LEVEL

EVALUATE_SUPPORT_LEVEL = 1;

Save the file

Through either EM or through command console restart your OPMN managed BIEE Services(coreapplication_obis1,coreapplication_obips1 etc..)

User_1JG01

sure

EVALUATE_SUPPORT_LEVEL = 2;

guess i wanted to go with 2 with your explanation,

is there a way to change it from the front end applications, rather than doing this from back end

where i searched for this in the directoty i have 2 of these files NQSConfig.INI

one located under instance/instance1/....../coreapplication_obis1/

Other one is under Oracle_BI/bifoundation/......./OracleBiServerComponent/

Please let me know

Regards:

bahsekr.V

jsglp

Sherry George

You should make the edit in the file itself. And the file is the one under the instance directory. Also take a backup before editing the file.

User_1JG01

Thanks for all the info. m all set with this request

Regards:

Bhasker.V

Jsglp

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

Post Details

Locked on May 18 2013
Added on Mar 25 2013
10 comments
5,348 views