Oracle WebDB Installation Guide
Release 2.2
A77053-01

Contents
Index

Prev Next

2
Installing WebDB 2.2 on Windows NT

This chapter contains the following sections:

2.1 Prerequisites

On Windows NT, you can install WebDB into a local or remote Oracle 8.0.5, 8.0.6, or 8i database. If you are installing WebDB into Oracle 7.3.4, the Oracle 7.3.4 database must be local.

If you are installing in an Oracle Home for the 7.3.4, 8.0.5, or 8.0.6 database, the install program will ask you shut down all Oracle services during the installation process, and restart them afterwards.

Before you install WebDB into Oracle 7.3.4, 8.0.5, 8.0.6, or 8i on Windows NT:

In addition, if you are installing WebDB into Oracle8i on Windows NT:

If you are installing WebDB into Oracle 7.34 on Windows NT:

2.2 WebDB on Windows NT Install

The Oracle WebDB 2.2 install program is designed to allow installation of all WebDB components or installation of selected components. Complete the preliminary steps below before referring to the section that applies to your environment to continue the install process:

2.2.1 Preliminary Steps

The steps in this section are common for both a Windows NT typical install and a Windows NT custom install.

To complete the preliminary steps for installing Oracle WebDB on Windows NT:

  1. Insert the CD labeled WebDB into your CD-ROM drive.

  2. From the Start menu on the NT desktop, choose Run.

  3. Type D:\NT\SETUP.EXE (substitute the appropriate letter of your CD-ROM drive for "D"), then click OK.

  4. In the Oracle Installation Settings window, type the information requested for each field, then click OK. If you have questions about any field in this window or any other installation window, click Help.

    • In the Company Name field, type the name of your company.

    An Oracle Home corresponds to the environment in which an Oracle product runs. You typically define an Oracle Home for an Oracle database during installation.

    IMPORTANT:

    If you are installing on Oracle8i, you must install WebDB into an Oracle Home that is different from the Oracle Home for the 8i database.

    The Oracle Home can be one where you have installed an Oracle product other than Oracle8i or a new Oracle Home. Go to Step 5 for information about creating a new Oracle Home.

    If you are installing WebDB for the first time in an Oracle Home for the 7.3.4, 8.0.5, 8.0.6 database, the install program will ask you shut down all Oracle services during the installation process, then restart them.  

    • The Name list contains all currently defined Oracle Homes. To create a new Oracle Home, go to Step 5.

    • Location is the path to the Oracle Home location where Oracle products are installed. You must choose a valid path that is not in the Windows directory. Different homes cannot share the same home location.

      Note The default Location updates with the correct path based on the Oracle Home you choose in the Name field.

    • The Language list contains supported languages for installing WebDB. Choose English.

  5. To create a new Oracle Home, type a new name in the Name field. The name can be anything you choose. Then, you must type a path to the new home in the Location field. If the directory doesn't exist, the installation program will create it.

    The installation program also automatically creates the new home and installs all required files (for example, SQL*Plus and SQL*Loader).

  6. Click OK. In the next screen, choose a Typical or Custom install.

  7. Click OK. The following message appears if you are trying to install in the same Oracle Home location as the Oracle 8.0.5 or 7.3.4 database installation.

  8. Without stopping the installation, navigate to the Windows NT desktop, click Start, Settings, Control Panel, then Services. You should see a window similar to the following:

    Highlight an Oracle Service and click the Stop button. Repeat this step for every Oracle Service that is currently started.

  9. Navigate back to the screen shown in Step 7 and click Yes to continue installation.

  10. The installation program continues installing required dependencies into the Oracle Home. When it is finished, the following message appears:

  11. Without stopping the installation, navigate back to the Services window shown in Step 8.

  12. Highlight an Oracle Service in the Services list, then click Start to restart it. Repeat this step until you have restarted all stopped Oracle services.

  13. Navigate back to the screen shown in Step 10 and click OK to continue installation.

2.2.2 WebDB on Windows NT Typical Install

