1/199

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 IBM AIX on POWER Systems (64-Bit)
• 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

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 Configuring Operating Systems for Oracle Database on IBM AIX on POWER Systems (64-Bit)

• Guidelines for IBM AIX on POWER Systems (64-Bit) 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 IBM AIX on POWER Systems (64-Bit)
  • Supported IBM AIX 6.1 Versions
  • Supported IBM AIX 7.1 Versions
  • Supported IBM AIX 7.2 Versions
• Additional Drivers and Software Packages for IBM AIX on POWER Systems (64-Bit)
  • Installing Oracle Messaging Gateway
  • Installation Requirements for ODBC and LDAP
    • About ODBC Drivers and Oracle Database
    • Installing ODBC Drivers for IBM AIX
    • About LDAP and Oracle Plug-ins
    • Installing the LDAP Package
  • Installation Requirements for Programming Environments
    • Installation Requirements for Programming Environments for IBM AIX
  • Installation Requirements for Web Browsers
• Checking the Software Requirements
• Confirming Host Name Resolution
• Enabling I/O Completion Ports
• Using Automatic SSH Configuration During Installation

4 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
• Running the rootpre.sh Script

5 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

6 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 IBM AIX
  • 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

7 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 HCC on Direct NFS Client

8 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 Disk Devices for Oracle ASM on IBM AIX
• 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

9 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

10 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 IBM AIX on POWER Systems (64-Bit)
• Installing the Oracle Database Software
  • Running Oracle Universal Installer to Install Oracle Database
• About Character Set Selection During Installation
• About Automatic Memory Management Installation Options
• Running Oracle Universal Installer in Different Languages

11 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

12 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 Shell Limits and System Configuration Parameters for IBM AIX
  • Configuring Shell Limits on IBM AIX
  • Configuring System Configuration Parameters for IBM AIX
• Checking Asynchronous Input Output Processes
• Setting UDP and TCP Kernel Parameters Manually

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