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.

OWB 11.2.0.4 Configuration Problem for Oracle 12c database

user6296952Jul 16 2014

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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 13 2014
Added on Jul 16 2014
#11g, #12c, #configuration, #data-warehousing, #database, #owb, #warehouse-builder
0 comments
1,958 views