1/212

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 on Oracle Solaris
• 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 Solaris with Oracle Database Prerequisites Packages

• About the Oracle Database Prerequisites Packages for Oracle Solaris
• Checking the Oracle Database Prerequisites Packages Configuration
• Installing the Oracle Database Prerequisites Packages for Oracle Solaris

4 Configuring Oracle Solaris Operating System for Oracle Database

• Guidelines for Oracle Solaris Operating System Installation
• 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
• Operating System Requirements for Oracle Solaris on SPARC (64-Bit)
  • Supported Oracle Solaris 11 Releases for SPARC (64-Bit)
  • Supported Oracle Solaris 10 Releases for SPARC (64-Bit)
• Operating System Requirements for Oracle Solaris on x86–64 (64-Bit)
  • Supported Oracle Solaris 11 Releases for x86-64 (64-Bit)
  • Supported Oracle Solaris 10 Releases for x86-64 (64-Bit)
• Additional Drivers and Software Packages for Oracle Solaris
  • Installing Oracle Messaging Gateway
  • Installation Requirements for ODBC and LDAP
    • About ODBC Drivers and Oracle Database
    • Installing ODBC Drivers for Oracle Solaris
    • About LDAP and Oracle Plug-ins
    • Installing the LDAP Package
  • Installation Requirements for Programming Environments
    • Installation Requirements for Programming Environments for Oracle Solaris
  • Installation Requirements for Web Browsers
• Checking the Software Requirements for Oracle Solaris
  • Verifying Operating System Version on Oracle Solaris
  • Verifying Operating System Packages on Oracle Solaris
  • Verifying Operating System Patches on Oracle Solaris 10
• Confirming Host Name Resolution
• Using Automatic SSH Configuration During Installation

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
  • 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 Oracle Solaris
  • 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
  • Guidelines for Installing Oracle ASMFD on Oracle Solaris
• Configuring Disk Devices for Oracle ASM on Oracle Solaris
• 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 Oracle Solaris 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
  • Enabling Data Analytics Accelerators on SPARC for Oracle Database
• 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

14 Completing Preinstallation Tasks Manually

• Configuring Kernel Parameters on Oracle Solaris
  • Minimum Parameter Settings for Installation
  • Checking Shared Memory Resource Controls
  • Displaying and Changing Kernel Parameter Values
  • Setting UDP and TCP Kernel Parameters Manually
• Configuring Shell Limits for Oracle Solaris

A 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

B 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

C Cloning Oracle Database

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

D Managing Oracle Database Port Numbers

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

Index