Solved

Installing Oracle Warehouse Builder 10.2.0.1

Posted on 2009-07-09
8
1,801 Views
Last Modified: 2013-12-19
Please advise on the steps required to install OWB 10.2.0.1

My database is 10.2.0.4 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/ins_rdbms.mk'

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

Please help urgently.

R.
0
Comment
Question by:Richard Olutola
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 48

Assisted Solution

by:schwertner
schwertner earned 50 total points
ID: 24821187
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

0
 
LVL 16

Author Comment

by:Richard Olutola
ID: 24821358
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?

R.
0
 
LVL 48

Expert Comment

by:schwertner
ID: 24821553
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.
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 48

Expert Comment

by:schwertner
ID: 24821559
Also possibly you have to use different Oracle user as that dedicated to the Oracle instance.
0
 
LVL 16

Author Comment

by:Richard Olutola
ID: 24822788
I have overcome the issue now by following these steps:

I unset ORACLE_HOME
unset ORACLE_BASE

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.

R.
0
 
LVL 48

Expert Comment

by:schwertner
ID: 24824129
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.
0
 
LVL 16

Author Comment

by:Richard Olutola
ID: 24824527
I always installed OWB in a separate home according to the documentation.
I used the same oracle user

It has worked.
0
 
LVL 16

Accepted Solution

by:
Richard Olutola earned 0 total points
ID: 24959679
The steps I was asking for are as follows:

1. Install the software on the server
2. Build the repository by running reposinst.sh 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 owbclient.sh

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

R.
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle Verification of DataPump Export and Import 17 69
Oracle dataguard 5 61
ORA-02288: invalid OPEN mode 2 89
PL/SQL: ORA-00979: not a GROUP BY expression 3 56
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to recover a database from a user managed backup

697 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question