Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

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

• New Grid Infrastructure Installation Option
• New Desktop and Server Class Options
• Daylight Savings Time Upgrade of Timestamp with Timezone Data Type
• SYSASM Privilege
• New Tool to Configure Custom Installation Options
• Deinstallation Tool
• Intelligent Data Placement
• Oracle Automatic Storage Management Cluster File System (Oracle ACFS)
• Data Pump Export and Data Pump Import
• Use Oracle Restart to Automatically Restart Your Database
• 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 Your Installation
• 1.3 Installation Considerations
  • 1.3.1 Installation Differences Between Windows and UNIX Systems
  • 1.3.2 Recommended File System
  • 1.3.3 Managing User Accounts with User Account Control
  • 1.3.4 Hardware and Software Certification
    • 1.3.4.1 Third-Party Database Certification for SQL Developer
  • 1.3.5 Multiple Oracle Homes Support
  • 1.3.6 Grid Infrastructure for a Standalone Server
  • 1.3.7 Oracle Cluster Synchronization Services
  • 1.3.8 Oracle Universal Installer Overview
  • 1.3.9 Oracle Base Directory
  • 1.3.10 Oracle Home Directory
    • 1.3.10.1 Contents of the Oracle Home Environment
    • 1.3.10.2 Multiple Oracle Home Components
  • 1.3.11 Installing Oracle Database Vault in an Oracle Data Guard Environment
  • 1.3.12 Oracle Database Vault Default Audit Policy and Initialization Parameters
• 1.4 Migration Considerations
• 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.8.2.1 Automatic Storage Management Components
• 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 Upgrade Considerations
  • 1.12.1 Automatic Storage Management Is Installed with Oracle Grid Infrastructure
  • 1.12.2 Daylight Savings Time Upgrade
  • 1.12.3 Policies for Client and Application Software Installations
  • 1.12.4 Downgrading a Database

2 Oracle Database Preinstallation Requirements

• 2.1 Oracle Database Hardware Requirements
  • 2.1.1 Hardware Component Requirements for Windows 32-Bit
  • 2.1.2 Hardware Component Requirements for Windows x64
  • 2.1.3 Hard Disk Space Requirements
  • 2.1.4 Verifying Hardware Requirements
• 2.2 Oracle Database Software Requirements
• 2.3 Windows Certification and Web Browser Support
  • 2.3.1 Windows Terminal Services and Remote Desktop Support
  • 2.3.2 Oracle Services for Microsoft Transaction Server
  • 2.3.3 Unsupported Components on 32-Bit Windows Client Operating Systems
  • 2.3.4 Unsupported Components on Windows x64
  • 2.3.5 Web Browser Support
• 2.4 Oracle Database Network Topics
  • 2.4.1 Installing Oracle Database on DHCP Computers
  • 2.4.2 Installing Oracle Database on Computers with Multiple IP Addresses
  • 2.4.3 Installing Oracle Database on Computers with Multiple Aliases
  • 2.4.4 Installing Oracle Database on Non-Networked Computers
  • 2.4.5 Installing a Loopback Adapter
    • 2.4.5.1 Checking if a Loopback Adapter Is Installed on Your Computer
    • 2.4.5.2 Installing a Loopback Adapter on Windows Server 2003, Windows Server 2003 R2, or Windows XP
    • 2.4.5.3 Installing a Loopback Adapter on Windows Vista and Windows Server 2008
    • 2.4.5.4 Installing a Loopback Adapter on Windows 7
    • 2.4.5.5 Removing a Loopback Adapter
• 2.5 Individual Component Requirements
  • 2.5.1 Configuring Disk Storage for Oracle Data Files and Recovery Files
    • 2.5.1.1 Choosing a Storage Option for Oracle Data Files
    • 2.5.1.2 Choosing a Storage Option for Oracle Database Recovery Files
    • 2.5.1.3 Configuring Disk Storage
  • 2.5.2 Creating Directories for Oracle Data Files or Recovery Files
    • 2.5.2.1 Guidelines for Placing Oracle Data Files on a File System
    • 2.5.2.2 Guidelines for Placing Oracle Recovery Files on a File System
    • 2.5.2.3 Creating Required Directories
  • 2.5.3 Stopping Existing Oracle Services
  • 2.5.4 Oracle Advanced Security Requirements
  • 2.5.5 Oracle Enterprise Manager Requirements
  • 2.5.6 Oracle-Managed Files Requirements
  • 2.5.7 Oracle Real Application Clusters (Oracle RAC)
  • 2.5.8 Oracle Volume Shadow Copy Service (VSS) Writer
  • 2.5.9 Preinstallation Requirement for Oracle Database Vault

