Oracle Database 19c: Administration Training Course

Introduction

• An overview of the Oracle database server architecture
• An introduction to Oracle multitenant container databases
• Concepts of Oracle database instances and database sharding

Interacting with Oracle Database

• Establishing connections to Oracle database instances
• Utilizing core Oracle database tools
• Working with SQL*Plus
• Leveraging Oracle SQL developer
• Using the Database Configuration Assistant (DBCA)
• Exploring the features of Enterprise Manager cloud control 13c
• An overview of the Oracle Enterprise Manager component
• The concept of a single pane of glass for enterprise management
• Administering the Oracle Enterprise Manager database

Creating an Oracle Database

• Setting up an Oracle database via DBCA
• Creating an Oracle database using SQL commands

Operating with Database Instances

• Initiating the Oracle database instance
• Terminating an Oracle database instance
• Comparing different shutdown modes
• Opening and closing PDBs
• Configuring PDBs

Administering Database Instances

• Managing initialization parameters
• Working with the automatic diagnostic repository
• Reviewing the alert log
• Utilizing trace files
• Managing the DDL log file
• Interacting with dynamic performance views
• Using the data dictionary

Introduction to Oracle Net Services

• Identifying the components of Oracle net services
• Configuring and administering Oracle net services
• An overview of the Oracle net listener
• Comparing dedicated and shared server architectures

Naming Conventions

• Establishing connections over the Oracle network
• Understanding various naming methods
• Implementing easy connect
• Managing local and directory naming
• Managing workloads through database services
• Creating database services

Working with the Listener

• Utilizing the default listener
• Setting up dynamic service registration
• Setting up static service registration

Setting Up a Shared Server Architecture

• Enabling the shared server
• Controlling shared server operations
• Utilizing SGA and PGA
• Considerations for shared server configuration

Configuring Oracle Connect Manager

• Understanding the Oracle Connection Manager
• Applying filtering rules
• Implementing access control for intranet and internet environments
• Utilizing session multiplexing
• Configuring the Oracle Connection Manager
• Configuring the cman.ora file
• Configuring client connections
• Configuring the database server
• Using the Oracle Connection Manager control utility

Creating PDBs

• Provisioning new pluggable databases
• Creating a new PDB from PDB$SEED
• Utilizing the FILE_NAME_CONVERT clause
• Using OMF or the PDB_FILE_NAME_CONVERT parameter
• Alternative methods for creating PDBs

Administering PDBs

• Modifying the PDB mode
• Updating PDB settings
• Changing initialization parameters
• Using the Alter System Command within a PDB
• Configuring hostname and port numbers for each PDB
• Dropping PDBs

Understanding Database Storage

• The architecture of database storage
• Database structural components
• Utilizing segments, extents, and blocks
• Managing tablespaces and data files
• Understanding the different types of segments
• Storing table data
• Database block contents
• Managing deferred segment creation
• Monitoring space usage within tablespaces

Managing Tablespaces

• Creating new tablespaces
• Defining default permanent tablespaces
• Working with temporary tablespaces
• Altering and dropping tablespaces
• Implementing Oracle Managed File (OMF)
• Moving or renaming online data files

Optimizing Space Usage

• Understanding space management features
• Managing block space
• Configuring table compression

Managing Undo Data

• Handling transactions and undo data
• Storing undo information
• Configuring undo retention settings
• Enabling temporary undo

Creating and Managing User Accounts

• Oracle-supplied administrator accounts
• Authenticating users
• Assigning resource quotas

Configuring Privilege and Role Authorization

• Understanding system privileges
• Configuring system privileges
• Managing privilege assignments

Configuring User Resource Limits

• Managing user profiles and accounts
• Understanding profile parameters

Oracle Database Auditing

• Understanding database security protocols
• Implementing auditing measures
• Configuring FGA policy

Loading and Transporting Data

• Moving data between systems
• Various data loading methods
• Exporting and importing data sets
• Transporting entire databases

Database Monitoring

• Activities related to performance management
• Routine database maintenance
• Understanding performance tuning methodologies

Database Processes

• Process architecture and structural design
• Utilizing various writer and monitor processes

Memory Management

• Managing memory components
• Implementing automatic memory management

Analyzing SQL

• Leveraging the Oracle optimizer
• Optimizing data access paths
• Managing SQL plan directives

Summary and Next Steps