Oracle® Database

3.1 Disk Space Requirements

The following disk space sizes apply to Oracle HTML DB and Oracle HTTP Server only. They do not include the sizes in an existing Oracle Database installation.

Disk space requirements for Oracle HTML DB only:

• TEMP space: 110 MB

• SYSTEM_DRIVE:\Program Files\Oracle directory: 0.13 MB

• SYSTEM_DRIVE:\ORACLE_BASE\ORACLE_HOME directory: 342 MB

• SYSTEM_DRIVE:\ORACLE_BASE\oradata directory: 230 MB (datafiles)

• Total: 682.13 MB

Disk space requirements for Oracle HTML DB and Oracle HTTP Server together:

• TEMP space: 110 MB

• SYSTEM_DRIVE:\Program Files\Oracle directory: 1.12 MB

• SYSTEM_DRIVE:\ORACLE_BASE\ORACLE_HOME directory: 715 MB

• SYSTEM_DRIVE:\ORACLE_BASE\oradata directory: 230 MB (datafiles)

• Total: 1.03 GB

3.2 Browser Requirements

To view or develop Oracle HTML DB applications, Web browsers must support JavaScript and the HTML 4.0 and CSS 1.0 standards. The following browsers meet this requirement:

• Netscape Communicator 7.0 or later

• Microsoft Internet Explorer 6.0 or later (Windows only)

• Mozilla 1.2 or later

• Firefox 1.0.4

3.3 Oracle Database Requirement

Oracle HTML DB requires an Oracle database that is release 9.2.0.3 or later. You need to install Oracle HTML DB into an Oracle home that contains Oracle HTTP Server. This Oracle home can be on a different physical server from the Oracle Database home, as long as Oracle HTML DB can access this database with Oracle*Net.

For example, if Oracle Database has been installed in OraDB10g_home1, when you run Oracle Universal Installer to install Oracle HTML DB and are prompted for an Oracle database, you can specify the Oracle Database in that home, but you need to install Oracle HTML DB into its own home that contains Oracle HTTP Server, for example, OraDB10g_home2.

3.4 Oracle HTTP Server Requirement

Oracle HTML DB must have access to Oracle HTTP Server and mod_plsql in order to run. The Oracle HTML DB installation option that you choose determines the available versions of Oracle HTTP Server that meet this requirement:

• Oracle HTML DB Only: If you plan to select the Oracle HTML DB Only installation option, you need to install it into an existing Oracle HTTP Server home. The following products include the versions of Oracle HTTP Server and mod_plsql that meet the requirements:

  • Oracle 9i Database release 2 (9.2) or later.

  • Oracle 9i Application Server release 1 (1.0.2.2) or later.

  Oracle HTTP Server has the following minimum operating system and service pack requirements:

  • Windows 2000 with Service Pack 3 or later

    Windows 2000 includes: Window 2000 Professional, Windows 2000 Server, Windows 2000 Advanced Server, Windows 2000 Datacenter Server, and Terminal Services

  • Windows 2003

  • Windows XP Professional

  Note:

  Windows Multilingual User Interface Pack is supported on Windows 2003 and Windows XP.

  If the system does not meet these requirements, select the Oracle HTML DB and Oracle HTTP Server installation option instead of Oracle HTML DB Only.

• Oracle HTML DB and Oracle HTTP Server: If you plan to install the version of Oracle HTTP Server that is included in the Oracle Database 10g Companion Products release, see "Using the Oracle HTTP Server Provided with the Companion Products" for its requirements.

3.5 Oracle XML DB Requirement

Oracle XML DB first must be installed in the Oracle database that you want to use for Oracle HTML DB. If you are using a preconfigured database created either during an installation or by Database Configuration Assistant (DBCA), Oracle XML DB is already installed and configured.

3.6 Oracle Text Requirement

Oracle Text must be installed so that you can use the searchable online help in Oracle HTML DB. By default, Oracle Text is installed as part of Oracle Database.

In addition, make sure that the default language preferences for Oracle Text have been installed. To install the Oracle Text default language, log into the Oracle database where you plan to install Oracle HTML DB and run the appropriate drdeflang.sql script, which by default is located in ORACLE_BASE\ORACLE_HOME\ctx\admin\defaults. For example, to run the language preferences script for US English, drdefus.sql:

