Course Description

The Oracle Database 19c Essential Administration course is designed for Database Administrators of small-sized databases who need to carry out basic system administration tasks on Oracle Database 19c.

The course is also suitable for support staff and personnel required to perform occasional administration or troubleshooting tasks. It is not intended for full-time Database Administrators. The focus is on using Enterprise Manager Express and SQL Developer to manage the database, with SQL*Plus also covered.

Exercises and examples provide practical hands-on experience.

Full-time Database Administrators should attend the Oracle Database 19c Administration course.

Versions supported: 12cR2, 18c, 19c.

Target Student

• Database Administrators of small-sized databases who need to install, monitor, and support an Oracle Database 12c.
• Support staff and personnel required to carry out occasional administration or troubleshooting tasks.

Pre-requisites

• Understanding of relational database concepts.
• Basic operating system knowledge.
• Working knowledge of Oracle SQL (can be gained from a prerequisite course).
• Course is run on Linux; basic knowledge of UNIX/Linux is recommended but not essential.

Course Objectives

• Install Oracle Database 19c software.
• Create and manage an Oracle database.
• Administer an Oracle database using Enterprise Manager Express, SQL Developer, and SQL*Plus.
• Configure the Oracle Network Environment.
• Create and manage database storage structures.
• Manage schema objects and users.
• Maintain database security.
• Backup, restore, and recover the database.
• Monitor database performance using advisors.

Course Content

Day 1

• Course Introduction
  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions
• Session 1: Introduction
  • Oracle product overview
  • Oracle Support services
  • Relational database concepts
  • Oracle architecture
  • Oracle Multitenant architecture
  • Overview of the Oracle Cloud
  • Database administration tasks
  • Database administration responsibilities
• Session 2: Install the Oracle Database Software with OUI
  • Installation planning
  • System requirements and OS pre-requisites
  • Oracle flexible architecture
  • Environment variables
  • Oracle Universal Installer (OUI)
  • Oracle Inventory
  • De-install Oracle Database software
• Session 3: Create a Database with DBCA
  • Storage methods
  • CDB vs. non-CDB database
  • Database type based on workload
  • Character set selection
  • Creating a database using DBCA
• Session 4: Administer a Database
  • Tools available to DBA
  • Using SQL*Plus and SQL Developer
  • Enterprise Manager Express
  • Enterprise Manager Cloud Control overview
• Session 5: Configure the Oracle Network Environment
  • Network configuration overview
  • Oracle Net Listener configuration and management
  • Oracle Net Naming methods
  • Configuring local naming
  • Managing Oracle listener
  • Testing connectivity with TNSPING
  • Connecting to the database

Day 2

• Session 6: Manage an Oracle Instance
  • Instance management
  • Memory structures
  • Background processes
  • Database authentication
  • Initialization parameters
  • Password file
  • Database startup/shutdown
  • Viewing alert logs and trace files
• Session 7: Database Storage Structures
  • Database structures
  • Control files, redo logs, and archive logs
  • Tablespaces and data files
  • Managing tablespaces
  • Managing undo using the Undo Advisor
• Session 8: Manage Users
  • Database administration accounts
  • User accounts
  • Creating and managing users
  • Locking/unlocking accounts
  • Changing passwords
  • Administering privileges and roles
• Session 9: Manage Schema Objects
  • Creating schema objects
  • Defining constraints
  • Creating indexes, views, synonyms, and sequences
• Session 10: Backup, Recover, and Restore a Database
  • Backup strategy
  • Backup, restore, and recovery overview
  • Configuring ARCHIVELOG mode
  • Scheduled backups
  • Performing recovery
• Session 11: Performance Monitoring
  • Self-monitoring architecture
  • Monitoring an Oracle database
  • Automatic Workload Repository
  • Automatic Database Diagnostics Monitor (ADDM)
  • Using performance advisors