Database Installation Guide - Oracle

2y ago
44 Views
2 Downloads
920.11 KB
198 Pages
Last View : 16d ago
Last Download : 2m ago
Upload by : Maxton Kershaw
Transcription

Oracle DatabaseDatabase Installation Guide19c for Microsoft WindowsE96293-06June 2020

Oracle Database Database Installation Guide, 19c for Microsoft WindowsE96293-06Copyright 1996, 2020, Oracle and/or its affiliates.Primary Authors: Sunil Surabhi, Tanaya BhattacharjeeContributing Authors: Prakash Jashnani, Mark Bauer, Bharathi JayathirthaContributors: 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, MohammedShahnawaz Quadri, Vishal Saxena, Krishna Itikarlapall, , Santanu Datta, Christian Shay, Aneesh Khanderwal,Michael Coulter, Robert Achacoso, Malai Stalin, David Price, Ramesh ChakravarthulaThis software and related documentation are provided under a license agreement containing restrictions onuse and disclosure and are protected by intellectual property laws. Except as expressly permitted in yourlicense 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. Reverseengineering, disassembly, or decompilation of this software, unless required by law for interoperability, isprohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. Ifyou 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 onbehalf 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. Governmentend users are "commercial computer software" or “commercial computer software documentation” pursuantto 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 programsembedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oraclecomputer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in thelicense contained in the applicable contract. The terms governing the U.S. Government’s use of Oracle cloudservices 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 thatmay create a risk of personal injury. If you use this software or hardware in dangerous applications, then youshall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure itssafe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of thissoftware or hardware in dangerous applications.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks oftheir respective owners.Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks areused 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 registeredtrademark 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 expresslydisclaim all warranties of any kind with respect to third-party content, products, and services unless otherwiseset forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will notbe 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.

ContentsPrefaceAudiencexiiiDocumentation AccessibilityxiiiSet Up Java Access Bridge to Implement Java AccessibilityxivRelated DocumentationxivConventionsxvChanges in this Release for Oracle Database Installation GuideChanges in Oracle Database 19c12xviOracle Database Installation ChecklistServer Hardware Checklist for Oracle Database Installation1-1Operating System Checklist for Oracle Database Installation on Microsoft Windows1-2Server Configuration Checklist for Oracle Database Installation1-2Storage Checklist for Oracle Database Installation1-3Oracle User Environment Configuration Checklist for Oracle Database Installation1-4Installer Planning Checklist for Oracle Database Installation1-5Oracle Database Preinstallation TasksOracle Database Minimum Hardware Requirements2-1Hardware Component Requirements for Windows x642-1Hard Disk Space Requirements2-2Verifying Hardware Requirements2-3Oracle Database Software Requirements2-3Windows Certification and Web Browser Support2-5Remote Desktop Services2-5Microsoft Windows Servicing Options2-6Installation Requirements for Web Browsers2-6Default Share Configuration Requirement2-7Reviewing Operating System Security Common Practices2-7iii

Confirming Host Name Resolution2-7Individual Component Requirements2-7Configuring Disk Storage for Oracle Data Files and Recovery FilesChoosing a Storage Option for Oracle Database and Recovery FilesCreating Directories for Oracle Data Files or Recovery Files2-82-9Guidelines for Placing Oracle Recovery Files on a File System2-92-10Oracle Database Security Strong Authentication Requirements2-11Oracle Enterprise Manager Requirements2-11Oracle-Managed Files Requirements2-11Oracle Volume Shadow Copy Service (VSS) Writer2-11Overview of Oracle Database InstallationInstallation Considerations3-1Oracle Base Directory3-1Oracle Home Directory3-2Contents of the Oracle Home Environment3-3Multiple Oracle Home Components3-3Oracle Inventory Directory3-3Installing Oracle Database Vault in an Oracle Data Guard Environment3-3Oracle Database Vault Default Audit Policy and Initialization Parameters3-4Consider Memory Allocation and Automatic Memory Management3-4Database Configuration OptionsCreating a Database After InstallationCreating an Oracle Database on Direct NFS42-8Guidelines for Placing Oracle Database Files on a File System or LogicalVolumeCreating Required Directories32-83-43-53-5Configuring Users, Groups and Environments for Oracle DatabaseCreating Required Operating System Groups and Users4-1About the Oracle Installation User4-2Creating Oracle Home User4-2Understanding the Oracle Inventory Directory and the Oracle Inventory Group4-3Operating System Groups Created During Oracle Database Installation4-4Operating System Groups and Users for Job Role Separation4-7About Job Role Separation Operating System Privileges Groups and Users4-8Oracle Software Owner for Each Oracle Software Product4-8Standard Oracle Database Groups for Job Role Separation4-8Extended Oracle Database Groups for Job Role Separation4-9Oracle Automatic Storage Management Groups for Job Role Separation4-10iv

