Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

What's New in Oracle Database for Windows?

• Oracle Database Support on Windows Vista and Windows Server 2008
• Oracle Database 10g Release 2 (10.2) New Features for Windows
• Oracle Database 10g Release 2 (10.2) Deprecated Components
• Oracle Database 10g Release 1 (10.1) New Features for Windows
• Oracle Database 10g Release 1 (10.1) Deprecated Components

1 Overview of Oracle Database Installation

• Planning Your Installation
• Oracle Database Installation Types
• Oracle Database Installation Methods
• Installation Considerations
  • Licensing Information
  • Installation Differences Between Windows and UNIX Systems
  • Recommended File System
  • Managing User Accounts with User Account Control on Windows Vista and Windows Server 2008
  • Oracle Cluster Synchronization Services
  • Oracle Universal Installer Overview
  • Oracle Base Directory
  • Oracle Home Directory
    • Contents of the Oracle Home Environment
    • Multiple Oracle Home Components
    • Multiple Oracle Home Support
• Database Configuration Options
  • Preconfigured Database Types
  • Oracle Database Configuration Assistant Behavior During Database Installation
  • Creating a Database After Installation
• Database Storage Options
  • File System
  • Automatic Storage Management
    • Automatic Storage Management Components
    • General Steps for Installing Automatic Storage Management
• Database Management Options
  • Oracle Enterprise Manager
  • Oracle Enterprise Manager Database Control
  • Management Options for Preconfigured Databases
  • Management Options for Custom Databases
• Database Backup and Recovery Options
  • Enabling Automated Backups
  • Backup Job Default Settings
• E-mail Notification Options
• Upgrade Considerations
  • Upgrading Databases that Use the AL24UTFFSS Character Set
  • Policies for Linking and Relinking Applications
  • Oracle Real Application Clusters Upgrade Requirements
  • Downgrading a Database

2 Oracle Database Preinstallation Requirements

• Oracle Database Hardware Requirements
  • Hardware Component Requirements
  • Hard Disk Space Requirements
  • Verifying Hardware Requirements
• Oracle Database Software Requirements
• Oracle Database Hardware and Software Certification
  • Windows Telnet Services Support
  • Windows Terminal Services and Remote Desktop Support
  • Components Supported on Windows x64 Operating Systems
  • Web Browser Support
• Oracle Database Network Topics
  • Installing Oracle Database on DHCP Computers
  • Installing Oracle Database on Computers with Multiple IP Addresses
  • Installing Oracle Database on Computers with Multiple Aliases
  • Installing Oracle Database on Non-Networked Computers
  • Installing a Loopback Adapter
    • Checking if a Loopback Adapter Is Installed on Your Computer
    • Installing a Loopback Adapter on Windows 2003 or Windows XP
    • Installing a Loopback Adapter on Windows Vista and Windows Server 2008
    • Removing a Loopback Adapter
• Individual Component Requirements
  • Configuring Disk Storage for Oracle Data Files and Recovery Files
    • Choosing a Storage Option for Oracle Data Files
    • Choosing a Storage Option for Oracle Database Recovery Files
    • Configuring Disk Storage
  • Creating Directories for Oracle Data Files or Recovery Files
    • Guidelines for Placing Oracle Data Files on a File System
    • Guidelines for Placing Oracle Recovery Files on a File System
    • Creating Required Directories
  • Preparing Disk Groups for an Automatic Storage Management Installation
    • General Steps for Preparing Disk Groups for an ASM Installation
    • Step 1: Identifying Storage Requirements for Automatic Storage Management
    • Step 2 (Optional): Using an Existing Automatic Storage Management Disk Group
    • Step 3: Creating DAS or SAN Disk Partitions for an ASM Instance
    • Step 4: Manually Configuring Disks for Automatic Storage Management
  • Stopping Existing Oracle Services
  • Oracle Advanced Security Requirements
  • Oracle-Managed Files Requirements
  • Oracle Real Application Clusters

3 Installing Oracle Database

• Preinstallation Considerations for Installing Oracle Database
  • Installation Considerations on Windows Vista and Windows Server 2008
  • Performing Multiple Oracle Database Installations
  • Installing onto Systems That Already Have Oracle Components
  • Installing with Minimum Memory Requirements
• Reviewing Component-Specific Installation Guidelines
• Accessing the Installation Software
  • Installing from a Remote DVD Drive
    • Step 1: On the Remote Computer, Share the DVD Drive
    • Step 2: On the Local Computer, Map the DVD Drive
  • Installing on Remote Computers Through Remote Access Software
    • Installing on Remote Computers from a Hard Drive
    • Installing on Remote Computers from a Remote DVD Drive
  • Downloading Oracle Software from the Oracle Technology Network Web Site
  • Copying the Oracle Database Software to a Hard Disk
• Installing the Oracle Database Software
• Installing Automatic Storage Management
  • Step 1: Reviewing Automatic Storage Management Installation Considerations
  • Step 2: Creating the ASM Instance and ASM Disk Groups
  • Step 3: Installing Oracle Database to Use with Automatic Storage Management
  • Step 4: Testing the Automatic Storage Management Installation
• Cloning an Oracle Home

4 Oracle Database Postinstallation Tasks