c:\> sqlplus sys/SYS_password as sysdba
SQL> @c:\oracle\product\10.2.0\db_1\ctx\admin\defaults\drdefus.sql

4.1 Disk Space Requirements

The following disk space sizes reflect the sizes required by the Oracle Database 10g Companion Products only. They do not include the sizes in an existing Oracle Database installation.

Disk space requirements for Oracle Workflow middle tier components only:

• TEMP space: 90 MB

• SYSTEM_DRIVE:\Program Files\Oracle directory: 0.15 MB

• SYSTEM_DRIVE:\ORACLE_BASE\ORACLE_HOME directory: 21 MB

• Total: 111.15 MB

Disk space requirements for Oracle Workflow middle tier components and Oracle HTTP Server:

• TEMP space: 90 MB

• SYSTEM_DRIVE:\Program Files\Oracle directory: 1.11 MB

• SYSTEM_DRIVE:\ORACLE_BASE\ORACLE_HOME directory: 390 MB

• Total: 481.11 MB

Disk space requirements for Oracle HTTP Server only:

• TEMP space: 90 MB

• SYSTEM_DRIVE:\Program Files\Oracle directory: 1.1 MB

• SYSTEM_DRIVE:\ORACLE_BASE\ORACLE_HOME directory: 372 MB

• Total: 463.1 MB

4.2 Oracle Database Requirement

Your system must have access to Oracle Database release 2 (10.2) before you can install the Oracle Database 10g Products installation type.

4.3 Oracle Workflow Server Browser Requirements

Oracle Workflow server requires a Web browser that supports frames, JavaScript, Java Development Kit (JDK) Version 1.4, and AWT. The following Web browsers meet this requirement:

• Netscape Communicator 7.2 or later

• Mozilla 1.7 or later

• Microsoft Internet Explorer 6.0 or later

• Firefox 1.0.4 or later

• Safari 1.2 or later

4.4 Oracle Workflow Server Product Requirements

In addition to Oracle Database, Oracle Workflow server needs the following products in order to run:

• An unzip utility, such as WINZIP from NicoMak, to extract the Workflow HTML help from the wfdoc.zip file.

• Java Development Kit (JDK) Version 1.4, to run the Oracle Workflow Java Function Activity Agent and the Workflow XML Loader.

• An outbound SMTP mail server and an inbound IMAP mail server, if you want to send and receive e-mail notifications using an Oracle Workflow notification mailer.

5.1 Disk Space Requirements

The following disk space sizes reflect the sizes required by the Oracle Database 10g Companion Products only. They do not include the sizes in an existing Oracle Database installation.

Disk space requirements for Oracle Workflow middle tier components only:

• TEMP space: 90 MB

• SYSTEM_DRIVE:\Program Files\Oracle directory: 0.15 MB

• SYSTEM_DRIVE:\ORACLE_BASE\ORACLE_HOME directory: 21 MB

• Total: 111.15 MB

Disk space requirements for Oracle Workflow middle tier components and Oracle HTTP Server:

• TEMP space: 90 MB

• SYSTEM_DRIVE:\Program Files\Oracle directory: 1.11 MB

• SYSTEM_DRIVE:\ORACLE_BASE\ORACLE_HOME directory: 390 MB

• Total: 481.11 MB

Disk space requirements for Oracle HTTP Server only:

• TEMP space: 90 MB

• SYSTEM_DRIVE:\Program Files\Oracle directory: 1.1 MB

• SYSTEM_DRIVE:\ORACLE_BASE\ORACLE_HOME directory: 372 MB

• Total: 463.1 MB

5.2 Browser Requirements

The Oracle Database 10g Companion Products require a Web browser that supports frames, JavaScript, Java Development Kit (JDK) Version 1.4, and AWT. The following following Web browsers meet this requirement:

• Netscape Communicator 7.2 or later

• Mozilla 1.7 or later

• Microsoft Internet Explorer 6.0 or later

• Firefox 1.0.4 or later

• Safari 1.2 or later

5.3 Oracle Workflow Server Requirement

If Oracle Workflow server is not installed, follow the instructions in this guide for installing Oracle Database 10g products. After you install Oracle Workflow server, you need to configure it using Oracle Workflow Configuration Assistant.

