Contents

Title and Copyright Information

Preface

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

What's New in Oracle Database 11g

• New Grid Infrastructure Installation Option
• New Desktop and Server Class Options
• Daylight Savings Time Upgrade of Timestamp with Timezone Data Type
• SYSASM Privilege
• Fixup Scripts and Prerequisite Checks
• Deinstallation Tool
• Intelligent Data Placement
• Oracle Automatic Storage Management Cluster File System (Oracle ACFS)
• Data Pump Export and Data Pump Import
• Automatic Restart of Single Instance Databases
• SRVCTL Support for Single Instance Database in a Cluster
• Deprecated in Oracle Database 11g Release 2 (11.2)

1 Overview of Oracle Database Installation

• 1.1 New Oracle Products and Features Installed with This Release
• 1.2 Planning the Installation
• 1.3 Installing the Linux Operating System
  • 1.3.1 Completing a Minimal Linux Installation
  • 1.3.2 Completing a Default Linux Installation
  • 1.3.3 About the Oracle Validated Configuration RPM
  • 1.3.4 Installing the Oracle Validated Configuration RPM
• 1.4 Installation Considerations
  • 1.4.1 Hardware and Software Certification
    • 1.4.1.1 Third-Party Database Certification for SQL Developer
  • 1.4.2 Multiple Oracle Homes Support
    • 1.4.2.1 Installing the Software on a System with an Existing Oracle Installation
  • 1.4.3 Grid Infrastructure for a Standalone Server
  • 1.4.4 Oracle Cluster Synchronization Services
  • 1.4.5 Installing Oracle Database Vault in an Oracle Data Guard Environment
  • 1.4.6 Oracle Database Vault Default Audit Policy and Initialization Parameters
• 1.5 Oracle Database Installation Methods
  • 1.5.1 Interactive Installation Types
  • 1.5.2 Automated Installation Methods Using Response Files
• 1.6 Oracle Database Editions
• 1.7 Database Configuration Options
  • 1.7.1 Preconfigured Database Types
  • 1.7.2 Installation Choices that Affect Database Creation
  • 1.7.3 Creating a Database After Installation
• 1.8 Database Storage Options
  • 1.8.1 File System
  • 1.8.2 Automatic Storage Management
• 1.9 Database Management Options
  • 1.9.1 Management Options for Preconfigured Databases
  • 1.9.2 Management Options for Custom Databases
  • 1.9.3 Features Provided by Oracle Enterprise Manager Database Control
• 1.10 Database Backup and Recovery Options
  • 1.10.1 Enabling Automated Backups
  • 1.10.2 Backup Job Default Settings
• 1.11 E-mail Notification Options
• 1.12 Migration Consideration
• 1.13 Upgrade Considerations
  • 1.13.1 Upgrading an Oracle Database Installed on Red Hat Enterprise Linux 2.1
  • 1.13.2 Automatic Storage Management Is Installed with Oracle Grid Infrastructure
  • 1.13.3 Daylight Savings Time Upgrade

2 Oracle Database Preinstallation Requirements

• 2.1 Logging In to the System as root
• 2.2 Checking the Hardware Requirements
  • 2.2.1 Memory Requirements
  • 2.2.2 System Architecture
  • 2.2.3 Disk Space Requirements
  • 2.2.4 Display Requirements
  • 2.2.5 Run Level Requirement
  • 2.2.6 Recommended Hardware Requirement for SQL Developer
• 2.3 Checking the Software Requirements
  • 2.3.1 Operating System Requirements
  • 2.3.2 Kernel Requirements
  • 2.3.3 Package Requirements
  • 2.3.4 Compiler Requirements
  • 2.3.5 Additional Software Requirements
    • 2.3.5.1 Oracle ODBC Drivers
    • 2.3.5.2 Oracle JDBC/OCI Drivers
    • 2.3.5.3 Oracle Messaging Gateway
    • 2.3.5.4 Browser Requirements
