Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Command Syntax
• Accessing Documentation
• Related Documentation
• Typographic Conventions

1 Installation Overview

• Overview of Oracle Database Installation
• Oracle Database Installation Methods
  • Interactive Installation Methods
  • Automated Installation Methods Using Response Files
• Oracle Database Installation Types
• Database Configuration Options
  • Preconfigured Database Types
  • Installation Choices that Affect Database Creation
  • Creating a Database After Installation
• Available Installation Options
  • Database Storage Options
    • File System
• Installation Considerations
  • Hardware and Software Certification
  • Multiple Oracle Homes
    • Installing the Software on a System with an Existing Oracle Installation

2 Preinstallation Tasks

• Logging In to the System as root
• Checking the Hardware Requirements
• Checking the Software Requirements
• Checking the Network Setup
  • Configuring Name Resolution
  • Installing on DHCP Computers
  • Installing on Multihomed Computers
  • Installing on Computers with Multiple Aliases
  • Installing on Non-Networked Computers
• Creating Required Operating System Groups and Users
  • Creating the Oracle Inventory Group
  • Creating the OSDBA Group
  • Creating an OSOPER Group (Optional)
  • Creating the Oracle Software Owner User
    • Determining Whether an Oracle Software Owner User Exists
    • Creating an Oracle Software Owner User
    • Modifying an Oracle Software Owner User
• Configuring Kernel Parameters
• Identifying Required Software Directories
  • Oracle Base Directory
  • Oracle Inventory Directory
  • Oracle Home Directory
• Identifying or Creating an Oracle Base Directory
  • Identifying an Existing Oracle Base Directory
  • Creating an Oracle Base Directory
• Choosing a Storage Option for Oracle Database and Recovery Files
• Creating Directories for Oracle Database or Recovery Files
  • Guidelines for Placing Oracle Database Files on a File System
  • Guidelines for Placing Oracle Recovery Files on a File System
  • Creating Required Directories
• Stopping Existing Oracle Processes
• Configuring the Oracle User's Environment

3 Installation Tasks

• Preinstallation Considerations
  • Performing Multiple Oracle Database Installations in Noninteractive Mode
• Reviewing Component-Specific Installation Guidelines
• Accessing the Installation Software
  • Downloading and Extracting Oracle Software from the OTN Web Site
    • Downloading the Installation Archive Files
    • Extracting the Installation Files
  • Copy the Oracle Database Software to a Hard Disk
• Installing the Oracle Database Software
  • Reviewing Product-Specific Installation Guidelines
  • Running the Oracle Universal Installer

4 Postinstallation Tasks

• Required Postinstallation Tasks
  • Downloading and Installing Patches
  • Configuring Oracle Products
• Recommended Postinstallation Tasks
  • Creating a Backup of the root.sh Script
  • Configuring New or Upgraded Databases
  • Setting Up User Accounts
  • Setting the NLS_LANG Environment Variable
  • Generating the Client Static Library
• Required Product-Specific Postinstallation Tasks
  • Configuring Oracle Net Services
  • Configuring Oracle Label Security
  • Installing Natively Compiled Java Libraries for Oracle JVM and Oracle interMedia
  • Installing Oracle Text Supplied Knowledge Bases
  • Configuring Oracle Messaging Gateway
    • Modifying the listener.ora File for External Procedures
    • Modifying the tnsnames.ora File for External Procedures
    • Setting Up the mgw.ora Initialization File
  • Configuring Oracle Precompilers
    • Configuring Pro*C/C++
  • Configuring OCCI
• Installing Oracle Database 10g Products from the Companion CD

5 Getting Started with Oracle Database

• Checking the Installed Oracle Database Contents and Directory Location
• Reviewing Accounts and Passwords
• Unlocking and Resetting User Passwords
  • Using SQL*Plus to Unlock Accounts and Reset Passwords
• Identifying Databases
• Locating the Server Parameter File
• Reviewing Tablespaces and Data Files, Redo Log Files, and Control Files
  • Identifying Tablespaces and Data Files
  • Locating Redo Log Files
  • Locating Control Files

6 Removing Oracle Software

• Overview
• Identifying All Instances
• Removing an Oracle Database
• Removing Oracle Software

A Installing and Configuring Oracle Database Using Response Files

• How Response Files Work
  • Reasons for Using Silent Mode or Noninteractive Mode
  • General Procedure for Using Response Files
• Creating the oraInst.loc File
• Preparing a Response File
  • Editing a Response File Template
  • Recording a Response File
• Running Oracle Universal Installer Using a Response File
• Running NetCA Using a Response File
• Running Database Configuration Assistant Using a Response File
  • Using Database Configuration Assistant in Noninteractive Mode
  • Using Database Configuration Assistant in Silent Mode
  • Running Database Configuration Assistant in Noninteractive or Silent Mode

B Cloning an Oracle Home

C Optimal Flexible Architecture

• Overview of the Optimal Flexible Architecture Standard
  • Characteristics of an Optimal Flexible Architecture Compliant Installation
• Changes to the Optimal Flexible Architecture for Oracle Database 10g
• Implementing Optimal Flexible Architecture
  • File Systems
    • Number of File Systems
    • Naming Conventions
    • Naming Mount Points for Very Large Databases (VLDBs)
  • Naming Directories
    • Oracle Base Directory Naming Convention
    • Referring to Path Names
    • Oracle Home Directory Naming Convention
    • Naming Subdirectories
  • Naming Database Files
  • Separating Segments with Different Requirements
  • Naming Tablespaces
  • Exploiting the Optimal Flexible Architecture Structure for Oracle Files
  • Optimal Flexible Architecture File Mapping
• Improving Reliability and Performance
  • Disk Mirroring
  • Disk Striping

D Managing Oracle Database Port Numbers

• About Managing Ports
• Viewing Port Numbers and Access URLs
• Port Numbers and Protocols of Oracle Components
• Changing the iSQL*Plus Ports
• Changing the Oracle Ultra Search Ports
• Changing the Oracle XML DB Ports

E Configuring Oracle Database Globalization Support

• About NLS_LANG Environment Variable
• Running Oracle Universal Installer in Different Languages

F Troubleshooting

• Verify Requirements
• What to Do If an Installation Error Occurs?
• Reviewing the Log of an Installation Session
• Troubleshooting Configuration Assistants
  • Configuration Assistant Failure
  • Fatal Errors
• Silent-Mode Response File Error Handling
• Cleaning Up After a Failed Installation

G Frequently Asked Questions About Installation

• Installing Oracle Database or Oracle Database Client
• Installing Oracle Database Tools
• Installing Oracle Database with Oracle Applications

Index