1/239

Contents

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Command Syntax
• Related Documentation
• Conventions

Changes in this Release for Oracle Database

• 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 Linux
• 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
• Deployment Checklist for Oracle Database

2 Checking and Configuring Server Hardware for Oracle Database

• Logging In to a Remote System Using X Window System
• Checking Server Hardware and Memory Configuration

3 Automatically Configuring Oracle Linux with Oracle Preinstallation RPM

• Overview of Oracle Linux Configuration with Oracle RPMs
• Installing the Oracle Preinstallation RPM with ULN Support
• Installing the Oracle Preinstallation RPM From Unbreakable Linux Network
• Installing a New Oracle Linux Installation from DVDs or Images
• Installing Oracle Linux with Oracle Linux Yum Server Support
• Configuring Oracle Ksplice to Perform Oracle Linux Updates
• Configure Additional Operating System Features

4 Configuring Operating Systems for Oracle Database on Linux

• Guidelines for Linux Operating System Installation
  • Completing a Minimal Linux Installation
    • About Minimal Linux Installations
    • RPM Packages for Completing Operating System Configuration
    • Open SSH Requirement for Minimal Installation
  • Completing a Default Linux Installation
  • About Oracle Linux with the Unbreakable Enterprise Kernel
  • About the Oracle Preinstallation RPM
  • Restrictions for HugePages and Transparent HugePages Configurations
• Reviewing Operating System and Software Upgrade Best Practices
  • General Upgrade Best Practices
  • New Server Operating System Upgrade Option
  • Oracle ASM Upgrade Notifications
• Reviewing Operating System Security Common Practices
• About Installation Fixup Scripts
• About Operating System Requirements
• Using Oracle RPM Checker on IBM: Linux on System z
• Operating System Requirements for x86-64 Linux Platforms
  • Supported Oracle Linux 7 Distributions for x86-64
  • Supported Oracle Linux 6 Distributions for x86-64
  • Supported Red Hat Enterprise Linux 7 Distributions for x86-64
  • Supported Red Hat Enterprise Linux 6 Distributions for x86-64
  • Supported SUSE Linux Enterprise Server 12 Distributions for x86-64
• Operating System Requirements for IBM: Linux on System z
  • Supported Red Hat Enterprise Linux 7 Distributions for IBM: Linux on System z
  • Supported Red Hat Enterprise Linux 6 Distributions for IBM: Linux on System z
  • Supported SUSE Linux Enterprise Server 12 Distributions for IBM: Linux on System z
• Additional Drivers and Software Packages for Linux
  • Installing PAM for Login Authentication on Linux
  • Installation Requirements for OCFS2
    • About OCFS2 and Shared Storage
    • Installing OCFS2
  • Installing Oracle Messaging Gateway
  • Installation Requirements for ODBC and LDAP
    • About ODBC Drivers and Oracle Database
    • Installing ODBC Drivers for Linux x86-64
    • About LDAP and Oracle Plug-ins
    • Installing the LDAP Package
  • Installation Requirements for Programming Environments for Linux
    • Installation Requirements for Programming Environments for Linux x86-64
    • Installation Requirements for Programming Environments for IBM: Linux on System z
  • Installation Requirements for Web Browsers
• Checking Kernel and Package Requirements for Linux
• Installing the cvuqdisk RPM for Linux
• Confirming Host Name Resolution
• Disabling Transparent HugePages
• Using Automatic SSH Configuration During Installation
• Verifying the Disk I/O Scheduler on Linux

5 Configuring Users, Groups and Environments for Oracle Grid Infrastructure and Oracle Database

• Required Operating System Groups and Users
  • Determining If an Oracle Inventory and Oracle Inventory Group Exist
  • Creating the Oracle Inventory Group If an Oracle Inventory Does Not Exist
  • About Oracle Installation Owner Accounts
  • Identifying an Oracle Software Owner User Account
• Oracle Installations with Standard and Job Role Separation Groups and Users
  • About Oracle Installations with Job Role Separation
  • Standard Oracle Database Groups for Database Administrators
  • Extended Oracle Database Groups for Job Role Separation
  • Creating an ASMSNMP User
  • Oracle Automatic Storage Management Groups for Job Role Separation