• 2.4 Preinstallation Requirement for Oracle Database Vault
• 2.5 Installation Fixup Scripts
• 2.6 Checking the Network Setup
  • 2.6.1 Installing on DHCP Computers
  • 2.6.2 Installing on Multihomed Computers
  • 2.6.3 Installing on Computers with Multiple Aliases
  • 2.6.4 Installing on Non-Networked Computers
• 2.7 Creating Required Operating System Groups and Users
  • 2.7.1 Creating Custom Configuration Groups and Users for Job Roles
    • 2.7.1.1 Users for Oracle Installations with Job Role Separation
    • 2.7.1.2 Database Groups for Job Role Installations
    • 2.7.1.3 Grid Infrastructure Groups for Job Role Installations
  • 2.7.2 Creating Database Operating System Groups and Users with Job Role Separation
    • 2.7.2.1 Creating the Oracle Inventory Group
    • 2.7.2.2 Creating the OSDBA Group for Database Installations
    • 2.7.2.3 Creating an OSOPER Group for Database Installation
    • 2.7.2.4 Creating the OSASM Group for Automatic Storage Management
    • 2.7.2.5 Creating the OSDBA Group for Oracle Grid Infrastructure
    • 2.7.2.6 Creating the OSOPER Group for Automatic Storage Management
    • 2.7.2.7 Creating the Oracle Software Owner User
• 2.8 Configure Oracle Installation Owner Shell Limits
• 2.9 Configuring Kernel Parameters
  • 2.9.1 Displaying and Changing Kernel Parameter Values
• 2.10 Identifying Required Software Directories
  • 2.10.1 Oracle Base Directory
  • 2.10.2 Oracle Inventory Directory
  • 2.10.3 Oracle Home Directory
• 2.11 Identifying or Creating an Oracle Base Directory
  • 2.11.1 Identifying an Existing Oracle Base Directory
  • 2.11.2 Creating an Oracle Base Directory
• 2.12 Choosing a Storage Option for Oracle Database and Recovery Files
• 2.13 Creating Directories for Oracle Database or Recovery Files
  • 2.13.1 Guidelines for Placing Oracle Database Files on a File System
  • 2.13.2 Creating Required Directories
• 2.14 Configuring Storage for Oracle Database Files Using Block Devices
• 2.15 Configuring Disk Devices for Oracle Database
  • 2.15.1 Example of Creating a Udev Permissions File for Oracle Database
  • 2.15.2 Example of Configuring Block Device Storage for Oracle Database
• 2.16 Stopping Existing Oracle Processes
• 2.17 Configuring the oracle User's Environment

3 Oracle Grid Infrastructure

• 3.1 Requirements for Oracle Grid Infrastructure Installation
  • 3.1.1 Memory Requirements
  • 3.1.2 Disk Space Requirements
  • 3.1.3 Configuring the User's Environment
• 3.2 Oracle ACFS and Oracle ADVM Support
• 3.3 Migrating Existing Automatic Storage Management Instances
• 3.4 Automatic Storage Management Installation Considerations
• 3.5 Preparing Disks for an Automatic Storage Management Installation
  • 3.5.1 General Steps for Configuring Automatic Storage Management
  • 3.5.2 Step 1: Identifying Storage Requirements for Automatic Storage Management
  • 3.5.3 Step 2: Using an Existing Automatic Storage Management Disk Group
  • 3.5.4 Step 3: Creating DAS or SAN Disk Partitions for Automatic Storage Management
  • 3.5.5 Step 4: Configuring Disks for Automatic Storage Management
    • 3.5.5.1 Configuring Disks for Automatic Storage Management Using the Automatic Storage Management Library Driver (ASMLIB)
• 3.6 Installing and Configuring Grid Infrastructure for a Standalone Server
  • 3.6.1 Installing Grid Infrastructure with a New Database Installation
  • 3.6.2 Installing Grid Infrastructure for an Existing Database
• 3.7 Manually Configuring Oracle Automatic Storage Management Disk Groups
• 3.8 Testing the Automatic Storage Management Installation

4 Installing Oracle Database

• 4.1 Preinstallation Considerations
  • 4.1.1 Performing Multiple Oracle Database Installations in Response File or Silent Mode
• 4.2 Reviewing Component-Specific Installation Guidelines
  • 4.2.1 Selecting the Database Character Set
