3 Installing the Oracle Database Companion CD Software

3.1 General Steps for Installing Companion CD Products

After completing the tasks in Chapter 1 and Chapter 2, follow these general steps to install the Companion CD products:

1. Consider the following issues:

   • Installing in interactive or noninteractive mode: The instructions in this chapter are written for interactive installations. If you prefer to perform the installation in noninteractive mode (for example, if your site requires multiple installations) refer to "Installing Oracle Components in Noninteractive Mode" for more information.

   • Installing in a Different Language: Refer to "Installing and Using Oracle Components in Different Languages" for language considerations.

2. Follow the procedures described in "Accessing the Installation Software" if you want to install the software from a hard drive or install remotely. If you are copying or directly installing from the installation media, then refer to the instructions in the "Mounting Discs" section.

3. Depending on the products that you want to install, follow the procedures described in the following sections to complete the installation:

   • Installing Oracle HTML DB

     You must install Oracle HTML DB in an Oracle HTTP Server home. If there is no existing Oracle HTTP Server installation, then you can install Oracle HTML DB with Oracle HTTP Server.

   • Installing Oracle Database 10g Products

     If you plan to use Oracle Workflow Server, which is one of the Oracle Database 10g Products, then you must complete the steps in "Preparing Oracle Workflow Server for the Oracle Workflow Middle Tier Installation" before installing the Oracle Workflow middle-tier components. The Oracle Workflow middle-tier components are available with the Oracle Database 10g Companion Products.

   • Installing Oracle Database 10g Companion Products

     This section explains how to install Oracle Workflow middle-tier components.

3.2 Accessing the Installation Software

The Oracle Database Companion CD software is available on the installation media, or you can download it from the Oracle Technology Network Web site.

When you are ready to install the software, you can access it by any one of the following methods:

• Download the software to the hard disk

• Copy the software from the installation media to the hard disk

• Access the software by using a remote drive

• Install on a remote computer by using remote access software

3.3 Mounting Discs

On most UNIX-based systems, the disc mounts automatically when you insert it into the disc drive. If the disc does not mount automatically, then perform the procedure described in this section.

To mount a disc:

1. Switch user to root:

   $ su - root
   
   

2. If required, enter a command similar to the following to unmount the currently mounted disc, then remove it from the drive:

   # /usr/sbin/umount /SD_DVD
   
   

   In this example, /SD_DVD is the mount point directory for the disc drive.

3. Insert the disc into the disc drive, and then enter a command similar to the following to mount it:

   # /usr/sbin/mount -F cdfs -o rr /dev/dsk/cxtydz /SD_DVD
   
   

   In this example, /dev/dsk/cxtydz is the device name of the disc drive and /SD_DVD is the mount point directory.

4. If Oracle Universal Installer displays the Disk Location screen, then enter the disc mount point directory path.

To continue, refer to one of the following sections:

• Installing Oracle HTML DB

• Installing Oracle Database 10g Products

• Installing Oracle Database 10g Companion Products

3.4 Installing Oracle HTML DB

This section explains how to install Oracle HTML DB by using one of the following options:

• Installing Oracle HTML DB with Oracle HTTP Server: If you select this option, then Oracle HTML DB is installed with Oracle HTTP Server in a new Oracle home.

• Installing or upgrading Oracle HTML DB in an existing Oracle HTTP Server home: If you select this option, then depending on the preinstallation conditions, either Oracle HTML DB is installed or the existing Oracle HTML DB installation is upgraded.

To install Oracle HTML DB:

1. If you are installing from the installation media, then mount the disc if it is not already mounted.

2. If required, log in as the Oracle software owner user (oracle) and set the DISPLAY environment variable.

3. Verify that the Oracle Database that you plan to use for Oracle HTML DB is accessible and running.

4. To start Oracle Universal Installer, enter the following commands:

   $ cd /tmp
   $ /directory_path/runInstaller
   
   

   In the preceding command, directory_path is the path of the companion directory on the installation media or the hard drive.

5. On the Welcome screen, click Next.

6. If this is the first installation of Oracle products on this system, then Oracle Universal Installer displays the Specify Inventory Directory and Credentials screen. Specify the following information, and then click Next:

   • Enter the full path of the inventory directory:

     Verify that the path is similar to the following, where oracle_base is the value you specified for the ORACLE_BASE environment variable:

     oracle_base/oraInventory
     
     

   • Specify operating system group name:

     Verify that the group specified is the Oracle Inventory group, oinstall.

