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)
- Reviewing prerequisites and supported platforms.
- Installing Oracle Database 19c SE2 and establishing the initial database.
- Configuring post-installation components, including listeners, services, and EM Express.
Oracle Database Architecture and Core Infrastructure
- Distinguishing between instance and database concepts.
- Examining the SGA, PGA, Shared Pool, Database Buffer Cache, Redo Logs, and background processes.
- Managing parameter files, diagnostic destinations, and alert/trace files.
Administration Tools and Connectivity
- Mastering basics of Enterprise Manager Express and performing common tasks.
- Leveraging SQL Developer for administrative and developmental workflows.
- Configuring Oracle Net Services and listeners (covering dedicated/shared modes).
Database Creation and Instance Management
- Creating databases using DBCA and SQL commands.
- Managing startup/shutdown modes, services, and gaining PDB awareness suitable for SE2.
- Utilizing initialization parameters and dynamic performance views (V$).
Storage Management Best Practices
- Handling tablespaces and datafiles, including local extent management, temp, and undo spaces.
- Monitoring segments, extents, blocks, and overall space usage.
- Managing growth, relocating datafiles, and considering OMF.
Security and Auditing
- Designing least-privilege structures using users, roles, and system/object privileges.
- Implementing password policies, profiles, and resource limits.
- Applying auditing concepts and implementations appropriate for SE2.
Backup and Recovery Strategies with RMAN
- Defining backup types, retention policies, and recovery objectives.
- Configuring RMAN, managing catalogs (where applicable), and validating backups.
- Executing media recovery, point-in-time recovery, and handling failure scenarios.
Performance Monitoring and Troubleshooting (SE2-Safe Methods)
- Interpreting execution plans using EXPLAIN PLAN and AUTOTRACE.
- Applying SQL tracing and analyzing wait events.
- Conducting proactive monitoring via the data dictionary and dynamic views.
Migrating from 11g to 19c
- Evaluating upgrade paths, prerequisites, and compatibility factors.
- Utilizing pre/auto-upgrade utilities and performing validation steps.
- Addressing post-upgrade tasks, deprecated features, and testing requirements.
Summary and Next Steps
Requirements
- Foundational knowledge of SQL.
- Working familiarity with operating system administration on Linux or Windows.
- A solid 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.