Make sure that you have performed the steps in Section 2.2, "WebDB on Windows NT Install" before continuing with this section.

To perform a typical install of Oracle WebDB on Windows NT:

  1. If you selected Typical Install in Step 6, you must specify the database where you are installing WebDB.

    • Click Oracle 8i if you are installing WebDB into a local or remote version of the Oracle8i database.

    • Click Oracle 8.0.5 or 8.0.6 if you are installing WebDB into a local or remote version of the Oracle database.

    • Click Oracle 7.3.4 if you are installing WebDB into a local version of the Oracle 7.3.4 database.

  2. Click OK. If you selected Oracle 8.0.5 or 8.0.6 in the previous step, specify whether the database is local or remote.

  3. Click OK.

  4. The following window displays if you selected:

    • Oracle 8.0.5 or 8.0.6 in Step 1 and Local in Step 2 or

    • Oracle 7.3.4 in Step 1

    • Password is the SYS user password that you use to log on to the Oracle database where you are installing WebDB.

    • Host Name is the name of the machine on which the WebDB Listener will be installed. You can obtain the host name on Windows NT by typing hostname at a DOS command line prompt.

      Note Make sure you enter the fully qualified domain name; for example, 

       hostname.mycompany.com.
    • The WebDB Listener Port # is used by the WebDB Listener to transmit data between the database and Web browser. The default port number is 80. Choose another port number if 80 is being used by another application. After you finish entering the fields in this window, go to Step 21.

  5. The install window displays an additional field, TNS Names Alias if you selected:

    • Oracle 8i in Step 1 or

    • Oracle 8.0.5 or 8.0.6 in Step 1 and Remote in Step 2


    TNS Names Alias is a connect string to a database. It is required if you are installing WebDB into:

    • A remotely installed 8.0.5 or 8.0.6 database (that is, a database with a different Oracle Home than the Oracle Home where WebDB will be installed)

    • The Oracle8i database (always remote)

    If you have not already defined a TNS names alias to the database in your tnsnames.ora file, you can create a new one by typing a new name in the TNS Names Alias field; for example, newalias.

    Note:

    Make a note of this name. The installation program will start the Oracle Net8 Easy Configuration wizard to help you create the new TNS names alias using this name. 

  6. Click OK. The following message displays if you typed:

    Click OK. The following message displays if you typed:

    • An incorrect TNS names alias to a remote database, or

    • A nonexistent TNS names alias in the previous window with the intention of using the Oracle Net8 Easy Configuration wizard to create a new TNS names alias using this name.

  7. If the message does not display, this means you already have a TNS names alias configured for your database. Go to Step 19 to continue the installation.

  8. Click OK. The first window of the Net8 Easy Configuration wizard displays. The wizard guides you through the steps for creating a new TNS names alias or modifying an existing one. To do so, the wizard will modify the tnsnames.ora file for the Oracle Home you specified earlier in Step 4.

  9. If you have added comments to the tnsnames.ora file or installed WebDB into a new Oracle Home, you may see the following message warning that this information may be reorganized or deleted if you continue.

    • Click Yes to continue.

    • (Not recommended) Click No to stop the configuration assistant and create a TNS names alias manually. You can create a TNS names alias manually by following the instructions in "Creating a TNS Names Alias".

  10. In the next window, ensure Add New Service is selected. Choosing this option enables you to create a new TNS names alias for the database.

  11. In New Service Name, type the name of the TNS names alias you specified in the TNS Names Alias field in Step 5.

  12. Click Next. In the next window, choose the networking protocol that you want to use to communicate with the database.

  13. Click Next. The contents of the next window change depending on your selection in the previous step. For example, if you selected TCP/IP (Internet Protocol) in the previous step, the following window displays:

  14. Type the host name of the machine where the database is installed and a database port number.

    Note This port is for the database and is different from the Listener port name you specified in a previous installation window. Specify 1521 as the database port number unless you know it has changed.

  15. Click Next. In the next window, type the System Identifier (SID) for the database where you are installing WebDB.

    IMPORTANT:

    In Windows NT, make sure that the Oracle database SID is for the database into which you are installing Oracle WebDB. If the SID you enter is for another database, connection to the appropriate database may fail. 

    Note:

    The SID is shown in the INSTANCE_NAME parameter in the INITSID.ORA database initialization parameter file. In most cases, the Database SID is ORCL. 

  16. Click Next. In the next window, click Test Service to test the new TNS names alias you created.

  17. Type the SYS user name and password for the database where you are installing WebDB and click Test. If the TNS names alias works correctly, you should see a success message similar to the following:

  18. Click Done, then Next.

  19. Click OK. In the last Net8 Easy Configuration window, click Finish.

  20. The following message asks you to confirm that you have successfully created and tested the TNS names alias.

  21. Click OK. If the install program detects a version of the PL/SQL Web Toolkit, the following window displays.

    • Choose Proceed, delete the previously existing copies and install the new ones to delete any currently existing versions of the PL/SQL Web Toolkit and install the 4.0.8 version instead.

      Version 4.0.8 of the PL/SQL Web Toolkit must be installed in order to install WebDB 2.2.

    • Choose Proceed, I already have version 4.0.8.0.0 installed if a 4.0.8 version of the PL/SQL Toolkit already exists in the database. Installation will proceed using this version.

  22. In the next window, specify the database schema where you will install WebDB 2.2 and the tablespaces that will be used by this schema.

    • The Installation Schema is the database schema where WebDB will be installed. You must specify a schema that does not already exist. The installation program will automatically create the new schema for you.

      You type the installation schema name to log on to WebDB for the first time.

    • The Default Tablespace is used to store any database objects or components created by the WebDB user.

      The install program attempts to choose the best tablespace to use for WebDB. If you don't have one of the following default tablespaces in your database, the install program uses the SYSTEM tablespace:

      TOOLS
      USER_DATA
      USER
      USERS
      USR_DATA
      USERDATA
      USR

    • The Temporary Tablespace is used for creation of temporary table segments for operations performed by the WebDB user such as sorting table rows.

      If you don't have one of the following temporary tablespaces in your database, the install program will create temporary storage in the SYSTEM tablespace:

      TEMP_DATA
      TEMPORARY_DATA
      TEMP
      TEMPORARY

      The Document Tablespace is used to store any items uploaded onto a WebDB Web site. These item types can include files, images, folders, and stored procedures.

      Note The Document Tablespace will gradually fill as end users add items to WebDB Web sites. You should choose a tablespace large enough to accommodate these additions or a tablespace that automatically extends itself.

    You can choose the same Default, Temporary, or Document Tablespace. For example, you can choose USER_DATA as the Default Tablespace and the Document Tablespace.

  23. Click OK. If the Installation Schema you specified in the previous step already exists, you must specify a new schema in which to install WebDB 2.2.

    • Choose Proceed, let me create a new schema where WebDB 2.2 will be installed, to install WebDB 2.2 into a new schema. Click OK to return to the previous page where you can specify a different Installation Schema.

    • Choose Stop, I do not want to install the WebDB packages at this time, then OK if you don't want to install WebDB into a schema other than WebDB. Choosing this option terminates installation.

  24. After you specify a valid Installation Schema, a message displays the user id and password that you use to log on to WebDB initially after it is installed. In the following example, the user id is WebDB and the password is WebDB.

  25. Choose which language or languages to install in addition to English. After installation, end users can use options in their Web browsers to choose which of these languages will be used to display WebDB. 2.2

    You can choose multiple languages by pressing the Shift or Ctrl keys as you choose.

    Important:

    The language(s) you select from this list must be supported on the database where you are installing WebDB. 

  26. Click OK. A message asks if you want to continue installation.

  27. Click Yes to proceed.

    Note:

    Please be patient, as this operation may take several minutes to complete. 

  28. During installation, the wdbsvr.cfg and wdbsvr.app files are backed up if they already exist. These files contain configuration information for the WebDB Listener. You can update the contents of these files after installation by navigating to the WebDB Listener settings page. see "Configuring the WebDB Listener and PL/SQL Gateway" for more information.

    Note  If necessary, the install program automatically updates the
    connect_string parameter to point to the appropriate database where you are installing WebDB.

  29. Click OK to back up the wdbsvr.cfg and wdbsvr.app files.

  30. When installation completes, a success message displays.

    The message displays two URLs that you type into your Web browser's location or address field to navigate to pages for adjusting the WebDB Listener settings.

    Important Make a note of the URLs and user name and password in the message.

  31. Check the log file for errors that may have occurred during installation; for example, PL/SQL compile errors. The log file is located in 

    <ORACLE_HOME>\orainst\wdb_install_packages.log

    where <ORACLE_HOME> is the Oracle Home location where you installed WebDB.

    Additional Information:

    If you encounter any problems after installation, see "Troubleshooting" for more information. 

