Database Installation Guide

[Pages:22]Oracle? Database

Database Installation Guide

19c for Microsoft Windows

E96293-08 January 2022

Oracle Database Database Installation Guide, 19c for Microsoft Windows

E96293-08

Copyright ? 2015, 2022, Oracle and/or its affiliates.

Primary Author: Sunil Surabhi

Contributing Authors: Prakash Jashnani, Jean-Francois Verrier

Contributors: Sivaselvam Narayanasamy, Barb Glover, Eric Belden, Sudip Datta, David Friedman, Alex Keh, Peter LaQuerre, Rich Long, Matt McKerley, Sham Rao Pavan, Hanlin Qian, Sujatha Tolstoy, Sergiusz Wolicki, Sue Mavris, Mohammed Shahnawaz Quadri, Vishal Saxena, Krishna Itikarlapalli, Santanu Datta, Christian Shay, Aneesh Khanderwal, Michael Coulter, Robert Achacoso, Malai Stalin, David Price, Ramesh Chakravarthula

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government end users are "commercial computer software" or "commercial computer software documentation" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oracle computer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the license contained in the applicable contract. The terms governing the U.S. Government's use of Oracle cloud services are defined by the applicable contract for such services. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle, Java, and MySQL are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc, and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Contents

Preface

Audience

xiii

Documentation Accessibility

xiii

Set Up Java Access Bridge to Implement Java Accessibility

xiv

Related Documentation

xiv

Conventions

xv

Changes in this Release for Oracle Database Installation Guide

Changes in Oracle Database 19c

xvi

1 Oracle Database Installation Checklist

Server Hardware Checklist for Oracle Database Installation

1-1

Operating System Checklist for Oracle Database Installation on Microsoft Windows

1-2

Server Configuration Checklist for Oracle Database Installation

1-2

Storage Checklist for Oracle Database Installation

1-3

Oracle User Environment Configuration Checklist for Oracle Database Installation

1-4

Installer Planning Checklist for Oracle Database Installation

1-5

2 Oracle Database Preinstallation Tasks

Oracle Database Minimum Hardware Requirements

2-1

Hardware Component Requirements for Windows x64

2-1

Hard Disk Space Requirements

2-2

Verifying Hardware Requirements

2-3

Oracle Database Software Requirements

2-3

Windows Certification and Web Browser Support

2-5

Remote Desktop Services

2-5

Microsoft Windows Servicing Options

2-6

Installation Requirements for Web Browsers

2-6

Default Share Configuration Requirement

2-7

Reviewing Operating System Security Common Practices

2-7

iii

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

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

2-7 2-7 2-8 2-8 2-8 2-9 2-9 2-10 2-11 2-11 2-11 2-11

3 Overview of Oracle Database Installation

Installation Considerations

3-1

Oracle Base Directory

3-1

Oracle Home Directory

3-2

Contents of the Oracle Home Environment

3-3

Multiple Oracle Home Components

3-3

Oracle Inventory Directory

3-3

Installing Oracle Database Vault in an Oracle Data Guard Environment

3-3

Oracle Database Vault Default Audit Policy and Initialization Parameters

3-4

Consider Memory Allocation and Automatic Memory Management

3-4

Database Configuration Options

3-4

Creating a Database After Installation

3-5

Creating an Oracle Database on Direct NFS

3-5

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 Extended Oracle Database Groups for Job Role Separation Oracle Automatic Storage Management Groups for Job Role Separation

4-1 4-2 4-2 4-3 4-4 4-7 4-8 4-8 4-8 4-9 4-10

iv

Windows Group Managed Service Accounts and Virtual Accounts Microsoft Hyper-V Requirements Stopping Existing Oracle Services Configuring User Accounts Configuring Environment Variables for the Software Installation Owner Managing User Accounts with User Account Control Creating Oracle Database Vault User Accounts

4-11 4-11 4-11 4-12 4-12 4-12 4-13

5 Configuring File System Storage for Oracle Database

About Direct NFS Client Storage

5-2

About the Oranfstab File for Direct NFS Client

5-3

Mounting NFS Storage Devices with Direct NFS Client

5-3

Specifying Network Paths for a NFS Server

5-3

Creating an oranfstab File for Direct NFS Client

5-3

Performing Basic File Operations Using the ORADNFS Utility

5-6

Monitoring Direct NFS Client Usage

5-7