Oracle Workflow server must be installed in an Oracle Database 10g Oracle home. You can use the Oracle Universal Installer to check the contents of an Oracle home.

5.4 Oracle HTTP Server Requirement

The Oracle Workflow middle tier components need access to Oracle HTTP Server in order to run. You can install the version of Oracle HTTP Server that is available with the Oracle Database 10g Companion Products. Alternatively, you can use an existing Oracle HTTP Server installation.

• Using the Oracle HTTP Server Provided with the Companion Products

• Using an Existing Oracle HTTP Server Installation

6.1 Recommended Preinstallation Task for Oracle HTML DB

Before you install Oracle HTML DB, back up the Oracle database that you plan to use for the installation. You can use Oracle Database Recovery Manager, which is included the Oracle Database installation, to perform the backup.

6.2 Procedure for Installing Oracle HTML DB and Oracle HTTP Server

This section explains how to install Oracle HTML DB using either of the following scenarios:

• Installing both a new Oracle HTML DB and Oracle HTTP Server: Oracle Universal Installer creates an Oracle HTTP Server home in which to install Oracle HTML DB.

• Installing Oracle HTML DB into an existing Oracle HTTP Server home: You can either install a new Oracle HTML DB or upgrade an existing HTML DB into an existing Oracle HTTP Server home.

To install Oracle HTML DB and Oracle HTTP Server:

1. Log on as a member of the Administrators group to the computer on which to install Oracle components.

   If you are installing on a Primary Domain Controller (PDC) or a Backup Domain Controller (BDC), log on as a member of the Domain Administrators group.

2. Make sure that the Oracle database that you plan to use for Oracle HTML DB is accessible and running.

   You can use the Windows Services utility, located either in the Windows Control Panel or from the Administrative Tools menu (under Start and then Programs), to check that the Oracle database service is running. In the Services listing, names of Oracle databases are preceded with OracleService. Right-click the name of the database service you want and from the drop-down menu, choose Start.

3. Delete the ORACLE_HOME environment variable (from the System Control Panel) if it exists.

   Refer to your Microsoft online help for more information about deleting environment variables.

   Note:

   The ORACLE_HOME environment variable is automatically set in the registry. Manually setting this variable prevents installation.

4. Insert the Oracle Database installation media and navigate to the companion directory. Alternatively, navigate to the directory where you downloaded or copied the installation files.

   Use the same installation media to install Oracle Database on all supported Windows platforms.

5. Double-click setup.exe to start Oracle Universal Installer.

6. In the Welcome window click Next.

7. In the Select a Product to Install window, choose Oracle HTML DB and click Next.

8. In the Select Installation Type window, select one of the following choices and then click Next.

   • Oracle HTML DB and Oracle HTTP Server: Select this option to install a new Oracle HTML DB and Oracle HTTP Server into a new Oracle home.

   • Oracle HTML DB only: Select this option to install a new Oracle HTML DB into an existing Oracle HTTP Server home, or to upgrade an existing Oracle HTML DB installation.

9. In the Specify Home Details window, enter the following:

   • Name: If you chose Oracle HTML DB and Oracle HTTP Server in the previous step, enter a new Oracle home. If you chose Oracle HTML DB only, select the name of the existing Oracle HTTP Server home that Oracle HTML DB will use.

   • Path: Enter the directory location for the Oracle home that you specified under Name. Do not enter a directory path that has spaces. After you enter a correct directory path, Oracle Universal Installer creates a new directory for you.

   See Also:

   "Identifying the Oracle Home Directory Location" for information on finding the Oracle home. Select each home and search for Apache Standalone. Oracle HTTP Server is listed as Apache Standalone in the Specify Home Details window.

10. Click Next.

11. In the Available Product Components window, select the additional components you would like to have installed as part of Oracle HTML DB, and then click Next.

12. In the Product-specific Prerequisite Checks window, check for and correct any errors that may have occurred while Oracle Universal Installer was checking your system.

13. Click Next.

