1/21

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 Components Available for Installation
• Changes in the Install Options
• Database Configuration Assistant
• Database Upgrade Assistant
• Automatic Storage Management Fast Mirror Resync
• SYSASM Privilege for Automatic Storage Management Administration
• Automatic Maintenance Tasks Management
• Automatic Diagnostic Repository
• Enhanced Optimal Flexible Architecture
• Oracle Direct Network File System Client
• Deprecated Components in Oracle Database 11g Release 1 (11.1)

1 Overview of Oracle Database Installation

• 1.1 Planning the Installation
• 1.2 New Oracle Products Installed with This Release
  • 1.2.1 Oracle Application Express
  • 1.2.2 Oracle Warehouse Builder
  • 1.2.3 Oracle Configuration Manager
  • 1.2.4 Oracle Database Vault
• 1.3 Installation Considerations
  • 1.3.1 Hardware and Software Certification
  • 1.3.2 Multiple Oracle Homes Support
    • 1.3.2.1 Installing the Software on a System with an Existing Oracle Installation
  • 1.3.3 Oracle Cluster Synchronization Services
  • 1.3.4 Using Network Attached Storage or NFS File Systems
  • 1.3.5 Default Audit Policy and Initialization Parameters
• 1.4 Oracle Database Installation Methods
  • 1.4.1 Interactive Installation Methods
  • 1.4.2 Automated Installation Methods Using Response Files
• 1.5 Oracle Database Installation Types
• 1.6 Database Configuration Options
  • 1.6.1 Preconfigured Database Types
  • 1.6.2 Installation Choices that Affect Database Creation
  • 1.6.3 Creating a Database After Installation
• 1.7 Database Storage Options
  • 1.7.1 File System
  • 1.7.2 Automatic Storage Management
  • 1.7.3 Raw Devices
• 1.8 Database Management Options
  • 1.8.1 Management Options for Preconfigured Databases
  • 1.8.2 Management Options for Custom Databases
  • 1.8.3 Features Provided by Oracle Enterprise Manager Database Control
• 1.9 Database Backup and Recovery Options
  • 1.9.1 Enabling Automated Backups
  • 1.9.2 Backup Job Default Settings
• 1.10 E-mail Notification Options
• 1.11 Upgrade Considerations
  • 1.11.1 AL24UTFFSS Character Set

2 Preinstallation Tasks

• 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.3 Checking the Software Requirements
  • 2.3.1 Operating System Requirements
  • 2.3.2 Package Requirements
  • 2.3.3 Compiler Requirements
  • 2.3.4 Additional Software Requirements
    • 2.3.4.1 Oracle Messaging Gateway
    • 2.3.4.2 Oracle JDBC/OCI Drivers
    • 2.3.4.3 Browser Requirements
    • 2.3.4.4 Oracle XML DB for Oracle Application Express
    • 2.3.4.5 PL/SQL Web Toolkit
    • 2.3.4.6 Oracle Text
  • 2.3.5 Patch Requirements
    • 2.3.5.1 Operating system-specific patches
• 2.4 Preinstallation Requirements for Oracle Configuration Manager
• 2.5 Checking the Network Setup
  • 2.5.1 Configuring Name Resolution
  • 2.5.2 Installing on DHCP Computers
  • 2.5.3 Installing on Multihomed Computers
  • 2.5.4 Installing on Computers with Multiple Aliases
  • 2.5.5 Installing on Non-Networked Computers
• 2.6 Creating Required Operating System Groups and Users
  • 2.6.1 Creating the Oracle Inventory Group
  • 2.6.2 Creating the OSDBA Group
  • 2.6.3 Creating an OSOPER Group (Optional)
  • 2.6.4 Creating the Oracle Software Owner User
    • 2.6.4.1 Determining Whether an Oracle Software Owner User Exists
    • 2.6.4.2 Creating an Oracle Software Owner User
    • 2.6.4.3 Modifying an Oracle Software Owner User
  • 2.6.5 Verifying that the User nobody Exists
• 2.7 Configure Shell Limits
• 2.8 Configuring Kernel Parameters
  • 2.8.1 Configuring Kernel Parameters On Solaris 9
  • 2.8.2 Configuring Kernel Parameters on Solaris 10
