1/23

Contents

Expand All · Collapse All

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Accessing Documentation
• Related Documentation
• Conventions

Changes in This Release for Oracle Database Installation Guide

• Changes in Oracle Database 12c Release 1 (12.1)

1 Oracle Database Installation Checklist

• 1.1 Hardware Checklist for Oracle Database Installation
• 1.2 Operating System Checklist for Oracle Database Installation
• 1.3 Oracle User Environment Configuration Checklist for Oracle Database Installation
• 1.4 Storage and Recovery Checklist for Oracle Database Installation
• 1.5 OUI Checklist for Single Instance Oracle Database Installation
• 1.6 Planning Checklist for Oracle Database Installation

2 Overview of Oracle Database Installation

• 2.1 New Oracle Products and Features Installed with This Release
• 2.2 Planning Your Installation
• 2.3 Installation Considerations
  • 2.3.1 Installation Differences Between Windows and UNIX Systems
  • 2.3.2 Recommended File System
  • 2.3.3 Hardware and Software Certification
    • 2.3.3.1 Third-Party Database Certification for Oracle SQL Developer
  • 2.3.4 Multiple Oracle Homes Support
    • 2.3.4.1 Installing the Software on a System with an Existing Oracle Installation
  • 2.3.5 Oracle Grid Infrastructure for a Standalone Server
  • 2.3.6 Oracle Cluster Synchronization Services
  • 2.3.7 Oracle Universal Installer Overview
  • 2.3.8 Oracle Base Directory
  • 2.3.9 Oracle Home Directory
    • 2.3.9.1 Contents of the Oracle Home Environment
    • 2.3.9.2 Multiple Oracle Home Components
  • 2.3.10 Oracle Inventory Directory
  • 2.3.11 Installing Oracle Database Vault in an Oracle Data Guard Environment
  • 2.3.12 Oracle Database Vault Default Audit Policy and Initialization Parameters
  • 2.3.13 Consider Memory Allocation and Automatic Memory Management
• 2.4 Oracle Database Installation Methods
  • 2.4.1 Interactive Installation Types
  • 2.4.2 Automated Installation Methods Using Response Files
• 2.5 Oracle Database Editions
• 2.6 Database Security Notification Options
• 2.7 Database Configuration Options
  • 2.7.1 Preconfigured Database Types
  • 2.7.2 Installation Choices That Affect Database Creation
  • 2.7.3 Creating a Database After Installation
    • 2.7.3.1 Creating an Oracle Database on Direct NFS
• 2.8 Database Storage Options
  • 2.8.1 File System
  • 2.8.2 Oracle Automatic Storage Management
    • 2.8.2.1 Oracle Automatic Storage Management Components
• 2.9 Database Management Options
  • 2.9.1 Management Options for Preconfigured Databases
  • 2.9.2 Management Options for Custom Databases
  • 2.9.3 Features Provided by Oracle Enterprise Manager Database Express 12c
• 2.10 Database Backup and Recovery Options
  • 2.10.1 Configuring Recovery
• 2.11 Upgrade Considerations
  • 2.11.1 Upgrading Your Operating System Before a Database Upgrade
    • 2.11.1.1 Upgrading the Operating System
    • 2.11.1.2 Migrating to a New Computer
  • 2.11.2 Upgrading Oracle Automatic Storage Management
• 2.12 Migration Considerations

3 Oracle Database Preinstallation Tasks

• 3.1 Oracle Database Hardware Requirements
  • 3.1.1 Hardware Component Requirements for Windows x64
  • 3.1.2 Hard Disk Space Requirements
  • 3.1.3 Verifying Hardware Requirements
• 3.2 Oracle Database Software Requirements
• 3.3 Windows Certification and Web Browser Support
  • 3.3.1 Remote Desktop Services
  • 3.3.2 Installation Requirements for Web Browsers
  • 3.3.3 Default Share Configuration Requirement
