Contents

Title and Copyright Information

Preface

• Intended Audience
• Documentation Accessibility
• Related Documentation
• Conventions
• Third-Party Software Notices

1 Installation Overview

• 1.1 Overview of Oracle Database Installation
• 1.2 Changes and Enhancements
  • 1.2.1 Turning Off the Image Dump
  • 1.2.2 Oracle Database Dependency on ODS-5 Disk Structure
  • 1.2.3 Oracle Database Installation Directory Structure
• 1.3 Oracle Database Installation Types
• 1.4 Overview of Database Configuration Assistant
• 1.5 Database Configuration Options
  • 1.5.1 Database Options
    • 1.5.1.1 General Purpose
    • 1.5.1.2 OLTP
    • 1.5.1.3 Customized
    • 1.5.1.4 Software Only
  • 1.5.2 Installation Choices that Affect Database Creation
  • 1.5.3 Creating a Database After Installation
• 1.6 Available Installation Options
  • 1.6.1 Database Storage Options
  • 1.6.2 Database Backup and Recovery Options
• 1.7 Important Compatibility Issues
• 1.8 Installation Considerations
  • 1.8.1 Hardware and Software Certification
  • 1.8.2 Multiple Oracle Homes
  • 1.8.3 Logical Names and Symbols
  • 1.8.4 Oracle Cluster Synchronization Services Daemon
• 1.9 Upgrade Issues
  • 1.9.1 Manually Upgrade a Database
  • 1.9.2 AL24UTFFSS Character Set
  • 1.9.3 Cluster Ready Services and Oracle RAC Upgrade
• 1.10 Cluster File System

2 Preinstallation Tasks

• 2.1 Logging In to the System as root
• 2.2 Checking Hardware Requirements
  • 2.2.1 Minimum Hardware Requirements
  • 2.2.2 Images
  • 2.2.3 Disk Space Requirements
  • 2.2.4 Oracle Advanced Security
• 2.3 Checking Network Requirements for Oracle RAC
  • 2.3.1 Network Hardware Requirements
  • 2.3.2 IP Address Requirements
  • 2.3.3 Checking Each Node for Network Requirements
• 2.4 Checking Software Requirements
• 2.5 Installation-Specific Issues and Restrictions
  • 2.5.1 New ORA_ROOT
  • 2.5.2 JDK
  • 2.5.3 Devices
• 2.6 Creating a User Account
  • 2.6.1 Creating an Oracle Database DBA Account
  • 2.6.2 Adding a Record in the User Authorization File
  • 2.6.3 Setting Account Privileges
  • 2.6.4 Setting Account Quotas
  • 2.6.5 Process Rights for Database Administrators
  • 2.6.6 Process Rights for SGA Protection
  • 2.6.7 Security Issues with Multiple Databases
  • 2.6.8 Completing Account Setup
  • 2.6.9 Verifying Privileges
  • 2.6.10 Setting Permissions for File Creation
• 2.7 SYSGEN Parameters
  • 2.7.1 Reserved Memory Registry
  • 2.7.2 AUTOGEN
• 2.8 System Configuration
• 2.9 Performing Setup Tasks As the SYSTEM User
  • 2.9.1 Creating an Oracle Database Account
  • 2.9.2 Creating an Apache Server Account
• 2.10 Performing Setup Tasks As the oracle user
  • 2.10.1 Setting the Display
  • 2.10.2 Setting Up a Batch Queue for the Oracle Enterprise Manager Agent and HAS
• 2.11 Setup Tasks for Oracle Products
  • 2.11.1 Precompilers and Tools
  • 2.11.2 Network and System Management Products
    • 2.11.2.1 Setup Tasks for Oracle Net Services
• 2.12 Identifying Required Software Directories
  • 2.12.1 Oracle Inventory Directory
  • 2.12.2 Oracle Clusterware Home Directory
  • 2.12.3 Oracle Home Directory
