Oracle 19c Database Administration I

Module 1: Introduction to Oracle Database

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

Module 2: Accessing an Oracle Database

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

Module 3: Creating an Oracle Database by Using DBCA

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

Module 4: Creating an Oracle Database by Using a SQL Command

• Creating a Container Database
• Enable Pluggable Database

Module 5: Starting Up and Shutting Down a Database Instance

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

Module 6: Managing Database Instances

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

Module 7: Oracle Net Services Overview

• Oracle Net Services Components
• Oracle Net Listener

Module 8: Configuring Naming Methods

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

Module 9: Configuring and Administering the Listener

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

Module 10: Configuring a Shared Server Architecture

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

Module 11: Configuring Oracle Connection Manager for Multiplexing and Access Control

• Oracle Connection Manager Processes
• Filtering Rules
• Session Multiplexing

Module 12: 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

Module 13: 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

Module 14: Managing PDBs

• Renaming a PDB
• Setting Parameter Values for PDBs

Module 15: Database Storage Overview

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

Module 16: Creating and Managing Tablespaces

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

Module 17: Improving Space Usage

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

Module 18: Managing Undo Data

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

Module 19: Creating and Managing User Accounts

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

Module 20: Configuring Privilege and Role Authorization

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

Module 21: Configuring User Resource Limits

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

Module 22: Implementing Oracle Database Auditing

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

Module 23: 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