• 4.3 Accessing the Installation Software
  • 4.3.1 Downloading Oracle Software
    • 4.3.1.1 Downloading the Installation Archive Files from OTN
    • 4.3.1.2 Downloading the Software from Oracle E-Delivery
    • 4.3.1.3 Extracting the Installation Files
  • 4.3.2 Copying the Software to the Hard Disk
    • 4.3.2.1 Mounting Disks
    • 4.3.2.2 Copying the Oracle Database Software to a Hard Disk
• 4.4 Database Security Options
• 4.5 Installing the Oracle Database Software
  • 4.5.1 Running Oracle Universal Installer
• 4.6 Installing Oracle Database Examples

5 Oracle Database Postinstallation Tasks

• 5.1 Required Postinstallation Tasks
  • 5.1.1 Downloading and Installing Patches
• 5.2 Recommended Postinstallation Tasks
  • 5.2.1 Creating a Backup of the root.sh Script
  • 5.2.2 Configuring New or Upgraded Databases
  • 5.2.3 Creating and Configuring Additional Operating System Accounts
    • 5.2.3.1 Configuring the Accounts of Oracle Users
  • 5.2.4 Setting the NLS_LANG Environment Variable
  • 5.2.5 Generating the Client Static Library
  • 5.2.6 Guidelines for Setting Semaphore Parameters
  • 5.2.7 Create a Fast Recovery Area Disk Group
    • 5.2.7.1 About the Fast Recovery Area and the Fast Recovery Area Disk Group
    • 5.2.7.2 Creating the Fast Recovery Area Disk Group
• 5.3 Required Product-Specific Postinstallation Tasks
  • 5.3.1 Configuring Oracle Net Services
  • 5.3.2 Configuring Oracle Label Security
  • 5.3.3 Configuring Oracle Database Vault
  • 5.3.4 Configuring Oracle Messaging Gateway
    • 5.3.4.1 Modifying the listener.ora File for External Procedures
    • 5.3.4.2 Modifying the tnsnames.ora File for External Procedures
    • 5.3.4.3 Setting Up the mgw.ora Initialization File
  • 5.3.5 Configuring Oracle Precompilers
    • 5.3.5.1 Configuring Pro*C/C++
    • 5.3.5.2 Configuring Pro*FORTRAN
  • 5.3.6 Configuring Secure Sockets Layer
  • 5.3.7 Installing Oracle Text Supplied Knowledge Bases
  • 5.3.8 Configuring or Reinstalling Oracle XML DB
  • 5.3.9 Configuring and Using Direct NFS Client
    • 5.3.9.1 Direct NFS Client
• 5.4 Postinstallation Tasks for SQL Developer
  • 5.4.1 Migrating User Settings from Release 1.0
  • 5.4.2 Migrating Information from Previous Releases
  • 5.4.3 Location of User-Related Information

6 Getting Started with Oracle Database

• 6.1 Checking the Installed Oracle Database Contents and Directory Location
• 6.2 Logging In to Oracle Enterprise Manager Database Control
• 6.3 Managing Automatic Storage Management
  • 6.3.1 Starting and Stopping Automatic Storage Management
  • 6.3.2 Automatic Storage Management Utilities
• 6.4 Accessing Oracle Database with SQL*Plus
• 6.5 Accessing Oracle Database with SQL Developer
• 6.6 Reviewing Accounts and Passwords
• 6.7 Unlocking and Resetting User Passwords
  • 6.7.1 Using Database Control to Unlock Accounts and Reset Passwords
  • 6.7.2 Using SQL*Plus to Unlock Accounts and Reset Passwords
  • 6.7.3 Unlocking and Changing Passwords
• 6.8 Identifying Databases
• 6.9 Locating the Server Parameter File
• 6.10 Reviewing Tablespaces and Data Files, Redo Log Files, and Control Files
  • 6.10.1 Identifying Tablespaces and Data Files
  • 6.10.2 Locating Redo Log Files
  • 6.10.3 Locating Control Files

7 Removing Oracle Database Software

