Oracle® Database

1 Reviewing Information About This Guide

This guide describes the installation procedure for the following installation types:

• Oracle HTML DB Installation Type

  This installation type includes the following products:

  • Oracle HTTP Server

  • Oracle HTML DB

• Oracle Database 10g Products Installation Type

  This installation type includes the following products:

  • Oracle JDBC Development Drivers

  • Oracle SQLJ

  • Oracle Database Examples

  • Oracle Text Supplied Knowledge Bases

  • Oracle Workflow Server

  • Oracle Ultra Search

  • JPublisher

• Oracle Database 10g Companion Products Installation Type

  This installation type includes the following products:

  • Oracle Workflow middle-tier components

  • Oracle HTTP Server

Tasks Not Described in this Guide

This guide does not provide information about the following:

• Some of the instructions for verifying that the installation requirements are met

• Postinstallation tasks to be performed before using the Companion CD products

• Instructions for using the Companion CD products

Where to Get Additional Installation Information

For more detailed information about installing Oracle Database 10g Companion CD products, including information about the tasks not described in this guide, refer to Oracle Database Companion CD Installation Guide for Linux x86.

This guide is available on the installation media. To access it, use a Web browser to open the welcome.htm file, which is in the companion directory on the installation media. On the Welcome page, select the Documentation tab.

2 Requirements for Installing Companion CD Products

The following sections describe the requirements for installing Companion CD products:

• Hardware and Software Certification

• General Requirements for Installing Oracle Software

• Requirements for Installing Oracle HTTP Server from the Oracle HTML DB Installation Type

• Requirements for Installing Oracle HTML DB from the Oracle HTML DB Installation Type

• Requirements for Installing Oracle Database 10g Products

• Requirements for Installing Oracle Database 10g Companion Products

make-3.79.1
gcc-3.2.3-34
glibc-2.3.2-95.20
compat-db-4.0.14-5
compat-gcc-7.3-2.96.128
compat-gcc-c++-7.3-2.96.128
compat-libstdc++-7.3-2.96.128
compat-libstdc++-devel-7.3-2.96.128
openmotif21-2.1.30-8
setarch-1.3-1

binutils-2.15.92.0.2-13.EL4
compat-db-4.1.25-9
compat-libstdc++-296-2.96-132.7.2
control-center-2.8.0-12
gcc-3.4.3-22.1.EL4
gcc-c++-3.4.3-22.1.EL44
glibc-2.3.4-2.9
glibc-common-2.3.4-2.9
gnome-libs-1.4.1.2.90-44.1
libstdc++-3.4.3-22.1
libstdc++-devel-3.4.3-22.1
make-3.80-5
pdksh-5.2.14-30
sysstat-5.0.5-1
xscreensaver-4.18-5.rhel4.2
setarch-1.6-1

binutils-2.15.90.0.1.1-32.5
gcc-3.3.3-43.24
gcc-c++-3.3.3-43.24
glibc-2.3.3-98.28
gnome-libs-1.4.1.7-671.1
libstdc++-3.3.3-43.24
libstdc++-devel-3.3.3-43.24
make-3.80-184.1
pdksh-5.2.14-780.1
sysstat-5.0.1-35.1
xscreensaver-4.16-2.6

3 Beginning the Procedure for Installing Companion CD Products

This section provides screen-wise instructions for installing each of the 3 installation types. Most of the Oracle Universal Installer screens are the same for all 3 installation types. However, before you install Oracle Workflow middle-tier components, you must first install and prepare Oracle Workflow Server.

If you want to install Oracle HTML DB or Oracle Database 10g Products, then refer to "Beginning the Installation".

If you have already installed Oracle Workflow Server and you want to install Oracle Workflow middle-tier components, then first perform the following procedure.

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 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, run 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, 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 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 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 Lightweight Directory Access Protocol (LDAP) directory isFT 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. If you do not want to integrate with Oracle Internet Directory, then do not select Enter LDAP Parameters.

6. 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 parameter.

   • 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: 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, 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.

   • 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 update the notification mailer configuration values, if required, 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: The "Setting Up Oracle Workflow" section 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, first select Change Tablespace and then select an existing tablespace from the list of values.

