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.
- Installing Oracle Database 19c SE2 and establishing the initial database.
- Post-installation configuration, including listeners, services, and EM Express.
Oracle Database Architecture and Core Infrastructure
- Conceptual distinction between instance and database.
- Detailed 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
- Basics of Enterprise Manager Express and common administrative tasks.
- Utilizing SQL Developer for administration and development workflows.
- Oracle Net Services and listener configuration, covering dedicated and shared basics.
Database Creation and Instance Management
- Creating databases via DBCA and SQL commands.
- Managing startup/shutdown modes, services, and basic PDB awareness (SE2-appropriate).
- Reviewing initialization parameters and dynamic performance views (V$).
Storage Management Best Practices
- Managing tablespaces and datafiles, including local extent management, temp, and undo.
- Understanding segments, extents, blocks, and space monitoring techniques.
- Handling growth, moving datafiles, and considerations for OMF.
Security and Auditing
- Managing users, roles, system/object privileges, and least-privilege design.
- Implementing password policies, profiles, and resource limits.
- Auditing concepts and implementation suitable for SE2.
Backup and Recovery Strategies with RMAN
- Defining backup types, retention policies, and recovery objectives.
- Configuring RMAN, catalogs (where applicable), and validation processes.
- Executing media recovery, point-in-time recovery, and addressing failure scenarios.
Performance Monitoring and Troubleshooting (SE2-Safe Methods)
- Interpreting execution plans using EXPLAIN PLAN and AUTOTRACE.
- SQL tracing and understanding wait events.
- Proactive monitoring through data dictionary and dynamic views.
Migration from 11g to 19c
- Reviewing upgrade paths, prerequisites, and compatibility considerations.
- Utilizing pre/auto-upgrade utilities and validation steps.
- Post-upgrade tasks, deprecated features, and testing procedures.
Summary and Next Steps
Requirements
- Foundational knowledge of SQL.
- Familiarity with operating system administration, specifically Linux or Windows.
- Understanding of fundamental 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.