• 7.1 Reconfiguring Oracle Cluster Synchronization Services
• 7.2 Removing Oracle Software Using the Deinstallation Tool
  • 7.2.1 About the Deinstallation Tool
  • 7.2.2 Example of Running the Deinstall Command for an Oracle Database
  • 7.2.3 Example of a Deinstallation Parameter File for Oracle Database
  • 7.2.4 Example of a Deinstallation Parameter File for Oracle Grid Infrastructure for a Standalone Server
  • 7.2.5 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 Response File 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 Net Configuration Assistant Using a Response File
• A.6 Running Database Configuration Assistant Using a Response File
  • A.6.1 Using Database Configuration Assistant in Response File Mode
  • A.6.2 Using Database Configuration Assistant in Silent Mode
  • A.6.3 Running Database Configuration Assistant in Response File or Silent Mode
• A.7 Postinstallation Configuration Using a Response File
  • A.7.1 About the Postinstallation Configuration File
  • A.7.2 Running Postinstallation Configuration Using a Response File

B Cloning an Oracle Home

• B.1 Cloning an Oracle Home
• B.2 Configuring Oracle Configuration Manager in a Cloned Oracle Home

C Using NAS Devices

• C.1 General Configuration Guidelines for NAS Devices
• C.2 NFS Feature Description
• C.3 Choosing Mount Points
  • C.3.1 Choosing Mount Points for Oracle Software Files
  • C.3.2 Choosing Mount Points for Oracle Database and Recovery Files
• C.4 Creating Files on a NAS Device for Use with Automatic Storage Management
• C.5 NFS Mount Options

D Optimal Flexible Architecture

• D.1 Overview of the Optimal Flexible Architecture Standard
• D.2 Implementing Optimal Flexible Architecture
  • D.2.1 File Systems
    • D.2.1.1 Number of File Systems
    • D.2.1.2 Naming Conventions
  • D.2.2 Naming Directories
    • D.2.2.1 Oracle Base Directory Naming Convention
    • D.2.2.2 Naming Mount Points for Very Large Databases (VLDBs)
    • D.2.2.3 Referring to Path Names
    • D.2.2.4 Oracle Home Directory Naming Convention
    • D.2.2.5 Naming Subdirectories
  • D.2.3 Naming Database Files
  • D.2.4 Separating Segments with Different Requirements
  • D.2.5 Exploiting the Optimal Flexible Architecture Structure for Oracle Files
  • D.2.6 Optimal Flexible Architecture File Mapping

E Managing Oracle Database Port Numbers

• E.1 About Managing Ports
• E.2 Viewing Port Numbers and Access URLs
• E.3 Port Numbers and Protocols of Oracle Components
• E.4 Changing the Oracle Enterprise Management Agent Port
• E.5 Changing the Oracle Enterprise Manager Database Control Ports
• E.6 Changing the Oracle XML DB Ports

F Configuring Oracle Database Globalization Support

• F.1 Installing and Using Oracle Components in Different Languages
  • F.1.1 Configuring Oracle Components to Run in Different Languages
    • F.1.1.1 Determining the Operating System Locale by Using the LANG Environment Variable
    • F.1.1.2 Configuring Locale and Character Sets by Using the NLS_LANG Environment Variable
  • F.1.2 Installing Translation Resources
• F.2 Running Oracle Universal Installer in Different Languages

G Troubleshooting

• G.1 Verify Requirements
• G.2 X Window Display Errors
• G.3 Remote Terminal Installation Error
• G.4 What to Do If an Installation Error Occurs?
• G.5 Reviewing the Log of an Installation Session
• G.6 Troubleshooting Host Name Changes and CSS
• G.7 Troubleshooting Configuration Assistants
  • G.7.1 Configuration Assistant Failure
  • G.7.2 Irrecoverable Errors
• G.8 Troubleshooting Inventory Issues
• G.9 Troubleshooting Screen Display Issues
• G.10 Silent-Mode Response File Error Handling
• G.11 Cleaning Up After a Failed Installation

H Frequently Asked Questions About Installation

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

I Country Codes

• I.1 Valid Country Codes

Glossary

Index