Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 35 hours
Course Outline
Environment Preparation, Installation, and Configuration (SE2 Focus)
- Prerequisites and supported platforms.
- Installation of Oracle Database 19c SE2 and creation of the initial database.
- Post-installation configuration, including listeners, services, and EM Express.
Oracle Database Architecture and Core Infrastructure
- Distinguishing between instance and database concepts.
- Overview of SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes.
- Management of parameter files, diagnostic destinations, and alert/trace files.
Administration Tools and Connectivity
- Fundamentals of Enterprise Manager Express and common administrative tasks.
- Utilizing SQL Developer for both administration and development tasks.
- Configuration of Oracle Net Services and listeners (dedicated/shared basics).
Database Creation and Instance Management
- Creating databases using DBCA and SQL commands.
- Understanding startup/shutdown modes, services, and basic PDB awareness (tailored for SE2).
- Review of initialization parameters and dynamic performance views (V$).
Storage Management Best Practices
- Management of tablespaces and datafiles (local extent management, temp/undo).
- Monitoring segments, extents, blocks, and space usage.
- Handling growth, moving datafiles, and considering OMF.
Security and Auditing
- Defining users, roles, system/object privileges, and designing for least privilege.
- Implementing password policies, profiles, and resource limits.
- Concepts and implementation of auditing suitable for SE2.
Backup and Recovery Strategies with RMAN
- Types of backups, retention policies, and recovery objectives.
- Configuring RMAN, catalogs (where applicable), and validation procedures.
- Media recovery, point-in-time recovery, and handling failure scenarios.
Performance Monitoring and Troubleshooting (SE2-Safe Methods)
- Interpreting execution plans (EXPLAIN PLAN, AUTOTRACE).
- Basics of SQL tracing and wait events.
- Proactive monitoring using data dictionary and dynamic views.
Migrating from 11g to 19c
- Upgrade paths, prerequisites, and compatibility considerations.
- Utilizing pre/auto-upgrade utilities and validation steps.
- Post-upgrade tasks, deprecated features, and testing.
Summary and Next Steps
Requirements
- Fundamental understanding of SQL.
- Proficiency in operating system administration (either Linux or Windows).
- Grasp of core networking concepts, including ports, services, and hostnames.
Target Audience
- System Administrators.
- Technical Consultants.
- Database Administrators.
Testimonials (1)
good explanation on each points and provide assignment for practices.
