Contents

Title and Copyright Information

Preface

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

What's New in Oracle Database 11g Release 2 (11.2)

• Oracle Database 11g Release 2 (11.2.0.3) New Features and Enhancements
• Oracle Database 11g Release 2 (11.2.0.2) New Features
• Oracle Database 11g Release 2 (11.2.0.1) New Features
• 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 Installation Considerations
  • 1.3.1 Hardware and Software Certification
  • 1.3.2 Multiple Oracle Homes Support
    • 1.3.2.1 Installing Oracle Database on a System with an Existing Oracle Installation
  • 1.3.3 Oracle Grid Infrastructure for a Standalone Server
  • 1.3.4 Oracle Cluster Synchronization Services
  • 1.3.5 Installing Oracle Database Vault in an Oracle Data Guard Environment
  • 1.3.6 Oracle Database Vault Default Audit Policy and Initialization Parameters
• 1.4 Oracle Database Installation Methods
  • 1.4.1 Interactive Installation Types
  • 1.4.2 Automated Installation Methods Using Response Files
• 1.5 Software Updates Option
• 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 Oracle 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 Oracle ASM Installed with Oracle Grid Infrastructure
  • 1.13.2 Daylight Saving Time Upgrade
  • 1.13.3 Upgrading an Oracle Database in the Same Oracle Home

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 Disk Space Requirements
  • 2.2.3 Display Requirements
  • 2.2.4 Run Level Requirement
• 2.3 Checking the Software Requirements
  • 2.3.1 Operating System Requirements
  • 2.3.2 Compiler Requirements
  • 2.3.3 Additional Software Requirements
    • 2.3.3.1 Oracle ODBC Drivers
    • 2.3.3.2 Oracle JDBC/OCI Drivers
    • 2.3.3.3 Oracle Messaging Gateway
    • 2.3.3.4 Programming Languages
    • 2.3.3.5 Browser Requirements
    • 2.3.3.6 Oracle Database Vault Preinstallation Requirement
  • 2.3.4 Patch Requirement
• 2.4 Reviewing Operating System Security Common Practices
• 2.5 Installation Fixup Scripts
• 2.6 Verifying UDP and TCP Kernel Parameters
• 2.7 Checking the Network Setup
  • 2.7.1 Installing on DHCP Computers
  • 2.7.2 Installing on Multihomed Computers
  • 2.7.3 Installing on Computers with Multiple Aliases
  • 2.7.4 Installing on Non-Networked Computers
• 2.8 Creating Required Operating System Groups and Users
  • 2.8.1 Creating Custom Configuration Groups and Users for Job Roles
    • 2.8.1.1 Understanding Restrictions for Oracle Installations with Job Role Separation
    • 2.8.1.2 Database Groups for Job Role Installations
    • 2.8.1.3 Oracle Grid Infrastructure Groups for Job Role Installations
  • 2.8.2 Creating Database Operating System Groups and Users with Job Role Separation
    • 2.8.2.1 Creating the Oracle Inventory Group
    • 2.8.2.2 Creating the OSDBA Group for Database Installations
    • 2.8.2.3 Creating an OSOPER Group for Database Installations
    • 2.8.2.4 Creating the OSASM Group for Oracle Automatic Storage Management
    • 2.8.2.5 Creating the OSDBA Group for Oracle Automatic Storage Management
    • 2.8.2.6 Creating the OSOPER Group for Oracle Automatic Storage Management
    • 2.8.2.7 Creating the Oracle Software Owner User
    • 2.8.2.8 Creating the External Jobs User Account for HP-UX
• 2.9 Configuring Kernel Parameters on HP-UX Systems
• 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 Stopping Existing Oracle Processes
• 2.15 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 Managing Disk Groups for Older Database Versions
• 3.3 Migrating Existing Oracle Automatic Storage Management Instances
• 3.4 Oracle Automatic Storage Management Installation Considerations
• 3.5 Preparing Disks for an Oracle Automatic Storage Management Installation
  • 3.5.1 General Steps for Configuring Oracle Automatic Storage Management
  • 3.5.2 Step 1: Identifying Storage Requirements for Oracle Automatic Storage Management
  • 3.5.3 Step 2: Creating DAS or SAN Disk Partitions for Oracle Automatic Storage Management
  • 3.5.4 Step 3: Configuring Disks for Oracle Automatic Storage Management
• 3.6 Installing Oracle Grid Infrastructure Using a Software-Only Installation
  • 3.6.1 Installing the Software Binaries
  • 3.6.2 Configuring the Software Binaries
• 3.7 Installing and Configuring Oracle Grid Infrastructure for a Standalone Server
  • 3.7.1 Installing Oracle Grid Infrastructure with a New Database Installation
  • 3.7.2 Installing Oracle Grid Infrastructure for an Existing Database
• 3.8 Modifying Oracle Grid Infrastructure for a Standalone Server Binaries
• 3.9 Manually Configuring Oracle Automatic Storage Management Disk Groups
• 3.10 Testing the Oracle 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.2.2 Using an Oracle Automatic Storage Management Disk Group
• 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 Software Delivery Cloud
    • 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.1.2 Setting External Jobs Ownership for Installations
• 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 Creating 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.2.8 Enabling and Disabling Database Options
• 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

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 Oracle Automatic Storage Management
  • 6.3.1 Starting and Stopping Oracle Automatic Storage Management
  • 6.3.2 Oracle 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 About the Deinstallation Tool
• 7.2 Downloading the Deinstallation Tool for Use with Failed Installations
• 7.3 Example of Running the Deinstall Command
• 7.4 Deinstallation Parameter File Example for Oracle Database
• 7.5 Deinstallation Parameter File Example for Oracle Grid Infrastructure

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 Oracle 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 Saving 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 Oracle Automatic Storage Management
• C.5 NFS Mount Options

D Optimal Flexible Architecture

• D.1 Overview of the Optimal Flexible Architecture Standard
  • D.1.1 Advantages of Multiple Oracle Homes and OFA
• 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

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 Using NLS_LANG
  • 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 and Deconfiguring Oracle Restart
• G.7 Troubleshooting Host Name Changes and CSS
• G.8 Troubleshooting Configuration Assistants
  • G.8.1 Configuration Assistant Failure
  • G.8.2 Irrecoverable Errors
• G.9 Troubleshooting Inventory Issues
• G.10 Troubleshooting Screen Display Issues
• G.11 Silent-Mode Response File Error Handling
• G.12 Cleaning Up After a Failed Installation

H Frequently Asked Questions About Installation

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

Glossary

Index