| Oracle Warehouse Builder (OWB) Release 11g is | | | | prompted I entered the path, started the Repository |
| included in all Oracle Database 11g installations. OWB is | | | | Assistant for the install, and received additional error |
| Oracle's tool for metadata and data management. | | | | messages. For whatever reason, when running the |
| OWB also provides data quality, ETL, dimensional | | | | script from the command prompt, the script did not like |
| modeling, and data auditing. | | | | the way the path was entered. After a number of |
| I recently installed the Oracle Database 11g on my | | | | attempts, I finally was able to resolve this problem. |
| computer which runs Microsoft Vista. | | | | Using a text editor, I opened the |
| I was in the process of running the Repository | | | | reset_owbcc_home.sql file to examine the script. I |
| Assistant of OWB and at the installation stage of 76% | | | | noticed that the script has three entries in the BEGIN |
| completion; I received the following error message: | | | | block of the script. Two of the entries are for Unix and |
| The Warehouse Builder workspace owner installation | | | | the third entry is for Windows. I added a fourth entry |
| failed on user OWBSYS. | | | | for Windows which grants permissions to the |
| Exception occurred in | | | | rtrepos.properties file. |
| 'processSPAWN'.java'lang.Exception: Error: | | | | To resolve this error, I used the following process: |
| java.sql.SQLException: ORA-29532: Java call | | | | First, unlock the OWBSYS user account and assign a |
| terminated by uncaught Java exception: | | | | password. |
| java.sqlSQLException: OWBSYS is not granted | | | | Second, edit the reset_owbcc_home.sql script with |
| access to c:\oracle\product\11.1.0\db_1\/owb/bin/admin | | | | the following entry and then save the |
| rtrepos.propterties: Please run UnifiedRepos | | | | te'); |
| reset_owbcc_home.sql specifying the path of the | | | | Third, run the Repository Assistant from the Design |
| Oracle Home from which the Control Center Service | | | | Center in Warehouse Builder. |
| is being run. | | | | Fourth, complete the screens with the appropriate |
| At times while installing applications, Oracle JVM will | | | | responses. After you click Finish the install will begin. |
| give the ORA-29532 error message when | | | | When the installation is complete, you will receive a |
| permissions are not granted. The ORA-29532 error | | | | dialog box stating that Warehouse Builder was |
| message is stating that the OWBSYS user is not | | | | successfully installed. |
| granted access to the rtrepos.properties file. The | | | | A reason for not having the fourth Windows entry is |
| suggested solution is to run the | | | | that the Oracle Home for the Control Center Service |
| reset_owbcc_home.sql script and specify the path to | | | | or for OWB can be created differently by all |
| your Oracle Home where the Control Center Service | | | | individuals. Therefore, the path to my Oracle Home for |
| of OWB is running. | | | | OWB can be different from another person. |
| I ran the reset_owbcc_home.sql script, when | | | | |