• 3.4 Reviewing Operating System Security Common Practices
• 3.5 Confirming Host Name Resolution
• 3.6 Individual Component Requirements
  • 3.6.1 Configuring Disk Storage for Oracle Data Files and Recovery Files
    • 3.6.1.1 Choosing a Storage Option for Oracle Database and Recovery Files
    • 3.6.1.2 Configuring Disk Storage
  • 3.6.2 Creating Directories for Oracle Data Files or Recovery Files
    • 3.6.2.1 Guidelines for Placing Oracle Data Files on a File System
    • 3.6.2.2 Guidelines for Placing Oracle Recovery Files on a File System
    • 3.6.2.3 Creating Required Directories
  • 3.6.3 Oracle Database Security Strong Authentication Requirements
  • 3.6.4 Oracle Enterprise Manager Requirements
  • 3.6.5 Oracle-Managed Files Requirements
  • 3.6.6 Oracle Real Application Clusters (Oracle RAC)
  • 3.6.7 Oracle Volume Shadow Copy Service (VSS) Writer

4 Configuring Users, Groups and Environments for Oracle Database

• 4.1 Creating Required Operating System Groups and Users
  • 4.1.1 About the Oracle Installation User
  • 4.1.2 Creating Oracle Home User
  • 4.1.3 Understanding the Oracle Inventory Directory and the Oracle Inventory Group
  • 4.1.4 Operating System Groups Created During Oracle Database Installation
  • 4.1.5 Operating System Groups and Users for Job Role Separation
    • 4.1.5.1 About Job Role Separation Operating System Privileges Groups and Users
    • 4.1.5.2 Oracle Software Owner For Each Oracle Software Product
    • 4.1.5.3 Standard Oracle Database Groups for Job Role Separation for Oracle Database
    • 4.1.5.4 Extended Oracle Database Groups for Job Role Separation
    • 4.1.5.5 Oracle Automatic Storage Management Groups for Job Role Separation
• 4.2 Stopping Existing Oracle Services
• 4.3 Configuring User Accounts
  • 4.3.1 Configuring Environment Variables for the Software Installation Owner
  • 4.3.2 Managing User Accounts with User Account Control

5 Oracle Grid Infrastructure for a Standalone Server

• 5.1 Requirements for an Oracle Grid Infrastructure for a Standalone Server Installation
  • 5.1.1 System Requirements
  • 5.1.2 Memory Requirements
  • 5.1.3 Disk Space Requirements
• 5.2 Oracle ACFS and Oracle ADVM
  • 5.2.1 About Oracle ACFS and Oracle ADVM
  • 5.2.2 Oracle ACFS and Oracle ADVM Support on Windows
  • 5.2.3 Restrictions and Guidelines for Oracle ACFS
• 5.3 Oracle Automatic Storage Management Storage Configuration
  • 5.3.1 Managing Disk Groups for Older Database Versions
  • 5.3.2 Oracle Automatic Storage Management Installation Considerations
  • 5.3.3 Configuring Storage for Oracle Automatic Storage Management
    • 5.3.3.1 Identifying Storage Requirements for Oracle Automatic Storage Management
    • 5.3.3.2 Creating DAS or SAN Disk Partitions for an Oracle Automatic Storage Management Instance
    • 5.3.3.3 Configuring Disks Manually for Oracle Automatic Storage Management
• 5.4 Configuring Oracle Automatic Storage Management Disk Groups Manually Using Oracle ASMCA
• 5.5 Testing the Oracle Automatic Storage Management Installation
• 5.6 Upgrading Existing Oracle Automatic Storage Management Instances
• 5.7 Installing Oracle Grid Infrastructure for a Standalone Server Using a Software-Only Installation
  • 5.7.1 Installing the Software Binaries
  • 5.7.2 Configuring the Software Binaries
• 5.8 Installing and Configuring Oracle Grid Infrastructure for a Standalone Server
  • 5.8.1 Installing Oracle Grid Infrastructure for a Standalone Server with a New Database Installation
  • 5.8.2 Installing Oracle Grid Infrastructure for a Standalone Server for an Existing Database
• 5.9 Modifying Oracle Grid Infrastructure for a Standalone Server Binaries After Installation

6 Installing Oracle Database

• 6.1 Preinstallation Considerations for Installing Oracle Database
  • 6.1.1 Installation Consideration on Windows
  • 6.1.2 Performing Multiple Oracle Database Installations
  • 6.1.3 Installing on Systems That Already Have Oracle Components
  • 6.1.4 Installing with Minimum Memory Requirements