• 2.13 Guidelines for Placing Oracle Recovery Files
• 2.14 Creating Directories for Oracle Database or Recovery Files
• 2.15 Stopping Existing Oracle Processes
• 2.16 Configuring the oracle User's Environment
• 2.17 The ORATAB File

3 Installation Tasks

• 3.1 Installation Overview
  • 3.1.1 Reviewing Product-Specific Installation Guidelines
• 3.2 Downloading Oracle Software from the Oracle Technology Network Web Site
  • 3.2.1 Downloading the Installation Archive Files
• 3.3 Installing Oracle Database Software
  • 3.3.1 Installing Oracle Database from the Hard Drive
  • 3.3.2 Installing Oracle Database from Install Media
    • 3.3.2.1 Mount the DVD
    • 3.3.2.2 Installing Oracle Database
    • 3.3.2.3 Completing Oracle Database Server Enterprise Edition Installation
• 3.4 Installing Oracle Database Client
• 3.5 Reviewing the Log of an Installation Session
• 3.6 Cleaning Up After a Failed Installation

4 Postinstallation Tasks

• 4.1 Database Configuration Assistant
  • 4.1.1 Running Database Configuration Assistant in Interactive Mode
  • 4.1.2 Using Database Configuration Assistant Response Files
  • 4.1.3 Database Configuration Assistant Unsupported Options
• 4.2 Required Postinstallation Tasks
  • 4.2.1 Downloading and Installing Patches
  • 4.2.2 Configuring Oracle Products
  • 4.2.3 Setting the NLS_LANG Environment Variable
• 4.3 Configuring New or Upgraded Databases
• 4.4 Changing User Passwords
• 4.5 Performing Configuration Tasks as the SYSTEM User
• 4.6 Performing Configuration Tasks as the oracle User
• 4.7 Required Product-Specific Postinstallation Tasks
  • 4.7.1 Configuring Oracle Net Services
  • 4.7.2 Configuring Oracle Label Security
  • 4.7.3 Installing Oracle Text Supplied Knowledge Bases
  • 4.7.4 Configuring Oracle Messaging Gateway
  • 4.7.5 Oracle Precompilers

5 Installing Oracle RAC

• 5.1 Oracle RAC Documentation Overview
  • 5.1.1 Oracle Real Application Clusters Administrator's Guide
  • 5.1.2 Oracle Real Application Clusters Deployment and Performance Guide
  • 5.1.3 Documentation Sources
• 5.2 Quota Considerations
• 5.3 Cluster Setup and Preinstallation Configuration Tasks
• 5.4 Preinstallation, Installation, and Postinstallation Overview
  • 5.4.1 Preinstallation Overview
  • 5.4.2 Installation Overview
  • 5.4.3 Postinstallation Overview
• 5.5 Oracle Universal Installer and Oracle Real Application Clusters
• 5.6 Additional Considerations
• 5.7 Oracle Database and Oracle Real Application Clusters Components
  • 5.7.1 Oracle Clusterware
  • 5.7.2 Installed Oracle Real Application Clusters Components
• 5.8 Oracle Real Application Clusters Version Compatibility
• 5.9 Installing Oracle Clusterware
  • 5.9.1 Installation Setup
  • 5.9.2 Installing Oracle Clusterware
• 5.10 Installation Tasks for Oracle Real Application Clusters
• 5.11 Selecting a Database Configuration Type
  • 5.11.1 Configuration Type Descriptions
    • 5.11.1.1 Using the Standard Configuration Types
    • 5.11.1.2 Using the Advanced Configuration Type
  • 5.11.2 Action of Oracle Universal Installer, Database Configuration Assistant, and Other Assistants During Installation
• 5.12 Procedure for Installation Setup
• 5.13 Installing Oracle Database with Oracle Real Application Clusters
• 5.14 Postinstallation Procedures for Oracle Real Application Clusters
  • 5.14.1 Backing Up the Voting Disk After Installation
  • 5.14.2 Downloading and Installing Patches
  • 5.14.3 Configuring Oracle Products
  • 5.14.4 Verifying Enterprise Manager Operations
  • 5.14.5 Setting Up Users Accounts After Installation