14. In the Specify HTML DB Database Details window, enter the information required to configure Oracle HTML DB.

    • Hostname

      Specify the host name of the system where the database is installed. If the host name is the local host, enter the name of the computer (for example, myserver.us.mycompany.com), not localhost.

    • Port

      Specify the TCP/IP port number for the Oracle Net listener on the database system. The default port number is 1521. To find the current port number for your Oracle Database installation, check its tnsnames.ora file, which by default is located in ORACLE_BASE\ORACLE_HOME\network\admin.

    • Database Service Name

      Specify the database service name for the database where you want to install the Oracle HTML DB database objects, for example, sales. (You can find the database service names in the tnsnames.ora file.) Alternatively, you can enter the domain name, which is usually the same as the global database name, for example, sales.us.mycompany.com.

      To configure Oracle HTML DB, you must install the Oracle HTML DB database objects in an Oracle database. The database that you choose must be a release 9.2.0.3 or later database. If you plan to use the 10g release of Oracle HTTP Server, Oracle Universal Installer automatically creates a database access descriptor (DAD) in the mod_plsql configuration file and directory aliases in the Oracle HTTP Server configuration file httpd.conf, based on the information you enter during installation. However, if you plan to use a release 9i Release 2 of Oracle HTTP Server, you need to create these settings manually by using procedure described in the postinstallation steps in Chapter 4.

    • TABLESPACE Name

      Enter the name of the tablespace where you want to load the Oracle HTML DB database objects, or accept the default (SYSAUX).

    • SYS Password

      Specify the password for the SYS user in the database.

    • HTML DB Password

      Specify the password that you want to use for the Oracle HTML DB schemas (users). These schemas are created in the database during the installation.

      After the installation, you can use this password to connect to Oracle HTML DB as the administrative user. The password that you specify is also used for the HTMLDB_PUBLIC_USER schema, which is used by mod_plsql to connect to the database, and for the FLOWS_010600 and FLOWS_FILES schemas.

    • Confirm HTML DB Password

      Enter the password again to verify that you have specified it correctly.

15. Click Next.

16. In the Summary window, check the list of products that will be installed, and click Install.

17. When the installation completes, click Exit and then click Yes to exit from Oracle Universal Installer.

18. Optionally, delete the OraInstalldate_time directory if you want to remove the temporary files that were created during the installation process. The OraInstalldate_time directory holds about 45 MB of files. This directory is created in the location set by the TEMP environment variable setting.

    Restarting your computer also removes the OraInstalldate_time directory.

7.1 Identifying the Oracle Home Directory Location

Before you install Oracle Database 10g Products into an existing Oracle home, you need to identify the location of this Oracle home. If you do not know the path of the Oracle home directory, you can check it using Oracle Universal Installer.

To check the path of the Oracle home directory:

1. From the Start menu, choose Programs, then Oracle - HOME_NAME, then Oracle Installation Products, then Universal Installer.

2. When the Welcome window appears, click Installed Products.

   The Inventory window appears, listing all of the Oracle homes on the system and the products installed in each Oracle home.

3. In the Inventory window, expand each Oracle home and locate Oracle Database 10g 10.2.0.1.0.

4. Click Close and then Cancel to exit Oracle Universal Installer.

5. Have the Oracle home name available when you begin installing Oracle Database 10g Products, described next.

7.2 Procedure for Installing Oracle Database 10g Products

In brief, you first run Oracle Universal Installer to install the Oracle Database 10g Products. Afterwards, you configure Oracle Workflow server before you install the Oracle Workflow middle tier components.

To install Oracle Database 10g Products:

1. Log on as a member of the Administrators group to the computer on which to install Oracle components.

   If you are installing on a Primary Domain Controller (PDC) or a Backup Domain Controller (BDC), log on as a member of the Domain Administrators group.

2. Make sure that the Oracle database that you plan to use for Oracle Workflow is accessible and running.

   You can use the Windows Services utility, located either in the Windows Control Panel or from the Administrative Tools menu (under Start and then Programs), to check that Oracle Database is running. Names of Oracle databases are preceded with OracleService. Right-click the name of the service and from the menu, choose Start.

3. Delete the ORACLE_HOME environment variable (from the System Control Panel) if it exists.

   Refer to your Microsoft online help for more information about deleting environment variables.

   Note:

   The ORACLE_HOME environment variable is automatically set in the registry. Manually setting this variable prevents installation.

4. Insert the Oracle Database installation media and navigate to the companion directory. Alternatively, navigate to the directory where you downloaded or copied the installation files.

   Use the same installation media to install Oracle Database on all supported Windows platforms.

