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 (Focus on SE2)
- Review of prerequisites and supported platforms.
- Installation of Oracle Database 19c SE2 and creation of the initial database.
- Post-installation configuration of listeners, services, and EM Express.
Oracle Database Architecture and Core Infrastructure
- Distinguishing between instance and database concepts.
- Deep dive into SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes.
- Configuration 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 workflows.
- Configuration of Oracle Net Services and listeners (covering dedicated/shared basics).
Database Creation and Instance Management
- Database creation using DBCA and SQL commands.
- Management of startup/shutdown modes, services, and basic PDB awareness (suitable for SE2).
- Tuning initialization parameters and analyzing dynamic performance views (V$).
Storage Management Best Practices
- Management of tablespaces and datafiles, including local extent management and temp/undo space.
- Understanding segments, extents, blocks, and monitoring space usage.
- Strategies for managing growth, relocating datafiles, and OMF considerations.
Security and Auditing
- Design of least-privilege access through users, roles, and system/object privileges.
- Implementation of password policies, profiles, and resource limits.
- Application of auditing concepts and methods appropriate for SE2.
Backup and Recovery Strategies with RMAN
- Defining backup types, retention policies, and recovery objectives.
- RMAN configuration, catalog usage (where applicable), and validation procedures.
- Execution of media recovery, point-in-time recovery, and failure scenario handling.
Performance Monitoring and Troubleshooting (SE2-Safe Methods)
- Interpretation of execution plans using EXPLAIN PLAN and AUTOTRACE.
- Analysis of SQL tracing and basic wait events.
- Proactive monitoring through the data dictionary and dynamic views.
Migration from 11g to 19c
- Evaluation of upgrade paths, prerequisites, and compatibility considerations.
- Use of pre/auto-upgrade utilities and execution of validation steps.
- Completion of post-upgrade tasks, addressing deprecated features, and conducting testing.
Summary and Next Steps
Requirements
- Foundational knowledge of SQL.
- Familiarity with operating system administration (Linux or Windows).
- Understanding 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.