• 5.15 Uninstalling Oracle Real Application Clusters Software
  • 5.15.1 Procedure for Removing Oracle Real Application Clusters Software
  • 5.15.2 Uninstalling Oracle Clusterware

6 Configuring Oracle RAC

• 6.1 Creating Directories
  • 6.1.1 Guidelines for Placing Oracle Clusterware Files on a File System
  • 6.1.2 Guidelines for Placing Oracle Database Files on a File System
  • 6.1.3 Guidelines for Placing Oracle Database Recovery Files on a File System
  • 6.1.4 Creating Required Directories
• 6.2 Using Database Configuration Assistant for Oracle RAC
• 6.3 Benefits of Using Database Configuration Assistant
• 6.4 Oracle RAC High-Availability Services
  • 6.4.1 Service Configuration and Instance Preferences
  • 6.4.2 Transparent Application Failover Policies
• 6.5 Creating the Database After Installation
• 6.6 Creating the Oracle RAC Database
• 6.7 Deleting an Oracle RAC Database
• 6.8 Configuring Oracle RAC
• 6.9 Parameter Files and Oracle RAC
• 6.10 Using Server Parameter Files in Oracle RAC
  • 6.10.1 Location of the Server Parameter File
• 6.11 Parameter File Search Order in Oracle RAC
• 6.12 Upgrading to the Server Parameter File in Oracle RAC Environments
  • 6.12.1 Server Parameter File Placement in Oracle RAC
  • 6.12.2 Procedures for Upgrading to the Server Parameter File
• 6.13 Server Parameter File Errors in Oracle RAC
• 6.14 Understanding the Oracle RAC Installed Configuration
  • 6.14.1 Understanding the Configured Environment in Oracle RAC
  • 6.14.2 Oracle Cluster Registry in Oracle RAC
  • 6.14.3 HP OpenVMS oratab Configurations for Oracle RAC
• 6.15 Database Components Created Using Database Configuration Assistant
  • 6.15.1 Tablespaces and Data Files
  • 6.15.2 Control Files
  • 6.15.3 Redo Log Files
• 6.16 Managing Undo Tablespaces in Oracle RAC
• 6.17 Configuring Service Registration-Related Parameters
• 6.18 Configuring the Listener File (LISTENER.ORA)
  • 6.18.1 Local Listeners
  • 6.18.2 Multiple Listeners
  • 6.18.3 How Oracle Database Uses the Listener (LISTENER.ORA)
    • 6.18.3.1 Listener Registration and PMON Discovery
• 6.19 Directory Server Access (LDAP.ORA File)
• 6.20 Net Service Names (TNSNAMES.ORA File)
• 6.21 Profile (SQLNET.ORA File)

7 Getting Started with Oracle Database

• 7.1 Checking the Installed Oracle Database Contents and Directory Location
• 7.2 Reviewing Accounts and Passwords
• 7.3 Unlocking and Resetting User Passwords
  • 7.3.1 Using Grid Control to Unlock Accounts and Reset Passwords
  • 7.3.2 Using SQL*Plus to Unlock Accounts and Reset Passwords
• 7.4 Identifying Databases
• 7.5 Locating the Parameter Files
  • 7.5.1 Locating the INIT.ORA File
  • 7.5.2 Locating the Server Parameter File
• 7.6 Reviewing Tablespaces and Data Files, Redo Log Files, and Control Files
  • 7.6.1 Identifying Tablespaces and Data Files
  • 7.6.2 Locating Redo Log Files
  • 7.6.3 Locating Control Files
• 7.7 Adding or Upgrading Products
  • 7.7.1 Preparing to Add a Product
  • 7.7.2 Adding a Product Summary
• 7.8 Relinking the Oracle Code

8 Removing Oracle Software