Windows Group Managed Service Accounts and Virtual Accounts4-11Microsoft Hyper-V Requirements4-11Stopping Existing Oracle Services4-11Configuring User Accounts4-12Configuring Environment Variables for the Software Installation Owner4-12Managing User Accounts with User Account Control4-12Creating Oracle Database Vault User Accounts564-13Configuring File System Storage for Oracle DatabaseAbout Direct NFS Client Storage5-2About the Oranfstab File for Direct NFS Client5-3Mounting NFS Storage Devices with Direct NFS Client5-3Specifying Network Paths for a NFS Server5-3Creating an oranfstab File for Direct NFS Client5-3Performing Basic File Operations Using the ORADNFS Utility5-6Monitoring Direct NFS Client Usage5-7Enabling Direct NFS Client5-7Disabling Direct NFS Client5-7Enabling HCC on Direct NFS Client5-8Installing and Configuring Oracle Grid Infrastructure for aStandalone ServerRequirements for an Oracle Restart Installation6-3System Requirements6-3Memory Requirements6-4Disk Space Requirements6-4Oracle ACFS and Oracle ADVM6-4Oracle ACFS and Oracle ADVM Support on Microsoft Windows6-4Restrictions and Guidelines for Oracle ACFS6-5Oracle Automatic Storage Management Storage Configuration6-6About Managing Disk Groups for Older Database Versions6-6Oracle Automatic Storage Management Installation Considerations6-7Configuring Storage for Oracle Automatic Storage Management6-7Identifying Storage Requirements for Oracle Automatic StorageManagement6-8Oracle ASM Disk Space Requirements6-11ASM Disk Group Options for Interactive and Noninteractive Installation6-12Configuring Disks Manually for Oracle Automatic Storage Management6-14About Upgrading Existing Oracle Automatic Storage Management Instances6-16v

7Configuring Oracle Automatic Storage Management Disk Groups Manually UsingOracle ASMCA6-17About Image-Based Oracle Grid Infrastructure Installation6-17Setup Wizard Installation Options for Creating Images6-18Installing Oracle Grid Infrastructure for a Standalone Server with a New DatabaseInstallation6-19Installing Oracle Grid Infrastructure for a Standalone Server for an ExistingDatabase6-20Installing Oracle Grid Infrastructure for a Standalone Server Using a Software-OnlyInstallation6-20Installing Software Binaries for Oracle Grid Infrastructure for a StandaloneServer6-21Configuring Software Binaries for Oracle Grid Infrastructure for a StandaloneServer6-21Testing the Oracle Automatic Storage Management Installation6-22Modifying Oracle Grid Infrastructure for a Standalone Server Binaries AfterInstallation6-23Installing Oracle DatabasePreinstallation Considerations for Installing Oracle Database7-1Installation Consideration on Windows7-2Performing Multiple Oracle Database Installations7-2Installing on Systems That Already Have Oracle Components7-2Installing with Minimum Memory Requirements7-3Reviewing Component-Specific Installation Guidelines7-4Using an Oracle Automatic Storage Management Disk Group7-4About Character Set Selection During Installation7-5Accessing the Installation Software7-6Downloading Oracle Software7-7Downloading the Installation Archive Files from Oracle Technology Network7-7Downloading the Software from Oracle Software Delivery Cloud7-7Extracting the Installation File7-8Installing on Remote Computers Through Remote Access Software7-9Installing on Remote Computers from a Hard Drive7-9Installing on Remote Computers from a Remote DVD Drive7-9Installing from a Remote DVD Drive7-10Step 1: On the Remote Computer, Share the DVD Drive7-10Step 2: On the Local Computer, Map the DVD Drive7-10Copying the Oracle Database Software to a Hard DiskInstalling and Using Oracle Components in Different Languages7-117-11Configuring Oracle Components to Run in Different Languages7-11Determining the Operating System Locale7-12vi

