Forum Stats

  • 3,839,465 Users
  • 2,262,494 Discussions


OWB Configuration Problem for Oracle 12c database


I'm trying to configure an OWB 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 (

  • 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][email protected]:15:32.032: 00> oracle.wh.service.impl.assistant.ProcessEngine.display( 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/

main.TaskScheduler timer[5][email protected]:15:32.032: 00> oracle.wh.service.impl.assistant.ProcessEngine.display(>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','', path||'/owb/bin/admin/', '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 file.

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

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

Thanks for your help in advance.


This discussion has been closed.