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
• Oracle Database 10g Release 2 (10.2) New Features for Windows
• Oracle Data Provider for .NET New Features for Release 10.1.0.3
• 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

• 1.1 Planning Your Installation
• 1.2 Oracle Database Installation Types
• 1.3 Oracle Database Installation Methods
• 1.4 Installation Considerations
  • 1.4.1 Licensing Information
  • 1.4.2 Installation Differences Between Windows and UNIX Systems
  • 1.4.3 Managing User Accounts with User Account Control on Windows Vista
  • 1.4.4 Oracle Cluster Synchronization Services
  • 1.4.5 Oracle Universal Installer Overview
  • 1.4.6 Oracle Base Directory
  • 1.4.7 Oracle Home Directory
    • 1.4.7.1 Contents of the Oracle Home Environment
    • 1.4.7.2 Multiple Oracle Home Components
    • 1.4.7.3 Multiple Oracle Home Support
• 1.5 Database Configuration Options
  • 1.5.1 Preconfigured Database Types
  • 1.5.2 Oracle Database Configuration Assistant Behavior During Database Installation
  • 1.5.3 Creating a Database After Installation
• 1.6 Database Storage Options
  • 1.6.1 File System
  • 1.6.2 Automatic Storage Management
    • 1.6.2.1 Automatic Storage Management Components
    • 1.6.2.2 General Steps for Installing Automatic Storage Management
• 1.7 Database Management Options
  • 1.7.1 Oracle Enterprise Manager
  • 1.7.2 Oracle Enterprise Manager Database Control
  • 1.7.3 Management Options for Preconfigured Databases
  • 1.7.4 Management Options for Custom Databases
• 1.8 Database Backup and Recovery Options
  • 1.8.1 Enabling Automated Backups
  • 1.8.2 Backup Job Default Settings
• 1.9 E-mail Notification Options
• 1.10 Upgrade Considerations
  • 1.10.1 Upgrading Databases that Use the AL24UTFFSS Character Set
  • 1.10.2 Policies for Linking and Relinking Applications
  • 1.10.3 Oracle Real Application Clusters Upgrade Requirements
  • 1.10.4 Downgrading a Database

2 Oracle Database Preinstallation Requirements

• 2.1 Oracle Database Hardware Requirements
  • 2.1.1 Hardware Component Requirements
  • 2.1.2 Hard Disk Space Requirements
  • 2.1.3 Verifying Hardware Requirements
• 2.2 Oracle Database Software Requirements
• 2.3 Oracle Database Hardware and Software Certification
  • 2.3.1 Windows Telnet Services Support
  • 2.3.2 Windows Terminal Services and Remote Desktop Support
  • 2.3.3 Components Supported on Windows XP and Windows Vista
  • 2.3.4 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 2000
    • 2.4.5.3 Installing a Loopback Adapter on Windows 2003 or Windows XP
    • 2.4.5.4 Installing a Loopback Adapter on Windows Vista
    • 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 Preparing Disk Groups for an Automatic Storage Management Installation
    • 2.5.3.1 General Steps for Preparing Disk Groups for an ASM Installation
    • 2.5.3.2 Step 1: Identifying Storage Requirements for Automatic Storage Management
    • 2.5.3.3 Step 2 (Optional): Using an Existing Automatic Storage Management Disk Group
    • 2.5.3.4 Step 3: Creating DAS or SAN Disk Partitions for an ASM Instance
    • 2.5.3.5 Step 4: Manually Configuring Disks for Automatic Storage Management
  • 2.5.4 Stopping Existing Oracle Services
  • 2.5.5 Oracle Advanced Security Requirements
  • 2.5.6 Oracle Enterprise Manager Requirements
  • 2.5.7 Oracle-Managed Files Requirements
  • 2.5.8 Oracle Real Application Clusters
  • 2.5.9 Oracle Snap-Ins to the Microsoft Management Console Requirements

3 Installing Oracle Database

• 3.1 Preinstallation Considerations for Installing Oracle Database
  • 3.1.1 Installation Considerations on Windows Vista
  • 3.1.2 Performing Multiple Oracle Database Installations
  • 3.1.3 Installing onto Systems That Already Have Oracle Components
  • 3.1.4 Installing with Minimum Memory Requirements
