Oracle 19C Database Administration I (Oracle DBA I)

Course Overview

Introduction to Oracle Database

• Oracle Multitenant Container Database
• Oracle Database Instance Configurations
• Database Sharding
• Oracle Database Server

Accessing an Oracle Database

• Oracle Database Tools
• Database Tool Choices
• SQL Developer
• Enterprise Manager Database Express

Creating an Oracle Database by Using DBCA

• Planning the Database
• Choosing a Database Template
• Configuration Assistant

Creating an Oracle Database by Using a SQL Command

• Creating a Container Database
• Enable Pluggable Database

Starting Up and Shutting Down a Database Instance

• Starting the Oracle Database Instance
• Shutting Down an Oracle Database Instance
• Opening and Closing PDBs

Managing Database Instances

• Investigating Initialization Parameter Files   
• Viewing Initialization Parameters by Using SQL*Plus   
• Modifying Initialization Parameters by Using SQL*Plus   
• Viewing Diagnostic Information   

Oracle Net Services Overview

• Oracle Net Services Components
• Oracle Net Listener

Configuring Naming Methods

• Configuring the Oracle Network to Access a Database   
• Creating a Net Service Name for a PDB

Configuring and Administering the Listener

• Exploring the Default Listener
• Creating a Second Listener   
• Connecting to a Database Service Using the New Listener

Configuring a Shared Server Architecture

• Configuring Shared Server Mode   
• Configuring Clients to Use a Shared Server

Configuring Oracle Connection Manager for Multiplexing and Access Control

• Oracle Connection Manager Processes
• Filtering Rules
• Session Multiplexing

Creating PDBs from Seed

• Provisioning New Pluggable Databases
• Tools
• Creating a New PDB from PDB$SEED
• Using OMF or the PDB_FILE_NAME_CONVERT Parameter   

Using Other Techniques to Create PDBs

• Cloning Regular PDBs
• Migrating Data from a Non-CDB into a CDB
• Remote PDB
• Cloning Remote PDBs in Hot Mode
• Creating a Proxy PDB

Managing PDBs

• Renaming a PDB   
• Setting Parameter Values for PDBs

Database Storage Overview

• Logical and Physical Database Structures
• Tablespaces and Data Files
• Types of Segments
• Monitoring Tablespace Space Usage

Creating and Managing Tablespaces

•  Viewing Tablespace Information   
• Creating a Tablespace   
• Managing Temporary and Permanent Tablespaces   

Improving Space Usage

• Managing Space in Tablespaces   
• Using Compression   
• Enabling the Resumable Space Allocation Feature

Managing Undo Data

• Transactions and Undo Data
• Managing Undo
• Configuring Undo Retention
• Categories of Undo
• Temporary Undo Benefits

Creating and Managing User Accounts

• Creating Common and Local Users   
• Creating a Local User for an Application   
• Exploring OS and Password File Authentication

Configuring Privilege and Role Authorization

• Granting a Local Role (DBA) to PDBADMIN   
• Using SQL*Developer to Create Local Roles

Configuring User Resource Limits

• Using SQL*Developer to Create a Local Profile & Users
• Configuring a Default Role for a User   

Implementing Oracle Database Auditing

• Enabling Unified Auditing   
• Creating Audit Users   
• Creating an Audit Policy   

Introduction to Loading and Transporting Data

• General Architecture
• Oracle Data Pump
• SQL Loader   
• Loading Data into a PDB from an External File   
• Moving Data from One PDB to Another PDB   
• Transporting a Tablespace   

Prerequisites

This hands-on course is geared for experienced DBAs new to Oracle 19c. Incoming students should possess:

• Basic understanding of database principles
• Linux skills, including familiarity with command-line options such as ls, cd, cp, and su
• Beginning to intermediate proficiency with SQL

Attendees should have skills equivalent to or should have attended this course as a pre-requisite: Introduction to Writing SQL Queries