Oracle Warehouse Builder (OWB) Release 11g is integrated in all Oracle Database 11g installations. OWB is Oracle’s tool for metadata and knowledge administration. OWB also gives data good quality, ETL, dimensional modeling, and facts auditing.
I not too long ago mounted the Oracle Databases 11g on my laptop or computer which operates Microsoft Vista.
I was in the approach of functioning the Repository Assistant of OWB and at the set up phase of 76% completion I received the following mistake message:
The Warehouse Builder workspace operator set up unsuccessful on consumer OWBSYS.
Exception transpired in ‘processSPAWN’.java’lang.Exception: Error: java.sql.SQLException: ORA-29532: Java call terminated by uncaught Java exception: java.sqlSQLException: OWBSYS is not granted obtain to c:oracleproduct11.1.0db_1/owb/bin/admin/rtrepos.propterties: Please run UnifiedRepos/reset_owbcc_residence.sql specifying the route of the Oracle House from which the Manage Center Services is currently being operate.
At moments when putting in applications, Oracle JVM will give the ORA-29532 error concept when permissions are not granted. The ORA-29532 error information is stating that the OWBSYS person is not granted obtain to the rtrepos.properties file. The prompt resolution is to run the reset_owbcc_home.sql script and specify the path to your Oracle Household where by the Control Center Service of OWB is jogging.
I ran the reset_owbcc_household.sql script, when prompted I entered the route, started off the Repository Assistant for the put in, and gained supplemental error messages. For no matter what explanation, when running the script from the command prompt, the script did not like the way the route was entered. Just after a amount of attempts, I finally was equipped to take care of this trouble.
Using a text editor, I opened the reset_owbcc_dwelling.sql file to take a look at the script. I noticed that the script has a few entries in the Get started block of the script. Two of the entries are for Unix and the 3rd entry is for Home windows. I included a fourth entry for Home windows which grants permissions to the rtrepos.qualities file.
To resolve this error, I applied the subsequent process:
1st, unlock the OWBSYS person account and assign a password.
2nd, edit the reset_owbcc_residence.sql script with the following entry and then save the file:
Third, operate the Repository Assistant from the Design and style Center in Warehouse Builder.
Fourth, full the screens with the proper responses. Immediately after you simply click End the install will begin.
When the set up is total, you will get a dialog box stating that Warehouse Builder was successfully mounted.
A rationale for not acquiring the fourth Home windows entry is that the Oracle Property for the Command Heart Company or for OWB can be made in different ways by all persons. Consequently, the route to my Oracle Home for OWB can be unique from an additional human being.