0 Replies Latest reply on Jul 16, 2014 1:57 PM by user6296952

    OWB 11.2.0.4 Configuration Problem for Oracle 12c database

    user6296952

      Hello,

       

      I'm trying to configure an OWB 11.2.0.4 Installation for an Oracle 12c database.

      Both systems are running on the same machine, a Windows Server 2012.

      I want to create a new workspace and do not want to migrate an existing one from an older version.

      I'm following the instructions from the Oracle Warehouse Builder Installation and Administration Guide 11g Release 2 (http://docs.oracle.com/cd/E11882_01/owb.112/e17130/setup_windows.htm#BACCHBHD):

      • run the scripts cat_owb.sql and reset_owbcc_home.sql from the %ORACLE_HOME%/owb/UnifiedRepos directory.
      • unlock the OWBSYS and OWBSYS_AUDIT users
      • run the Repository Assistant

       

      At 1%, I got the following error:

      main.TaskScheduler timer[5]20140716@15:15:32.032: 00> oracle.wh.service.impl.assistant.ProcessEngine.display(ProcessEngine.java:2122): Exception = java.sql.SQLException: ORA-29532: Java-Aufruf durch nicht abgefangene Java-Exception beendet: java.sql.SQLException: OWBSYS can not access to E:\oracle\product\11.2.0\owb11g_home/owb/bin/admin/rtrepos.properties

      main.TaskScheduler timer[5]20140716@15:15:32.032: 00> oracle.wh.service.impl.assistant.ProcessEngine.display(ProcessEngine.java:2122)+>ORA-06512: in "OWBSYS.WB_RT_UPDATE_HOME_PATH", Zeile 2

       

      According to different other Forums, I added the following line to reset_owbcc_home.sql:

      dbms_java.grant_permission('OWBSYS','java.io.FilePermission', path||'/owb/bin/admin/rtrepos.properties', 'read,write');

       

      But this did not solve the problem. When I have a look at the %ORACLE_HOME%/owb/bin/admin, I can find no rtrepos.properties file.

       

      Creating the file manually results in the following error during the repository assistant run at 73%:

      main.TaskScheduler timer[5]20140716@11:28:59.059: 00> oracle.wh.service.impl.assistant.ProcessEngine.display(ProcessEngine.java:2122): [processSPAWN]: A spawned program error. Exception = java.lang.Exception: Error : java.sql.SQLException: ORA-29532: Java-Aufruf durch nicht abgefangene Java-Exception beendet: java.io.FileNotFoundException: Permission denied

       

      Thanks for your help in advance.

       

      Sebastian