Configuring Locale and Character Sets Using the NLS LANG EnvironmentVariable7-13NLS LANG Settings in Console Mode and Batch Mode7-14Installing Translation Resources7-15Running Oracle Universal Installer in Different Languages7-16About Image-Based Oracle Database Installation7-16Setup Wizard Installation Options for Creating Images7-17Installing the Oracle Database Software7-18Installing Standard Edition High Availability7-19About Standard Edition High Availability7-19Requirements for Installing Standard Edition High Availability7-20Deploying Standard Edition High Availability7-21Installing Standard Edition High Availability Database Software on Local FileSystem7-21Installing Standard Edition High Availability Database Software on OracleACFS7-23Cloning an Oracle Home87-26Oracle Database Postinstallation TasksDownloading and Installing Release Update Patches8-2Requirements for Database Password8-2About Installing Oracle Autonomous Health Framework8-3Recompiling Invalid Objects on Windows Systems8-3Configuring the Secure Sockets Layer8-4Configuring Oracle Components8-4Configuring Oracle Messaging Gateway8-5Configuring the OraClrAgnt Service for Oracle Database Extensions for .NET8-5Configuring Oracle Net Services8-6Installing Oracle Text Supplied Knowledge Bases8-7Installing the Oracle Text Filtering Component8-7Configuring or Reinstalling Oracle XML DB8-7Configuring PL/SQL External Procedures8-7Configuring Shared Server Support8-8Setting Credentials for the Job System to Work with Oracle Enterprise Manager8-8Configuring Oracle Database to Communicate with Oracle Automatic StorageManagement8-9Installing Oracle Database Examples8-9Creating the OraMTS Service for Microsoft Transaction Server8-9Creating a Fast Recovery Area Disk Group8-10About the Fast Recovery Area and the Fast Recovery Area Disk Group8-10Creating the Fast Recovery Area Disk Group8-11vii

9Enabling and Disabling Database Options After Installation8-12Changing the Oracle Home User Password8-13Getting Started with Oracle DatabaseChecking the Installed Oracle Database Contents and Directory Location9-2Logging In to Oracle Enterprise Manager Database Express 19c9-2Managing Oracle Automatic Storage Management9-3Starting and Stopping Oracle Automatic Storage Management9-3Oracle Automatic Storage Management Utilities9-3Starting and Stopping an Oracle DatabaseStarting and Stopping the Database from the Microsoft Windows Services Utility9-5Accessing Oracle Database with Oracle SQL Developer9-5Reviewing User Accounts and Passwords9-6B9-7Unlocking and Resetting User Passwords9-10Using EM Express to Unlock Accounts and Reset Passwords9-11Using SQL*Plus to Unlock and Change Passwords9-11Identifying Databases9-12Locating the Server Parameter File9-13Identifying Tablespaces and Data Files9-13Locating Redo Log Files9-14Locating Control Files9-15Understanding Oracle Database Services on Windows9-15Removing Oracle Database SoftwareAbout Oracle Deinstallation Options10-1Files Deleted by the deinstall Command10-2Deinstallation Examples for Oracle Database10-3Downgrading Oracle RestartA9-4Accessing Oracle Database with SQL*PlusOracle Database System Privileges Accounts and Passwords109-410-4Installing Java Access BridgeOverview of Java Access Bridge 2.0.2A-1Setting Up Java Access Bridge 2.0.2A-1Optimal Flexible ArchitectureAbout the Optimal Flexible Architecture StandardB-1About Multiple Oracle Homes SupportB-2viii