7. On the Select a Product to Install screen, select Oracle HTML DB and then click Next.

8. On the Select Installation Type screen, select one of the following and then click Next.

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

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

9. On the Specify Home Details screen, enter the following:

   • Name: If you select Oracle HTML DB and Oracle HTTP Server in the previous step, then specify the name for a new Oracle home. If you select Oracle HTML DB only, then select the name of the existing Oracle HTTP Server home. If you select Oracle HTML DB only and if there is an existing Oracle HTML DB installation, then specify the name of the Oracle home of this existing installation.

   • Path: Enter the directory location for the Oracle home that you specified under Name. If the directory does not exist, then Oracle Universal Installer creates it for you.

   See Also:

   "Oracle Database Requirement" for information about finding the Oracle home. Select each home and search for Apache Standalone. Oracle HTTP Server is listed as Apache Standalone on the Specify Home Details screen

10. Click Next.

11. On the Product-specific Prerequisite Checks screen, check for and correct any errors that may have occurred while Oracle Universal Installer was checking your system. Then, click Next.

    When you click Next, a warning message may be displayed. If there is an existing Oracle HTML DB installation, then this message informs you that the database access descriptors (DADs) associated with this installation have insufficient or incorrect values for some of the required directives. This makes them unsuitable for upgrade. If you want to upgrade Oracle HTML DB under these conditions, then you must first fix the problem. If you want to install Oracle HTML DB, then continue with this installation session.

    Click OK to continue.

12. The screen displayed for this installation step depends on whether Oracle HTML DB is to be installed or the existing Oracle HTML DB installation is to be upgraded:

    • Installing Oracle HTML DB

      On the Specify HTML DB Database Details screen, enter the information required to configure Oracle HTML DB.

      Host Name

      Specify the host name of the system where the database is installed. If the host name is the local host, then enter the name of the computer, 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 default port number for your Oracle Database installation, check its tnsnames.ora file, which by default is located in the $ORACLE_HOME/network/admin directory.

      Database Service Name

      Specify the database service name for the database in which you want to install the Oracle HTML DB database objects, for example, sales. 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 a release 9.2.0.3 or later Oracle Database. If you plan to use the 10g release of Oracle HTTP Server, then based on the information that you specify during installation, Oracle Universal Installer automatically creates a database access descriptor (DAD) in the mod_plsql configuration file and directory aliases in httpd.conf, the Oracle HTTP Server configuration file. However, if you plan to use an Oracle9i HTTP Server release 2 installation, then you must create these settings manually by using the postinstallation steps described 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), which 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.

    • Upgrading an existing Oracle HTML DB installation

      On the Specify HTML DB Upgrade Information screen, select the Oracle HTML DB installation that you want to upgrade from the list of available DADs.

      When you specify the Oracle HTML DB installation that you want to upgrade, the host name, port, and database service name values are automatically displayed in their respective fields. You cannot change these values. The remaining fields are the same as those displayed on the Specify HTML DB Database Details screen.

13. Click Next.

14. On the Summary screen, check the list of products that will be installed, and then click Install.

15. If prompted, run the following scripts in a separate terminal window as the root user:

    oracle_base/oraInventory/orainstRoot.sh
    oracle_home/root.sh
    
    

    Then, click OK.

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

    See Also:

    • Chapter 4 for information about tasks that you must complete after you have installed the software

    • "Installing and Configuring Oracle HTML DB on a Remote Oracle Database" if you want to install additional Oracle HTML DB instances in a remote Oracle Database

17. Follow the instructions in "Starting, Stopping, and Restarting Oracle HTTP Server" to start Oracle HTTP Server.

3.5 Installing Oracle Database 10g Products

You must install Oracle Database 10g Products in an existing Oracle Database 10g release 2 (10.2) Oracle home.

To install Oracle Database 10g Products, you first run Oracle Universal Installer. You then configure Oracle Workflow Server before you install the Oracle Workflow middle-tier components.

To install Oracle Database 10g Products:

1. If you are installing from the installation media, then mount the disc if it is not already mounted.

2. If required, log in as the Oracle software owner user (oracle) and set the DISPLAY environment variable.

3. Verify that the Oracle Database that you plan to use for Oracle HTML DB is accessible and running.

4. To start Oracle Universal Installer, enter the following commands:

   $ cd /tmp
   $ /directory_path/runInstaller
   
   

   In the preceding command, directory_path is the path of the companion directory on the installation media or the hard drive.

5. On the Welcome screen, click Next.

