| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Question about WebDB uses
It's an adult toy.
-----Original Message-----
From: Dax Mickelson [mailto:dax.mickelson_at_lightcom.net]
Sent: Friday, May 26, 2000 12:27 AM
To: Multiple recipients of list ORACLE-L
Subject: Question about WebDB uses
I have played a little with WebDB but I haven't seen or heard of anyone using it for commercial uses. Is WebDB just a toy or what?
At 14:11 2000-05-25 -0800, you wrote:
>Charlie,
>
>I have done this a few times.
>Below are the exact installation instructions.
>I got these from Oracle support.
>
>Goodluck.
>
>Chris Grabowy
>"May Oracle be with you...always"
>
>
>PURPOSE
>==========
>
>This bulletin will give detailed instructions on how to install WebDB
>2.2.0.0.5
>on UNIX. WebDB must be installed in a separate Oracle Home. WebDB
installs
>SQL*Net 8.0.5 components, binary files, and libraries into its Oracle Home
>and therefore must be installed separately.
>
>Note: If you try to install WebDB into the same Oracle Home as the
>database,
>it will install these 8.0.5 components into the database home and possibly
>corrupt the SQL*Net or Database libraries.
>
>
>SCOPE & APPLICATION
>
>Assumptions
>=============
>
>1. You have an Oracle database (7.3.4, 8.0.5, 8.0.6, 8.1.5) installed in
its
> own Oracle Home.
>
>2. Using SQL*Plus from the database home, you can connect to any user using
>a
> connect_string, for example:
>
> connect username/password_at_connect_string
> connect scott/tiger_at_V815
>
>3. The following environment variables are set:
> a. ORACLE_HOME
> i. For example: ORACLE_HOME=/u01/app/oracle/product/WebDB22
> ii. C shell: setenv ORACLE_HOME /u01/app/oracle/product/WebDB22
>
>
> b. ORACLE_BASE
> i. For example: ORACLE_BASE=/u01/app/oracle
> ii. C shell: setenv ORACLE_BASE /u01/app/oracle
>
> c. ORACLE_SID
> i. V815
> ii. C shell: setenv ORACLE_SID V815
>
> d. TNS_ADMIN
> i. Path to tnsnames.ora in your database home. During installation
> WebDB will ask for a tnsnames alias. Make sure that this
>environment
> variable is set to the path of your tnsnames.ora location.
>
> ii. For example:
>
>TNS_ADMIN=/oracle/home/oracle/V815/oracle/product/8.1.5/network/admin
>
> iii. C shell:
> setenv TNS_ADMIN
> /oracle/home/oracle/V815/oracle/product/8.1.5/network/admin
>
> e. PATH
> i. Add $ORACLE_HOME/bin to your PATH environment variable where
> $ORACLE_HOME is your WebDB home. Make sure this environment
>variable
> is pointing to the new WebDB Home first.
>
> ii. Note: If it sees the bin directory of the database home, it
will
> try to use the database SQL*Plus and fail during installation.
>
> f. LD_LIBRARY_PATH
> i. Add $ORACLE_HOME/lib to your LD_LIBRARY_PATH environment
>variable
> where $ORACLE_HOME is your WebDB home. Make sure this
>environment
> variable is pointing to the new WebDB Home first.
>
> ii. Note: If it sees the lib directory of the database home, it
>will
> try to use the database libraries and fail during
> installation.
>
>
> g. SHLIB_PATH
> i. Point this to the $ORACLE_HOME/lib as well where $ORACLE_HOME is
> the WebDB home.
>
> ii. For example: setenv SHLIB_PATH $ORACLE_HOME/lib
>
> h. LIBPATH (for AIX ONLY)
> i. Point this to the $ORACLE_HOME/lib as well where $ORACLE_HOME is
> the WebDB home
>
> ii. For example: setenv LIBPATH $ORACLE_HOME/lib
>
>
> i. WV_GATEWAY_CFG
> i. Point this to the $ORACLE_HOME/listener/cfg/wdbsvr.app where
> $ORACLE_HOME is the WebDB home. This environment variable will
> be used when starting the WebDB listener.
>
> ii. For example: setenv WV_GATEWAY_CFG
> $ORACLE_HOME/listener/cfg/wdbsvr.app
>
>Installing WebDB
>================
>
>
>1. From the unix prompt, cd to the staging area for your WebDB Media and
go
>to the
> orainst directory.
>
> For example: cd /CDROM/orainst/
>
>2. Run orainst for the Oracle Installer to begin.
>
> For example: ./orainst
>
>3. 'Oracle WebDB 2.1 Installation Requirements' will appear on the
screen.
> Select OK.
>
>4. 'Environment Variables'. 'Confirm, change, or enter values for the
> environment variables listed.
>
> ORACLE_BASE: /u01/app/oracle
> ORACLE_HOME: /u01/app/oracle/product/WebDB22
>
>
>5. 'Software Asset Manager' screen. Select the products you wish to
>install.
>
> SELECT: Oracle WebDB 2.2.0.0.5
> Oracle WebDB Listener 2.2.0.0.5
>
>
>6. 'WebDB Listener'. 'Specify Data Access Descriptor (DAD) configuration
> Information. This screen is asking for your DAD name that the
listener
> will use to connect to the database. For this section, it is best to
> choose the Default Settings. It is okay, however, to change the
>listener
> port.
>
> Host Name: <your host>
>
> Data Access: WebDB (Changing this entry will affect how you call
WebDb
> in the URL.)
>
> WebDB Schema: WebDB (This must match the schema name you select to
>install
> WebDB products later in the installation.)
>
> Listener Port: 22005 (Selecting a port below 1024 will require you
to
> start the listener as root.)
>
>
>7. It now begins installing the WebDB listener libraries, SQL*Net, and
> binaries. It will needs these files later in the installation to
>connect
> to the database.
>
>8. 'Choose the database' Choose the version of the database where you are
> installing WebDB.
>
> 8i
> 8.0.5/8.0.6
> 7.3.4
>
>9. 'Enter Your Oracle Database SYS password and a TNS Names alias.'
> Note: It sometimes fails the first time. If it does fail, please try
> it again.
>
> Passord: <sys password>
> TNS Names Alias: <Enter the same alias that connected you in step 2
of
> Assumptions>
>
>
>10. If a toolkit is already installed, it will detect it.
>
> At least one copy of the Oracle PL/SQL toolkit Packages was detected
> in your database. Oracle WebDB requires you to have the 4.0.8
version
> installed.
>
> 1. Proceed, delete previous existing copies.
> 2. Proceed, I already have version 4.0.8 installed.
>
>
>11. Choose a schema where WebDB will be installed and tablespaces for this
> schema. Note: This must match the WebDB Schema you entered in step
6.
>
> Installation: WEBDB
>
> Default: <Default Tablespace>
>
> Temporary: <Temporary Tablespace>
>
> Document: <Tablespace to store uploaded files. Suggest same as
>Default>
>
>
>12. It will now let you know the Default Password for WebDB.
>
>
>13. You can select additional languages for WebDb. Do NOT select any if
you
> only want english.
>
>
>14. It now begins to install the WebDB Packages. Please note: Allow 1hr
>for
> installation. It seems to hang on Task 2 for 45 minutes or more.
Allow
> the installation to continue for up to 2 hours if necessary.
>
>
>
>Post Installation
>===================
>
>
>15. At the end of the installation, run root.sh located in the WebDB Oracle
> Home/orainst directory as the root user.
>
>
>16. You will notice that it has created the following directories in the
> WebDB home.
>
> This WebDB directory will contain an 8.0.5 type home to store all the
> listener files and client libraries. It will contain the following
> directories:
>
> bin/ lib/ network/ ocommon/ orainst/ plsql/ rdbms/
> images/ listener/ nlsrtl/ oracore/ otrace/ precomp/ slax/
>
>
>
>Connecting to WebDB
>====================
>
>
>1. Start the listener
> a. Use one of the following commands to start your webdb listener.
> i. wdbstart <host> <port>&
> A. wdbstart suncst.us.oracle.com 22005 &
> B. wdbstart suncst 22005 &
>
> ii. wdblsnr <host> <port> start&
> A. wdblsnr suncst.us.oracle.com 22005 start &
> B. wdblsnr suncst 22005 &
>
> iii. If your listener started successfully, it will display a
process
> id number. If you listener fails, check your environment
>variables.
>
>
>2. Go to the following URL:
>
> http://<host>:<port>/admin_/gateway.htm
>
> http://intprod.us.oracle.com:22005/admin_/gateway.htm
>
> a. Under the WebDB DAD information section, there is a text box called
> connect string. Add your TNS Alias to the connect string text box
>field.
>
> For example: Connect String: V815
>
> b. Click Apply
>
>
>3. Go to the following URL:
>
> http://<host>:<port>/WebDB/
>
> http://intprod.us.oracle.com:22005/WebDB/
>
> This should bring up the WebDB home page. Login as the username: webdb
> password: webdb.
>
>===========================================================================
=
>============
> __ __ _ __ __
>(__)|-< /-\(__|__(-_
>Enabling the Information Age
>
>Dane C. Isaacs
>Technical Analyst
>
>Oracle Corp.
>5959 T.G Lee Blvd
>Suite 500.
>Orlando, FL. 32822
>--
>Author: Grabowy, Chris
> INET: cgrabowy_at_fcg.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
____EFGH_JKLM___QRSTUVWXYZ
-- Author: Dax Mickelson INET: dax.mickelson_at_lightcom.net Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------Received on Fri May 26 2000 - 09:52:35 CDT
 |
 |