Contents

Title and Copyright Information

Preface

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

1 Installation Overview

• 1.1 Overview of Oracle Database Installation
• 1.2 Oracle Database Installation Methods
• • 1.2.1 Interactive Installation Methods
  • 1.2.2 Automated Installation Methods Using Response Files
• 1.3 Oracle Database Installation Types
• 1.4 Database Configuration Options
• • 1.4.1 Preconfigured Database Types
  • 1.4.2 Installation Choices that Affect Database Creation
  • 1.4.3 Creating a Database After Installation
• 1.5 Available Installation Options
• • 1.5.1 Database Storage Options
  • • 1.5.1.1 File System
    • 1.5.1.2 Automatic Storage Management
    • 1.5.1.3 Raw Devices
  • 1.5.2 Database Management Options
  • • 1.5.2.1 Management Options for Preconfigured Databases
    • 1.5.2.2 Management Options for Custom Databases
    • 1.5.2.3 Features Provided by Oracle Enterprise Manager Database Control
  • 1.5.3 Database Backup and Recovery Options
  • • 1.5.3.1 Enabling Automated Backups
    • 1.5.3.2 Backup Job Default Settings
    • 1.5.3.3 More Information About Automated Backups and Recovery
  • 1.5.4 E-mail Notification Options
• 1.6 Installation Considerations
• • 1.6.1 Hardware and Software Certification
  • 1.6.2 Multiple Oracle Homes
  • • 1.6.2.1 Installing the Software on a System with an Existing Oracle Installation
  • 1.6.3 Oracle Cluster Synchronization Services
  • 1.6.4 Using Network Attached Storage or NFS File Systems
• 1.7 Upgrade Issues
• • 1.7.1 AL24UTFFSS Character Set
  • 1.7.2 Upgrading an Oracle Database Installed on Red Hat Enterprise Linux 2.1
• 1.8 Deprecated Components in Oracle Database 10g Release 2 (10.2)

2 Preinstallation Tasks

• 2.1 Logging In to the System as root
• 2.2 Checking the Hardware Requirements
• 2.3 Checking the Software Requirements
• 2.4 Checking the Network Setup
• • 2.4.1 Configuring Name Resolution
  • 2.4.2 Installing on DHCP Computers
  • 2.4.3 Installing on Multihomed Computers
  • 2.4.4 Installing on Computers with Multiple Aliases
  • 2.4.5 Installing on Non-Networked Computers
• 2.5 Creating Required Operating System Groups and Users
• • 2.5.1 Creating the Oracle Inventory Group
  • 2.5.2 Creating the OSDBA Group
  • 2.5.3 Creating an OSOPER Group (Optional)
  • 2.5.4 Creating the Oracle Software Owner User
  • • 2.5.4.1 Determining Whether an Oracle Software Owner User Exists
    • 2.5.4.2 Creating an Oracle Software Owner User
    • 2.5.4.3 Modifying an Oracle Software Owner User
  • 2.5.5 Verifying that the User nobody Exists
• 2.6 Configuring Kernel Parameters
• 2.7 Identifying Required Software Directories
• • 2.7.1 Oracle Base Directory
  • 2.7.2 Oracle Inventory Directory
  • 2.7.3 Oracle Home Directory
• 2.8 Identifying or Creating an Oracle Base Directory
• • 2.8.1 Identifying an Existing Oracle Base Directory
  • 2.8.2 Creating an Oracle Base Directory
• 2.9 Choosing a Storage Option for Oracle Database and Recovery Files
• 2.10 Creating Directories for Oracle Database or Recovery Files
• • 2.10.1 Guidelines for Placing Oracle Database Files on a File System
  • 2.10.2 Guidelines for Placing Oracle Recovery Files on a File System
  • 2.10.3 Creating Required Directories
• 2.11 Preparing Disk Groups for an Automatic Storage Management Installation
• • 2.11.1 General Steps for Configuring Automatic Storage Management
  • 2.11.2 Step 1: Identifying Storage Requirements for Automatic Storage Management
  • 2.11.3 Step 2: Using an Existing Automatic Storage Management Disk Group
  • 2.11.4 Step 3: Creating DAS or SAN Disk Partitions for Automatic Storage Management
  • 2.11.5 Step 4: Configuring Disks for Automatic Storage Management
  • • 2.11.5.1 Configuring Disks for Automatic Storage Management Using the Automatic Storage Management Library Driver
    • 2.11.5.2 Configuring Disks for Automatic Storage Management Using Raw Devices
