Oracle® Database

1 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. 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 additional information, visit the Oracle Accessibility Program Web site at

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

Accessibility of Code Examples in Documentation

JAWS, a Windows screen reader, 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, JAWS 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.

2 Review Information About this Guide

This guide describes how to complete a default installation of the Oracle Database 10g Products and the Oracle Database 10g Companion Products.

You will install the Oracle Database 10g Products into the same Oracle home where Oracle Database 10g is installed. The Oracle Database 10g Products include:

• Oracle Database Examples: A rich set of examples and product demonstrations that you can use to learn about the products, options, and features of Oracle Database 10g. Many of these examples are designed to work with the Sample Schemas which you can optionally install in any Oracle Database 10g database. Many of the documents in the Oracle product-specific documentation library use the example programs and scripts provided with the Oracle Database Examples.

• JPublisher: A Java utility that generates Java classes to represent the following user-defined database entities a the Java program:

  • SQL object types

  • Object reference types (REF types)

  • SQL collection types (VARRAY types or nested table types)

  • PL/SQL packages

  • Server-side Java classes

  • SQL queries and DML statements

• Legato Single Server Version (LSSV): A backup and recovery application developed by Legato Systems, Inc. LSSV is a subset of Legato NetWorker and Legato NetWorker Module for Oracle products. You can use it to back up and restore Oracle data on a single server only. It enables you to perform online or offline backups of Oracle data stored on file systems, Automatic Storage Manager disk groups, or raw devices.

• Natively Compiled Java Libraries: JAccelerator and Oracle interMedia Image Accelerator, which contain the natively compiled Java libraries (NCOMPs) for Oracle JVM and Oracle interMedia. These libraries are required to improve the performance of these products on your platform.

• Oracle Text Supplied Knowledge Bases: Two Oracle Text knowledge bases, English and French. You can extend the supplied knowledge bases depending on your requirements. Alternatively, you can create your own knowledge bases, in languages other than English and French.

Oracle Database 10g Companion Products include:

• Oracle HTTP Server: A Web server that is based on Apache HTTP Server. You must install Oracle HTTP Server in a new Oracle home.

• Oracle HTML DB: A hosted development environment that enables non-programmers to create database-centric Web applications. It provides developers with the productivity of a desktop database, but with the security, reliability, and performance of the Oracle database. Any IT organization can host Oracle HTML DB environments for departments in the company that do not have Oracle development skills available.

  You must install Oracle HTML DB in an Oracle HTTP Server Oracle home. This can be an existing Oracle HTTP Server Oracle home, or you can choose to install Oracle HTTP Server when you install either or both of these products.

This guide does not describe how to complete the following tasks:

• Installing Oracle Database 10g Companion Products into an existing Oracle home that contains Oracle HTTP Server

• Migration issues

• Removing Oracle software

• Post-installation tasks

For more detailed information about the Oracle Database 10g Companion CD products, including information about the tasks not described in this guide, see the Oracle Database Companion CD Installation Guide.

This guide is available on the product disc. To access it, use a Web browser to open the welcome.htm file, either in the top-level directory of the CD-ROM or in the companion directory of the DVD-ROM, then select the Documentation tab.

3 Log In to the System with Administrator Privileges

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.

4 Requirements for Oracle Database 10g Products

You install the Oracle Database 10g Products into an existing Oracle Database 10g home. If you want to install the Oracle Database 10g Companion Products into an existing Oracle home, see the Oracle Database Companion Installation Guide for Windows.

1. Choose Start > Programs > Oracle - HOME_NAME > Oracle Installation Products > Universal Installer.

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

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

3. In the Inventory screen, expand each Oracle home and locate Oracle Database 10g 10.1.0.2.0.

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

5. Have the Oracle home name available for the Oracle Database 10g Products.

Make sure that the file system that the Oracle home directory has at least 100 MB of available disk space on the system drive and 530 MB in the Oracle home drive.

5 Requirements for Installing Oracle Database 10g Companion Products

This section describes the requirements for installing Oracle Database 10g Companion Products into a new Oracle Home.

6 Install Oracle Database 10g Products

To install Oracle Database 10g Products in an existing Oracle Database 10g release 1 (10.1) Oracle home, follow these steps:

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. Delete the ORACLE_HOME environment variable 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.