8. Select Submit to begin the configuration, or select Quit to exit Oracle 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_HOME/wf/install/workflow.log file.

Beginning the Installation

To begin installing Companion CD 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. If you are going to install Oracle HTML DB, then 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
     
     

The following section provides instructions specific to each installation type.

4 Specifying Product-Specific Information During the Installation

To continue, select the installation type that you want to use:

• Oracle HTML DB Installation Type

• Oracle Database 10g Products Installation Type

• Oracle Database 10g Companion Products Installation Type

Oracle HTML DB Installation Type

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

• Installing Oracle HTML DB with Oracle HTTP Server: In this case, Oracle Universal Installer creates an Oracle HTTP Server home in which to install Oracle HTML DB.

• Installing or upgrading Oracle HTML DB in an existing Oracle HTTP Server home: In this case, you have the option of either installing a new Oracle HTML DB, or upgrading an earlier release of existing HTML DB, in an existing Oracle HTTP Server home.

To continue with the procedure for installing Oracle HTML DB products:

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

2. 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 a new Oracle HTML DB and 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.

3. 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.

4. Click Next.

5. 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. Click Next.

   When you click Next, a warning message may be displayed if there is no Oracle HTML DB installation on this system or if the values of the DADs associated with the detected Oracle HTML DB installations are insufficient or incorrect. The message specifies that if you want to proceed with an upgrade, then you first must fix the problems in the DADs.

   Click OK to continue.

6. 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.

     Hostname

     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 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, then 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, based on the information that you enter during installation.

     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.

7. Click Next.

8. To continue, refer to "Completing the Installation".

Oracle Database 10g Products Installation Type

To continue with the procedure for installing Oracle Database 10g Products:

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

2. 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. If the directory does not exist, then Oracle Universal Installer creates it for you.

3. 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.

4. To continue, refer to "Completing the Installation".

Oracle Database 10g Companion Products Installation Type

To continue with the procedure for installing Oracle Database 10g Companion products:

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

2. 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, or 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.

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

   • Apache Standalone: This option installs Oracle HTTP Server.

   • Oracle Workflow Middle Tier

   
   

   Note: If you are installing Oracle Workflow middle tier in a new Oracle home, then you must select Oracle HTTP Server.

   
   

4. 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 the prerequisite check to confirm the selected Oracle home. Then, click Next.

5. On the 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 name (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 where 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 where you installed the Oracle Workflow server database objects.

6. On the Oracle Workflow Middle Tier Configuration screen, enter a password for the Oracle Workflow schema you created in the previous step, and then click Next.

7. On the Oracle Apache Installation screen, enter the following information, which is required to configure Oracle Workflow middle tier 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 database access descriptor.

   • Confirm Password

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

8. To continue, refer to "Completing the Installation".

5 Completing the Installation

This section provides instructions for Oracle Universal Installer screens that are common to all installation types. To complete the installation:

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

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

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

   After the script runs, click OK.

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

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

6 What to Do Next?

After you install the Companion CD products, complete the following steps:

• Follow the instructions in the "Starting, Stopping, and Restarting Oracle HTTP Server" section of Oracle Database Companion CD Installation Guide for Linux x86 to start Oracle HTTP Server.

• Use a Web browser to access the Oracle HTTP Server home page, using the URL displayed at the end of the installation. The default URL is similar to the following:

  http://host.domain:7777/
  
  

• Use a Web browser to access the Oracle HTML DB administration page:

  http://host.domain:7777/pls/htmldb/htmldb_admin
  
  

  Log in to Oracle HTML DB by using the user name ADMIN and the password that you specified during the installation.

• Refer to the online Help and Oracle HTML DB User's Guide to learn about using, developing applications with, and administering Oracle HTML DB.

• Refer to Chapter 5, "Oracle Database Companion CD Postinstallation Tasks" of Oracle Database Client Installation Guide for Linux x86 for information about other postinstallation steps.

7 Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at

http://www.oracle.com/accessibility/

Accessibility of Code Examples in Documentation

Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

TTY Access to Oracle Support Services

Oracle provides dedicated Text Telephone (TTY) access to Oracle Support Services within the United States of America 24 hours a day, seven days a week. For TTY support, call 800.446.2398.