• 2.12 Configuring Raw Partitions or Raw Logical Volumes
• • 2.12.1 Using Raw Logical Volumes
  • 2.12.2 Identifying the Required Raw Partitions
  • 2.12.3 Creating the Required Raw Partitions on IDE, SCSI, or RAID Devices
  • 2.12.4 Binding the Partitions to Raw Devices
  • 2.12.5 Creating the Oracle Database Configuration Assistant Raw Device Mapping File
• 2.13 Stopping Existing Oracle Processes
• 2.14 Configuring the oracle User's Environment

3 Installation Tasks

• 3.1 Preinstallation Considerations
• • 3.1.1 Performing Multiple Oracle Database Installations in Noninteractive Mode
• 3.2 Reviewing Component-Specific Installation Guidelines
• 3.3 Accessing the Installation Software
• • 3.3.1 Downloading Oracle Software from the OTN Web Site
  • • 3.3.1.1 Downloading the Installation Archive Files
    • 3.3.1.2 Extracting the Installation Files
  • 3.3.2 Copying the Software to the Hard Disk
  • • 3.3.2.1 Mounting Discs
    • 3.3.2.2 Copying the Oracle Database Software to a Hard Disk
• 3.4 Installing the Oracle Database Software
• • 3.4.1 Reviewing Installation Guidelines
  • 3.4.2 Running Oracle Universal Installer
• 3.5 Installing Automatic Storage Management
• • 3.5.1 Step 1: Reviewing Automatic Storage Management Installation Considerations
  • 3.5.2 Step 2: Creating the Automatic Storage Management Instance and Disk Groups
  • 3.5.3 Step 3: Installing Oracle Database to Use with Automatic Storage Management
  • 3.5.4 Step 4: Testing the Automatic Storage Management Installation

4 Postinstallation Tasks

• 4.1 Required Postinstallation Tasks
• • 4.1.1 Downloading and Installing Patches
  • 4.1.2 Configuring Oracle Products
• 4.2 Recommended Postinstallation Tasks
• • 4.2.1 Creating a Backup of the root.sh Script
  • 4.2.2 Configuring New or Upgraded Databases
  • 4.2.3 Setting Up User Accounts
  • 4.2.4 Setting the NLS_LANG Environment Variable
  • 4.2.5 Generating the Client Static Library
• 4.3 Required Product-Specific Postinstallation Tasks
• • 4.3.1 Configuring Oracle Net Services
  • 4.3.2 Configuring Oracle Label Security
  • 4.3.3 Installing Natively Compiled Java Libraries for Oracle JVM and Oracle interMedia
  • 4.3.4 Installing Oracle Text Supplied Knowledge Bases
  • 4.3.5 Configuring Oracle Messaging Gateway
  • • 4.3.5.1 Modifying the listener.ora File for External Procedures
    • 4.3.5.2 Modifying the tnsnames.ora File for External Procedures
    • 4.3.5.3 Setting Up the mgw.ora Initialization File
  • 4.3.6 Configuring Oracle Precompilers
  • • 4.3.6.1 Configuring Pro*C/C++
  • 4.3.7 Configuring OCCI
  • 4.3.8 Configuring GCC as the Primary Compiler
• 4.4 Installing Oracle Database 10g Products from the Companion CD

5 Getting Started with Oracle Database

• 5.1 Checking the Installed Oracle Database Contents and Directory Location
• 5.2 Logging In to Oracle Enterprise Manager Database Control
• 5.3 Managing Automatic Storage Management
• • 5.3.1 Starting and Stopping Automatic Storage Management
  • 5.3.2 Automatic Storage Management Utilities
• 5.4 Reviewing Accounts and Passwords
• 5.5 Unlocking and Resetting User Passwords
• • 5.5.1 Using Database Control to Unlock Accounts and Reset Passwords
  • 5.5.2 Using SQL*Plus to Unlock Accounts and Reset Passwords
• 5.6 Identifying Databases
• 5.7 Locating the Server Parameter File
• 5.8 Reviewing Tablespaces and Data Files, Redo Log Files, and Control Files
• • 5.8.1 Identifying Tablespaces and Data Files
  • 5.8.2 Locating Redo Log Files
  • 5.8.3 Locating Control Files

6 Removing Oracle Software

