1/133

Contents

List of Examples

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Accessing Documentation
  • Platform-Specific Documentation
  • Product Documentation
• Related Documentation
• Conventions

Changes in this Release for Oracle Database Installation Guide

• Changes in Oracle Database 12c Release 2 (12.2)
  • New Features
  • Deprecated Features
  • Desupported Features
• Changes in Oracle Database 12c Release 1 (12.1)
  • New Features
  • Deprecated Features
  • Desupported Features

1 Oracle Database Installation Checklist

• Server Hardware Checklist for Oracle Database Installation
• Operating System Checklist for Oracle Database Installation on Microsoft Windows
• Server Configuration Checklist for Oracle Database Installation
• Oracle User Environment Configuration Checklist for Oracle Database Installation
• Storage Checklist for Oracle Database Installation
• Installer Planning Checklist for Oracle Database
• Creating a Database After Installation

2 Oracle Database Preinstallation Tasks

• Oracle Database Minimum Hardware Requirements
  • Hardware Component Requirements for Windows x64
  • Hard Disk Space Requirements
  • Verifying Hardware Requirements
• Oracle Database Software Requirements
• Windows Certification and Web Browser Support
  • Remote Desktop Services
  • Installation Requirements for Web Browsers
  • Default Share Configuration Requirement
• Reviewing Operating System Security Common Practices
• Confirming Host Name Resolution
• Individual Component Requirements
  • Configuring Disk Storage for Oracle Data Files and Recovery Files
    • Choosing a Storage Option for Oracle Database and Recovery Files
    • Configuring Disk Storage
  • Creating Directories for Oracle Data Files or Recovery Files
    • Guidelines for Placing Oracle Database Files on a File System or Logical Volume
    • Guidelines for Placing Oracle Recovery Files on a File System
    • Creating Required Directories
  • Oracle Database Security Strong Authentication Requirements
  • Oracle Enterprise Manager Requirements
  • Oracle-Managed Files Requirements
  • Oracle Volume Shadow Copy Service (VSS) Writer

3 Overview of Oracle Database Installation

• New Oracle Products and Features Installed with this Release
• Planning Your Installation
• Installation Considerations
  • Installation Differences Between Windows and UNIX Systems
  • Recommended File System
  • Hardware and Software Certification
    • Third-Party Database Certification for Oracle SQL Developer
  • Oracle Grid Infrastructure for a Standalone Server
  • Oracle Cluster Synchronization Services
  • Oracle Universal Installer Overview
  • Oracle Base Directory
  • Oracle Home Directory
    • Contents of the Oracle Home Environment
    • Multiple Oracle Home Components
  • Oracle Inventory Directory
  • Installing Oracle Database Vault in an Oracle Data Guard Environment
  • Oracle Database Vault Default Audit Policy and Initialization Parameters
  • Consider Memory Allocation and Automatic Memory Management
• Oracle Database Installation Methods
  • Interactive Installation Types
  • Automated Installation Methods Using Response Files
• Database Configuration Options
  • Creating a Database After Installation
    • Creating an Oracle Database on Direct NFS
• Database Backup and Recovery Options
  • Configuring Recovery
• Migration Considerations

4 Configuring Users, Groups and Environments for Oracle Database

• Creating Required Operating System Groups and Users
  • About the Oracle Installation User
  • Creating Oracle Home User
  • Understanding the Oracle Inventory Directory and the Oracle Inventory Group
  • Operating System Groups Created During Oracle Database Installation
  • Operating System Groups and Users for Job Role Separation
    • About Job Role Separation Operating System Privileges Groups and Users
    • Oracle Software Owner For Each Oracle Software Product
    • Standard Oracle Database Groups for Job Role Separation for Oracle Database
    • Extended Oracle Database Groups for Job Role Separation
    • Oracle Automatic Storage Management Groups for Job Role Separation
    • Windows Group Managed Service Accounts and Virtual Accounts
    • Microsoft Hyper-V
• Stopping Existing Oracle Services
• Configuring User Accounts
  • Configuring Environment Variables for the Software Installation Owner
  • Managing User Accounts with User Account Control

5 Installing and Configuring Oracle Grid Infrastructure for a Standalone Server

• About Image-Based Oracle Grid Infrastructure Installation
• Requirements for an Oracle Grid Infrastructure for a Standalone Server (Oracle Restart) Installation
  • System Requirements
  • Memory Requirements
  • Disk Space Requirements
