Installing Oracle Warehouse Builder

Please advise on the steps required to install OWB

My database is on Red Hat AS4

I would like a client/server build.

I am struggling to install the software with the error "Error in invoking target 'isqlldr' of makefile '<ORACLE_HOME>/rdbms/lib/'

After installing the software, then what do I do? I believe I need to run to create a repository. I can't find this file. Where should it be?

Please help urgently.

LVL 16
Richard OlutolaConsultantAsked:
Who is Participating?
Richard OlutolaConnect With a Mentor ConsultantAuthor Commented:
The steps I was asking for are as follows:

1. Install the software on the server
2. Build the repository by running in $OWB_HOME/owb/bin/unix folder
3. Install client software on a client machine
4. Configure tnsnames.ora on client
5. Connect from client by running

Before you do any of the above, ensure to upgrade to which contains fixes to many of the bugs in 10.2.01

schwertnerConnect With a Mentor Commented:
When installing the OWB in the location under database ORACLE_HOME, it will use the already existing oraInventory folder containing database installation information and sharing the same oraInventory fails sometime.  

Create a seperate oraInventory folder and oraInst.loc file for OWB and specify the file oraInst.loc as parameter while invoking the installer.

 Re-install the OWB in a new ORACLE_HOME i.e altogether in a new location and don't install on top of database ORACLE_HOME.

In addition to new location(ORACLE_HOME), create a new Inventory and inventory location file as follows.

1. Set the new location for installing OWB  like

export ORACLE_HOME=/u01/app/oracle/product/owb

ensure that the location /u01/app/oracle/product/ exists.

2. Create a directory oraInventory inside the ORACLE_HOME

3. Create  a file oraInst.loc pointing to oraInventory in $ORACLE_HOME by doing:

echo "inventory_loc=$ORACLE_HOME/oraInventory" > oraInst.loc

Note: the directory oraInventory and file oraInst.loc will be present under ORACLE_HOME

4. Invoke the installer by providing the parmater as

./runInstaller -invPtrLoc $ORACLE_HOME/oraInst.loc

Richard OlutolaConsultantAuthor Commented:
Sorry I forgot to mention that I already tried that fix but it didn't work for me so I have raised a TAR. Apart from the error, have you installed OWB? What steps did you follow?

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

I think some environment variables are missing or incorrect.
Check all prerequisites in the installation manual.
Installation of Oracle products on Linux is always a challenge
and the first step is to be very accurate with all OS prerequisites.
Also possibly you have to use different Oracle user as that dedicated to the Oracle instance.
Richard OlutolaConsultantAuthor Commented:
I have overcome the issue now by following these steps:


Set new ORACLE_HOME as I did before

Followed the steps to use a new inventory

Also this time around, I used a different HOME name during installation.

I need the steps to implement OWB in 10g.

Did you install IWB in the same HOME where was the DB?
Do you use different OS users?
If they are different there will not be mess with the parameters.
Richard OlutolaConsultantAuthor Commented:
I always installed OWB in a separate home according to the documentation.
I used the same oracle user

It has worked.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.