• Creating Operating System Privileges Groups
  • Creating the OSDBA for ASM Group
  • Creating the OSOPER for ASM Group
  • Creating the OSDBA Group for Database Installations
  • Creating an OSOPER Group for Database Installations
  • Creating the OSBACKUPDBA Group for Database Installations
  • Creating the OSDGDBA Group for Database Installations
  • Creating the OSKMDBA Group for Database Installations
  • Creating the OSRACDBA Group for Database Installations
• Creating Operating System Oracle Installation User Accounts
  • Creating an Oracle Software Owner User
  • Environment Requirements for Oracle Software Owners
  • Procedure for Configuring Oracle Software Owner Environments
  • Modifying Oracle Owner User Groups
  • Checking Resource Limits for Oracle Software Installation Users
  • Setting Remote Display and X11 Forwarding Configuration
  • Preventing Installation Errors Caused by Terminal Output Commands
• Creating Oracle Database Vault User Accounts
• Unsetting Oracle Installation Owner Environment Variables

6 Configuring Networks for Oracle Database

• About Oracle Database Network Configuration Options
• About Assigning Global Database Names During Installation
• Network Configuration for Computers Completed After Installation
• Network Configuration for Multihome Computers
• Setting the ORACLE_HOSTNAME Environment Variable
• Network Configuration for Computers with Multiple Aliases

7 Supported Storage Options for Oracle Database and Oracle Grid Infrastructure

• Supported Storage Options for Oracle Database
• About Oracle Grid Infrastructure for a Standalone Server
• About Upgrading Existing Oracle Automatic Storage Management Instances
• About Managing Disk Groups for Older Database Versions
• Oracle ACFS and Oracle ADVM
  • Oracle ACFS and Oracle ADVM Support on Linux x86–64
  • Restrictions and Guidelines for Oracle ACFS
• File System Options for Oracle Database
• Guidelines for Placing Oracle Database Files On a File System or Logical Volume
• About NFS Storage for Data Files
• About Direct NFS Client Mounts to NFS Storage Devices

8 Configuring File System Storage for Oracle Database

• Configuring NFS Buffer Size Parameters for Oracle Database
• Checking TCP Network Protocol Buffer for Direct NFS Client
• Creating an oranfstab File for Direct NFS Client
• Enabling and Disabling Direct NFS Client Control of NFS
• Enabling Hybrid Columnar Compression on Direct NFS Client

9 Configuring Storage for Oracle Grid Infrastructure for a Standalone Server

• Configuring Storage for Oracle Automatic Storage Management
  • Identifying Storage Requirements for Oracle Automatic Storage Management
  • ASM Disk Group Options for Interactive and Noninteractive Installation
  • Using an Existing Oracle ASM Disk Group
• Configuring Storage Device Path Persistence Using Oracle ASMFD
  • About Oracle ASM with Oracle ASM Filter Driver
• Creating DAS or SAN Disk Partitions for Oracle Automatic Storage Management
• Creating Directories for Oracle Database Files
• Creating Files on a NAS Device for Use with Oracle Automatic Storage Management

10 Installing and Configuring Oracle Grid Infrastructure for a Standalone Server

• About Image-Based Oracle Grid Infrastructure Installation
• Installing Oracle Grid Infrastructure for a Standalone Server with a New Database Installation
• Installing Oracle Grid Infrastructure for a Standalone Server for an Existing Database
• Installing Oracle Grid Infrastructure for a Standalone Server Using a Software-Only Installation
  • About Oracle Grid Infrastructure Software-Only Installations
  • Installing Software Binaries for Oracle Grid Infrastructure for a Standalone Server
  • Configuring Software Binaries for Oracle Grid Infrastructure for a Standalone Server
• Testing the Oracle Automatic Storage Management Installation
• Modifying Oracle Grid Infrastructure for a Standalone Server Binaries After Installation
• Configuring Oracle ASM Disk Groups Manually using Oracle ASMCA
• Enabling Oracle ACFS on Oracle Restart Configurations

