Skip Headers
Oracle® Database Installation Guide
10
g
Release 2 (10.2) for Microsoft Windows (64-Bit) on Intel Itanium
Part Number B14317-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
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
Oracle Cluster Synchronization Services
1.4.4
Oracle Universal Installer Overview
1.4.5
Oracle Base Directory
1.4.6
Oracle Home Directory
1.4.6.1
Contents of the Oracle Home Environment
1.4.6.2
Multiple Oracle Home Components
1.4.6.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
Windows Support
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 2003
2.4.5.3
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-Managed Files Requirements
2.5.7
Oracle Real Application Clusters
3
Installing Oracle Database
3.1
Preinstallation Considerations for Installing Oracle Database
3.1.1
Performing Multiple Oracle Database Installations
3.1.2
Installing onto Systems That Already Have Oracle Components
3.1.3
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 Administration Assistant for Windows
4.3.2
Installing Natively Compiled Java Libraries for Oracle JVM and Oracle
inter
Media
4.3.3
Running Oracle Cluster Synchronization Services from a Different Oracle Home
4.3.4
Configuring Oracle Counters for Windows Performance Monitor
4.3.5
Configuring Oracle Label Security
4.3.6
Configuring Oracle Net Services
4.3.7
Installing Oracle Text Supplied Knowledge Bases
4.3.8
Configuring or Reinstalling Oracle XML DB
4.3.9
Configuring PL/SQL External Procedures
4.3.10
Configuring Shared Server Support
4.3.11
Setting Credentials for the Job System to Work with Enterprise Manager
4.3.12
Configuring Oracle Database to Communicate with Automatic Storage Management
4.3.13
Configuring Databases to Use Oracle Enterprise Manager Database Control
4.3.14
Using Oracle9
i
Language and Definition Files with Oracle Database 10
g
Release 2 (10.2)
4.3.15
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
i
SQL*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
Optimal Flexible Architecture
B.1
Overview of the Optimal Flexible Architecture Standard
B.1.1
Characteristics of an Optimal Flexible Architecture-Compliant Installation
B.2
Changes to the Optimal Flexible Architecture for Oracle Database 10
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 1
B.5.4
Installing a Nondefault Optimal Flexible Architecture Database: Example 2
B.6
Increasing Reliability and Performance
B.6.1
Disk Mirroring
B.6.2
Disk Striping
B.6.3
Using Raw Partitions for Tablespaces
B.7
Comparison Between Optimal Flexible Architecture on Windows and UNIX
B.7.1
Directory Naming
B.7.2
ORACLE_BASE Directory
B.7.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
Running Oracle Universal Installer in Different Languages
D.1.2
Using Oracle Components in Different Languages
D.2
Configuring Locale and Character Sets with the NLS_LANG Parameter
D.2.1
About the NLS_LANG Parameter
D.2.2
Default Values for NLS_LANG
D.2.3
NLS_LANG Settings in MS-DOS Mode and Batch Mode
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
i
SQL*Plus 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 Configuration Assistants
F.5.1
Configuration Assistant Failures
F.5.2
Fatal Errors
F.6
Cleaning Up After a Failed Installation
Glossary
Index