RE: Oracle V8.1.6 & WebDB V2.2

From: Grabowy, Chris <cgrabowy_at_fcg.com>
Date: Thu, 25 May 2000 16:51:48 -0400
Message-Id: <10508.106780@fatcity.com>

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

You have an Oracle database (7.3.4, 8.0.5, 8.0.6, 8.1.5) installed in its own Oracle Home.
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:

ORACLE_HOME
For example: ORACLE_HOME=/u01/app/oracle/product/WebDB22 ii. C shell: setenv ORACLE_HOME /u01/app/oracle/product/WebDB22
ORACLE_BASE
For example: ORACLE_BASE=/u01/app/oracle ii. C shell: setenv ORACLE_BASE /u01/app/oracle
ORACLE_SID
V815 ii. C shell: setenv ORACLE_SID V815
TNS_ADMIN
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

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>

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.

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>

It will now let you know the Default Password for WebDB.
You can select additional languages for WebDb. Do NOT select any if you only want english.
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

At the end of the installation, run root.sh located in the WebDB Oracle Home/orainst directory as the root user.
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

Start the listener
Use one of the following commands to start your webdb listener.
wdbstart <host> <port>&
wdbstart suncst.us.oracle.com 22005 &
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

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 Received on Thu May 25 2000 - 15:51:48 CDT