• 6.1 Overview
• 6.2 Identifying All Instances
• 6.3 Removing an Oracle Database
• 6.4 Removing an Automatic Storage Management Instance
• 6.5 Reconfiguring Oracle Cluster Synchronization Services
• • 6.5.1 Identifying Oracle Database 10g Oracle Homes
  • 6.5.2 Reconfiguring the Oracle CSS Daemon
  • 6.5.3 Deleting the Oracle CSS Daemon Configuration
• 6.6 Removing Oracle Software

A Installing and Configuring Oracle Database Using Response Files

• A.1 How Response Files Work
• • A.1.1 Reasons for Using Silent Mode or Noninteractive Mode
  • A.1.2 Creating a Database Using Automatic Storage Management as the Storage Option for Database Files
  • A.1.3 General Procedure for Using Response Files
• A.2 Creating the oraInst.loc File
• A.3 Preparing a Response File
• • A.3.1 Editing a Response File Template
  • A.3.2 Recording a Response File
• A.4 Running Oracle Universal Installer Using a Response File
• A.5 Running NetCA Using a Response File
• A.6 Running Database Configuration Assistant Using a Response File
• • A.6.1 Using Database Configuration Assistant in Noninteractive Mode
  • A.6.2 Using Database Configuration Assistant in Silent Mode
  • A.6.3 Running Database Configuration Assistant in Noninteractive or Silent Mode

B Using NAS Devices

• B.1 General Configuration Guidelines for NAS Devices
• B.2 Choosing Mount Points
• • B.2.1 Choosing Mount Points for Oracle Software Files
  • B.2.2 Choosing Mount Points for Oracle Database and Recovery Files
• B.3 Creating Files on a NAS Device for Use with Automatic Storage Management
• B.4 NFS Mount Options

C Optimal Flexible Architecture

• C.1 Overview of the Optimal Flexible Architecture Standard
• • C.1.1 Characteristics of an Optimal Flexible Architecture Compliant Installation
• C.2 Changes to the Optimal Flexible Architecture for Oracle Database 10g
• C.3 Implementing Optimal Flexible Architecture
• • C.3.1 File Systems
  • • C.3.1.1 Number of File Systems
    • C.3.1.2 Naming Conventions
    • C.3.1.3 Naming Mount Points for Very Large Databases (VLDBs)
  • C.3.2 Naming Directories
  • • C.3.2.1 Oracle Base Directory Naming Convention
    • C.3.2.2 Referring to Path Names
    • C.3.2.3 Oracle Home Directory Naming Convention
    • C.3.2.4 Naming Subdirectories
  • C.3.3 Naming Database Files
  • C.3.4 Separating Segments with Different Requirements
  • C.3.5 Naming Tablespaces
  • C.3.6 Exploiting the Optimal Flexible Architecture Structure for Oracle Files
  • C.3.7 Optimal Flexible Architecture File Mapping
• C.4 Improving Reliability and Performance
• • C.4.1 Disk Mirroring
  • C.4.2 Disk Striping

D Managing Oracle Database Port Numbers

• D.1 About Managing Ports
• D.2 Viewing Port Numbers and Access URLs
• D.3 Port Numbers and Protocols of Oracle Components
• D.4 Changing the Oracle Enterprise Management Agent Port
• D.5 Changing the Oracle Enterprise Manager Database Console Ports
• D.6 Changing the iSQL*Plus Ports
• D.7 Changing the Oracle Ultra Search Ports
• D.8 Changing the Oracle XML DB Ports

E Configuring Oracle Database Globalization Support

• E.1 About NLS_LANG Environment Variable
• E.2 Running Oracle Universal Installer in Different Languages

F Troubleshooting

• F.1 Verify Requirements
• F.2 X Window Display Errors
• F.3 What to Do If an Installation Error Occurs?
• F.4 Reviewing the Log of an Installation Session
• F.5 Troubleshooting Configuration Assistants
• • F.5.1 Configuration Assistant Failure
  • F.5.2 Fatal Errors
• F.6 Silent-Mode Response File Error Handling
• F.7 Cleaning Up After a Failed Installation

G Frequently Asked Questions About Installation

• G.1 Installing Oracle Database or Oracle Database Client
• G.2 Installing Oracle Database Tools
• G.3 Installing Oracle Database with Oracle Applications
• G.4 Installing Oracle Database Heterogeneous Connectivity Tools (Gateways)

Index