2.2.3 WebDB on Windows NT Custom Install

The steps in this section are for a Windows NT custom install. You can choose to custom install either Oracle WebDB or Oracle WebDB Listener.

  1. Make sure that you have performed the steps in Section 2.2.1, "Preliminary Steps" before continuing with this section.

  2. If you selected Custom Install in Step 6, the Software Asset Manager window displays.

    • Available Products lists the WebDB software components you can install.

    • Products Installed lists the Oracle Software already installed on your machine

  3. Select (highlight) one or more WebDB software components to install, then click Install.

  1. Refer to the appropriate section to continue the custom installation after completing the above three steps in this section:

2.2.3.1 Oracle WebDB Custom Install on Windows NT

This section covers installing the Oracle WebDB Listener only. If you want to install the entire Oracle WebDB product, see "WebDB on Windows NT Typical Install".

To install the Oracle WebDB product:

  1. If you selected Oracle WebDB in the Software Asset Manager window, WebDB attempts to install the following software components:

    Software Component  Purpose 

    WebDB 2.2 

     

    PL/SQL Web Toolkit 4.0.8 

    Allows you to write Web-enabled applications. 

    Required Support Files 8.0.5.1 

    Required by the WebDB Listener.  

    SQL*Loader 8.0.5 

    Installed in the Oracle Home where you install WebDB. 

    SQL*Plus 8.0.5 

    Installed in the Oracle Home where you install WebDB. 

    If any of the above components or other dependencies are not installed in the Oracle Home you specified in Step 4, a message similar to the following displays.

  2. Click OK. The components and dependencies shown in the message are required prior to installing WebDB and will be installed along with the WebDB packages.

  3. The next window asks you for information about the database where you are installing WebDB:

    • Click Oracle 8i if you are installing WebDB into a local or remote version the Oracle8i database. Go to Step 7.

    • Click Oracle 8.0.5 or 8.0.6 if you are installing WebDB into a local or remote version of the Oracle database.

    • Click Oracle 7.3.4 if you are installing WebDB into the Oracle 7.3.4 database. Go to Step 6.

  4. Click OK. If you selected Oracle 8.0.5 or 8.0.6 in the previous step, specify whether the database is local or remote.

  5. Click OK.

  6. The following window displays if you selected:

    • Oracle 8.0.5 or 8.0.6 in Step 3 and Local in Step 4 or

    • Oracle 7.3.4 in Step 3

    • Password is the SYS user password that you use to log on to the Oracle database where you are installing WebDB.

    After you finish entering a password, go to Step 23.

  7. The install window displays an additional field, TNS Names Alias, if you selected:

    • Oracle 8i in Step 3 or

    • Oracle 8.0.5 or 8.0.6 in Step 3 and Remote in Step 4

    TNS Names Alias is a connect string to a database. If you have not already defined a TNS names alias to the Oracle8i, 8.0.5, or 8.06 database in your tnsnames.ora file, you can create a new one by typing a new name in the TNS Names Alias field; for example, newalias.

    Important:

    Make a note of this name. The installation program will start the Oracle Net8 Easy Configuration wizard to then help you create the new TNS names alias using this name, beginning in Step 10. 

  8. Click OK. The following message displays if you typed:

    • An incorrect TNS names alias to a remote database, or

    • A nonexistent TNS names alias in the previous window with the intention of using the Oracle Net8 Easy Configuration wizard to create a new TNS names alias using this name.

  9. If the message does not display, go to Step 23

  10. Click OK. The first window of the Net8 Easy Configuration Assistant displays. The configuration assistant is a wizard that guides you through the steps for creating a new TNS names alias or modifying an existing one. To do so, the configuration assistant will modify the tnsnames.ora file for the Oracle Home you specified in Step 4.

  11. If you have added comments to the tnsnames.ora file or installed WebDB into a new Oracle Home, you may see the following message warning you that this information may be reorganized or deleted if you continue.

    • Click Yes to continue.

    • Click No to stop the configuration assistant.

    Note You still can create a TNS names alias manually by following the instructions in "Configuring Variables and General Configuration".

  12. In the next window, ensure Add New Service is selected. Choosing this option enables you to create a new TNS names alias for the database.

  13. In New Service Name, type the name of the TNS names alias you specified in the TNS Names Alias field in Step 7.

  14. Click Next. In the next window, choose the networking protocol that you want to use to communicate with the database.

  15. Click Next. The contents of the next window change depending on your selection in the previous step. For example, if you chose TCP/IP (Internet Protocol) in the previous step, the following window displays:

  16. Type the host name of the machine where the database is installed and a port number.

    Note This port is for the database and is different from the Listener port name you specified in a previous installation window. Specify 1521 as the database port number unless you know it has changed.

  17. Click Next. In the next window, type the System Identifier (SID) for the database where you are installing WebDB.

    Note:

    The SID is shown in the INSTANCE_NAME parameter in the INITSID.ORA database initialization parameter file. In most cases, the Database SID is ORCL. 

  18. Click Next. In the next window, click Test Service to test the new TNS names alias you created.

  19. Type the SYS user name and password for the database where you are installing WebDB and click Test. If the TNS names alias works correctly, you should see a success message similar to the following:

    Additional Information:

    If the Test Service fails, this indicates that the connection to the Oracle database was not successful. To troubleshoot, see "Creating a TNS Names Alias". 

  20. Click Done, then Next.

  21. In the last Net8 Easy Configuration window, click Finish.

  22. The following message asks you to confirm that you have successfully created and tested the TNS names alias.

  23. Click OK. If the install program detects a version of the PL/SQL Web Toolkit in the database, you are asked if you want to delete it and install the 4.0.8 version. Version 4.0.8 of the PL/SQL Web Toolkit must be installed in order to install WebDB.

    • Choose Proceed, delete the previously existing copies and install the new ones to delete any currently existing versions of the PL/SQL Web Toolkit and install the 4.0.8 version instead.

    • Choose Proceed, I already have the 4.0.8.0.0 installed if a 4.0.8 version of the PL/SQL Web Toolkit already exists in the database. Installation will proceed using this version.

  24. Click OK. In the next window, specify the database schema where you will install WebDB and the tablespaces for this schema.

    • The Installation Schema is the database schema where WebDB will be installed. You must specify a schema that does not already exist. The installation program will automatically create the new schema for you.

      You type this schema name to log on to WebDB for the first time.

    • The Default Tablespace is used to store any database objects or components created by the WebDB user.

      The install program attempts to choose the best tablespace to use for WebDB. If you don't have one of the following default tablespaces in your database, the install program uses the SYSTEM tablespace:

      TOOLS
      USER_DATA
      USER
      USERS
      USR_DATA
      USERDATA

    • The Temporary Tablespace is used for creation of temporary table segments for operations performed by the WebDB user such as sorting table rows. If you don't have one of the following temporary tablespaces in your database, the install will create temporary storage in the SYSTEM tablespace:

      TEMP_DATA
      TEMPORARY_DATA
      TEMP
      TEMPORARY

    • The Document Tablespace is used to store any items uploaded to a WebDB Web site. These item types can include files, images, folders, and stored procedures.

      Note The Document Tablespace will gradually fill as end users add items to WebDB Web sites. You should choose a tablespace large enough to accommodate these additions, or a tablespace that automatically extends itself.

    You can choose the same Default, Temporary, or Document Tablespace. For example, you can choose USER_DATA as the Default Tablespace and the Document Tablespace.

  25. Click OK. If the Installation Schema you specified in the previous step already exists, you must specify a new schema in which to install WebDB 2.2.

    • Choose Proceed, but let me create a new schema where WebDB 2.2 will be installed, then OK to return to the previous page where you can specify a different Installation Schema.

    • Choose Stop, I do not want to install the WebDB packages at this time, then OK if you don't want to install WebDB into a different schema. Choosing this option stops installation.

  26. In the next window, choose which language or languages to install in addition to the default language, English. After installation, end users can use options in their Browsers to choose which of these languages will be used to display WebDB.

    You can choose multiple languages by pressing the Shift or Ctrl keys as you choose.

    Note Ensure that the database where you are installing WebDB supports the languages you select.

  27. Click OK. A message asks if you want to continue installation.

  28. Click Yes to proceed.

    Note:

    Please be patient, as this operation may take several minutes to complete. 

  29. Check the log file for errors that may have occurred during installation. The log file is located in 

    <ORACLE_HOME>\orainst\wdb_install_packages.log

    where ORACLE_HOME is the Oracle Home where you have installed WebDB.

    Note:

    If connection to the database fails, you may need to edit the connect_string parameter in the wdbsvr.app file which is located in the <ORACLE_HOME>\wdb\listener\cfg directory to point to the appropriate database where you have installed WebDB. Then, you will need to stop and restart WebDB. 

    Additional Information:

    If you need help, see "Troubleshooting". 