• 6.2 Reviewing Component-Specific Installation Guidelines
  • 6.2.1 Selecting the Database Character Set
  • 6.2.2 Using an Oracle Automatic Storage Management Disk Group
• 6.3 Accessing the Installation Software
  • 6.3.1 Installing from a Remote DVD Drive
    • 6.3.1.1 Step 1: On the Remote Computer, Share the DVD Drive
    • 6.3.1.2 Step 2: On the Local Computer, Map the DVD Drive
  • 6.3.2 Installing on Remote Computers Through Remote Access Software
    • 6.3.2.1 Installing on Remote Computers from a Hard Drive
    • 6.3.2.2 Installing on Remote Computers from a Remote DVD Drive
  • 6.3.3 Downloading Oracle Software
    • 6.3.3.1 Downloading the Installation Archive Files from Oracle Technology Network
    • 6.3.3.2 Downloading the Software from Oracle Software Delivery Cloud
    • 6.3.3.3 Extracting the Installation Files
  • 6.3.4 Copying the Oracle Database Software to a Hard Disk
• 6.4 Installing the Oracle Database Software
• 6.5 Cloning an Oracle Home
• 6.6 Configuring Oracle Configuration Manager in a Cloned Oracle Home

7 Oracle Database Postinstallation Tasks

• 7.1 Installing the Latest Patch Set Release
• 7.2 Validating Invalid PL/SQL Modules
• 7.3 Configuring the Secure Sockets Layer
• 7.4 Configuring Oracle Components
  • 7.4.1 Configuring Direct NFS Client
    • 7.4.1.1 About Direct NFS Client Storage
    • 7.4.1.2 About the Oranfstab File for Direct NFS Client
    • 7.4.1.3 Mounting NFS Storage Devices with Direct NFS Client
    • 7.4.1.4 Specifying Network Paths for a NFS Server
    • 7.4.1.5 Enabling Direct NFS Client
    • 7.4.1.6 Performing Basic File Operations Using the ORADNFS Utility
    • 7.4.1.7 Monitoring Direct NFS Client Usage
    • 7.4.1.8 Disabling Direct NFS Client
    • 7.4.1.9 Enabling HCC on Direct NFS Client
  • 7.4.2 Configuring Oracle Messaging Gateway
  • 7.4.3 Configuring Oracle Administration Assistant for Windows
  • 7.4.4 Configuring Oracle Label Security
  • 7.4.5 Configuring the OraClrAgnt Service for Oracle Database Extensions for .NET
  • 7.4.6 Configuring Oracle Database Vault
  • 7.4.7 Configuring Oracle Net Services
  • 7.4.8 Installing Oracle Text Supplied Knowledge Bases
  • 7.4.9 Installing the Oracle Text Filtering Component
  • 7.4.10 Configuring or Reinstalling Oracle XML DB
  • 7.4.11 Configuring PL/SQL External Procedures
  • 7.4.12 Configuring Shared Server Support
  • 7.4.13 Setting Credentials for the Job System to Work with Oracle Enterprise Manager
  • 7.4.14 Configuring Oracle Database to Communicate with Oracle Automatic Storage Management
  • 7.4.15 Installing Oracle Database Examples
  • 7.4.16 Creating the OraMTS Service for Microsoft Transaction Server
• 7.5 Creating a Fast Recovery Area Disk Group
  • 7.5.1 About the Fast Recovery Area and the Fast Recovery Area Disk Group
  • 7.5.2 Creating the Fast Recovery Area Disk Group
• 7.6 Enabling and Disabling Database Options
• 7.7 Changing the Oracle Home User Password
• 7.8 Postinstallation Tasks for SQL Developer

8 Getting Started with Oracle Database

• 8.1 Checking the Installed Oracle Database Contents and Directory Location
• 8.2 Logging In to Oracle Enterprise Manager Database Express 12c
• 8.3 Managing Oracle Automatic Storage Management
  • 8.3.1 Starting and Stopping Oracle Automatic Storage Management
  • 8.3.2 Oracle Automatic Storage Management Utilities
• 8.4 Starting and Stopping an Oracle Database
  • 8.4.1 Starting and Stopping the Database with Oracle Administration Assistant for Windows
  • 8.4.2 Starting and Stopping the Database from the Microsoft Windows Services Utility
