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:
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.
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