Re: Installing Discoverer 4.1

Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3ECBA02D.822DA241_at_exxesolutions.com>...
> Declan wrote:
>
> > Hello,
> >
> > I am a complete novice to Oracle and Discoverer and I am having
> > difficulties setting up Discoverer 4.1 on a Windows 2000 PC.
> >
> > I have tried a couple of approaches.
> > 1. I installed Oracle 8i Enterprise Edition for Windows NT and
> > connected to the standard database through SQL Plus using the
> > SYSTEM/MANAGER login. But when I tried to install Discoverer 4.1, I
> > got the message:
> > "The location specified c:\oracle\ora81 is already used as an Oracle
> > home for 'Oracle 815 Production'. It cannot be used as an Oracle home
> > for 'nt'".
> >
> > I saw from this newsgroup that people had a similar problem in the
> > past. I tried the suggestion of changing the home directory in regedit
> > and went on to install Discoverer. But when I tried run SQL Plus, I
> > got the error:
> > "Message file SP1<lang>.msb not found"
> > And when I try to run the Administration Edition of Discoverer, I get
> > the error:
> > "Failed to Connect to database - ORA-12203: TNS: unable to connect to
> > destination"
> >
> > 2. On a different PC, I installed Discoverer 4.1 first and when I
> > tried to install Oracle 8i, I got a similar message about the Oracle
> > directory already being used.
> >
> > Now before I go any further there are a couple of very basic
> > questions, I would like to ask:
> >
> > 1. WHEN YOU INSTALL DISCOVERER, DO YOU ALSO HAVE TO INSTALL ORACLE OR
> > IS THERE A STANDARD DATABASE THAT COMES WITH THE INSTALLATION OF
> > DISCOVERER 4.1?
> > I tried connecting by running SQL Plus 8.0 (and through Discoverer
> > Administration) and logging in as SYSTEM, but I get the error:
> > "Failed to connect to database .........etc." again.
> >
> > 2. CAN YOU INSTALL DISCOVERER 4.1 AND ORACLE 8i ENTERPRISE EDITION
> > TOGETHER ON A WINDOWS 2000 PC? AND IF SO, HOW? i.e in which sequence,
> > etc.
> >
> > As I said, I'm a complete novice so I apologise for my naivety, but I
> > don't know anyone who knows anything about Discoverer.
> >
> > Declan.
>
> Regedit? Oh no. I can only wonder what damage you have done. Given that
> possibility here is my suggestion.
>
> 1. Deinstall Oracle from your system.
> 2. Install Discoverer and when it asks for a new home directory keep out
> of the registry and just give it
> a home name like DISC_HOME and point it to c:\oracle\discovery as the
> directory location
> 3. Install the RDBMS again and when it asks for a home name just use
> something like RDBMS_HOME
> and point it to c:\oracle\ora81 or whatever as long as it is different.

Thank you.
That worked fine. Received on Thu May 22 2003 - 14:12:22 CEST