Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIA 11g error

Received Response
1
Views
2
Comments
user1014019
user1014019 Rank 2 - Community Beginner
in Oracle Business Intelligence Applications

Hi Sir,

My Oracle database is installed is Oracle 12C(12.0.2.0) version and it is installed in Linux environment. My Operating system installed is Windows Server 2012 R2 Standard. I am trying to install OBIA 11g using RCU.bat file which will create 3 users by the name as shown below 1) DEV_DW 2) DEV_BICOMP 3) DEV_BIA_ODIREPO

This will also dump the below dmp  files as shown below 1) obia.dmp, 2) obia_comp.dmp 3) obia_odi.dmp The OS is compatible and the OBIA 11g version is  OBIA  version 11.1.1.10.2.

The error which I am getting is as shown below at java.lang.Thread.run(Thread.java:662) Caused by: java.sql.SQLException: ORA-39002: invalid operation ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79 ORA-06512: at "SYS.DBMS_DATAPUMP", line 4087 ORA-06512: at "SYS.DBMS_DATAPUMP", line 4498 ORA-06512: at line 1 I have already given full access to the directory path.

Appreciate your help on the above issue.

Regards

OBIA_ERROR.gifOS_Config.gif

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Isn't this the exact same thing as getting error while installing OBIA 11g  you posted 4 days ago?

    Please avoid double posting: the result is 2 threads with their own life which will probably not get any follow up ...

  • user1014019
    user1014019 Rank 2 - Community Beginner

    Hi Ceresa,

    Any help is appreciated to resolve the issue.

    I have also given read write permisions for the location of the below dmp files where the below files are kept in the unix box directory

    1) obia.dmp, 2) obia_comp.dmp 3) obia_odi.dmp

    '

    I have also given the grant through system user as shown below

    grant read,write on directory OBIA_DW_DIR to sys;

    grant read,write on directory OBIA_BICOMP_DIR to sys;

    gran tread,write on directory OBIA_BIA_ODIREPO to sys.

    I am still getting the same error.

    Appreciate any help is provided.