3. Insert the CD-ROM labeled Oracle Database Companion CD 10g Release 1 (10.1) Disk 1 of 1 or navigate to the Oracle Database Companion CD location on the Oracle Database 10g release 1 (10.1) DVD-ROM.

   When installing from a hard disk, double-click setup.exe.

   When installing from the installation media, the Autorun screen automatically appears. If the Autorun screen does not appear, then:

   1. Click Start > Run.

   2. Enter the following:

      DRIVE_LETTER:\autorun\autorun.exe
      
      

      The Welcome screen appears.

      
      

      Note: If you need additional information about a screen, click Help.

4. On the Welcome screen click Next.

5. On the Specify File Locations screen, do the following:

   1. Under Source, leave the path to the file that represents the products you want to install at the default setting.

   2. Under Destination, verify that the Oracle home specified is the Oracle Database Oracle home. (The default Oracle home is offered.)

6. Click Next.

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

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

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

10. Optionally, delete the temp\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.

    Restarting your computer also removes the OraInstalldate_time directory.

7 Install Oracle Database 10g Companion Products

To install Oracle Database 10g Companion Products in a new Oracle home, follow these steps:

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. Delete the ORACLE_HOME environment variable 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

3. Insert the CD-ROM labeled Oracle Database Companion CD 10g Release 1 (10.1) Disk 1 of 1 or navigate to the Oracle Database Companion CD location on the Oracle Database 10g release 1 (10.1) DVD-ROM.

   When installing from a hard disk, double-click setup.exe.

   When installing from the installation media, the Autorun screen automatically appears. If the Autorun screen does not appear, then:

   1. Click Start > Run.

   2. Enter the following:

      DRIVE_LETTER:\autorun\autorun.exe
      
      

      The Welcome screen appears.

      
      

      Note: If you need additional information about a screen, click Help.

4. On the Welcome screen click Next.

5. On the Specify File Locations screen, do the following:

   1. Under Source, leave the setting at the default for the path representing the products that you want to install.

   2. Under Destination, enter the name and path for a new Oracle home directory. (The default Oracle home name is offered. Do not enter a directory path that has spaces. The Oracle Universal Installer will create a new directory for you.)

6. Click Next.

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

8. On the Available Product Components screen, choose Apache Standalone (which is Oracle HTTP Server), HTML DB, or both.

   
   

   Note: If you are installing Oracle HTML DB in a new Oracle home, you must choose Oracle HTTP Server.

9. Click Next.

10. On the Enter HTML Configuration Information screen, enter the information required to configure Oracle HTML DB and click Next.

    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 an Oracle 10g database, the Oracle Universal Installer automatically creates a database access descriptor (DAD) in the mod_sql configuration file and directory aliases in the Oracle HTTP Server configuration file, based on the information you enter during installation. However, if you plan to use a 9.2.0.3 or later database (but not 10g), you need to create these settings manually. For instructions, see the Oracle Database Companion CD Installation Guide.

    To configure Oracle HTML DB, specify the following information:

    • 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, not localhost.

    • Port

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

    • Database Service Name

      Specify the database service name for the database where you want to install the Oracle HTML DB database objects. The database service name is usually the same as the global database name for the database, for example, sales.us.oracle.com.

    • 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 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 ADMIN 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_010500 and FLOWS_FILES schemas.

    • Confirm HTML DB Password

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

    • TABLESPACE Name

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

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

12. On the End of Installation screen, make a note of the URLs that Oracle HTTP Server will use.

    
    

    Note: If you are installing Oracle HTML DB in a new Oracle home, you must choose Oracle HTTP Server.

13. Click Exit and then click Yes to exit from the Oracle Universal Installer.

14. Optionally, delete the temp\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.

    Restarting your computer also removes the OraInstalldate_time directory.

8 What to Do Next

After you have successfully installed Oracle HTTP Server and Oracle HTML DB complete the following steps:

1. Open the following URL in a Web browser:

   http://hostname:port/pls/htmldb/htmldb_admin
   
   

   In this example:

   • hostname is the name of the system where Oracle HTTP Server is installed.

   • port is the Oracle HTTP Server port.

     You can see a listing of all Oracle HTTP ports, in the portlist.ini file. You can find this file in the Oracle HTTP Server \install directory. For example:

     \ORACLE_BASE\ORACLE_HOME\install\postlist.ini
     
     

2. Log in to Oracle HTML DB using the username ADMIN and the password that you specified during the installation.

   Use the password that you specified for the FLOWS user when you created the database objects.