• 8.5 Accessing Oracle Database with SQL*Plus
• 8.6 Accessing Oracle Database with Oracle SQL Developer
• 8.7 Reviewing User Accounts and Passwords
  • 8.7.1 Reviewing Administrative Accounts
  • 8.7.2 Unlocking and Resetting User Passwords
    • 8.7.2.1 Using Enterprise Manager Database Express 12c to Unlock Accounts and Reset Passwords
    • 8.7.2.2 Using SQL*Plus to Unlock and Change Passwords
• 8.8 Identifying Databases
• 8.9 Locating the Server Parameter File
• 8.10 Identifying Tablespaces and Data Files
• 8.11 Locating Redo Log Files
• 8.12 Locating Control Files
• 8.13 Understanding Oracle Database Services on Windows

9 Removing Oracle Database Software

• 9.1 About the Deinstallation Tool
• 9.2 Example of Running the Deinstallation Tool
• 9.3 Example of Running the Deinstallation Command
• 9.4 Example of a Deinstallation Response File for an Oracle Database
• 9.5 Example of a Deinstallation Response File for Oracle Grid Infrastructure

A Installing Java Access Bridge

• A.1 Overview of Java Access Bridge 2.0.2
• A.2 Setting Up Java Access Bridge 2.0.2

B Optimal Flexible Architecture

• B.1 Overview of the Optimal Flexible Architecture Standard
  • B.1.1 Advantages of Multiple Oracle Homes and OFA
• B.2 Changes to the Optimal Flexible Architecture for Oracle Database
• 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 Automatic Diagnostic Repository (ADR) Directory
  • B.4.4 ADMIN Directory
  • B.4.5 ORADATA Directory
  • B.4.6 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 1
  • 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
• B.7 Optimal Flexible Architecture Structure File Mapping

C Installing and Configuring Oracle Database Using Response Files

• C.1 How Response Files Work
  • C.1.1 Reasons for Using Silent Mode or Response File 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 Saving 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
  • C.5.1 Silent Mode of Database Configuration Assistant
  • C.5.2 Progress Only Mode of Database Configuration Assistant
  • C.5.3 Running Database Configuration Assistant in Response File Mode
• C.6 Postinstallation Configuration Using a Response File
  • C.6.1 About the Postinstallation Configuration File
  • C.6.2 Running Postinstallation Configuration Using a Response File

D Configuring Networks for Oracle Database

• D.1 Installing Oracle Database on Computers with Multiple IP Addresses
• D.2 Installing Oracle Database on Computers with Multiple Aliases
• D.3 Installing Oracle Database on Nonnetworked Computers
• D.4 Installing a Loopback Adapter
  • D.4.1 Checking if a Loopback Adapter is Installed on Your Computer
  • D.4.2 Installing a Loopback Adapter on Windows Server 2008
  • D.4.3 Installing a Loopback Adapter on Windows 7 and Windows Server 2008 R2
  • D.4.4 Installing Microsoft KM-TEST Loopback Adapter on Windows 8, Windows 8.1, Windows Server 2012, and Windows Server 2012 R2
  • D.4.5 Removing a Loopback Adapter

E Configuring Oracle Database Globalization Support

• E.1 Installing and Using Oracle Components in Different Languages
  • E.1.1 Configuring Oracle Components to Run in Different Languages
    • E.1.1.1 Determining the Operating System Locale
    • E.1.1.2 Configuring Locale and Character Sets Using the NLS_LANG Environment Variable
    • E.1.1.3 NLS_LANG Settings in Console Mode and Batch Mode
  • E.1.2 Installing Translation Resources
• E.2 Running Oracle Universal Installer in Different Languages

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 Services for Microsoft Transaction Server Port

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 Mode Response File Error Handling
• G.5 Troubleshooting Host Name Changes and CSS
• G.6 Troubleshooting Configuration Assistants
  • G.6.1 Configuration Assistant Failures
  • G.6.2 Irrecoverable Errors
• G.7 Troubleshooting Inventory Issues
• G.8 Troubleshooting Screen Display Issues
• G.9 Cleaning Up After a Failed Installation
• G.10 Continuing Installations or Upgrades After Server Restarts

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)

Glossary

Index