Oracle Database 19c: Administration Training Course

Introduction

• Architectural overview of the Oracle database server
• Introduction to Oracle multitenant container databases
• Oracle database instances and database sharding concepts

Interacting with Oracle Database

• Establishing connections to an Oracle database instance
• Utilizing Oracle database tools
• Using SQL*Plus
• Leveraging Oracle SQL Developer
• Employing the Database Configuration Assistant (DBCA)
• Key features of Enterprise Manager cloud control 13c
• Overview of Oracle Enterprise Manager components
• Consolidated enterprise management via a single pane of glass
• Administering the Oracle Enterprise Manager database

Oracle Database Creation

• Initializing an Oracle database via DBCA
• Creating an Oracle database using SQL commands

Managing Database Instances

• Initiating the Oracle database instance
• Terminating an Oracle database instance
• Differences between shutdown modes
• Opening and closing pluggable databases (PDBs)
• Configuration of PDBs

Database Instance Administration

• Application of initialization parameters
• Interaction with the automatic diagnostic repository
• Reviewing the alert log
• Utilizing trace files
• Administration of the DDL log file
• Working with dynamic performance views
• Utilization of the data dictionary

Oracle Net Services Overview

• Definition of Oracle net services components
• Configuration and management of Oracle net services
• Introduction to the Oracle net listener
• Comparison of dedicated versus shared server architectures

Naming Conventions and Methods

• Establishment of Oracle network connections
• Comprehension of naming methodologies
• Easy connect functionality
• Local and directory-based naming
• Workload management through database services
• Creation of database services

Listener Operations

• Utilization of the default listener
• Setting up dynamic service registration
• Configuring static service registration

Shared Server Architecture Setup

• Enabling the shared server mode
• Regulation of shared server operations
• Usage of SGA and PGA
• Considerations for shared server configuration

Oracle Connect Manager Configuration

• Understanding Oracle Connection Manager
• Application of filtering rules
• Implementation of intranet and internet access controls
• Utilization of session multiplexing
• General configuration of Oracle Connection Manager
• Configuration of the cman.ora file
• Client configuration
• Database server configuration
• Use of the Oracle Connection Manager control utility

PDB Creation

• Provisioning new pluggable databases
• Creating a new PDB from PDB$SEED
• Application of the FILE_NAME_CONVERT clause
• Use of OMF or the PDB_FILE_NAME_CONVERT parameter
• Alternative techniques for PDB creation

PDB Management

• Modification of PDB modes
• Adjustment of PDB settings
• Changes to initialization parameters
• Execution of the Alter System Command within a PDB
• Configuration of hostname and port number per PDB
• Removal of PDBs

Database Storage Concepts

• Architecture of database storage
• Database structures
• Application of segments, extents, and blocks
• Usage of tablespaces and data files
• Types of segments
• Storage of table data
• Contents of database blocks
• Management of deferred segment creation
• Monitoring of tablespace space utilization

Tablespace Administration

• Creation of tablespaces
• Definition of default permanent tablespaces
• Interaction with temporary tablespaces
• Modification and deletion of tablespaces
• Implementation of Oracle Managed Files (OMF)
• Migration or renaming of online data files

Optimizing Space Utilization

• Space management features
• Management of block space
• Specification of table compression

Undo Data Administration

• Management of transactions and undo data
• Storage of undo information
• Configuration of undo retention
• Enabling temporary undo

User Account Management

• Oracle-provided administrator accounts
• User authentication processes
• Assignment of quotas

Privilege and Role Authorization Setup

• System privileges concepts
• Configuration of system privileges
• Management of privileges

User Resource Limit Configuration

• Management of profiles and users
• Profile parameters explanation

Oracle Database Auditing

• Database security principles
• Implementation of auditing
• Fine-Grained Auditing (FGA) policy

Data Loading and Transport

• Data movement techniques
• Methods for data loading
• Data export and import procedures
• Database transportation

Database Monitoring

• Performance management tasks
• Database maintenance activities
• Performance tuning methodologies

Database Processes

• Process architecture and structure
• Utilization of distinct writer and monitor processes

Memory Management

• Administration of memory components
• Automatic memory management

SQL Analysis

• Utilization of the Oracle optimizer
• Optimization of access paths
• SQL plan directives

Course Summary and Future Steps