5. Double-click setup.exe to start Oracle Universal Installer.

6. In the Welcome window click Next.

7. In the Select a Product to Install window, choose Oracle Database 10g Products and click Next.

8. In the Specify Home Details window, do the following:

   1. Name: Verify that the Oracle home specified is the Oracle Database Oracle home. (The default Oracle home is offered.)

   2. Path: Enter the directory location of the Oracle Database Oracle home where you want to install the Oracle home files. (The directory of the default Oracle home is offered.)Do not enter a directory path that has spaces. After you enter a correct directory path, Oracle Universal Installer creates a new directory for you.

      See also:

      "Identifying the Oracle Home Directory Location" for information on finding the correct Oracle home

9. Click Next.

10. In the Product-specific Prerequisite Checks window, check for and correct any errors that may have occurred when Oracle Universal Installer checked your system.

11. Click Next.

12. In the Summary window, check the list of products that will be installed, and click Install.

13. When the installation completes, click Exit and then click Yes to exit from Oracle Universal Installer.

14. Optionally, delete the OraInstalldate_time directory if you want to remove the temporary files that were created during the installation process. The OraInstalldate_time directory holds about 45 MB of files. This directory is created in the location set by the TEMP environment variable setting.

    Restarting your computer also removes the OraInstalldate_time directory.

15. Restart Oracle HTTP Server. For example:

    ORACLE_BASE\ORACLE_HOME\opmn\bin\opmnctl restartproc ias-component=HTTP_Server
    

7.3 Preparing Oracle Workflow Server for the Oracle Workflow Middle Tier Installation

After you have installed Oracle Workflow server, you need to configure it before you install the Oracle Workflow middle tier components. You use Oracle Workflow Configuration Assistant to configure Oracle Workflow.

To prepare Oracle Workflow server for the Oracle Workflow middle tier components:

1. Make sure that the Oracle database that you plan to use for Oracle Workflow is accessible and running.

   You can use the Windows Services utility, located either in the Windows Control Panel or from the Administrative Tools menu (under Start and then Programs), to check that Oracle Database is running. Names of Oracle databases are preceded with OracleService. Right-click the name of the service and from the menu, choose Start.

2. From the Start menu, choose Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools, then Workflow Configuration Assistant.

3. In the Welcome to Oracle Workflow Configuration Assistant window, enter the following information:

   • Install Option - Select either Server Only or Add Language.

     If you choose the Server Only option, Workflow Configuration Assistant installs Oracle Workflow into the Oracle database.

     Note:

     To upgrade to Oracle Workflow release 2.6.4, make sure that the existing Oracle Workflow server is release 2.6.2 or higher.

     If you chose the Add Language installation option, select the language abbreviation for the language that you want to add. You must install Oracle Workflow before you can add a language. Oracle Database Globalization Support Guide provides a list of language abbreviations used by Oracle Database.

   • Workflow Account - Enter the name that you want to use for the Oracle Workflow database account or accept the default name, typically owf_mgr.

     The default tablespace for this account is USERS and the temporary tablespace is TEMP. You can change the tablespace if necessary.

     Note:

     If you are upgrading an existing installation of Oracle Workflow, enter the name and password for the existing Oracle Workflow database account.

   • Workflow Password - Enter a password for the Oracle Workflow account.

   • SYS Password - Enter the password for the SYS account of the Oracle Database installation on the system. The password is mandatory for Oracle Workflow Server installations but not if you are adding a language.

   • TNS Connect Descriptor - The database connect string in TNS format:

     (DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =
     host_name)(PORT = port_number))) (CONNECT_DATA = (SERVICE_NAME =
     database_service_name)))
     
     

     The connect string is stored in the tnsnames.ora file, which in a default installation is located in ORACLE_BASE\ORACLE_HOME\network\admin. An easy way to find the connect string in a single-line format is to run the tnsping command at a command prompt, output the results into a text file, and then copy and paste the connect string into the TNS Connect Descriptor box. For example, to get the connect string for a server named mau, you could enter:

     c:\> tnsping mau > tns.txt
     
     