• 2.9 Identifying Required Software Directories
  • 2.9.1 Oracle Base Directory
  • 2.9.2 Oracle Inventory Directory
  • 2.9.3 Oracle Home Directory
• 2.10 Identifying or Creating an Oracle Base Directory
  • 2.10.1 Identifying an Existing Oracle Base Directory
  • 2.10.2 Creating an Oracle Base Directory
• 2.11 Choosing a Storage Option for Oracle Database and Recovery Files
• 2.12 Creating Directories for Oracle Database or Recovery Files
  • 2.12.1 Guidelines for Placing Oracle Database Files on a File System
  • 2.12.2 Creating Required Directories
• 2.13 Preparing Disk Groups for an Automatic Storage Management Installation
  • 2.13.1 General Steps for Configuring Automatic Storage Management
  • 2.13.2 Step 1: Identifying Storage Requirements for Automatic Storage Management
  • 2.13.3 Step 2: Using an Existing Automatic Storage Management Disk Group
  • 2.13.4 Step 3: Creating DAS or SAN Disk Partitions for Automatic Storage Management
  • 2.13.5 Step 4: Configuring Disks for Automatic Storage Management
• 2.14 Stopping Existing Oracle Processes
• 2.15 Configuring the oracle User's Environment

3 Installing Oracle Database

• 3.1 Preinstallation Considerations
  • 3.1.1 Performing Multiple Oracle Database Installations in Noninteractive Mode
• 3.2 Reviewing Installation Guidelines
  • 3.2.1 Selecting the Database Character Set
  • 3.2.2 Installing the Sample Schemas
• 3.3 Accessing the Installation Software
  • 3.3.1 Downloading Oracle Software from the Oracle Technology Network 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 Disks
    • 3.3.2.2 Copying the Oracle Database Software to a Hard Disk
• 3.4 Database Security Options
• 3.5 Installing the Oracle Database Software
  • 3.5.1 Running Oracle Universal Installer
• 3.6 Installing Automatic Storage Management
  • 3.6.1 Step 1: Reviewing Automatic Storage Management Installation Considerations
  • 3.6.2 Step 2: Installing the Automatic Storage Management Instance and configuring Disk Groups
  • 3.6.3 Step 3: Installing Oracle Database to Use Automatic Storage Management
  • 3.6.4 Step 4: Testing the Automatic Storage Management Installation
• 3.7 Installing Oracle Database Examples

4 Oracle Database 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.2.6 Direct NFS Client
    • 4.2.6.1 Enabling Direct NFS Client
    • 4.2.6.2 Disabling Direct NFS Client
    • 4.2.6.3 Checking NFS Buffer Size Parameters
• 4.3 Required Product-Specific Postinstallation Tasks
  • 4.3.1 Configuring Oracle Net Services
  • 4.3.2 Configuring Oracle Label Security
  • 4.3.3 Configuring Oracle Database Vault
  • 4.3.4 Configuring Oracle Messaging Gateway
    • 4.3.4.1 Modifying the listener.ora File for External Procedures
    • 4.3.4.2 Modifying the tnsnames.ora File for External Procedures
    • 4.3.4.3 Setting Up the mgw.ora Initialization File
  • 4.3.5 Configuring Oracle Precompilers
    • 4.3.5.1 Configuring Pro*C/C++
    • 4.3.5.2 Configuring Pro*FORTRAN
  • 4.3.6 Configuring Secure Sockets Layer
  • 4.3.7 Installing Oracle Text Supplied Knowledge Bases
