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

Environment Preparation, Installation, and Configuration (SE2 Focus)

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

Oracle Database Architecture and Core Infrastructure

• Understanding instance versus database concepts in the context of public sector operations
• Key components: SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes for government systems
• Configuration of parameter files, diagnostic destinations, and alert/trace files to ensure robust monitoring and troubleshooting for government applications

Administration Tools and Connectivity

• Basics of Enterprise Manager Express and common administrative tasks for government use
• Utilizing SQL Developer for administration and development in government environments
• Oracle Net Services and listener configuration, including dedicated/shared basics for efficient connectivity in public sector applications

Database Creation and Instance Management

• Creating databases using DBCA and SQL commands tailored for government requirements
• Managing startup/shutdown modes, services, and basic PDB awareness (SE2-appropriate) to ensure continuous operation in public sector systems
• Configuration of initialization parameters and dynamic performance views (V$) to optimize performance for government databases

Storage Management Best Practices

• Managing tablespaces and datafiles, including local extent management, temporary, and undo tablespaces for efficient storage in government applications
• Understanding segments, extents, blocks, and space monitoring to ensure optimal resource utilization for government systems
• Strategies for managing growth, moving datafiles, and considerations for Oracle Managed Files (OMF) to support scalable public sector operations

Security and Auditing

• User management, roles, system/object privileges, and implementing least-privilege design to enhance security in government databases
• Configuring password policies, profiles, and resource limits to ensure compliance with public sector standards
• Implementing auditing concepts appropriate for SE2 to meet the stringent security requirements of government agencies

Backup and Recovery Strategies with RMAN

• Types of backups, retention policies, and recovery objectives to ensure data integrity in government systems
• Configuring RMAN, catalogs (where applicable), and validation procedures for reliable backup management in public sector environments
• Media recovery, point-in-time recovery, and handling failure scenarios to maintain continuous operation of government databases

Performance Monitoring and Troubleshooting (SE2-Safe Methods)

• Reading execution plans using EXPLAIN PLAN and AUTOTRACE for effective query optimization in government applications
• Basics of SQL tracing and wait event analysis to identify performance bottlenecks in public sector systems
• Proactive monitoring techniques using data dictionary and dynamic views to ensure optimal performance for government databases

Migrating from 11g to 19c

• Upgrade paths, prerequisites, and compatibility considerations for a smooth transition in government environments
• Utilizing pre-auto upgrade utilities and validation steps to ensure successful migration for government databases
• Post-upgrade tasks, deprecated features, and comprehensive testing to maintain operational integrity in public sector systems

Summary and Next Steps