4. If you want to integrate Oracle Internet Directory as the directory repository for Oracle Workflow, select the Enter LDAP Parameters check box and then select Get LDAP Values to display the Workflow LDAP Parameters window.

   Note:

   If you are upgrading an existing Oracle Workflow installation in which you already implemented Oracle Internet Directory integration, you must re-enter the Lightweight Directory Access Protocol (LDAP) values here to preserve the Oracle Internet Directory integration during the upgrade.

   Enter the following LDAP server information for the LDAP directory to which you want to connect and click OK. After the installation, you can update these values if necessary in the Global Workflow preferences Web page.

   See Also:

   "Setting Up Oracle Workflow" section in Oracle Workflow Administrator's Guide for more information

   • LDAP Host Name - Enter the host on which the Lightweight Directory Access Protocol (LDAP) directory is installed.

   • LDAP Non-SSL Port - Enter the port number that the host uses. This port must not be a Secure Sockets Layer (SSL) port.

   • LDAP Admin Username- Enter the username used to connect to the LDAP server. This username must have write privileges and is required to bind to the LDAP directory. For example:

     cn=orcladmin
     
     

   • LDAP Admin Password - Enter the Oracle Internet Directory password for the LDAP user account. LDAP password values are masked as asterisks in the display and are stored in encrypted form.

   • Changelog DN - Enter the LDAP node where change log files are located. For example:

     cn=changelog
     
     

   • User Base - Enter the LDAP node under which user records can be found. For example:

     cn=Base, cn=OracleSchemaVersion
     
     

     Note:

     After setting up integration with Oracle Internet Directory during installation, you must use the WF_LDAP APIs to synchronize the Oracle Workflow directory service with Oracle Internet Directory. For instructions, see Oracle Workflow Administrator's Guide.

5. If you do not want to integrate with Oracle Internet Directory, leave the Enter LDAP Parameters check box blank.

6. To enter configuration parameters for the seeded Java-based notification mailer service component Workflow Notification Mailer, select the Enter Mailer Parameters check box and then select Get Mailer Values to display the Workflow Mailer Parameters. Enter values for the following parameters and then click OK.

   • Inbound EMail Account: Server Name:

     • Server Name - Enter the name of the inbound IMAP mail server.

     • Username - Enter the username of the mail account where the notification mailer receives e-mail messages.

     • Password - Enter the password of the mail account specified in the Username parameter.

   • Outbound EMmail Account - Enter the name of the outbound SMTP mail server.

   • EMail Processing:

     • Processed Folder - Enter the name of the mail folder in the inbound e-mail account where the notification mailer places successfully processed notification messages.

     • Discard Folder - Enter the name of the mail folder in the inbound e-mail account where the notification mailer places incoming messages that are not recognized as notification messages.

   • Message Generation: HTML Agent:

     • HTML Agent - The HTML Agent is the base URL that identifies the Web agent defined for Oracle Workflow in Oracle HTTP Server. The notification mailer uses this URL to support e-mail notifications with HTML attachments. By default, this parameter is set to the following placeholder value:

       http://localhost.com/pls/wf 
       
       

       If you have already installed Oracle HTTP Server, replace localhost.com with the server and TCP/IP port number on which the Web listener accepts requests. Otherwise, leave this parameter set to the placeholder value. In this case you must set this parameter in the notification mailer configuration wizard in Oracle Workflow Manager after you complete the Oracle HTTP Server and Oracle Workflow installations.

       See Also:

       "Setting Up Oracle Workflow" in Oracle Workflow Administrator's Guide

     • Reply-to Address - Enter the address of the e-mail account that receives incoming messages, to which notification responses should be sent.

   After the initial installation, you can update the notification mailer configuration values if necessary in the Oracle Workflow Manager. You can also update the HTML agent value for Oracle Workflow in the Global Workflow preferences Web page.

   See Also:

   "Setting Up Oracle Workflow" in Oracle Workflow Administrator's Guide and Oracle Workflow Manager online help for more information

7. To change the tablespace assigned to the Oracle Workflow database account, select the Change Tablespace check box, then select an existing tablespace from the list of values.

8. Choose Submit to begin the configuration or choose Quit to exit Workflow Configuration Assistant without performing the configuration.

9. When the configuration is complete, a confirmation window appears. Click OK.

   You can check the status of the configuration by reviewing the ORACLE_BASE\ORACLE_HOME\wf\install\workflow.log file.