Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Oracle Discoverer download/Installation issue

Posted on 2004-10-26
Medium Priority
Last Modified: 2013-12-11
I initially installed Oracle 8i Personal Edition and it works fine.
Now, when I install , Oracle Discover Desktop Edition,
if I select the location as ORAHOME81,
it says "the location c:\oracle\ora81 is already used as an oracle home for oracle 815 production .  It cannot be used as Oracle home for win95".

If I select Admin as location,
it says "Oracle Discoverer cannot be installed in multiple locations , choose ORAHOME81 as location".

What to do for this.  I am installing all this in win98.

Question by:sampathgowri
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
LVL 48

Expert Comment

ID: 12419164
You have to choose another Oracle for Discoverer.
Oracle Home means a location (directory with appropriate size) on the Hard Disk which stores the software and parameters of Discoverer.

Author Comment

ID: 12423798
What do u mean by another Oracle.  I still can't understand.  Can u write in detail.
Thank you,

Expert Comment

ID: 12423916
It is many years since I worked with version this old but I seem to remember having a similar problem with Oracle 8iR2 and Oracle Developer. If I installed Oracle 8i (client or server) and then tried to install Developer it gave me the same error.

The solution was to wipe all Oracle from the machine and then install Oracle Developer (Discoverer in your case) first and then Oracle 8i as Developer does not support multiple homes but Oracel 8i does.

I will have a search to see if there is an easier solution that does not involve de-installation and post it if I can find it.

I hope that helps.


Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.


Expert Comment

ID: 12423969
One solution to this problem seems to be to upgrade to the version of Oracle Discoverer that comes with Oracle Developer 6i PatchSet 1 as that supports multiple homes.



Accepted Solution

chedgey earned 1000 total points
ID: 12424022
This is from Metalink article 105099.1 (too long to post whole article here) that describes your situation and the solution:

The problem with multiple versions of developer and multiple versions of the database is that pre 6i patch1 developer products are non-multiple home aware.  
This means that the 'ORACLE' key in the NT registry will become a mish-mash of values from each product installed.
The solution is to rename the ORACLE key after each successive install of developer.  
However this procedure is fine as long as there are no local Oracle databases, and you are always going to connect to remote machines.   This is the issue that the following instructions attempt to address.
The normal procedure when installing a single database and a single version of developer on the same PC is to install developer first then the DB afterwards, *AS LONG AS* the DB is multiple-home aware.   In this example, we are using 8i / 8.1.5 as this is MOH aware.    This is the standard method - install developer first then 8i.    
PROBLEM!  If using a pre 8i database,  you have to install it into the same Oracle home as developer - and only then there are only VERY SPECIFIC COMBINATIONS  of the two products that will work.  You HAVE to make sure this is correct.  The problem with this approach is that you cannot upgrade the one without upgrading the other.  As such Section A of this note is based on the assumption that you are using 8i or another MOH aware database.  

Following the supported method of installing say 8i over the top of developer 6 for example, the problem is that only the developer 6 registry is updated with the 8i details,  and not the other versions you have installed, say developer 2.1 and devloper 1.6.1.
The solution is to copy the registry entries relevant to 8i from the developer 6 registry area to the developer 2.1 registry area.   The other way is to create a king of oracle8 'skeleton' registry export, or 'merge-key', and merge these standalone relevant 8i registry entries with your developer registry areas.  Both are discussed in the worked example below.



Assisted Solution

Pontis earned 1000 total points
ID: 12451913

   When you install the Discoverer, when it asks for Oracle Home, specify a new location and a new name for Oracle home , let's say "OraDisc". Try installing it (it will fail).

 Now go into registry  and change the  HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES\DEFAULT_HOME to 'OraDisc'. Try installing again.


Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

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…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

636 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