Oracle Database 19c Administration (Standard Edition 2) Training Course

Environment Preparation, Installation, and Configuration (SE2 Focus)

• Prerequisites and supported platforms for government operations
• Installing Oracle Database 19c SE2 and creating the initial database for government systems
• Post-install configuration, including listeners, services, and EM Express for government environments

Oracle Database Architecture and Core Infrastructure

• Concepts of instance versus database for government applications
• Overview of SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes in the context of government systems
• Parameter files, diagnostic destinations, and alert/trace files for government database management

Administration Tools and Connectivity

• Basics of Enterprise Manager Express and common tasks for government administrators
• Using SQL Developer for administration and development in government databases
• Oracle Net Services and listener configuration, including dedicated and shared basics for government networks

Database Creation and Instance Management

• Creating databases using DBCA and SQL commands for government operations
• Startup/shutdown modes, services, and basic PDB awareness appropriate for SE2 in government settings
• Initialization parameters and dynamic performance views (V$) for government database monitoring

Storage Management Best Practices

• Managing tablespaces and datafiles, including local extent management, temporary, and undo tablespaces for government storage
• Understanding segments, extents, blocks, and space monitoring in government databases
• Strategies for managing growth, moving datafiles, and considerations for Oracle Managed Files (OMF) in government environments

Security and Auditing

• Managing users, roles, system/object privileges, and implementing least-privilege design for government security
• Configuring password policies, profiles, and resource limits for government compliance
• Auditing concepts and implementation appropriate for SE2 in government systems

Backup and Recovery Strategies with RMAN

• Types of backups, retention policies, and recovery objectives for government databases
• Configuring RMAN, catalogs (where applicable), and validation processes for government data integrity
• Media recovery, point-in-time recovery, and handling failure scenarios in government environments

Performance Monitoring and Troubleshooting (SE2-Safe Methods)

• Reading execution plans using EXPLAIN PLAN and AUTOTRACE for government database optimization
• Basics of SQL tracing and wait event analysis for government performance tuning
• Proactive monitoring techniques using data dictionary and dynamic views for government systems

Migrating from 11g to 19c

• Upgrade paths, prerequisites, and compatibility considerations for government migrations
• Utilizing pre/auto-upgrade utilities and validation steps for government database transitions
• Post-upgrade tasks, deprecated features, and testing procedures for government systems

Summary and Next Steps