kiccu的部落格

Oracle Warehouse Builder (OWB) Release 11g is incorporated in all Oracle Database 11g installations. OWB is Oracle's device for information and assemblage paperwork. OWB too provides accumulation quality, ETL, dimensional modeling, and information auditing.

I just now installed the Oracle Database 11g on my computer which runs Microsoft Vista.

I was in the method of moving the Repository Assistant of OWB and at the beginning produce of 76% completion; I received the succeeding inappropriateness message:

The Warehouse Builder space proprietor instalment failing on soul OWBSYS.

Exception occurred in 'processSPAWN'.java'lang.Exception: Error: island.sql.SQLException: ORA-29532: Java phone call over by uncaught Java exception: java.sqlSQLException: OWBSYS is not given right to c:\\oracle\\product\\11.1.0\\db_1\\/owb/bin/admin/rtrepos.propterties: Please run UnifiedRepos/reset_owbcc_home.sql specifying the bridle path of the Oracle Home from which the Control Center Service is one run.

At times time beginning applications, Oracle JVM will distribute the ORA-29532 clanger announcement once permissions are not granted. The ORA-29532 faux pas communication is stating that the OWBSYS individual is not granted admittance to the rtrepos.properties data file. The recommended medicine is to run the reset_owbcc_home.sql scrawl and contract the way to your Oracle Home where the Control Center Service of OWB is moving.

I ran the reset_owbcc_home.sql script, once prompted I entered the path, started the Repository Assistant for the install, and acceptable auxiliary mistake messages. For doesn't matter what reason, once running the calligraphy from the edict prompt, the calligraphy did not resembling the way the way was entered. After a figure of attempts, I before i finish was able to mend this challenge.

Using a primer editor, I wide the reset_owbcc_home.sql file to give something the onceover the marks. I noticed that the writing has 3 entries in the BEGIN choke of the dramatic work. Two of the entries are for Unix and the ordinal passageway is for Windows. I other a quaternary written account for Windows which grants permissions to the rtrepos.properties data file.

To work out this error, I used the succeeding process:

First, unlock the OWBSYS somebody article and organize a parole.

Second, repress the reset_owbcc_home.sql calligraphy near the following antechamber and past accumulate the file:

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

Third, run the Repository Assistant from the Design Center in Warehouse Builder.

Fourth, right-down the screens next to the appropriate responses. After you sound Finish the establish in office will inaugurate.

When the beginning is complete, you will receive a dialog box stating that Warehouse Builder was victoriously installed.

A judgment for not having the 4th Windows way in is that the Oracle Home for the Control Center Service or for OWB can be created otherwise by all individuals. Therefore, the course to my Oracle Home for OWB can be various from another individual.