• 8.1 Overview
• 8.2 Identifying All Instances
• 8.3 Removing an Oracle Database
• 8.4 Reconfiguring Oracle Cluster Synchronization Services
  • 8.4.1 Identifying Oracle Database Oracle Homes
  • 8.4.2 Reconfiguring the Oracle Cluster Synchronization Services Daemon
  • 8.4.3 Deleting the Oracle Cluster Synchronization Services Daemon Configuration
• 8.5 Removing Oracle Software

A Oracle Database 64-Bit Feature

• A.1 Introduction to Oracle Database 64-Bit Feature
  • A.1.1 Benefits of Oracle Database 64-Bit Feature
  • A.1.2 Implementation of Oracle 64-Bit Feature
• A.2 Suggested Parameter Settings
• A.3 Other Recommendations

B Noninteractive Installation and Configuration

• B.1 Silent Mode Installation
  • B.1.1 What Is a Response File?
  • B.1.2 Why Perform a Silent Installation?
  • B.1.3 Modifying a Response File
    • B.1.3.1 List of Response File Names
• B.2 Performing Silent Installation
  • B.2.1 Creating the ORAINST.LOC File
  • B.2.2 Preparing Response Files
  • B.2.3 Running Oracle Universal Installer Noninteractively
• B.3 Running Oracle Universal Installer in Silent Mode or Suppressed Mode
• B.4 Running Oracle Network Configuration Assistant in Silent Mode
• B.5 Running Database Configuration Assistant in Noninteractive or Silent Mode
  • B.5.1 Using Database Configuration Assistant in Noninteractive Mode
  • B.5.2 Using Database Configuration Assistant in Silent Mode
  • B.5.3 Running Database Configuration Assistant in Noninteractive or Silent Mode

C Oracle Transparent Gateway

• C.1 System Requirements for Oracle Transparent Gateway
  • C.1.1 Rdb Gateway Requirements
  • C.1.2 RMS Gateway Requirements
  • C.1.3 Tested Gateway Configurations
  • C.1.4 Gateway Installation Worksheets
    • C.1.4.1 Rdb Gateway Worksheet
    • C.1.4.2 RMS Gateway Worksheet
• C.2 Installing Oracle Transparent Gateway
  • C.2.1 Mounting Oracle Transparent Gateway from the DVD Drive
  • C.2.2 Installation Prompts for Oracle Transparent Gateway
    • C.2.2.1 Installation Prompts for Rdb Gateway
    • C.2.2.2 Completing Rdb Gateway Installation
• C.3 Removing Oracle Transparent Gateway

D Oracle RAC: Other Considerations

• D.1 Documentation Sources
• D.2 Troubleshooting the Oracle RAC Installation Process
• D.3 Preconversion Considerations
  • D.3.1 Prerequisites for Conversion
  • D.3.2 Administrative Considerations
• D.4 Converting from Single-Instance to Oracle RAC
  • D.4.1 Single-Instance Database on a Noncluster Computer to Oracle RAC
    • D.4.1.1 Backing Up the Original Single-Instance Database
    • D.4.1.2 Performing the Preinstallation Steps
    • D.4.1.3 Setting Up the Cluster
    • D.4.1.4 Copying the Preconfigured Database Image
    • D.4.1.5 Installing Oracle Database with Oracle RAC
  • D.4.2 Single-Instance Database on a Cluster to Oracle RAC
    • D.4.2.1 Single Instance on a Cluster Running from a Cluster-Enabled Oracle Home
    • D.4.2.2 Automated Conversion
    • D.4.2.3 Manual Conversion
    • D.4.2.4 Single-Instance Database on a Cluster Running from an Oracle RAC-Disabled Oracle Home
    • D.4.2.5 Single-Instance Database on a Cluster Running from a Noncluster-Installed Oracle Home
• D.5 Postconversion Steps
• D.6 HP OpenVMS Directory Structures for Oracle RAC

E Installing, Configuring, and Running Enterprise Manager Agent