• 4.4 Postinstallation Tasks for Oracle Application Express
  • 4.4.1 Restarting Processes
  • 4.4.2 Choosing an HTTP Server
    • 4.4.2.1 About the Embedded PL/SQL Gateway
    • 4.4.2.2 About Oracle HTTP Server and mod_plsql
    • 4.4.2.3 About Password Security
  • 4.4.3 Configuring the Embedded PL/SQL Gateway
    • 4.4.3.1 Configuring the Embedded PL/SQL Gateway in New Installation or When Upgrading Database
    • 4.4.3.2 Disabling and Enabling the Oracle XML DB HTTP Server
  • 4.4.4 Copying the Images Directory
    • 4.4.4.1 Copying the Images Directory After an Upgrade
    • 4.4.4.2 Copying the Images Directory After a New Installation
  • 4.4.5 Configuring Oracle HTTP Server in a New Installation
    • 4.4.5.1 Configuring Oracle HTTP Server Release 9.0.3 in a New Installation
    • 4.4.5.2 Configuring Oracle HTTP Server distributed with Oracle Database 11g or Oracle Application Server 10g in a New Installation
  • 4.4.6 Enabling Network Services in Oracle Database 11g
  • 4.4.7 Running Oracle Application Express in Other Languages
    • 4.4.7.1 Installing a Translated Version of Oracle Application Express
  • 4.4.8 Managing JOB_QUEUE_PROCESSES
    • 4.4.8.1 Viewing the Number of JOB_QUEUE_PROCESSES
    • 4.4.8.2 Changing the Number of JOB_QUEUE_PROCESSES
  • 4.4.9 Obfuscating PlsqlDatabasePassword Parameter
    • 4.4.9.1 Obfuscating Passwords
  • 4.4.10 Logging In to Oracle Application Express
    • 4.4.10.1 Oracle Application Express User Roles
    • 4.4.10.2 Setting Up Your Local Environment
  • 4.4.11 Patching Oracle Application Express 3.0
• 4.5 Postinstallation Database Configuration for Oracle Configuration Manager
  • 4.5.1 Preparing Pre-9.2 Databases
  • 4.5.2 Instrumenting the Database for Configuration Collections
  • 4.5.3 Additional Step for E-Business Suites
  • 4.5.4 Additional Step for Oracle Enterprise Manager Grid Control

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 Accessing Oracle Database with SQL*Plus
• 5.5 Accessing Oracle Database with SQL Developer
• 5.6 Reviewing Accounts and Passwords
• 5.7 Unlocking and Resetting User Passwords
  • 5.7.1 Using Database Control to Unlock Accounts and Reset Passwords
  • 5.7.2 Using SQL*Plus to Unlock Accounts and Reset Passwords
  • 5.7.3 Unlocking and Changing Passwords
• 5.8 Identifying Databases
• 5.9 Locating the Server Parameter File
• 5.10 Reviewing Tablespaces and Data Files, Redo Log Files, and Control Files
  • 5.10.1 Identifying Tablespaces and Data Files
  • 5.10.2 Locating Redo Log Files
  • 5.10.3 Locating Control Files

6 Removing Oracle Software

• 6.1 Overview
• 6.2 Identifying All Instances
• 6.3 Removing Oracle Configuration Manager
• 6.4 Removing Oracle Application Express from the Database
• 6.5 Removing an Oracle Database
• 6.6 Removing an Automatic Storage Management Instance
• 6.7 Reconfiguring Oracle Cluster Synchronization Services
  • 6.7.1 Identifying Oracle Database 11g Oracle Homes
  • 6.7.2 Reconfiguring the Oracle CSS Daemon
  • 6.7.3 Deleting the Oracle CSS Daemon Configuration
• 6.8 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 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 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 Cloning an 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 Console Ports
• E.6 Changing the Oracle Ultra Search Ports
• E.7 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 What to Do If an Installation Error Occurs?
• G.4 Reviewing the Log of an Installation Session
• G.5 Troubleshooting Host Name Changes and CSS
• G.6 Troubleshooting Oracle Configuration Manager
• G.7 Troubleshooting Configuration Assistants
  • G.7.1 Configuration Assistant Failure
  • G.7.2 Fatal Errors
• G.8 Silent-Mode Response File Error Handling
• G.9 Cleaning Up After a Failed Installation
• G.10 After Failed Upgrade Installation
  • G.10.1 Reverting to Earlier Release
  • G.10.2 After a Failed New Installation
• G.11 Images Displaying Incorrectly in Oracle Application Express
• G.12 Online Help Not Working

H Frequently Asked Questions About Installation

• H.1 Installing Oracle Database or 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)

I Country Codes

• I.1 Valid Country Codes

Glossary

Index