6. If this is the first installation of Oracle products on this system, then Oracle Universal Installer displays the Specify Inventory Directory and Credentials screen. Specify the following information, and then click Next:

   • Enter the full path of the inventory directory:

     Verify that the path is similar to the following, where oracle_base is the value you specified for the ORACLE_BASE environment variable:

     oracle_base/oraInventory
     
     

   • Specify operating system group name:

     Verify that the group specified is the Oracle Inventory group, oinstall.

7. On the Select a Product to Install screen, select Oracle Database 10g Products and then click Next.

8. On the Specify Home Details screen, enter the following:

   • Name: In this field, the default Oracle home is displayed. Verify that the Oracle home specified is the Oracle Database Oracle home.

   • Path: In this field, the directory of the default Oracle home is displayed. Enter the directory location of the Oracle Database Oracle home in which you want to install the Oracle home files.

   See Also:

   "Oracle Database Requirement" for information about finding the Oracle home

   If Oracle Real Application Clusters (RAC) is installed in the Oracle home that you select, then Oracle Universal Installer displays the Selected Nodes screen. Click Next to continue.

   Note:

   On a RAC installation, the software is installed on all the cluster nodes.

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

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

11. Follow the instructions in "Starting, Stopping, and Restarting Oracle HTTP Server" to start Oracle HTTP Server.

Preparing Oracle Workflow Server for the Oracle Workflow Middle Tier Installation

After you install Oracle Workflow Server, you must configure it before you install the Oracle Workflow middle-tier components. You can use Oracle Workflow Configuration Assistant to configure Oracle Workflow. The following steps explain how to run Oracle Workflow Configuration Assistant by using its graphical user interface (GUI):

1. Ensure that the Oracle Database that you plan to use for Oracle Workflow is accessible and running.

2. To start Oracle Workflow Configuration Assistant, enter the following command:

   $ORACLE_HOME/wf/install/wfinstall.csh
   
   

3. On the Welcome to Oracle Workflow Configuration Assistant screen, specify the following:

   • Install Option: Select the Server Only or Add Language installation option.

     If you select the Server Only option, then Oracle Workflow Configuration Assistant installs Oracle Workflow into the Oracle Database.

     Note:

     To upgrade to Oracle Workflow release 2.6.4, ensure that the existing Oracle Workflow Server is release 2.6.2 or later.

     If you chose the Add Language installation option, then select the language abbreviation for the language that you want to add. You must install Oracle Workflow before you can add a language.

     See Also:

     Oracle Database Globalization Support Guide for 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, which is typically owf_mgr.

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

     Note:

     If you are upgrading an existing installation of Oracle Workflow, then 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.

   • TNS Connect Descriptor: Specify the database connection string, in TNS format:

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

     The connection string is stored in the tnsnames.ora file, which by default is located in the $ORACLE_HOME/network/admin directory.

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

   Note:

   If you are upgrading an existing Oracle Workflow installation in which you have already implemented Oracle Internet Directory integration, then you must reenter 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 then click OK. After the installation, you can update these values, if required, on the Global Workflow preferences Web page.

   See Also:

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

   • LDAP Host Name: Enter the name of the host on which the 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 user name used to connect to the LDAP server. This user name 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, refer to Oracle Workflow Administrator's Guide.

5. To enter configuration parameters for the seeded Java-based notification mailer service component Workflow Notification Mailer, select Enter Mailer Parameters and select Get Mailer Values.

   Enter values for the following parameters, and then click OK.

   • Inbound Email Account: Server Name: Enter the name of the inbound IMAP mail server.

   • Inbound Email Account: Username: Enter the user name of the mail account where the notification mailer receives e-mail messages.

   • Inbound Email Account: Password: Enter the password of the mail account specified in the Username field.

   • Outbound Email Account: Server Name: 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.

   • Email Processing: 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: Enter 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, then 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 install Oracle HTTP Server and Oracle Workflow.

     See Also:

     Chapter 2, "Setting Up Oracle Workflow" in Oracle Workflow Administrator's Guide

   • Message Generation: 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, if required, update the notification mailer configuration values in the Oracle Workflow Manager. You can also update the HTML agent value for Oracle Workflow on the Global Workflow preferences Web page.

   See Also:

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

6. To change the tablespace assigned to the Oracle Workflow database account, first select Change Tablespace and then select an existing tablespace from the list of values.

7. Select Submit to begin the configuration.

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

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

3.6 Installing Oracle Database 10g Companion Products