• Oracle ACFS and Oracle ADVM
  • About Oracle ACFS and Oracle ADVM
  • Oracle ACFS and Oracle ADVM Support on Windows
  • Restrictions and Guidelines for Oracle ACFS
• Oracle Automatic Storage Management Storage Configuration
  • Managing Disk Groups for Older Database Versions
  • Oracle Automatic Storage Management Installation Considerations
  • Configuring Storage for Oracle Automatic Storage Management
    • Identifying Storage Requirements for Oracle Automatic Storage Management
    • ASM Disk Group Options for Interactive and Noninteractive Installation
    • Configuring Disks Manually for Oracle Automatic Storage Management
• Configuring Oracle Automatic Storage Management Disk Groups Manually Using Oracle ASMCA
• Testing the Oracle Automatic Storage Management Installation
• About Upgrading Existing Oracle Automatic Storage Management Instances
• Installing Oracle Grid Infrastructure for a Standalone Server (Oracle Restart) Using a Software-Only Installation
  • Installing the Software Binaries
  • Configuring Software Binaries for Oracle Grid Infrastructure for a Standalone Server (Oracle Restart)
• Installing and Configuring Oracle Grid Infrastructure for a Standalone Server (Oracle Restart)
  • Installing Oracle Grid Infrastructure for a Standalone Server (Oracle Restart) with a New Database Installation
    • Installing Oracle Grid Infrastructure for a Standalone Server (Oracle Restart) for an Existing Database
• Modifying Oracle Grid Infrastructure for a Standalone Server (Oracle Restart) Binaries After Installation

6 Installing Oracle Database

• Preinstallation Considerations for Installing Oracle Database
  • Installation Consideration on Windows
  • Performing Multiple Oracle Database Installations
  • Installing on Systems That Already Have Oracle Components
  • Installing with Minimum Memory Requirements
• Reviewing Component-Specific Installation Guidelines
  • About Character Set Selection During Installation
  • Using an Oracle Automatic Storage Management Disk Group
• 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
    • Downloading the Installation Archive Files from Oracle Technology Network
    • Downloading the Software from Oracle Software Delivery Cloud
    • Extracting the Installation Files
  • Copying the Oracle Database Software to a Hard Disk
• Installing and Using Oracle Components in Different Languages
  • Configuring Oracle Components to Run in Different Languages
    • Determining the Operating System Locale
    • Configuring Locale and Character Sets Using the NLS_LANG Environment Variable
    • NLS_LANG Settings in Console Mode and Batch Mode
  • Installing Translation Resources
• Running Oracle Universal Installer in Different Languages
• Installing Oracle Database
• Cloning an Oracle Home
  • Configuring Oracle Configuration Manager in a Cloned Oracle Home

7 Oracle Database Postinstallation Tasks

• Using Oracle9i Language and Definition Files with Oracle Database 12c
• Downloading and Installing Patch Updates
• Requirements for Database Password
• Setting Language and Locale Preferences for Client Connections
• Downloading and Installing the ORAchk Health Check Tool
• About Using CVU Cluster Healthchecks After Installation
• Recompiling Invalid Objects on Windows Systems
• Configuring the Secure Sockets Layer
• Configuring Oracle Components
  • Configuring Direct NFS Client
    • About Direct NFS Client Storage
    • About the Oranfstab File for Direct NFS Client
    • Mounting NFS Storage Devices with Direct NFS Client
    • Specifying Network Paths for a NFS Server
    • Creating an oranfstab File for Direct NFS Client
    • Performing Basic File Operations Using the ORADNFS Utility
    • Monitoring Direct NFS Client Usage
    • Enabling Direct NFS Client
    • Disabling Direct NFS Client
    • Enabling HCC on Direct NFS Client
  • Configuring Oracle Messaging Gateway
  • Configuring Oracle Administration Assistant for Windows
  • Configuring Oracle Label Security
  • Configuring the OraClrAgnt Service for Oracle Database Extensions for .NET
  • Configuring Oracle Database Vault
  • Configuring Oracle Net Services
  • Installing Oracle Text Supplied Knowledge Bases
  • Installing the Oracle Text Filtering Component
  • Configuring or Reinstalling Oracle XML DB
  • Configuring PL/SQL External Procedures
  • Configuring Shared Server Support
  • Setting Credentials for the Job System to Work with Oracle Enterprise Manager
  • Configuring Oracle Database to Communicate with Oracle Automatic Storage Management
  • Installing Oracle Database Examples
  • Creating the OraMTS Service for Microsoft Transaction Server
