ORA-29532: Java call terminated by uncaught Java exception: java.io.IOException using Oracle Warehouse Builder


While migrating an Oracle Warehouse Database to a new platform , the Oracle Warehouse builder needs to be installed as well. Because the Oracle home was not complying with the standards, i changed the Oracle home of Oracle Warehouse builder aswell.
When starting the OWB service i faces the following error :


SQL> @start_service.sql
Not available
Diagnostics:
service startup failure reason ORA-29532: Java call terminated by uncaught Java
exception: java.io.IOException
PL/SQL procedure successfully completed.
SQL>

After some research i found this to solve my problem.
Oracle keeps track of the Oracle Home which is used by Oracle Warehouse Builder in the OWB repository. ( please change the values to match you new Oracle Home in UPDATE OWBRT_SYS.OWBRTPS
 and UPDATE OWB_SCHEMA_OWNER.WB_RT_SERVICE_NODES )


UPDATE OWBRT_SYS.OWBRTPS
SET value='/u00/oracle/owb1020'
WHERE key ='10.2.0.1.31[1];

UPDATE OWB_OWNER.WB_RT_SERVICE_NODES
SET host = 'DWH01.YENLO.LOCAL'
, port = 1521
, service_name = 'DWH.YENLO.LOCAL'
, server_side_home = '/u00/oracle/owb1020'
WHERE node_id = 1;

Now reset the reportory settings.


SQL> @reset_repository.sql
Enter value for repos_password: xxx ( owb_owner schema password )
old 2: wb_rti_util.reset('&REPOS_PASSWORD.');
new 2: wb_rti_util.reset('xxx');
PL/SQL procedure successfully completed.
Commit complete.

Now start the service again

SQL> @start_service
Available
PL/SQL procedure successfully completed.