3 Oracle Grid Infrastructure

• 3.1 Requirements for Oracle Grid Infrastructure Installation
  • 3.1.1 Memory Requirements
  • 3.1.2 Disk Space Requirements
• 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 3: Creating DAS or SAN Disk Partitions for an Automatic Storage Management Instance
  • 3.5.4 Step 4: Manually Configuring Disks for Automatic Storage Management
• 3.6 Installing and Configuring the 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 Modifying Oracle Grid Infrastructure Binaries After Installation
• 3.8 Manually Configuring Oracle Automatic Storage Management Disk Groups
• 3.9 Testing the Oracle Automatic Storage Management Installation

4 Installing Oracle Database

• 4.1 Preinstallation Considerations for Installing Oracle Database
  • 4.1.1 Installation Consideration on Windows Vista and Later
  • 4.1.2 Performing Multiple Oracle Database Installations
  • 4.1.3 Installing on Systems That Already Have Oracle Components
  • 4.1.4 Installing with Minimum Memory Requirements
• 4.2 Reviewing Component-Specific Installation Guidelines
  • 4.2.1 Selecting the Database Character Set
  • 4.2.2 Using an Automatic Storage Management Disk Group
• 4.3 Accessing the Installation Software
  • 4.3.1 Installing from a Remote DVD Drive
    • 4.3.1.1 Step 1: On the Remote Computer, Share the DVD Drive
    • 4.3.1.2 Step 2: On the Local Computer, Map the DVD Drive
  • 4.3.2 Installing on Remote Computers Through Remote Access Software
    • 4.3.2.1 Installing on Remote Computers from a Hard Drive
    • 4.3.2.2 Installing on Remote Computers from a Remote DVD Drive
  • 4.3.3 Downloading Oracle Software
    • 4.3.3.1 Downloading the Installation Archive Files from OTN
    • 4.3.3.2 Downloading the Software from Oracle E-Delivery
    • 4.3.3.3 Extracting the Installation Files
  • 4.3.4 Copying the Oracle Database Software to a Hard Disk
• 4.4 Database Security Options
• 4.5 Installing the Oracle Database Software
• 4.6 Cloning an Oracle Home

5 Oracle Database Postinstallation Tasks

• 5.1 Installing the Latest Patch Set Release
• 5.2 Validating Invalid PL/SQL Modules
• 5.3 Configuring Secure Sockets Layer
• 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
• 5.5 Configuring Oracle Components
  • 5.5.1 Direct NFS Client
    • 5.5.1.1 Enable Direct NFS Client
    • 5.5.1.2 Disable Direct NFS Client
    • 5.5.1.3 ORADNFS
  • 5.5.2 Configuring Oracle Messaging Gateway
  • 5.5.3 Configuring Oracle Administration Assistant for Windows
  • 5.5.4 Configuring Oracle Counters for Windows Performance Monitor
  • 5.5.5 Configuring Oracle Label Security
  • 5.5.6 Configuring Oracle Database Vault
  • 5.5.7 Configuring Oracle Net Services
  • 5.5.8 Installing Oracle Text Supplied Knowledge Bases
  • 5.5.9 Installing Oracle Text Filtering Component
  • 5.5.10 Configuring or Reinstalling Oracle XML DB
  • 5.5.11 Configuring PL/SQL External Procedures
  • 5.5.12 Configuring Shared Server Support
  • 5.5.13 Setting Credentials for the Job System to Work with Enterprise Manager
  • 5.5.14 Configuring Oracle Database to Communicate with Automatic Storage Management
  • 5.5.15 Configuring Databases to Use Oracle Enterprise Manager Database Control
  • 5.5.16 Installing Oracle Database Examples
• 5.6 Create a Fast Recovery Area Disk Group
  • 5.6.1 About the Fast Recovery Area and the Fast Recovery Area Disk Group
  • 5.6.2 Creating the Fast Recovery Area Disk Group
• 5.7 Enabling and Disabling Database Options

6 Getting Started with Oracle Database

• 6.1 Checking the Installed Oracle Database Contents and Directory Location
• 6.2 Logging in to Enterprise Manager Database Control
  • 6.2.1 Understanding Database Control Login Privileges
• 6.3 Managing Automatic Storage Management
  • 6.3.1 Starting and Stopping Automatic Storage Management
  • 6.3.2 Automatic Storage Management Utilities
• 6.4 Starting and Stopping an Oracle Database
  • 6.4.1 Starting and Stopping the Database with Oracle Enterprise Manager Database Control
  • 6.4.2 Starting and Stopping the Database with Oracle Administration Assistant for Windows
  • 6.4.3 Starting and Stopping the Database from the Microsoft Windows Services Utility