• Creating a Fast Recovery Area Disk Group
  • About the Fast Recovery Area and the Fast Recovery Area Disk Group
  • Creating the Fast Recovery Area Disk Group
• Enabling and Disabling Database Options After Installation
• Changing the Oracle Home User Password
• Postinstallation Tasks for SQL Developer

8 Getting Started with Oracle Database

• Checking the Installed Oracle Database Contents and Directory Location
• Logging In to Oracle Enterprise Manager Database Express 12c
• Managing Oracle Automatic Storage Management
  • Starting and Stopping Oracle Automatic Storage Management
  • Oracle Automatic Storage Management Utilities
• Starting and Stopping an Oracle Database
  • Starting and Stopping the Database with Oracle Administration Assistant for Windows
  • Starting and Stopping the Database from the Microsoft Windows Services Utility
• Accessing Oracle Database with SQL*Plus
• Accessing Oracle Database with Oracle SQL Developer
• Reviewing User Accounts and Passwords
  • Reviewing Administrative Accounts
  • Unlocking and Resetting User Passwords
    • Using Enterprise Manager Database Express 12c to Unlock Accounts and Reset Passwords
    • Using SQL*Plus 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

9 Removing Oracle Database Software

• About Oracle Deinstallation Options
• Example of Running the Deinstallation Tool
• Deinstallation Examples for Oracle Database
• Deinstallation Response File Example for Oracle Database
• Deinstallation Response File Example for Oracle Grid Infrastructure
• Downgrading Oracle Restart

A Installing Java Access Bridge

• Overview of Java Access Bridge 2.0.2
• Setting Up Java Access Bridge 2.0.2

B Optimal Flexible Architecture

• About the Optimal Flexible Architecture Standard
  • About Multiple Oracle Homes Support
• Changes to the Optimal Flexible Architecture for Oracle Database
• 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 Naming Convention
  • ORACLE_HOME Directory Naming Convention
  • Automatic Diagnostic Repository (ADR) Directory
  • ADMIN Directory
  • ORADATA Directory
  • RECOVERY_AREA Directory
• Optimal Flexible Architecture and Multiple Oracle Home Configurations
  • Specifying an ORACLE_HOME Directory
  • Installing a Default Optimal Flexible Architecture Database: Example 1
  • Installing a Nondefault Optimal Flexible Architecture Database: Example 2
• Comparison Between Optimal Flexible Architecture on Windows and UNIX
  • Directory Naming
  • ORACLE_BASE Directory
  • Support for Symbolic Links on Windows
• Optimal Flexible Architecture Structure File Mapping

C Installing and Configuring Oracle Database Using Response Files

• How Response Files Work
  • Reasons for Using Silent Mode or Response File Mode
  • Using Response Files
• Preparing a Response File
  • Editing a Response File Template
  • Saving 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
  • Silent Mode of Database Configuration Assistant
  • Running Database Configuration Assistant in Response File Mode
• Postinstallation Configuration Using Response File Created During Installation
  • About the Postinstallation Configuration File
  • Running Postinstallation Configuration Using Response File
• Postinstallation Configuration Using the ConfigToolAllCommands Script
• Using the Installation Response File for Postinstallation Configuration

D Configuring Networks for Oracle Database

• Installing Oracle Database on Computers with Multiple IP Addresses
• Installing Oracle Database on Computers with Multiple Aliases
• Installing Oracle Database on Nonnetworked Computers
• Installing a Loopback Adapter
  • Checking if a Loopback Adapter is Installed on Your Computer
  • Installing a Loopback Adapter on Windows 7
  • Installing Microsoft KM-TEST Loopback Adapter on Windows 8, Windows 8.1, Windows Server 2012, and Windows Server 2012 R2
  • Removing a Loopback Adapter

E Managing Oracle Database Port Numbers

• About Managing Ports
• About Viewing Port Numbers and Access URLs
• Oracle Database Component Port Numbers and Protocols
• Changing the Oracle Services for Microsoft Transaction Server Port

F Troubleshooting the Oracle Database Installation

• Verifying Requirements
• Encountering Installation Errors
• Reviewing the Log of an Installation Session
• Silent Mode Response File Error Handling
• Troubleshooting Host Name Changes and CSS
• Troubleshooting Configuration Assistants
  • Configuration Assistant Failures
  • Irrecoverable Errors
• Troubleshooting Inventory Issues
• Troubleshooting Screen Display Issues
• Cleaning Up After a Failed Installation
• Continuing Installations or Upgrades After Server Restarts

G 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)

Index