Oracle 19c Install & Upgrade
Contents
1 Oracle Database 19c: Overview
Objectives 1-2
Oracle Database Innovation 1-3
Enterprise Cloud Computing 1-4
Oracle Database Server Architecture: Overview 1-5
Oracle Database Instance Configurations 1-6
Connecting to the Database Instance 1-7
Oracle Database Memory Structures 1-8
Process Architecture 1-10
Process Structures 1-12
Database Storage Architecture 1-14
Logical and Physical Database Structures 1-16
Tablespaces and Data Files 1-18
SYSTEM and SYSAUX Tablespaces 1-19
Database User Accounts 1-20
Predefined Administrative Accounts 1-22
Administrative Privileges 1-23
Interacting with an Oracle Database: Memory, Processes, and Storage 1-24
Summary
Laboratory 1
2 Oracle Software Installation Basics
Objectives 2-2
Planning Your Installation 2-3
Configuring Oracle Linux with Oracle RDBMS Pre-Install RPM 2-5
Operating System Groups and Users 2-7
Environment Variables 2-8
Configuring the Oracle Software Owner Environment 2-9
Using Oracle Universal Installer (OUI) 2-10
Installation Option: Silent Mode 2-11
Summary
Laboratory 2
3 Installing Oracle Grid Infrastructure for a Standalone Server
Objectives 3-2
Overview of Oracle Grid Infrastructure for a Standalone Server 3-3
Oracle Restart 3-4
ASM Storage Components 3-6
Configuring Storage for Oracle Automatic Storage Management (ASM) 3-7
Oracle Grid Infrastructure Installation: System Requirements 3-8
Creating Operating System Groups and Users 3-9
Types of Installations 3-10
Installing the Oracle Grid Infrastructure for Standalone Server 3-12
Upgrading Existing Oracle ASM Instances 3-13
Summary
Laboratory 3
4 Installing Oracle Database Software
Objectives 4-2
Oracle Database Installation: System Requirements 4-3
Creating Operating System Groups and Users 4-4
Types of Installations 4-6
Quiz 4-7
Summary
Laboratory 4
5 Creating an Oracle Database by Using DBCA
Objectives 5-2
Planning the Database 5-3
Types of Databases 5-4
Choosing the Appropriate Character Set 5-5
Understanding How Character Sets Are Used 5-7
Setting the NLS_LANG Initialization Parameter 5-8
Using the DBCA to Create a Database 5-9
Creating a Container Database by Using DBCA 5-10
Creating a Database Design Template 5-11
Using the DBCA to Delete a Database 5-12
Using the DBCA for Additional Tasks 5-14
Summary
Laboratory 5
6 Oracle Restart
Objectives 6-2
Oracle Restart 6-3
Oracle Restart Process Startup 6-5
Controlling Oracle Restart 6-6
Choosing the Correct SRVCTL Utility 6-8
Oracle Restart Configuration 6-9
Using the SRVCTL Utility 6-10
Obtaining Help for the SRVCTL Utility 6-11
Starting Components by Using the SRVCTL Utility 6-12
Stopping Components by Using the SRVCTL Utility 6-13
Viewing Component Status 6-14
Displaying the Oracle Restart Configuration for a Component 6-15
Manually Adding Components to the Oracle Restart Configuration 6-16
Summary
Laboratory 6
7 Introduction to Upgrading to Oracle Database 19c
Objectives 7-2
Defining Upgrade and Data Migration 7-3
Upgrade Methods 7-4
Database Upgrade Assistant: Advantages and Disadvantages 7-5
Manual Upgrade: Advantages and Disadvantages 7-6
Upgrade Paths 7-7
Upgrade Method Limitations 7-8
Upgrading to a New Release of Oracle Database 7-9
Migration Methods 7-10
Using the Export and Import Method 7-11
Summary
Laboratory 7
8 Preparing to Upgrade to Oracle Database 19c
Objectives 8-2
Preparing to Upgrade 8-3
Planning the Upgrade 8-4
Developing a Test Plan 8-5
Performance Testing 8-6
Requirements for Databases Using Oracle Label Security or Oracle
Database Vault 8-7
Requirement for Databases Using Oracle Warehouse Builder 8-8
Using the Pre-Upgrade Information Tool 8-9
Backing Up the Database 8-10
Summary
Laboratory 8
9 Upgrading to Oracle Database 19c
Objectives 9-2
Upgrading by Using the Database Upgrade Assistant (DBUA) 9-3
Key DBUA Features 9-4
Manually Upgrading to Oracle Database 19c 9-7
Migrating a Pre-12.1 or 12.1 Non-CDB to CDB 9-9
Plugging a Non-CDB Database into a CDB 9-10
Summary
Laboratory 9
10 Performing Post-Upgrade Tasks
Objectives 10-2
Required Tasks After Database Upgrade 10-3
Recommended Tasks After Database Upgrade 10-4
Understanding Auditing Implementation 10-6
Enabling Unified Auditing 10-7
Administering the Roles Required for Auditing 10-8
Summary
Laboratory 10
11 Migrating Data by Using Oracle Data Pump
Objectives 11-2
Oracle Data Pump: Overview 11-3
Data Pump Export and Import Clients: Overview 11-4
Data Pump Utility: Interfaces and Modes 11-5
Migrating by Using Oracle Data Pump 11-6
Importing by Using a Network Link 11-7
Creating a Container Database by Using DBCA 11-8
Creating a New PDB from PDB$SEED 11-9
Exporting from a Non-CDB and Importing into a PDB 11-10
Summary 11-11
Laboratory 11