• 6.5 Accessing Oracle Database with SQL*Plus
• 6.6 Accessing Oracle Database with SQL Developer
• 6.7 Reviewing User Accounts and Passwords
  • 6.7.1 Reviewing Administrative Accounts
  • 6.7.2 Minimum Requirements for Passwords
    • 6.7.2.1 Using Enterprise Manager Database Control to Unlock and Change Passwords
    • 6.7.2.2 Using SQL*Plus to Unlock and Change Passwords
  • 6.7.3 Recommendations for Passwords
• 6.8 Identifying Databases
• 6.9 Locating the Server Parameter File
• 6.10 Identifying Tablespaces and Data Files
• 6.11 Locating Redo Log Files
• 6.12 Locating Control Files
• 6.13 Understanding Oracle Database Services on Windows

7 Removing Oracle Database Software

• 7.1 About the Deinstallation Tool
• 7.2 Downloading the Deinstallation Tool
• 7.3 Example of Running the Deinstall Command for an Oracle Database
• 7.4 Example of a Deinstallation Parameter File for an Oracle Database
• 7.5 Example of a Deinstallation Parameter File for Oracle Grid Infrastructure
• 7.6 Removing Oracle Software

A Installing Java Access Bridge

• A.1 Overview of Java Access Bridge
• A.2 Setup for JRE 1.5
• A.3 Setup for Oracle Installed Components
  • A.3.1 Installing Java Access Bridge
  • A.3.2 Configuring Oracle Components to Use Java Access Bridge

B Optimal Flexible Architecture

• B.1 Overview of the Optimal Flexible Architecture Standard
  • B.1.1 Advantages of Multiple Oracle Homes and OFA
• B.2 Changes to the Optimal Flexible Architecture for Oracle Database 11g
• B.3 Directory Tree Differences by Release
  • B.3.1 Top-Level Oracle Directory
  • B.3.2 Database File Names
  • B.3.3 Database File Name Extensions
• B.4 Optimal Flexible Architecture Directory Naming Conventions
  • B.4.1 ORACLE_BASE Directory
  • B.4.2 ORACLE_HOME Directory
  • B.4.3 ADMIN Directory
  • B.4.4 ORADATA Directory
  • B.4.5 RECOVERY_AREA Directory
• B.5 Optimal Flexible Architecture and Multiple Oracle Home Configurations
  • B.5.1 Specifying an ORACLE_HOME Directory
  • B.5.2 Installing a Default Optimal Flexible Architecture Database: Example
  • B.5.3 Installing a Nondefault Optimal Flexible Architecture Database: Example 2
• B.6 Comparison Between Optimal Flexible Architecture on Windows and UNIX
  • B.6.1 Directory Naming
  • B.6.2 ORACLE_BASE Directory
  • B.6.3 Support for Symbolic Links on Windows

C Installing and Configuring Oracle Database Using Response Files

• C.1 How Response Files Work
  • C.1.1 Reasons for Using Silent Mode or Response File Mode
  • C.1.2 General Procedure for Using Response Files
• C.2 Preparing a Response File
  • C.2.1 Editing a Response File Template
  • C.2.2 Recording a Response File
• C.3 Running Oracle Universal Installer Using the Response File
• C.4 Running Net Configuration Assistant Using a Response File
• C.5 Running Oracle Database Configuration Assistant Using a Response File
• C.6 Postinstallation Configuration Using a Response File
  • C.6.1 About the Postinstallation Configuration File
  • C.6.2 Running Postinstallation Configuration Using a Response File

D Configuring Oracle Database Globalization Support

• D.1 Installing and Using Oracle Components in Different Languages
  • D.1.1 Configuring Oracle Components to Run in Different Languages
    • D.1.1.1 Determining the Operating System Locale
    • D.1.1.2 Configuring Locale and Character Sets Using the NLS_LANG Environment Variable
    • D.1.1.3 NLS_LANG Settings in Console Mode and Batch Mode
  • D.1.2 Installing Translation Resources
• D.2 Running Oracle Universal Installer in Different Languages

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
• E.7 Changing the Oracle Services for Microsoft Transaction Server Port

F Troubleshooting the Oracle Database Installation

• F.1 Verifying Requirements
• F.2 Encountering Installation Errors
• F.3 Reviewing the Log of an Installation Session
• F.4 Silent Mode Response File Error Handling
• F.5 Troubleshooting Host Name Changes and CSS
• F.6 Troubleshooting Configuration Assistants
  • F.6.1 Configuration Assistant Failures
  • F.6.2 Irrecoverable Errors
• F.7 Troubleshooting Inventory Issues
• F.8 Troubleshooting Screen Display Issues
• F.9 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)

Glossary

Index