Oracle® Database

1 Review Information About this Guide

This guide describes how to complete a default installation of Oracle Database 10g Companion Products in a new Oracle home directory. Oracle Database 10g Companion Products include:

• Oracle HTTP Server: A Web server that is based on Apache HTTP Server.

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

Tasks Not Described in this Guide

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

• Installing the Oracle Database 10g Products in an existing Oracle home that contains Oracle Database 10g

• Installing Oracle HTML DB in an existing Oracle home that contains Oracle HTTP Server

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, see the Oracle Database Companion CD Installation Guide for Apple Mac OS X.

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 on the DVD-ROM, then select the Documentation tab.

2 Identify Database Information for Oracle HTML DB

Complete the following tasks before installing Oracle HTML DB.

Check the Oracle Database Installation

Before installing Oracle HTML DB, identify the Oracle database that you want to use with Oracle HTML DB. The database must be Oracle9i release 9.2.0.3 or higher. The database can be on a different system from the system where you are installing Oracle HTML DB.

Check for Oracle XML DB

Oracle XML DB must be installed in the database that you want to use.

If you are using a preconfigured database created either during an installation or by the Database Configuration Assistant (DBCA), Oracle XML DB is already installed and configured. For information about manually adding Oracle XML DB to an existing database, see the Oracle XML DB Developer's Guide.

Identify Database Information

During the installation, you must specify the following information about the database:

• The host name of the database system

• The port number of the Oracle Net listener

• The service name of the database

• The password of the SYS user

Make sure that you have this information before starting the installation.

3 Log In to the System as root

Before you install the Oracle software, you must complete several tasks as the root user. To log in as the root user, follow these steps:

1. Log into the Mac OS X desktop as a user that is a member of the admin group.

   To complete the installation described in this guide, you must be logged in to the Mac OS X desktop. If you want to install the software from a remote system, or install it on a system without graphics hardware, you must use Apple Remote Desktop to display the Mac OS X desktop for the system where you want to install the software.

2. Start a local terminal session (/Applications/Utilities/Terminal).

3. If you are not logged in as the root user, enter the following command to start a shell session with root privileges:

   $ sudo sh
   
   

4. When prompted, enter your password.

$ sudo /usr/sbin/sysctl -a

4 Check the Hardware Requirements

The system must meet the following minimum hardware requirements:

To ensure that the system meets these requirements, follow these steps:

1. To determine the physical RAM size, use System Profiler (/Applications/Utilities/System Profiler) or enter the following command:

   # /usr/sbin/system_profiler SPHardwareDataType | grep Memory 
   
   

   If the size of the physical RAM installed in the system is less than 256 MB, you must install more memory before continuing.

2. To ensure that the system has enough swap space, enter the following command:

   # df -h /
   
   

   
   

   Note: Mac OS X dynamically creates swap files as required in the /private/var/vm directory. Make sure that you have at least 512 MB of available disk space on the root (/) file system to accommodate newly created swap files.

   
   

3. To determine the amount of free disk space available in the /tmp directory, enter the following command:

   # df -h /tmp
   
   

   If there is less than 400 MB of disk space available in the /tmp directory, complete one of the following steps:

   • Delete unnecessary files from the /tmp directory to achieve the required disk space.

   • Set the TEMP and TMPDIR environment variables when setting the oracle user's environment (described later).

   • Extend the file system that contains the /tmp directory. If necessary, contact your system administrator for information about extending file systems.

4. To determine the amount of free disk space available on the system, enter the following command:

   # df -h
   
   

   This command displays the disk space usage on all mounted file systems. To complete the installation, identify a file system with sufficient disk space.

5 Check the Software Requirements

The system must meet the following minimum software requirements:

• The operating system version must be Apple Mac OS X Server 10.3.6

• The following software (or a higher version) must be installed:

  • Xcode Tools v1.1

  • GNU C compiler (gcc) version 3.3 20030304 (Apple Computer, Inc. build 1635)

    This version of gcc is included in Xcode Tools 1.2 or higher or in the Dec 2003 gccLongBranch Tools update.

To ensure that the system meets these requirements, follow these steps:

1. To determine the version of the operating system, enter the following command:

   # sw_vers
   
   

   This command returns output similar to the following:

   ProductName:    Mac OS X Server
   ProductVersion: 10.3.6
   BuildVersion:   7R28
   

   
   

   Note: Only Mac OS X Server is supported.

   
   

