Re: WebDB install problems

Thank you David for sharing your pain! The ORACLE WebDB documentation is far from clear.

I haven't yet gone back to our Sun box to try installing WebDB again, but I have done 4 installs on our Red Hat box and through trial and error found a work-around for the SYS password / TNS alias problem. With luck my Red Hat work-around will be successful on the Sun too.

The nexus of the problem for me was the TNS_ADMIN env. variable. The WebDB install appeared to only want a tnsnames.ora file that was in the WebDB directory tree, NOT the tnsnames.ora file that is in the $ORACLE_HOME/network/admin path.

So, before the WebDB install I set the TNS_ADMIN env. variable to what WOULD BECOME the path to the tnsnames.ora file that would be placed in the $ORACLE_BASE/webdb_home/network/admin directory by the WebDB install process.

Then, when the WebDB install dialog asked for the SYS password and the TNS alias, I opened another command window and copied the tnsnames.ora file from the $ORACLE_HOME/network/admin directory to the by now existing $ORACLE_BASE/webdb_home/network/admin directory.

I then went back to the WebDB install dialog and entered the SYS password and TNS alias. BINGO, it worked!

Note that the tnsnames.ora file in the WebDB directory tree is absolutely identical to the one in the base ORACLE directory tree. Even so, the WebDB install would apparently only make use of it if was in the WebDB directory tree.

Oh my. Anyway, however hare-brained this "solution" is, it works on Red Hat 6.1 + ORACLE 8.1.5 + WebDB 2.2.

I'm keeping my fingers crossed for Solaris.

Jim

davidparent_at_my-deja.com wrote:

>Been THERE did THAT....I was caught in what seemed like an infinate loop
>installing this product on Solaris 2.7 with EE ORACLE 8i server on the
>same machine. I had the same issues as you, first it popped up an error
>on the screen with a make error and then it failed when I entered the
>SYS and TNS alias name, invalid password or TNS name.
 

>First off, you need to install webDb in its own product directory, ie.
>NOT in your ORACLE server directory (when I did this, my ORACLE server
>went SOUTH fast).
 

>Environment variables are pretty important, ...specifically the
>following (note that the below env variables are all relative,
>basically, you want to make sure that your lib path points to your webdb
>home library directory first) :
 

>LD_LIBRARY_PATH=/u01/app/oracle/webdb_home/lib:/u01/app/oracle/product/8.1.5/lib
 

>TNS_ADMIN=/u01/app/oracle/product/8.1.5/network/admin
 

>ORACLE_SID=<value>
 

>Note however that when the install prompts you for ORACLE_HOME and
>ORACLE_BASE, make sure that you change the field labeled ORACLE_HOME to
>/u01/app/oracle/webdb_home (your webdb home, not your ORACLE server
>home).
 

>As you know, it creates tables and stuff and there is a possibility that
>you could run out of tablespace if you are not careful.
 

>Anyways, off the oracle site, there is more info on the METALINK site,
>specifically, ORACLE METALINK document 91819.1.
 

>Good Luck, I feel your pain !
 

>David Parent

>In article <391B1ABB.E485A886_at_swipnet.se>,
> Cleo Rasvreer <frado_at_swipnet.se> wrote:
>>
>>
>> Jim Lewis wrote:
>> >
>> > This just about has driven me insane.
>> >
>> > I have Oracle 8i 8.1.5 installed on Solaris 2.6 and can administer
 it
>> > via OEM installed on an NT box. So, looks like the install and
>> > networking files are fine.
>> >
>> > But, my attempt to install WebDB 2.2 fails at the point where it
 asks
>> > for the SYS password and TNS alias for the server. I get a little
>> > popup telling me I have entered either an invalid password or an
>> > incorrect TNS alias.
>> >
>> > I have TNS_ADMIN pointing to the location of the tnsnames.ora file
>> > that was created by the original Oracle8i install.
>> >
>> > e,g, $ORACLE_HOME/network/admin
>> >
>> > I am absolutely sure that I am entering the correct password for the
>> > SYS account.
>> >
>> > I managed to solve this problem in a RedHat Linux install by
 pointing
>> > TNS_ADMIN to the tnsnames.ora file that was in the WebDB install
 path
>> > rather than the one in the $ORACLE_HOME path, but this doesn't work
>> > with this Solaris install.
>> >
>> > Can someone PLEASE help me sort out what dumb thing I'm doing?
>> > I have tried everything I can think of, but without any success.
>> >
>> >
>> >
>>
>>

>Sent via Deja.com http://www.deja.com/
>Before you buy.
    Received on Thu May 25 2000 - 00:00:00 CEST