Enabling Direct NFS Client

5-7

Disabling Direct NFS Client

5-7

Enabling HCC on Direct NFS Client

5-8

6 Installing and Configuring Oracle Grid Infrastructure for a Standalone

Server

Requirements for an Oracle Restart Installation System Requirements Memory Requirements Disk Space Requirements

Oracle ACFS and Oracle ADVM Oracle ACFS and Oracle ADVM Support on Microsoft Windows Restrictions and Guidelines for Oracle ACFS

Oracle Automatic Storage Management Storage Configuration About 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 Oracle ASM Disk Space Requirements ASM Disk Group Options for Interactive and Noninteractive Installation Configuring Disks Manually for Oracle Automatic Storage Management

About Upgrading Existing Oracle Automatic Storage Management Instances Configuring Oracle Automatic Storage Management Disk Groups Manually Using Oracle ASMCA

6-3 6-3 6-4 6-4 6-4 6-4 6-5 6-6 6-6 6-7 6-7 6-8 6-11 6-12 6-14 6-16

6-17

v

About Image-Based Oracle Grid Infrastructure Installation Setup Wizard Installation Options for Creating Images 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

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

7 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 Using an Oracle Automatic Storage Management Disk Group About Character Set Selection During Installation Accessing the Installation Software

Downloading Oracle Software Downloading the Installation Archive Files from Oracle Technology Network Downloading the Software from Oracle Software Delivery Cloud Extracting the Installation File

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

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

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 About Image-Based Oracle Database Installation

6-17 6-18

6-19 6-20

6-20 6-21 6-21 6-22 6-23

7-1 7-2 7-2 7-2 7-3 7-4 7-4 7-5 7-6 7-7 7-7 7-7 7-8 7-8 7-9 7-9 7-9 7-10 7-10 7-11 7-11 7-11 7-12 7-12 7-14 7-15 7-15 7-16

vi

Setup Wizard Installation Options for Creating Images Installing the Oracle Database Software Installing Standard Edition High Availability

About Standard Edition High Availability Requirements for Installing Standard Edition High Availability Deploying Standard Edition High Availability

Installing Standard Edition High Availability Database Software on Local File System Installing Standard Edition High Availability Database Software on Oracle ACFS Cloning an Oracle Home

8 Oracle Database Postinstallation Tasks

Downloading and Installing Release Update Patches Requirements for Database Password About Installing Oracle Autonomous Health Framework Recompiling Invalid Objects on Windows Systems Configuring the Secure Sockets Layer Configuring Oracle Components

Configuring Oracle Messaging Gateway Configuring the OraClrAgnt Service for Oracle Database Extensions for .NET 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

9 Getting Started with Oracle Database

Checking the Installed Oracle Database Contents and Directory Location Logging In to Oracle Enterprise Manager Database Express 19c

7-16 7-17 7-18 7-19 7-19 7-20

7-21 7-23 7-26

8-1 8-2 8-3 8-3 8-4 8-4 8-5 8-5 8-6 8-7 8-7 8-7 8-7 8-8 8-8

8-9 8-9 8-9 8-10 8-10 8-11 8-12 8-13

9-2 9-2

vii

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 from the Microsoft Windows Services Utility

Accessing Oracle Database with SQL*Plus Accessing Oracle Database with Oracle SQL Developer Reviewing User Accounts and Passwords

Oracle Database System Privileges Accounts and Passwords Unlocking and Resetting User Passwords Using EM Express 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-2 9-3 9-3 9-4 9-4 9-4 9-5 9-6 9-6 9-10 9-11 9-11 9-11 9-12 9-13 9-14 9-14 9-15

10 Removing Oracle Database Software

About Oracle Deinstallation Options Files Deleted by the deinstall Command Deinstallation Examples for Oracle Database

Downgrading Oracle Restart

10-1 10-2 10-3 10-4

A Installing Java Access Bridge

Overview of Java Access Bridge 2.0.2

A-1

Setting Up Java Access Bridge 2.0.2

A-1

B Optimal Flexible Architecture

About the Optimal Flexible Architecture Standard

B-1

About Multiple Oracle Homes Support

B-2

Oracle Base Directory Naming Convention

B-2

Oracle Home Directory Naming Convention

B-3

Optimal Flexible Architecture File Path Examples

B-4

C Installing and Configuring Oracle Database Using Response Files

How Response Files Work

C-1

viii

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download