2. To determine whether the required version of gcc is installed, enter the following command:

   # gcc -v
   
   

   This command returns output similar to the following:

   Reading specs from /usr/libexec/gcc/darwin/ppc/3.3/specs
   Thread model: posix
   gcc version 3.3 20030304 (Apple Computer, Inc. build 1635) (-mlongcall)
   
   

   If the required version (including the date and build number) or a later version is not installed, download and install either of the following:

   • The Dec 2003 gccLongBranch Tools update

   • Xcode Tools 1.2 or higher, which includes the correct version of gcc

   You can download this software from the Apple Developer Connection Web site:

   http://connect.apple.com
   
   

   After you log in, choose Download Software, then Developer Tools to display the download page.

6 Create Required UNIX Groups and User

The following local UNIX groups and user must exist on the system:

• The oinstall group (the Oracle Inventory group)

• The dba group (the OSDBA group)

• The oracle user (the Oracle software owner)

To create this user and these groups, follow these steps:

1. Start Workgroup Manager (/Applications/Server/Workgroup Manager)

2. Create the oinstall and dba groups.

3. Create the oracle user, specifying the following information:

   • For the Primary group, specify oinstall.

   • For the Other groups, specify dba.

4. Set the password of the oracle user.

7 Create an Oracle Base Directory

Create an Oracle base directory with a name similar to the following and specify the correct owner, group, and permissions for it:

/Volumes/u01/app/oracle

The Oracle base directory must have either 250 MB of free disk space to install only Oracle HTTP Server or 550 MB of free disk space to install Oracle HTTP Server and Oracle HTML DB.

To determine where to create this directory, follow these steps:

1. Enter the following command to display information about all mounted file systems:

   # df -h
   
   

   This command displays information about all of the file systems mounted on the system, including:

   • The physical device name

   • The total amount, used amount, and available amount of disk space

   • The mount point directory for that file system

2. From the display, identify a file system that has sufficient disk space.

3. Note the name of the mount point directory for the file system that you identified.

   In the following examples, /Volumes/u01 is the mount point directory used for the software. You must specify the appropriate mount point directory for the file system on your system.

To create the required directory and specify the correct owner, group, and permissions for it, follow these steps:

1. Enter the following command to create subdirectories in the mount point directory that you identified for the Oracle base directory:

   # mkdir -p /Volumes/u01/app/oracle
   
   

2. Change the owner and group of the directory that you created to the oracle user and the oinstall group:

   # chown -R oracle:oinstall /Volumes/u01/app/oracle
   
   

3. Change the permissions on the directory that you created to 775:

   # chmod -R 775 /Volumes/u01/app/oracle
   
   

8 Log In as the oracle User and Configure the oracle User's Environment

You run the Installer from the oracle account. However, before you start the Installer you must configure the environment of the oracle user. To configure the environment, you must:

• Set the default file mode creation mask (umask) to 022 in the shell startup file.

• Set the ORACLE_BASE environment variable.

To set the oracle user's environment, follow these steps:

1. Start another terminal session and log in as the oracle user.

2. To determine the default shell for the oracle user, enter the following command:

   $ echo $SHELL
   
   

3. Open the oracle user's shell startup file in any text editor:

   • Bash shell (bash):

     $ vi .bash_profile
     
     

   • Bourne shell (sh) or Korn shell (ksh):

     $ vi .profile
     
     

   • C shell (csh or tcsh):

     % vi .login
     
     

4. Enter or edit the following line in the shell startup file, specifying a value of 022 for the default file mode creation mask:

   umask 022
   
   

5. Save the file and exit from the editor.

6. To run the shell startup script, enter the following command:

   • Bash shell:

     $ . ./.bash_profile
     
     

   • Bourne shell or Korn shell:

     $ . ./.profile
     
     

   • C shell:

     % source ./.login
     
     

7. If you determined that the /tmp directory had insufficient free disk space when checking the hardware requirements, enter the following commands to set the TEMP and TMPDIR environment variables. Specify a directory on a file system with sufficient free disk space.

   • Bourne, Bash, or Korn shell:

     $ TEMP=/directory
     $ TMPDIR=/directory
     $ export TEMP TMPDIR
     
     

   • C shell:

     % setenv TEMP /directory
     % setenv TMPDIR /directory
     
     