CDEOracle Base Directory Naming ConventionB-2Oracle Home Directory Naming ConventionB-3Optimal Flexible Architecture File Path ExamplesB-4Installing and Configuring Oracle Database Using Response FilesHow Response Files WorkC-1Reasons for Using Silent Mode or Response File ModeC-2Using Response FilesC-2Preparing a Response FileC-3Editing a Response File TemplateC-3Saving a Response FileC-4Running Oracle Universal Installer Using the Response FileC-5Running Net Configuration Assistant Using a Response FileC-6Running Oracle Database Configuration Assistant Using a Response FileC-7Silent Mode of Database Configuration AssistantC-7Running Oracle Database Configuration Assistant in Response File ModeC-8Postinstallation Configuration Using Response File Created During InstallationC-8About the Postinstallation Configuration FileC-9Running Postinstallation Configuration Using Response FileC-9Postinstallation Configuration Using the ConfigToolAllCommands ScriptC-10Using the Installation Response File for Postinstallation ConfigurationC-11Configuring Read-Only Oracle HomesUnderstanding Read-Only Oracle HomesD-1About Read-Only Oracle HomesD-1About Oracle Base HomesD-2About Oracle Base ConfigD-3About orabasetabD-3Enabling a Read-Only Oracle HomeD-4Copying demo Directories to Oracle Base HomeD-6Determining if an Oracle Home is Read-OnlyD-9File Path and Directory Changes in Read-Only Oracle HomesD-9Configuring Networks for Oracle DatabaseInstalling Oracle Database on Computers with Multiple IP AddressesE-1Installing Oracle Database on Computers with Multiple AliasesE-2Installing Oracle Database on Nonnetworked ComputersE-2Installing a Loopback AdapterE-3About Using Loopback Adapters with Oracle DatabaseE-3ix

FChecking if a Loopback Adapter is Installed on Your ComputerE-3Installing a Loopback AdapterE-4Removing a Loopback AdapterE-6Managing Oracle Database Port NumbersAbout Managing PortsF-1Oracle Database Component Port Numbers and ProtocolsF-1Changing the Oracle Services for Microsoft Transaction Server PortF-3Indexx

List of Examples5-1Using Local and Path NFS Server Entries5-2Using Names in Place of IP Addresses, with Multiple Exports, management and5-5community5-55-3Using Kerberos Authentication with Direct NFS Export5-66-1Using the asmtool Utility (Command Line)6-156-2Enabling Oracle ACFS on Oracle Restart Configurations6-248-1Running the Chopt Tool8-12C-1Password response file for Oracle Grid Infrastructure for a Standalone ServerC-10C-2Password response file for Oracle DatabaseC-10C-3Response File Passwords for Oracle Grid InfrastructureC-11C-4Response File Passwords for Oracle Grid Infrastructure for a Standalone ServerC-5(Oracle Restart)C-11Response File Passwords for Oracle DatabaseC-12xi

List of Tables1-1Server Hardware Checklist for Oracle Database Installation1-11-2Operating System General Checklist for Oracle Database on Microsoft Windows1-21-3Server Configuration Checklist for Oracle Database1-21-4Storage Checklist for Oracle Database1-41-5User Environment Configuration for Oracle Database1-51-6Oracle Universal Installer Planning Checklist for Oracle Database Installation1-52-1Windows x64 Minimum Hardware Requirements2-12-2Windows x64 Minimum Disk Space Requirements on NTFS2-22-3Windows x64 Software Requirements2-44-1User Groups Created During Oracle Database Installation4-46-1Oracle ASM Disk Number and Minimum Space Requirements for an Oracle database(non-CDB)6-26-11Oracle ASM Disk Number and Minimum Space Requirements for a multitenantcontainer database (CDB) with one pluggable database (PDB)6-116-3Image-Creation Options for Setup Wizard6-187-1Oracle Character Sets for Console Mode (OEM) Code Pages7-147-2Image-Creation Options for Setup Wizard7-178-1Database Options for Chopt Tool Command8-129-1Partial List of Oracle Database System Privileges Accounts Locked After Installation9-2Tablespaces and Data FilesA-1Copy Files to JDK Directory on Windows 64-BitA-2B-1Examples of OFA-Compliant Oracle Base Directory NamesB-3B-2Optimal Flexible Architecture Hierarchical File Path ExamplesB-4C-1Response FilesC-3D-1read/write and Read-Only Oracle Home File Path ExamplesD-9F-1Ports Used in Oracle ComponentsF-29-79-13xii

