Oracle 10g R2 does not support Oracle Warehouse Builder.

Raymond de Vries 4

Oracle’s latest database release 10g R2 does not support OWB (Oracle Warehouse Builder). All OWB’s up to and including the current version 10.1.0.3 are not certified by Oracle 10g R2 and therefore do not work on the 10g R2 database.

The problem is that when you install the OWB Repository and Runtime, the installation process uses the following sql to identify the DBA privileges:
    SELECT value
    FROM v_$system_parameter
    WHERE name =’enqueue_resources‘.
Unfortunately enqueue_resources init parameter is obsolete in Oracle
Database 10g R2 and therefore the OWB cannot make a connection with the database.

Solution:
You will need to wait for the release 10.1.0.4 OWB patch or use an earlier version of the Database e.g. 10g R1

4 thoughts on “Oracle 10g R2 does not support Oracle Warehouse Builder.

  1. Update to my earlier comment, the Paris OWB and Oracle 10gR2 does make a connection but crashes at
    82% of the installation of the repository with an error about versions that are not correct.
    It first crashed at 52% but that I was able to fix. The problem was that the user OWBRT_SYS (that it creates)
    does not have create view privs and one of the scripts does try create a view under this user.

  2. My hack does permit installation of OWB design repository into 10GR2 (albeit insupported), but runtime repository gave ORA-29532: Java call terminated by uncaught Java exception: java.sql.SQLException: Incompatible server version
    after setting compatible=10.1.0.2.

  3. A hack to cheat the installation is to temporarily replace the v_$system_parameter view with a custom view that includes enqueue_resources. Someone mentioned this idea in the OTN Database forum (not the OWB forum). This should make the installation work although there might be other incompatibilities between the current version of OWB and Database 10g R2.

Comments are closed.

Next Post

Building Check In protection into Oracle Designer/Oracle SCM - Check In only by the user that did the Check Out

Facebook0TwitterLinkedinOne of the peculiarities – that word once took me three minutes to pronounce more or less correctly during a workshop in Melbourne, Australia and I vowed never to use it again – of Oracle Designer’s versioning functionality is the Shared Workarea. In a Shared Workarea, all users are equal. […]