• Installing the Latest Patch Set Release
• Validating Invalid PL/SQL Modules
• Configuring Oracle Components
  • Configuring Oracle Administration Assistant for Windows
  • Installing Natively Compiled Java Libraries for Oracle JVM and Oracle interMedia
  • Running Oracle Cluster Synchronization Services from a Different Oracle Home
  • Configuring Oracle Counters for Windows Performance Monitor
  • Configuring Oracle Label Security
  • Configuring Oracle Net Services
  • Installing Oracle Text Supplied Knowledge Bases
  • Configuring or Reinstalling Oracle XML DB
  • Configuring PL/SQL External Procedures
  • Configuring Shared Server Support
  • Setting Credentials for the Job System to Work with Enterprise Manager
  • Configuring Oracle Database to Communicate with Automatic Storage Management
  • Configuring Databases to Use Oracle Enterprise Manager Database Control
  • Using Oracle9i Language and Definition Files with Oracle Database 10g Release 2 (10.2)
  • Installing Oracle Database Components from the Companion CD

5 Getting Started with Oracle Database

• Checking the Installed Oracle Database Contents and Directory Location
• Logging in to Enterprise Manager Database Control
  • Understanding Database Control Login Privileges
• Starting and Stopping an Oracle Database
  • Starting and Stopping the Database with Oracle Enterprise Manager Database Control
  • Starting and Stopping the Database with Oracle Administration Assistant for Windows
  • Starting and Stopping the Database from the Microsoft Windows Services Utility
• Managing Automatic Storage Management
  • Starting and Stopping Automatic Storage Management
  • Automatic Storage Management Utilities
• Accessing Oracle Database with SQL*Plus or iSQL*Plus
• Reviewing User Accounts and Passwords
  • Reviewing Administrative Accounts
  • Unlocking and Changing Passwords
    • Using SQL*Plus to Unlock and Change Passwords
    • Using Enterprise Manager Database Control to Unlock and Change Passwords
• Identifying Databases
• Locating the Server Parameter File
• Identifying Tablespaces and Data Files
• Locating Redo Log Files
• Locating Control Files
• Understanding Oracle Database Services on Windows

6 Removing Oracle Database Software

• Removing Oracle Cluster Synchronization Services
• Removing All Oracle Database Components
  • Stopping Oracle Services
  • Removing Components with Oracle Universal Installer
  • Manually Removing the Remaining Oracle Database Components
    • Removing an Automatic Storage Management Instance
    • Removing Oracle Keys from the Microsoft Registry Editor
    • Updating the System Variable Path
    • Removing Oracle from the Start Menu
    • Removing Oracle Directories

A Frequently Asked Questions about Installation

• Installing Oracle Database or Oracle Database Client
• Installing Oracle Database Tools
• Installing Oracle Database with Oracle Applications
• Installing Oracle Database Heterogeneous Connectivity Tools (Gateways)

B Optimal Flexible Architecture

• Overview of the Optimal Flexible Architecture Standard
  • Characteristics of an Optimal Flexible Architecture-Compliant Installation
• Changes to the Optimal Flexible Architecture for Oracle Database 10g
• Directory Tree Differences by Release
  • Top-Level Oracle Directory
  • Database File Names
  • Database File Name Extensions
• Optimal Flexible Architecture Directory Naming Conventions
  • ORACLE_BASE Directory
  • ORACLE_HOME Directory
  • ADMIN Directory
  • ORADATA Directory
  • FLASH_RECOVERY_AREA Directory
• Optimal Flexible Architecture and Multiple Oracle Home Configurations
  • Specifying an ORACLE_HOME Directory
  • Installing a Default Optimal Flexible Architecture Database: Example
  • Installing a Nondefault Optimal Flexible Architecture Database: Example 1
  • Installing a Nondefault Optimal Flexible Architecture Database: Example 2
• Increasing Reliability and Performance
  • Disk Mirroring
  • Disk Striping
  • Using Raw Partitions for Tablespaces
• Comparison Between Optimal Flexible Architecture on Windows and UNIX
  • Directory Naming
  • ORACLE_BASE Directory
  • Support for Symbolic Links on Windows

C Installing and Configuring Oracle Database Using Response Files

• How Response Files Work
  • Reasons for Using Silent Mode or Noninteractive Mode
  • General Procedure for Using Response Files
• Preparing a Response File
  • Editing a Response File Template
  • Recording a Response File
• Running Oracle Universal Installer Using the Response File
• Running Net Configuration Assistant Using a Response File
• Running Oracle Database Configuration Assistant Using a Response File

D Configuring Oracle Database Globalization Support

• Installing and Using Oracle Components in Different Languages
  • Running Oracle Universal Installer in Different Languages
  • Using Oracle Components in Different Languages
• Configuring Locale and Character Sets with the NLS_LANG Parameter
  • About the NLS_LANG Parameter
  • Default Values for NLS_LANG
  • NLS_LANG Settings in MS-DOS Mode and Batch Mode

E Managing Oracle Database Port Numbers

• About Managing Ports
• Viewing Port Numbers and Access URLS
• Port Numbers and Protocols of Oracle Components
• Changing the Oracle Enterprise Management Agent Port
• Changing the Oracle Enterprise Manager Database Console Ports
• Changing the iSQL*Plus Ports
• Changing the Oracle XML DB Ports

F Troubleshooting the Oracle Database Installation

• Verifying Requirements
• Encountering Installation Errors
• Reviewing the Log of an Installation Session
• Silent or Noninteractive Installation Response File Error Handling
• Troubleshooting Configuration Assistants
  • Configuration Assistant Failures
  • Fatal Errors
• Cleaning Up After a Failed Installation

Glossary

Index