11 Installing Oracle Database

• Accessing the Installation Software
  • Downloading Oracle Software
  • Downloading the Installation Archive Files from OTN
  • Downloading the Software from Oracle Software Delivery Cloud Portal
  • Copying the Software to the Hard Disk
    • Mounting Disks on Linux Systems
• About Character Set Selection During Installation
• About Automatic Memory Management Installation Options
• Running Oracle Universal Installer in Different Languages
• Installing the Oracle Database Software
  • Running Oracle Universal Installer to Install Oracle Database

12 Oracle Database Postinstallation Tasks

• Required Postinstallation Tasks
  • Downloading and Installing Patch Updates
  • Unlocking and Resetting Oracle Database User Passwords
    • Requirements for Database Passwords
    • Oracle Database System Privileges Accounts and Passwords
    • Guidelines for Changing System Privileges Account Passwords
    • Locking and Unlocking User Accounts
    • Using SQL*Plus to Unlock Accounts and Reset Passwords
• Recommended Postinstallation Tasks
  • Creating a Backup of the root.sh Script
  • Setting Language and Locale Preferences for Client Connections
  • Recompiling All Invalid Objects
  • Downloading and Installing the ORAchk Health Check Tool
• About Changes in Default SGA Permissions for Oracle Database
• Checking Installed Oracle Database Contents and Directory Location
• Enabling and Disabling Oracle Database Options After Installation
  • Chopt Tool
• Starting Oracle Enterprise Manager Database Express
• About Deploying Oracle Database Using Rapid Home Provisioning
• Creating a Fast Recovery Area
  • About the Fast Recovery Area and the Fast Recovery Area Disk Group
  • Creating the Fast Recovery Area Disk Group

13 Removing Oracle Database Software

• About Oracle Deinstallation Options
• Oracle Deinstallation Tool (Deinstall)
• Deinstallation Examples for Oracle Database
• Downgrading Oracle Restart
• Deinstalling Previous Release Grid Home

A Completing Preinstallation Tasks Manually

• Configuring Kernel Parameters for Linux
  • Minimum Parameter Settings for Installation
  • Changing Kernel Parameter Values
  • Configuring Additional Kernel Settings for SUSE Linux
  • Setting UDP and TCP Kernel Parameters Manually
• Configuring Storage Device Path Persistence Using Oracle ASMLIB
  • About Oracle ASM with Oracle ASMLIB
  • Installing and Configuring Oracle ASMLIB Software
  • Configuring Disk Devices to Use Oracle ASMLIB
  • Administering Oracle ASMLIB and Disks
  • Deinstalling Oracle ASMLIB On Oracle Database
• Configuring Storage Device Path Persistence Manually
  • Configuring Device Persistence Manually for Oracle ASM

B 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 Response Files
  • Editing a Response File Template
  • Recording Response Files
• Running Oracle Universal Installer Using a Response File
• Running Configuration Assistants Using Response Files
  • Running Net Configuration Assistant Using Response Files
  • Running Database Configuration Assistant Using Response Files
• Postinstallation Configuration Using Response File Created During Installation
  • Using the Installation Response File for Postinstallation Configuration
  • Running Postinstallation Configuration Using Response File
• Postinstallation Configuration Using the ConfigToolAllCommands Script
  • About the Postinstallation Configuration File
  • Creating a Password Response File
  • Running Postinstallation Configuration Using a Password Response File

C Optimal Flexible Architecture

• About the Optimal Flexible Architecture Standard
• About Multiple Oracle Homes Support
• About the Oracle Inventory Directory and Installation
• Oracle Base Directory Naming Convention
• Oracle Home Directory Naming Convention
• Optimal Flexible Architecture File Path Examples

D Cloning Oracle Database

• Cloning an Oracle Home
• Configuring Oracle Configuration Manager in a Cloned Oracle Home

E Managing Oracle Database Port Numbers

• About Managing Ports
• About Viewing Port Numbers and Access URLs
• Oracle Database Component Port Numbers and Protocols

Index