8. Enter commands similar to the following to set the ORACLE_BASE environment variable:

   • Bourne, Bash, or Korn shell:

     $ ORACLE_BASE=/Volumes/u01/app/oracle
     $ export ORACLE_BASE
     
     

   • C shell:

     % setenv ORACLE_BASE /Volumes/u01/app/oracle
     
     

   In these examples, /Volumes/u01/app/oracle is the Oracle base directory that you created earlier.

9. Enter the following commands to ensure that the ORACLE_HOME and TNS_ADMIN environment variables are not set:

   • Bourne, Bash, or Korn shell:

     $ unset ORACLE_HOME
     $ unset TNS_ADMIN
     
     

   • C shell:

     % unsetenv ORACLE_HOME
     % unsetenv TNS_ADMIN
     
     

10. To verify that the environment has been set correctly, enter the following commands:

    $ umask
    $ env | more
    
    

    Verify that the umask command displays a value of 022 and that the environment variables you set in this section have the correct values.

9 Install Oracle Database 10g Companion Products

After configuring the oracle user's environment, start the Installer and install the Oracle software, as follows:

1. Insert the Oracle Database 10g Companion CD CD-ROM or Oracle Database 10g DVD-ROM into the disc drive.

2. To start the Installer, enter the following command, where directory_path is the CD-ROM mount point directory or the companion directory on the DVD-ROM:

   $ /directory_path/runInstaller
   
   

3. Use the following guidelines to complete the installation:

   • The following table describes the recommended action for each Installer screen.

     
     

     Note: If you have completed the tasks listed previously, you can complete the installation by choosing the default values on most screens.

     
     

   • If you need more assistance, or if you want to choose an option that is not a default, click Help for additional information.

   • If you are prompted to run a script with root privileges, enter a command similar to the following in a terminal where you are logged in as the root user, then click Continue or OK:

     # /script_path/script_name
     
     

     Alternatively, enter a command similar to the following to run the script in a terminal where you are logged in as a user that is a member of the admin group:

     $ sudo /script_path/script_name
     
     

   • If you encounter errors while installing or linking the software, see the Oracle Database Companion CD Installation Guide for Apple Mac OS X for information about troubleshooting.

   Screen	Recommended Action
   Welcome	Click Next.
   Specify Inventory Directory and Credentials	Note: This screen appears only during the first installation of Oracle products on a system. Specify the following information, 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 that 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
   Run orainstRoot.sh	If prompted, run the following script in a separate terminal window as the root user: oracle_base/oraInventory/orainstRoot.sh
   Specify File Locations	In the Destination section, specify values similar to the following for a new Oracle home directory, then click Next: Name OraDb10g_Home1 Path oracle_base/product/10.1.0/companion_1
   Select a Product to Install	Select Oracle Database 10g Companion Products, then click Next.
   Available Product Components	Select Apache Standalone to install Oracle HTTP Server, and optionally select HTML DB, then click Next.
   Enter HTML DB Configuration Information	Specify the following information, then click Next: Hostname Specify the host name of the system where the database is installed. 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. 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).
   Summary	Review the information displayed, then click Install.
   Install	The Install screen displays status information while the product is being installed.
   Configuration Assistants	The Configuration Assistants screen displays status information for the configuration assistants that configure the software.
   Setup Privileges	If prompted, run the following script in a separate terminal window as the root user: oracle_home/root.sh In this example, oracle_home is the directory where you installed the software. The correct path is displayed on the screen. When the script finishes, click OK.
   End of Installation	Make a note of the URL for the Oracle HTTP Server home page. This information is also available in the following file: oracle_home/install/setupinfo.txt To exit from the Installer, click Exit, then click Yes.

   
   

10 Restart Oracle HTTP Server

If you installed Oracle HTML DB, you must restart Oracle HTTP Server before you can access it. To restart Oracle HTTP Server, enter the following command:

$ oracle_home/Apache/Apache/bin/apachectl restart

11 What to Do Next

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

• 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 using the user name ADMIN and the password that you specified during the installation.

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

• See Chapter 5 in the Oracle Database Companion CD Installation Guide for Apple Mac OS X for information about required and optional post-installation steps.

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