Skip Headers
Oracle® Database Installation Guide
11g Release 1 (11.1) for Microsoft Windows
Part Number B32006-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 11
g
New Components Available for Installation
Changes in the Install Options
Database Configuration Assistant
Database Upgrade Assistant
Active Directory Security Enhancements
Automatic Storage Management Fast Mirror Resync
Oracle Data Provider for .NET
Oracle Volume Shadow Copy Service (VSS) Writer
SYSASM Privilege for Automatic Storage Management Administration
Automatic Maintenance Tasks Management
Automatic Diagnostic Repository
Enhanced Optimal Flexible Architecture
Oracle Direct Network File System Client
Windows Vista Support
Deprecated Components in Oracle Database 11g Release 1 (11.1)
1
Overview of Oracle Database Installation
1.1
Planning Your 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 SQL Developer
1.2.5
Oracle Database Vault
1.3
Installation Considerations
1.3.1
Installation Differences Between Windows and UNIX Systems
1.3.2
Managing User Accounts with User Account Control on Windows Vista
1.3.3
Hardware and Software Certification
1.3.3.1
Third-Party Database Certification for SQL Developer
1.3.4
Multiple Oracle Home Support
1.3.5
Oracle Cluster Synchronization Services
1.3.6
Using Network Attached Storage or NFS File Systems
1.3.7
Oracle Universal Installer Overview
1.3.8
Oracle Base Directory
1.3.9
Oracle Home Directory
1.3.9.1
Contents of the Oracle Home Environment
1.3.9.2
Multiple Oracle Home Components
1.3.10
Oracle Database Vault 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.2.1
Automatic Storage Management Components
1.7.2.2
General Steps for Installing Automatic Storage Management
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
1.11.2
Policies for Client and Application Software Installations
1.11.3
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 for Windows 32-Bit
2.1.4
Hard Disk Space Requirements for Windows x64
2.1.5
Verifying Hardware Requirements
2.2
Oracle Database Software Requirements
2.3
Preinstallation Requirements for Oracle Configuration Manager
2.4
Preinstallation Tasks for Oracle Application Express
2.4.1
Browser Requirements
2.4.2
Oracle XML DB Requirement
2.4.3
Oracle Text Requirement
2.4.4
PL/SQL Web Toolkit
2.5
Windows Certification and Web Browser Support
2.5.1
Windows Telnet Services Support
2.5.2
Windows Terminal Services and Remote Desktop Support
2.5.3
Components Supported on Windows XP and Windows Vista (32-Bit)
2.5.4
Unsupported Components on Windows x64
2.5.5
Web Browser Support
2.6
Oracle Database Network Topics
2.6.1
Installing Oracle Database on DHCP Computers
2.6.2
Installing Oracle Database on Computers with Multiple IP Addresses
2.6.3
Installing Oracle Database on Computers with Multiple Aliases
2.6.4
Installing Oracle Database on Non-Networked Computers
2.6.5
Installing a Loopback Adapter
2.6.5.1
Checking if a Loopback Adapter Is Installed on Your Computer
2.6.5.2
Installing a Loopback Adapter on Windows 2000
2.6.5.3
Installing a Loopback Adapter on Windows 2003, Windows Server 2003 R2, or Windows XP
2.6.5.4
Installing a Loopback Adapter on Windows Vista
2.6.5.5
Removing a Loopback Adapter
2.7
Individual Component Requirements
2.7.1
Configuring Disk Storage for Oracle Data Files and Recovery Files
2.7.1.1
Choosing a Storage Option for Oracle Data Files
2.7.1.2
Choosing a Storage Option for Oracle Database Recovery Files
2.7.1.3
Configuring Disk Storage
2.7.2
Creating Directories for Oracle Data Files or Recovery Files
2.7.2.1
Guidelines for Placing Oracle Data Files on a File System
2.7.2.2
Guidelines for Placing Oracle Recovery Files on a File System
2.7.2.3
Creating Required Directories
2.7.3
Preparing Disk Groups for an Automatic Storage Management Installation
2.7.3.1
General Steps for Preparing Disk Groups for an Automatic Storage Management Installation
2.7.3.2
Step 1: Identifying Storage Requirements for Automatic Storage Management
2.7.3.3
Step 2 (Optional): Using an Existing Automatic Storage Management Disk Group
2.7.3.4
Step 3: Creating DAS or SAN Disk Partitions for an Automatic Storage Management Instance
2.7.3.5
Step 4: Manually Configuring Disks for Automatic Storage Management
2.7.4
Stopping Existing Oracle Services
2.7.5
Oracle Advanced Security Requirements
2.7.6
Oracle Enterprise Manager Requirements
2.7.7
Oracle-Managed Files Requirements
2.7.8
Oracle Real Application Clusters (Oracle RAC)
2.7.9
Oracle Volume Shadow Copy Service (VSS) Writer
2.7.10
Recommended System Requirements for SQL Developer
3
Installing Oracle Database
3.1
Preinstallation Considerations for Installing Oracle Database
3.1.1
Installation Consideration 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.2.1
Selecting the Database Character Set
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
Database Security Options
3.5
Installing the Oracle Database Software
3.6
Installing Automatic Storage Management
3.6.1
Step 1: Reviewing Automatic Storage Management Installation Considerations
3.6.2
Step 2: Creating 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
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 Secure Sockets Layer
4.4
Postinstallation Tasks for SQL Developer
4.4.1
Migrating User Settings from Release 1.0
4.4.2
Migrating Information from Previous Releases
4.4.3
Location of User-Related Information
4.5
Postinstallation Tasks for Oracle Application Express
4.5.1
Restarting Processes
4.5.2
Choosing an HTTP Server
4.5.2.1
About the Embedded PL/SQL Gateway
4.5.2.2
About Oracle HTTP Server and mod_plsql
4.5.2.3
About Password Security
4.5.3
Configuring the Embedded PL/SQL Gateway
4.5.3.1
Configuring the Embedded PL/SQL Gateway in New Installation or When Upgrading Database
4.5.3.2
Disabling and Enabling the Oracle XML DB HTTP Server
4.5.4
Configuring Oracle HTTP Server in a New Installation
4.5.4.1
Configuring Oracle HTTP Server Release 9.0.3 in a New Installation
4.5.4.2
Configuring Oracle HTTP Server Distributed with Oracle Database 11
g
or Oracle Application Server 10
g
in a New Installation
4.5.5
Copying the Images Directory
4.5.5.1
Copying the Images Directory After an Upgrade
4.5.5.2
Copying the Images Directory in a New Installation
4.5.6
Enabling Network Services in Oracle Database 11
g
4.5.7
About Running Oracle Application Express in Other Languages
4.5.7.1
Installing a Translated Version of Oracle Application Express
4.5.8
Managing JOB_QUEUE_PROCESSES
4.5.8.1
Viewing the Number of JOB_QUEUE_PROCESSES
4.5.8.2
Changing the Number of JOB_QUEUE_PROCESSES
4.5.9
Obfuscating PlsqlDatabasePassword Parameter
4.5.9.1
Obfuscating Passwords
4.5.10
Logging In to Oracle Application Express
4.5.10.1
Oracle Application Express User Roles
4.5.10.2
Setting Up Your Local Environment
4.5.11
Patching Oracle Application Express 3.0
4.6
Postinstallation Database Configuration for Oracle Configuration Manager
4.6.1
Preparing Pre-9.2 Databases
4.6.2
Equipping the Database for Configuration Collections
4.6.3
Additional Step for E-Business Suites
4.6.4
Additional Step for Oracle Enterprise Manager Grid Control
4.7
Configuring Oracle Components
4.7.1
Configuring Oracle Direct NFS Client
4.7.1.1
Enable Direct NFS Client
4.7.1.2
Disable Direct NFS Client
4.7.1.3
NFS Buffer Size
4.7.2
Configuring Oracle Messaging Gateway
4.7.3
Configuring Oracle Administration Assistant for Windows
4.7.4
Running Oracle Cluster Synchronization Services from a Different Oracle Home
4.7.5
Configuring Oracle Counters for Windows Performance Monitor
4.7.6
Configuring Oracle Label Security
4.7.7
Configuring Oracle Database Vault
4.7.8
Configuring Oracle Net Services
4.7.9
Installing Oracle Text Supplied Knowledge Bases
4.7.10
Configuring or Reinstalling Oracle XML DB
4.7.11
Configuring PL/SQL External Procedures
4.7.12
Configuring Shared Server Support
4.7.13
Setting Credentials for the Job System to Work with Enterprise Manager
4.7.14
Configuring Oracle Database to Communicate with Automatic Storage Management
4.7.15
Configuring Databases to Use Oracle Enterprise Manager Database Control
4.7.16
Installing Oracle Database Examples
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
5.6
Accessing Oracle Database with SQL Developer
5.7
Reviewing User Accounts and Passwords
5.7.1
Reviewing Administrative Accounts
5.7.2
Unlocking and Changing Passwords
5.7.2.1
Using SQL*Plus to Unlock and Change Passwords
5.7.2.2
Using Enterprise Manager Database Control to Unlock and Change Passwords
5.8
Identifying Databases
5.9
Locating the Server Parameter File
5.10
Identifying Tablespaces and Data Files
5.11
Locating Redo Log Files
5.12
Locating Control Files
5.13
Understanding Oracle Database Services on Windows
6
Removing Oracle Database Software
6.1
Uninstalling Oracle Configuration Manager
6.2
Removing Oracle Cluster Synchronization Services
6.3
Removing Oracle Application Express from the Database
6.4
Removing All Oracle Database Components
6.4.1
Stopping Oracle Services
6.4.2
Removing Components with Oracle Universal Installer
6.4.3
Manually Removing the Remaining Oracle Database Components
6.4.3.1
Removing an Automatic Storage Management Instance
6.4.3.2
Updating the System Variable Path
6.4.3.3
Removing Oracle from the Start Menu
6.4.3.4
Removing Oracle Directories
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.2
Changes to the Optimal Flexible Architecture for Oracle Database 11
g
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
FLASH_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 Noninteractive 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
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 with 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 Console Ports
E.6
Changing the Oracle Ultra Search Ports
E.7
Changing the Oracle XML DB Ports
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 or Noninteractive Installation Response File Error Handling
F.5
Troubleshooting Hostname Changes and CSS
F.6
Troubleshooting Oracle Configuration Manager
F.7
Troubleshooting Configuration Assistants
F.7.1
Configuration Assistant Failures
F.7.2
Fatal Errors
F.8
Cleaning Up After a Failed Installation
F.9
Images Displaying Incorrectly in Oracle Application Express
F.10
Online Help Not Working
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)
H
Country Codes
H.1
Valid Country Codes
Glossary
Index