Course Outline
Environment Preparation, Installation, and Configuration (Focus on SE2)
- Review of prerequisites and supported platforms
- Installing Oracle Database 19c SE2 and establishing the initial database
- Post-installation setup, including listeners, services, and EM Express
Oracle Database Architecture and Core Infrastructure
- Distinguishing between instance and database concepts
- Examining SGA, PGA, Shared Pool, Database Buffer Cache, Redo Logs, and background processes
- Configuring parameter files, diagnostic destinations, and alert/trace files
Administration Tools and Connectivity
- Foundational operations and common tasks in Enterprise Manager Express
- Utilizing SQL Developer for both administrative and development tasks
- Oracle Net Services and listener configuration (basics of dedicated/shared connections)
Database Creation and Instance Management
- Building databases using DBCA and SQL commands
- Managing startup/shutdown modes, services, and basic PDB awareness (contextual for SE2)
- Working with initialization parameters and dynamic performance views (V$)
Storage Management Best Practices
- Managing tablespaces and datafiles (local extent management, temp/undo)
- Monitoring segments, extents, blocks, and overall space usage
- Handling growth, relocating datafiles, and considering OMF
Security and Auditing
- Designing least-privilege access through users, roles, and system/object privileges
- Establishing password policies, profiles, and resource limits
- Implementing auditing concepts and practices suitable for SE2
Backup and Recovery Strategies with RMAN
- Defining backup types, retention policies, and recovery objectives
- Configuring RMAN, setting up catalogs (where relevant), and validating backups
- Performing media recovery, point-in-time recovery, and managing failure scenarios
Performance Monitoring and Troubleshooting (SE2-Safe Methods)
- Interpreting execution plans using EXPLAIN PLAN and AUTOTRACE
- Analyzing SQL tracing and fundamental wait events
- Conducting proactive monitoring via data dictionaries and dynamic views
Migration from 11g to 19c
- Evaluating upgrade paths, prerequisites, and compatibility issues
- Utilizing pre/auto-upgrade utilities and performing validation checks
- Executing post-upgrade tasks, addressing deprecated features, and testing
Summary and Next Steps
Requirements
- Foundational knowledge of SQL
- Experience with operating system administration (Linux or Windows)
- Grasp of core networking principles (ports, services, hostnames)
Target Audience
- System administrators
- Technical consultants
- Database administrators
Testimonials (2)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
Learning about a new tool, the practices help a lot in understanding the topics, and that was what I liked the most.
David Vargas Alpizar - BANCO BAC SAN JOSE S.A
Course - Oracle Database 19c: Administration
Machine Translated