• 3.2 Reviewing Component-Specific Installation Guidelines
• 3.3 Accessing the Installation Software
  • 3.3.1 Installing from a Remote DVD Drive
    • 3.3.1.1 Step 1: On the Remote Computer, Share the DVD Drive
    • 3.3.1.2 Step 2: On the Local Computer, Map the DVD Drive
  • 3.3.2 Installing on Remote Computers Through Remote Access Software
    • 3.3.2.1 Installing on Remote Computers from a Hard Drive
    • 3.3.2.2 Installing on Remote Computers from a Remote DVD Drive
  • 3.3.3 Downloading Oracle Software from the Oracle Technology Network Web Site
  • 3.3.4 Copying the Oracle Database Software to a Hard Disk
• 3.4 Installing the Oracle Database Software
• 3.5 Installing Automatic Storage Management
  • 3.5.1 Step 1: Reviewing Automatic Storage Management Installation Considerations
  • 3.5.2 Step 2: Creating the ASM Instance and ASM Disk Groups
  • 3.5.3 Step 3: Installing Oracle Database to Use with Automatic Storage Management
  • 3.5.4 Step 4: Testing the Automatic Storage Management Installation
• 3.6 Cloning an Oracle Home

4 Oracle Database Postinstallation Tasks

• 4.1 Installing the Latest Patch Set Release
• 4.2 Validating Invalid PL/SQL Modules
• 4.3 Configuring Oracle Components
  • 4.3.1 Configuring Oracle Messaging Gateway
  • 4.3.2 Configuring Oracle Administration Assistant for Windows
  • 4.3.3 Installing Natively Compiled Java Libraries for Oracle JVM and Oracle interMedia
  • 4.3.4 Running Oracle Cluster Synchronization Services from a Different Oracle Home
  • 4.3.5 Configuring Oracle Counters for Windows Performance Monitor
  • 4.3.6 Configuring Oracle Label Security
  • 4.3.7 Configuring Oracle Net Services
  • 4.3.8 Installing Oracle Text Supplied Knowledge Bases
  • 4.3.9 Configuring or Reinstalling Oracle XML DB
  • 4.3.10 Configuring PL/SQL External Procedures
  • 4.3.11 Configuring Shared Server Support
  • 4.3.12 Setting Credentials for the Job System to Work with Enterprise Manager
  • 4.3.13 Configuring Oracle Database to Communicate with Automatic Storage Management
  • 4.3.14 Configuring Databases to Use Oracle Enterprise Manager Database Control
  • 4.3.15 Using Oracle9i Language and Definition Files with Oracle Database 10g Release 2 (10.2)
  • 4.3.16 Configuring GNU Compiler Collection as the Primary Compiler
  • 4.3.17 Installing Oracle Database Components from the Companion CD

5 Getting Started with Oracle Database

• 5.1 Checking the Installed Oracle Database Contents and Directory Location
• 5.2 Logging in to Enterprise Manager Database Control
  • 5.2.1 Understanding Database Control Login Privileges
• 5.3 Starting and Stopping an Oracle Database
  • 5.3.1 Starting and Stopping the Database with Oracle Enterprise Manager Database Control
  • 5.3.2 Starting and Stopping the Database with Oracle Administration Assistant for Windows
  • 5.3.3 Starting and Stopping the Database from the Microsoft Windows Services Utility
• 5.4 Managing Automatic Storage Management
  • 5.4.1 Starting and Stopping Automatic Storage Management
  • 5.4.2 Automatic Storage Management Utilities
• 5.5 Accessing Oracle Database with SQL*Plus or iSQL*Plus
• 5.6 Reviewing User Accounts and Passwords
  • 5.6.1 Reviewing Administrative Accounts
  • 5.6.2 Unlocking and Changing Passwords
    • 5.6.2.1 Using SQL*Plus to Unlock and Change Passwords
    • 5.6.2.2 Using Enterprise Manager Database Control to Unlock and Change Passwords
• 5.7 Identifying Databases
• 5.8 Locating the Server Parameter File
• 5.9 Identifying Tablespaces and Data Files
• 5.10 Locating Redo Log Files
• 5.11 Locating Control Files
• 5.12 Understanding Oracle Database Services on Windows