The Oracle Database 10g Companion Products are:

• Oracle HTTP Server

• Oracle Workflow middle-tier components

  Note:

  You can install the Oracle Workflow middle-tier components into either a new Oracle home or an existing Oracle HTTP Server home. Ensure that you have first installed Oracle Workflow Server from the Oracle Database 10g Products installation type and run Workflow Configuration Assistant to configure Oracle Workflow.

To install Oracle Database 10g Companion Products in a new Oracle home:

1. If you are installing from the installation media, then mount the disc if it is not already mounted.

2. If required, log in as the Oracle software owner user (oracle) and set the DISPLAY environment variable.

3. To start Oracle Universal Installer, enter the following commands:

   $ cd /tmp
   $ /directory_path/runInstaller
   
   

   In the preceding command, directory_path is the path of the companion directory on the installation media or the hard drive.

4. On the Welcome screen, click Next.

5. If this is the first installation of Oracle products on this system, then Oracle Universal Installer displays the Specify Inventory Directory and Credentials screen. Specify the following information, and then click Next:

   • Enter the full path of the inventory directory:

     Verify that the path is similar to the following, where oracle_base is the value you specified for the ORACLE_BASE environment variable:

     oracle_base/oraInventory
     
     

   • Specify operating system group name:

     Verify that the group specified is the Oracle Inventory group, oinstall.

6. On the Select a Product to Install screen, select Oracle Database 10g Companion Products and then click Next.

7. On the Specify Home Details screen, enter the following:

   • Name: Enter a name for the Oracle home. You can install the Oracle Database 10g Companion Products in a new Oracle home. Alternatively, you can install Oracle Workflow middle tier only in an existing Oracle HTTP Server Oracle home. You cannot install the Oracle Database 10g Companion Products in an existing Oracle Database home.

   • Path: Enter the directory location for the Oracle home. If the directory does not exist, then Oracle Universal Installer creates it for you.

8. On the Available Product Components screen, select one of the following products:

   • Apache Standalone

   • Oracle Workflow Middle Tier

   Note:

   The Apache Standalone option installs Oracle HTTP Server. If you are installing Oracle Workflow middle tier in a new Oracle home, then you must select the Apache Standalone option.

9. On the Product-Specific Prerequisite Checks screen, check for and correct any errors that may have occurred while Oracle Universal Installer was checking your system.

   If you are installing Oracle Workflow middle tier only in an existing Oracle HTTP Server Oracle home, then you may need to manually verify that the selected Oracle home exists. Then, click Next.

10. On the Oracle Workflow Middle Tier Configuration screen, specify the configuration settings needed for the Oracle Workflow middle tier.

    To configure the Oracle Workflow middle tier, you must create a database access descriptor (DAD) in the mod_plsql configuration files and directory aliases in the Oracle HTTP Server configuration file. Oracle Universal Installer completes these tasks for you using the information that you specify. Enter the following information:

    • Workflow Schema

      Specify the user (schema) name that you used when installing the Oracle Workflow Server database objects in the database. The default user name is owf_mgr.

    • DB Hostname

      Specify the host name of the system on which the database is installed. If the host name is the local host, then enter the name of the computer, not localhost.

    • Port Number

      Specify the TCP/IP port number for the Oracle Net listener on the database system. The default port number is 1521.

    • Oracle SID

      Specify the database instance identifier (SID) for the database on which you installed the Oracle Workflow Server database objects.

11. On the Oracle Workflow Middle Tier Configuration screen, enter a password for the Oracle Workflow schema that you created in the previous step. Then, click Next.

12. On the Oracle Apache Installation screen, enter the following information and then click Next.

    • Enter Password

      Specify the password for the Workflow user (typically, owf_mgr) that you specified on the previous screen. This password is used for the mod_plsql DAD.

    • Confirm Password

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

13. On the Summary screen, check the list of products that will be installed, and then click Install.

14. If prompted, run the following scripts in a new terminal window as the root user:

    oracle_base/oraInventory/orainstRoot.sh
    oracle_home/root.sh
    
    

    Then, click OK.

15. On the End of Installation screen, make a note of the URLs used by Oracle HTTP Server.

    Note:

    These URLs are also listed in the following file:

    $ORACLE_HOME/Apache/Apache/setupinfo.txt
    

16. Click Exit, and then click Yes to exit from Oracle Universal Installer.

17. Follow the instructions in "Starting, Stopping, and Restarting Oracle HTTP Server" to start Oracle HTTP Server.