PrefaceLearn how to install and configure Oracle Database, perform postinstallation tasks,and how to remove the database software.The following topics are covered: Audience Documentation Accessibility Set Up Java Access Bridge to Implement Java AccessibilityInstall Java Access Bridge so that assistive technologies on Microsoft Windowssystems can use the Java Accessibility API. Related Documentation ConventionsAudienceThis guide is intended for anyone responsible for installing Oracle Database 19c.To use this document, you need the following: A supported Microsoft Windows operating system installed and tested on yourcomputer system Administrative privileges on the computer where you are installing the OracleDatabase software Familiarity with object-relational database management conceptsAdditional installation guides for Oracle Database, Oracle Real Application Clusters,Oracle Clusterware, Oracle Database Examples, and Oracle Enterprise ManagerCloud Control ar

Oracle Database Database Installation Guide 19c for Microsoft Windows E96293-06 June 2020

Related Documents:

viii Related Documentation The platform-specific documentation for Oracle Database 10g products includes the following manuals: Oracle Database - Oracle Database Release Notes for Linux Itanium - Oracle Database Installation Guide for Linux Itanium - Oracle Database Quick Installation Guide for Linux Itanium - Oracle Database Oracle Clusterware and Oracle Real Application Clusters

2 Installing Oracle Database and Creating a Database 2.1 Overview of Installing Oracle Database Software and Creating a Database 2-1 2.1.1 Checking Oracle Database Installation Prerequisites 2-2 2.1.2 Deciding on Oracle Database Installation Choices 2-3 2.1.2.1 Install Option for Oracle Database 2-3 2.1.2.2 Installation Class for Oracle .

Oracle e-Commerce Gateway, Oracle Business Intelligence System, Oracle Financial Analyzer, Oracle Reports, Oracle Strategic Enterprise Management, Oracle Financials, Oracle Internet Procurement, Oracle Supply Chain, Oracle Call Center, Oracle e-Commerce, Oracle Integration Products & Technologies, Oracle Marketing, Oracle Service,

Oracle is a registered trademark and Designer/2000, Developer/2000, Oracle7, Oracle8, Oracle Application Object Library, Oracle Applications, Oracle Alert, Oracle Financials, Oracle Workflow, SQL*Forms, SQL*Plus, SQL*Report, Oracle Data Browser, Oracle Forms, Oracle General Ledger, Oracle Human Resources, Oracle Manufacturing, Oracle Reports,

Getting Started with Database Classic Cloud Service. About Oracle Database Classic Cloud Service1-1. About Database Classic Cloud Service Database Deployments1-2. Oracle Database Software Release1-3. Oracle Database Software Edition1-3. Oracle Database Type1-4. Computing Power1-5. Database Storage1-5. Automatic Backup Configuration1-6

Oracle Database using Oracle Real Application Clusters (Oracle RAC) and Oracle Resource Management provided the first consolidation platform optimized for Oracle Database and is the MAA best practice for Oracle Database 11g. Oracle RAC enables multiple Oracle databases to be easily consolidated onto a single Oracle RAC cluster.

Oracle Database Net Services Administrator's Guide SQL*Plus User's Guide and Reference Oracle Database Heterogeneous Connectivity User's Guide Oracle Database 2 Day DBA Oracle Database Security Guide Many of the examples in this book use the sample schemas of the seed database, which is installed by default when you install Oracle.

For more information, see these Oracle resources: Oracle Database Backup and Recovery User's Guide Oracle Database Reference Oracle Database Utilities Many of the examples in this book use the sample schemas of the seed database, which is installed by default when you install Oracle. Refer to Oracle Database Sample Schemas