Skip Headers
Oracle® Database Installation Guide
11g Release 1 (11.1) for Linux
Part Number B32002-01
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Command Syntax
Accessing Documentation
Related Documentation
Typographic 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
Automatic Storage Management Fast Mirror Resync
SYSASM Privilege for Automatic Storage Management Administration
Automatic Maintenance Tasks Management
Automatic Diagnostic Repository
Enhanced Optimal Flexible Architecture
Oracle Direct Network File System Client
Deprecated Components in Oracle Database 11g Release 1 (11.1)
1
Overview of Oracle Database Installation
1.1
Planning Your Installation
1.2
Installing the Linux Operating System
1.2.1
Completing a Default Linux Installation
1.2.2
About the Oracle Validated Configuration RPM
1.2.3
Installing the Oracle Validated Configuration RPM
1.3
New Oracle Products Installed with This Release
1.3.1
Oracle Application Express
1.3.2
Oracle Warehouse Builder
1.3.3
Oracle Configuration Manager
1.3.4
Oracle SQL Developer
1.3.5
Oracle Database Vault
1.4
Installation Considerations
1.4.1
Hardware and Software Certification
1.4.1.1
Third-Party Database Certification for SQL Developer
1.4.2
Multiple Oracle Homes Support
1.4.2.1
Installing the Software on a System with an Existing Oracle Installation
1.4.3
Oracle Cluster Synchronization Services
1.4.4
Using Network Attached Storage or NFS File Systems
1.4.5
Default Audit Policy and Initialization Parameters
1.5
Oracle Database Installation Methods
1.5.1
Interactive Installation Methods
1.5.2
Automated Installation Methods Using Response Files
1.6
Oracle Database Installation Types
1.7
Database Configuration Options
1.7.1
Preconfigured Database Types
1.7.2
Installation Choices that Affect Database Creation
1.7.3
Creating a Database After Installation
1.8
Database Storage Options
1.8.1
File System
1.8.2
Automatic Storage Management
1.8.3
Raw Devices
1.9
Database Management Options
1.9.1
Management Options for Preconfigured Databases
1.9.2
Management Options for Custom Databases
1.9.3
Features Provided by Oracle Enterprise Manager Database Control
1.10
Database Backup and Recovery Options
1.10.1
Enabling Automated Backups
1.10.2
Backup Job Default Settings
1.11
E-mail Notification Options
1.12
Upgrade Considerations
1.12.1
AL24UTFFSS Character Set
1.12.2
Upgrading an Oracle Database Installed on Red Hat Enterprise Linux 2.1
2
Oracle Database Preinstallation Requirements
2.1
Logging In to the System as root
2.2
Checking the Hardware Requirements
2.2.1
Memory Requirements
2.2.2
Disk Space Requirements
2.2.3
Recommended Hardware Requirement for SQL Developer
2.3
Checking the Software Requirements
2.3.1
Operating System Requirements
2.3.2
Kernel Requirements
2.3.3
Package Requirements
2.3.4
Compiler Requirements
2.3.5
Additional Software Requirements
2.3.5.1
Oracle ODBC Drivers
2.3.5.2
Integrated Development Environment
2.3.5.3
Oracle Messaging Gateway
2.3.5.4
Browser Requirements
2.3.5.5
Oracle XML DB for Oracle Application Express
2.3.5.6
PL/SQL Web Toolkit
2.3.5.7
Oracle Text
2.4
Preinstallation Requirements for Oracle Configuration Manager
2.5
Checking the Network Setup
2.5.1
Configuring Name Resolution
2.5.2
Installing on DHCP Computers
2.5.3
Installing on Multihomed Computers
2.5.4
Installing on Computers with Multiple Aliases
2.5.5
Installing on Non-Networked Computers
2.6
Creating Required Operating System Groups and Users
2.6.1
Creating the Oracle Inventory Group
2.6.2
Creating the OSDBA Group
2.6.3
Creating an OSOPER Group (Optional)
2.6.4
Creating an OSASM Group
2.6.5
Creating the Oracle Software Owner User
2.6.5.1
Determining Whether an Oracle Software Owner User Exists
2.6.5.2
Creating an Oracle Software Owner User
2.6.5.3
Modifying an Oracle Software Owner User
2.6.6
Verifying that the User
nobody
Exists
2.7
Configuring Kernel Parameters
2.8
Identifying Required Software Directories
2.8.1
Oracle Base Directory
2.8.2
Oracle Inventory Directory
2.8.3
Oracle Home Directory
2.9
Identifying or Creating an Oracle Base Directory
2.9.1
Identifying an Existing Oracle Base Directory
2.9.2
Creating an Oracle Base Directory
2.10
Choosing a Storage Option for Oracle Database and Recovery Files
2.11
Creating Directories for Oracle Database or Recovery Files
2.11.1
Guidelines for Placing Oracle Database Files on a File System
2.11.2
Creating Required Directories
2.12
Preparing Disk Groups for an Automatic Storage Management Installation
2.12.1
General Steps for Configuring Automatic Storage Management
2.12.2
Step 1: Identifying Storage Requirements for Automatic Storage Management
2.12.3
Step 2: Using an Existing Automatic Storage Management Disk Group
2.12.4
Step 3: Creating DAS or SAN Disk Partitions for Automatic Storage Management
2.12.5
Step 4: Configuring Disks for Automatic Storage Management
2.12.5.1
Configuring Disks for Automatic Storage Management Using the Automatic Storage Management Library Driver
2.13
Stopping Existing Oracle Processes
2.14
Configuring the oracle User's Environment
3
Installing Oracle Database
3.1
Preinstallation Considerations
3.1.1
Performing Multiple Oracle Database Installations in Noninteractive Mode
3.2
Reviewing Installation Guidelines
3.2.1
Selecting the Database Character Set
3.3
Accessing the Installation Software
3.3.1
Downloading Oracle Software from the Oracle Technology Network Web Site
3.3.1.1
Downloading the Installation Archive Files
3.3.1.2
Extracting the Installation Files
3.3.2
Copying the Software to the Hard Disk
3.3.2.1
Mounting Disks
3.3.2.2
Copying the Oracle Database Software to a Hard Disk
3.4
Database Security Options
3.5
Installing the Oracle Database Software
3.5.1
Running Oracle Universal Installer
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 Disk Groups
3.6.3
Step 3: Installing Oracle Database to Use with Automatic Storage Management
3.6.4
Step 4: Testing the Automatic Storage Management Installation
3.7
Installing Oracle Database Examples
4
Oracle Database Postinstallation Tasks
4.1
Required Postinstallation Tasks
4.1.1
Downloading and Installing Patches
4.1.2
Configuring Oracle Products
4.2
Recommended Postinstallation Tasks
4.2.1
Creating a Backup of the
root.sh
Script
4.2.2
Configuring New or Upgraded Databases
4.2.3
Setting Up User Accounts
4.2.4
Setting the NLS_LANG Environment Variable
4.2.5
Generating the Client Static Library
4.2.6
Direct NFS Client
4.2.6.1
Enabling Direct NFS Client
4.2.6.2
Disabling Direct NFS Client
4.2.6.3
Checking NFS Buffer Size Parameters
4.3
Required Product-Specific Postinstallation Tasks
4.3.1
Configuring Oracle Net Services
4.3.2
Configuring Oracle Label Security
4.3.3
Configuring Oracle Messaging Gateway
4.3.3.1
Modifying the listener.ora File for External Procedures
4.3.3.2
Modifying the tnsnames.ora File for External Procedures
4.3.3.3
Setting Up the mgw.ora Initialization File
4.3.4
Configuring Oracle Precompilers
4.3.4.1
Configuring Pro*C/C++
4.3.4.2
Configuring Pro*FORTRAN
4.3.5
Configuring Secure Sockets Layer
4.3.6
Installing Oracle Text Supplied Knowledge Bases
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 a 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
Copying the Images Directory
4.5.4.1
Copying the Images Directory After an Upgrade
4.5.4.2
Copying the Images Directory After a New Installation
4.5.5
Configuring Oracle HTTP Server in a New Installation
4.5.5.1
Configuring Oracle HTTP Server Release 9.0.3 in a New Installation
4.5.5.2
Configuring Oracle HTTP Server distributed with Oracle Database 11
g
or Oracle Application Server 10
g
in a New Installation
4.5.6
Enabling Network Services in Oracle Database 11
g
4.5.7
Installing Oracle Application Express in Other Languages
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
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
Instrumenting 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
5
Getting Started with Oracle Database
5.1
Checking the Installed Oracle Database Contents and Directory Location
5.2
Logging In to Oracle Enterprise Manager Database Control
5.3
Managing Automatic Storage Management
5.3.1
Starting and Stopping Automatic Storage Management
5.3.2
Automatic Storage Management Utilities
5.4
Accessing Oracle Database with SQL*Plus
5.5
Accessing Oracle Database with SQL Developer
5.6
Reviewing Accounts and Passwords
5.7
Unlocking and Resetting User Passwords
5.7.1
Using Database Control to Unlock Accounts and Reset Passwords
5.7.2
Using SQL*Plus to Unlock Accounts and Reset Passwords
5.7.3
Unlocking and Changing Passwords
5.8
Identifying Databases
5.9
Locating the Server Parameter File
5.10
Reviewing Tablespaces and Data Files, Redo Log Files, and Control Files
5.10.1
Identifying Tablespaces and Data Files
5.10.2
Locating Redo Log Files
5.10.3
Locating Control Files
6
Removing Oracle Software
6.1
Overview
6.2
Identifying All Instances
6.3
Removing Oracle Configuration Manager
6.4
Removing Oracle Application Express from the Database
6.5
Removing an Oracle Database
6.6
Removing an Automatic Storage Management Instance
6.7
Reconfiguring Oracle Cluster Synchronization Services
6.7.1
Identifying Oracle Database 11
g
Oracle Homes
6.7.2
Reconfiguring the Oracle CSS Daemon
6.7.3
Deleting the Oracle CSS Daemon Configuration
6.8
Removing Oracle Software
A
Installing and Configuring Oracle Database Using Response Files
A.1
How Response Files Work?
A.1.1
Reasons for Using Silent Mode or Noninteractive Mode
A.1.2
Creating a Database Using Automatic Storage Management as the Storage Option for Database Files
A.1.3
General Procedure for Using Response Files
A.2
Creating the oraInst.loc File
A.3
Preparing a Response File
A.3.1
Editing a Response File Template
A.3.2
Recording a Response File
A.4
Running Oracle Universal Installer Using a Response File
A.5
Running Net Configuration Assistant Using a Response File
A.6
Running Database Configuration Assistant Using a Response File
A.6.1
Using Database Configuration Assistant in Noninteractive Mode
A.6.2
Using Database Configuration Assistant in Silent Mode
A.6.3
Running Database Configuration Assistant in Noninteractive or Silent Mode
B
Cloning an Oracle Home
C
Using NAS Devices
C.1
General Configuration Guidelines for NAS Devices
C.2
NFS Feature Description
C.3
Choosing Mount Points
C.3.1
Choosing Mount Points for Oracle Software Files
C.3.2
Choosing Mount Points for Oracle Database and Recovery Files
C.4
Creating Files on a NAS Device for Use with Automatic Storage Management
C.5
NFS Mount Options
D
Optimal Flexible Architecture
D.1
Overview of the Optimal Flexible Architecture Standard
D.2
Implementing Optimal Flexible Architecture
D.2.1
File Systems
D.2.1.1
Number of File Systems
D.2.1.2
Naming Conventions
D.2.2
Naming Directories
D.2.2.1
Oracle Base Directory Naming Convention
D.2.2.2
Naming Mount Points for Very Large Databases (VLDBs)
D.2.2.3
Referring to Path Names
D.2.2.4
Oracle Home Directory Naming Convention
D.2.2.5
Naming Subdirectories
D.2.3
Naming Database Files
D.2.4
Separating Segments with Different Requirements
D.2.5
Exploiting the Optimal Flexible Architecture Structure for Oracle Files
D.2.6
Optimal Flexible Architecture File Mapping
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
Configuring Oracle Database Globalization Support
F.1
Installing and Using Oracle Components in Different Languages
F.1.1
Configuring Oracle Components to Run in Different Languages
F.1.1.1
Determining the Operating System Locale by Using the LANG Environment Variable
F.1.1.2
Configuring Locale and Character Sets by Using the NLS_LANG Environment Variable
F.1.2
Installing Translation Resources
F.2
Running Oracle Universal Installer in Different Languages
G
Troubleshooting
G.1
Verify Requirements
G.2
X Window Display Errors
G.3
What to Do If an Installation Error Occurs?
G.4
Reviewing the Log of an Installation Session
G.5
Troubleshooting Hostname Changes and CSS
G.6
Troubleshooting Oracle Configuration Manager
G.7
Troubleshooting Configuration Assistants
G.7.1
Configuration Assistant Failure
G.7.2
Fatal Errors
G.8
Silent-Mode Response File Error Handling
G.9
Cleaning Up After a Failed Installation
G.10
After Failed Upgrade Installation
G.10.1
Reverting to Earlier Release
G.10.2
After a Failed New Installation
G.11
Images Displaying Incorrectly in Oracle Application Express
G.12
Online Help Not Working
H
Frequently Asked Questions About Installation
H.1
Installing Oracle Database or Oracle Database Client
H.2
Installing Oracle Database Tools
H.3
Installing Oracle Database with Oracle Applications
H.4
Installing Oracle Database Heterogeneous Connectivity Tools (Gateways)
I
Country Codes
I.1
Valid Country Codes
Glossary
Index