2.2.3.2 WebDB Listener Custom Install on Windows NT

This section covers installing the Oracle WebDB Listener only. If you want to install the entire Oracle WebDB product, see "WebDB on Windows NT Typical Install".

To install the Oracle WebDB Listener product:

  1. If you selected WebDB Listener in the Software Asset Manager window (see Step 3), you are prompted for WebDB Listener configuration information.

    • The Host Name is the name of the machine on which the WebDB Listener will be installed. You can obtain the host name by typing hostname at a DOS command line prompt.

      Note Make sure you enter the fully qualified domain name; for example, 

       hostname.mycompany.com.
    • The Data Access Descriptor Name is a virtual directory that will be used in WebDB URLs. In the following URL: 

      http://myserver:2000/webdb

      myserver is the Host Name

      2000 is the Listener Port Number
      webdb is the Data Access Descriptor Name

    • The WebDB Schema is the name of the database schema in which WebDB was installed.

    • The WebDB Listener Port # will be used by the WebDB Listener to transmit data between the database and Web browser.

      The default port number is 80. Choose another port number if 80 is being used by another application.

  2. Click OK. A success message displays when installation completes.

  3. In the Data Access Descriptor for WebDB, ensure that there is a Connect String (TNS names alias) specified for the database where WebDB is installed.

2.3 Deinstalling WebDB on Windows NT

To deinstall WebDB 2.2 or other software components such as:

  1. Follow Steps 1-4 beginning.

  2. Click OK. In the next screen, choose Custom Install

  3. In the Software Asset Manager, select the product or products you want to deinstall (located in the right frame of the window).

  4. Click Remove.

  5. The contents of the next window are different depending on the product or products you are deinstalling. Follow the instructions in the next window and any after that until you deinstall the product.

Prev Next
Oracle
Copyright © 1999 Oracle Corporation.
All Rights Reserved.

Contents
Index