|
Re: Digest for WEB-@topica.com, issue 204
|
Kathleen Smith-Miller
|
Sep 26, 2002 09:57 PDT
|
Elena,
We are running Oracle 8i and WebDB on Solaris - it works great.
1) You need to put Webdb in its own oracle home and reset the
environment variables when you start the webdb listener. I have
a script that I run to reset the variables for webdb. Here is the
configuration we have:
ORACLE_BASE=/ora01/app/oracle
ORACLE_HOME=/ora01/app/oracle/product/8.1.6
(for webdb ORACLE_HOME) = /ora01/app/oracle/product/webdb
This is the script for resetting the environment variables (run as root):
# WebDB enviroment settings
# This must be sourced prior to starting webdb listener
setenv ORACLE_BASE /ora01/app/oracle
setenv ORACLE_HOME /ora01/app/oracle/product/webdb
setenv ORACLE_DOC /ora01/app/oracle/doc
setenv ORACLE_SID wdb
setenv TNS_ADMIN $ORACLE_BASE/product/8.1.6/network/admin
set lpath=( $ORACLE_HOME/bin )
set path=( $lpath $path )
setenv LD_LIBRARY_PATH
$ORACLE_HOME/lib:$ORACLE_BASE/product/8.1.6/lib:$ORACLE_BASE/product/8.1.6/ctx/lib
You can then start the listener as root with the wdbstart command
2) You can use your existing tnsnames file - notice the environment
variable above points to the 8i tnsnames directory.
3) Did you set the ORACLE_SID before trying to log in?
4) Plots are not one of webdb's things - I believe you can do bar charts,
but that's about it.
Hope this helps some.
Kathleen Smith-Miller
Desert Research Institute
kat-@dri.edu
| |
Date: Wed, 25 Sep 2002 17:12:20 +0000
From: Elena Zagrai <e_za-@yahoo.com>
Subject: WebDB installation
Hi!
I've got Oracle 8i on Sun Solaris. I was trying to install
WebDB but the installation guide was confusing for
me:
1) I've got Oracle Home at /oracle. Can I create the new
WebDB home in /oracle/webdb ?
2) Do I need to create a new file tnsnames.ora or
I can point to the existing one (in /oracle/network/admin/)?
3) The installation didn't go further then
entering SYS password and alias - I've got an error
that either alias or sys password is wrong
but I can connect with sql using this password and
alias...
4) I'd like to know also if WebDB can build plots
on the web using the data from the database.
Please, help!
Any suggestions are appreciated. Thanks in advance.)
|
|
|
 |
|