6 Removing Oracle Database Software

• 6.1 Removing Oracle Cluster Synchronization Services
• 6.2 Removing Oracle HTML DB from the Database
• 6.3 Removing All Oracle Database Components
  • 6.3.1 Stopping Oracle Services
  • 6.3.2 Removing Components with Oracle Universal Installer
  • 6.3.3 Manually Removing the Remaining Oracle Database Components
    • 6.3.3.1 Removing an Automatic Storage Management Instance
    • 6.3.3.2 Removing Oracle Keys from the Microsoft Registry Editor
    • 6.3.3.3 Updating the System Variable Path
    • 6.3.3.4 Removing Oracle from the Start Menu
    • 6.3.3.5 Removing Oracle Directories

A Frequently Asked Questions about Installation

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

B Installing Java Access Bridge

• B.1 Introduction
• B.2 Setup for JRE 1.4.2
• B.3 Setup for Oracle Installed Components
  • B.3.1 Installing Java Access Bridge
  • B.3.2 Configuring Oracle Components to Use Java Access Bridge

C Optimal Flexible Architecture

• C.1 Overview of the Optimal Flexible Architecture Standard
  • C.1.1 Characteristics of an Optimal Flexible Architecture-Compliant Installation
• C.2 Changes to the Optimal Flexible Architecture for Oracle Database 10g
• C.3 Directory Tree Differences by Release
  • C.3.1 Top-Level Oracle Directory
  • C.3.2 Database File Names
  • C.3.3 Database File Name Extensions
• C.4 Optimal Flexible Architecture Directory Naming Conventions
  • C.4.1 ORACLE_BASE Directory
  • C.4.2 ORACLE_HOME Directory
  • C.4.3 ADMIN Directory
  • C.4.4 ORADATA Directory
  • C.4.5 FLASH_RECOVERY_AREA Directory
• C.5 Optimal Flexible Architecture and Multiple Oracle Home Configurations
  • C.5.1 Specifying an ORACLE_HOME Directory
  • C.5.2 Installing a Default Optimal Flexible Architecture Database: Example
  • C.5.3 Installing a Nondefault Optimal Flexible Architecture Database: Example 1
  • C.5.4 Installing a Nondefault Optimal Flexible Architecture Database: Example 2
• C.6 Increasing Reliability and Performance
  • C.6.1 Disk Mirroring
  • C.6.2 Disk Striping
  • C.6.3 Using Raw Partitions for Tablespaces
• C.7 Comparison Between Optimal Flexible Architecture on Windows and UNIX
  • C.7.1 Directory Naming
  • C.7.2 ORACLE_BASE Directory
  • C.7.3 Support for Symbolic Links on Windows

D Installing and Configuring Oracle Database Using Response Files

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

E Configuring Oracle Database Globalization Support

• E.1 Installing and Using Oracle Components in Different Languages
  • E.1.1 Running Oracle Universal Installer in Different Languages
  • E.1.2 Using Oracle Components in Different Languages
• E.2 Configuring Locale and Character Sets with the NLS_LANG Parameter
  • E.2.1 About the NLS_LANG Parameter
  • E.2.2 Default Values for NLS_LANG
  • E.2.3 NLS_LANG Settings in MS-DOS Mode and Batch Mode

F Managing Oracle Database Port Numbers

• F.1 About Managing Ports
• F.2 Viewing Port Numbers and Access URLS
• F.3 Port Numbers and Protocols of Oracle Components
• F.4 Changing the Oracle Enterprise Management Agent Port
• F.5 Changing the Oracle Enterprise Manager Database Console Ports
• F.6 Changing the iSQL*Plus Ports
• F.7 Changing the Oracle XML DB Ports

G Troubleshooting the Oracle Database Installation

• G.1 Verifying Requirements
• G.2 Encountering Installation Errors
• G.3 Reviewing the Log of an Installation Session
• G.4 Silent or Noninteractive Installation Response File Error Handling
• G.5 Troubleshooting Configuration Assistants
  • G.5.1 Configuration Assistant Failures
  • G.5.2 Fatal Errors
• G.6 Cleaning Up After a Failed Installation

Glossary

Index