• E.1 Introduction to Enterprise Manager Framework
• E.2 Installation Requirements
• E.3 Installation and Configuration
• E.4 Management and Maintenance
  • E.4.1 Startup, Shutdown, and Status
  • E.4.2 Troubleshooting and Maintenance
    • E.4.2.1 Enterprise Manager Agent Fails to Start
    • E.4.2.2 Extended File Specification (EFS) Characteristics
    • E.4.2.3 TMP Directory
    • E.4.2.4 Monitoring the Batch Queue
    • E.4.2.5 Disk Space on Enterprise Manager Agent Install Area
    • E.4.2.6 Resetting Enterprise Manager Agent Environment
• E.5 Supported Targets and Jobs
• E.6 Known Limitations

F Managing Oracle Database Port Numbers

• F.1 About Managing Ports
• F.2 Viewing Port Numbers and Access URLs
• F.3 Port Numbers and Protocols of Oracle Components
• F.4 Changing the Oracle Enterprise Management Agent Port

G Configuring Oracle Database Globalization Support

• G.1 About NLS_LANG Logical

H Troubleshooting

• H.1 Verifying Requirements
• H.2 X Window Display Errors
• H.3 Errors During Installation
• H.4 Reviewing the Log of an Installation Session
• H.5 Troubleshooting Configuration Assistants
  • H.5.1 Configuration Assistant Failure
  • H.5.2 Fatal Errors
• H.6 Silent Response File Error Handling
• H.7 Cleaning Up After a Failed Installation

I Apache Server Installation and Configuration

• I.1 Postinstallation Checklist
  • I.1.1 Running AUTOGEN
  • I.1.2 Check Disk Quota
  • I.1.3 Checking for SET TERMINAL/INQUIRE
• I.2 Test the Installation
  • I.2.1 Browser Test
  • I.2.2 Troubleshooting
• I.3 Running Oracle HTTP Server on HP OpenVMS
  • I.3.1 Starting and Stopping the Server
  • I.3.2 Server Log File
    • I.3.2.1 Performance Considerations
    • I.3.2.2 Limits and Quotas for Light to Moderate Load
    • I.3.2.3 Server with Medium to High Load
    • I.3.2.4 Excessive File Build Up
  • I.3.3 Customizing the Server Environment
  • I.3.4 How to Configure Apache
  • I.3.5 Modules and Directives
  • I.3.6 Supported and Unsupported Features
    • I.3.6.1 Modules Not Included
    • I.3.6.2 Unsupported Directives
    • I.3.6.3 Command-Line Options
    • I.3.6.4 Virtual Host Support
    • I.3.6.5 Dynamic Shared Object Support
    • I.3.6.6 File Handlers
    • I.3.6.7 Content Negotiation
    • I.3.6.8 Apache API
    • I.3.6.9 suEXEC Support
  • I.3.7 File Formats
  • I.3.8 File Naming Conventions
  • I.3.9 File Transfer Process and Access Control List
  • I.3.10 Logical Names
  • I.3.11 HP OpenVMS Cluster Considerations
    • I.3.11.1 Individual System Versus Clusterwide Definition
    • I.3.11.2 Mixed-Architecture Cluster
  • I.3.12 CGI Programs
    • I.3.12.1 CGI Environment Logical
    • I.3.12.2 Referencing Input
    • I.3.12.3 Running CGI Images
    • I.3.12.4 Logical Names for Debugging CGI Scripts
    • I.3.12.5 Displaying Graphics with CGI Command Procedures
• I.4 Security Information
  • I.4.1 Process Model
  • I.4.2 Privileged Images
  • I.4.3 Privileges Required to Start and Stop the Server
  • I.4.4 File Ownership and Protection
  • I.4.5 Server Extensions (CGI Scripts)
  • I.4.6 suEXEC Not Available for Protecting Script Execution
• I.5 Open Source Licenses
  • I.5.1 Apache

J Identifying Listener Processes

K Frequently Asked Questions About Installation

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

Index