Oracle Database 19c: Administration

• Basic knowledge of SQL

Audience

• System administrator
• Technical consultant
• Database administrator

Oracle Database 19c is a multi-model database that provides full support for relational and non-relational data.

This instructor-led, live training (online or onsite) is aimed at system administrators who wish to learn how to administer, monitor, and support an Oracle database.

By the end of this training, participants will be able to:

• Understand the major feature and architectural changes Oracle database.
• Manage and monitor Oracle databases.
• Optimize Oracle database performance.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Introduction

• Overview of Oracle database server architecture
• Overview of Oracle multitenant container database
• Oracle database instance and database sharding

Accessing Oracle Database

• Connecting to an Oracle database instance
• Using Oracle database tools
• SQL*Plus
• Using Oracle SQL developer
• Using Database Configuration Assistant (DBCA)
• Understanding the Enterprise Manager cloud control 13c features
• Overview of Oracle Enterprise Manager component
• Single pane of glass for enterprise management
• Managing Oracle Enterprise Manager database

Creating an Oracle Database

• Creating an Oracle database using DBCA
• Creating an Oracle database using an SQL command

Working with Database Instances

• Starting the Oracle database instance
• Shutting down an Oracle database instance
• Comparing Shutdown modes
• Opening and closing PDBs
• Configuring PDBs

Managing Database Instances

• Using initialization parameters
• Working with the automatic diagnostic repository
• Viewing the alert log
• Using trace files
• Administering the DDL log file
• Working with dynamic performance views
• Using a data dictionary

Overview of Oracle Net Services

• Defining components of Oracle net services
• Configuring and managing Oracle net services
• Overview of Oracle net listener
• Comparing dedicated and shared server architecture

Naming Methods

• Establishing Oracle network connections
• Understanding the naming methods
• Easy connect
• Local and directory naming
• Managing workloads using database services
• Creating database services

Working with the Listener

• Using the default listener
• Configuring dynamic service registration
• Configuring static service registration

Configuring a Shared Server Architecture

• Enabling a shared server
• Controlling shared server operations
• Using SGA and PGA
• Shared server configuration considerations

Configuring Oracle Connect Manager

• Understanding Oracle Connection Manager
• Using filtering rules
• Implementing intranet and internet access control
• Using session multiplexing
• Configuring Oracle Connection Manager
• Configuring the cman.ora file
• Configuring clients
• Configuring the database server
• Using the Oracle Connection Manager control utility

Creating PDBs

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

Managing PDBs

• Changing the PDB mode
• Modifying PDB settings
• Changing initialization parameters
• Using the Alter System Command in a PDB
• Configuring hostname and port number per PDB
• Dropping PDBs

Understanding Database Storage

• Database storage architecture
• Database structures
• Using segments, extents, and blocks
• Using tablespaces and data files
• Understanding the types of segments
• Storing table data
• Database block content
• Managing deferred segment creation
• Monitoring tablespace space usage

Managing Tablespaces

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

Improving Usage Space

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

Managing Undo Data

• Managing transactions and undo data
• Storing undo information
• Configuring undo retention
• Enabling temporary undo

Creating and Managing User Accounts

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

Configuring Privilege and Role Authorization

• Understanding system privileges
• Configuring system privileges
• Managing privileges

Configuring User Resource Limits

• Managing profiles and users
• Understanding profile parameters

Oracle Database Auditing

• Understanding database security
• Auditing implementation
• FGA policy

Loading and Transporting Data

• Moving data
• Data loading methods
• Exporting and importing data
• Transporting a database

Database Monitoring

• Performance management activities
• Maintaining databases
• Understanding methods of performance tuning

Database Processes

• Process architecture and structure
• Using the different writer and monitor process

Managing Memory

• Managing memory components
• Automatic memory management

Analyzing SQL

• Using Oracle optimizer
• Optimising access paths
• SQL plan directives

Summary and Next Steps