Skip Headers
Oracle® Database Installation Guide
10
g
Release 2 (10.2) for Microsoft Windows (x64)
Part Number B15681-03
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documentation
Conventions
What's New in Oracle Database for Windows?
Oracle Database 10
g
Release 2 (10.2) New Features for Windows
Oracle Database 10g Release 2 (10.2) Deprecated Components
Oracle Database 10
g
Release 1 (10.1) New Features for Windows
Oracle Database 10
g
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
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
Windows Support
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
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
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
inter
Media
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 Oracle9
i
Language and Definition Files with Oracle Database 10
g
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
i
SQL*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 10
g
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
i
SQL*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