Oracle Database 19c SE2 Administration Essentials Training Course

Introduction and Fundamentals

• Overview of Oracle Database architecture for government use.
• Differentiating between a database instance and a database.
• Understanding the memory and process architecture, including the System Global Area (SGA), Program Global Area (PGA), and background processes.
• Key files: parameter files, control files, redo logs, alert logs, and trace files for government operations.
• General overview of Oracle Multitenant architecture, focusing on Container Databases (CDB) and Pluggable Databases (PDB), with specific scope in Standard Edition 2 (SE2).

Environment Preparation and Installation

• Prerequisites and supported platforms for government installations.
• Step-by-step installation of Oracle Database 19c SE2 in a government environment.
• Creating the initial database using Database Configuration Assistant (DBCA) for government systems.
• Post-installation configuration, including listeners, services, and Enterprise Manager Express for government use.

Administration Tools and Connectivity

• Connecting to an Oracle Database instance in a government setting.
• Basic commands and administration using SQL*Plus for government databases.
• Utilizing Oracle SQL Developer for database management tasks in government operations.
• Monitoring and common tasks with Oracle Enterprise Manager Express for government use.
• Configuring Net Services and listeners for secure government connectivity.

Instance and Database Management

• Startup and shutdown modes for government database instances.
• Creating databases using DBCA and SQL commands in a government context.
• Managing initialization parameters and dynamic performance views (V$) for government systems.
• Handling alert logs, trace files, and the Automatic Diagnostic Repository for government operations.
• Utilizing the data dictionary for government database management.

Connectivity and Naming Methods

• Establishing secure network connections in a government environment.
• Understanding naming methods: Easy Connect, Local Naming, and Directory Naming for government use.
• Managing database services in government operations.
• Configuring listener agents dynamically and statically for government systems.

Multitenant Architecture (CDB and PDB) – SE2 Scope

• Concepts of Container Databases (CDB) and Pluggable Databases (PDB) for government use.
• Creating PDBs using PDB$SEED, Oracle Managed Files (OMF), and PDB_FILE_NAME_CONVERT parameters in a government context.
• Managing PDB modes, parameters, and host/port configuration for government operations.
• Removing PDBs from government systems.
• Configuring shared server mode, including SGA and PGA settings, for government use.

Storage Administration

• Managing tablespaces and datafiles in a government database environment.
• Handling temporary and undo tablespaces for government operations.
• Understanding segments, extents, blocks, and space management in government systems.
• Configuring file growth, Oracle Managed Files (OMF), and datafile movement for government use.

Security and Auditing

• Managing users, roles, and privileges in government databases, adhering to the principle of least privilege.
• Implementing profiles, password policies, and resource limits for government security.
• Auditing concepts specific to Oracle SE2 for government use.
• Auditing critical operations in a government context.

Backup and Recovery (RMAN)

• Developing backup strategies, including types, retention policies, and recovery objectives for government systems.
• Configuring RMAN and catalogs for government use.
• Addressing recovery scenarios such as media recovery, point-in-time recovery, and common failures in a government context.
• Validating backups for government operations.

Monitoring and Performance Optimization

• Using execution plans (EXPLAIN PLAN, AUTOTRACE) for performance tuning in government databases.
• Diagnosing waits and common events in a government environment.
• Proactive monitoring with data dictionary and dynamic views for government operations.
• Implementing tuning methods specific to SE2 for government use.

Migration from Oracle 11g to 19c

• Understanding upgrade paths and prerequisites for government migrations.
• Utilizing pre-auto-upgrade tools for government database migrations.
• Performing validation steps and resolving incompatibilities during government migrations.
• Completing post-upgrade tasks, addressing deprecated features, and conducting post-migration testing for government systems.

Course Closure

• General summary of key concepts and practices for government use.
• Best practice recommendations for maintaining and optimizing Oracle Database 19c SE2 in a government environment.

Summary and Next Steps