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
Preparing the Environment, Installation, and Configuration (with a focus on SE2)
- Reviewing prerequisites and identifying supported platforms.
- Installing Oracle Database 19c SE2 and establishing the initial database.
- Completing post-installation setups, including listeners, services, and EM Express.
Oracle Database Architecture and Core Infrastructure
- Distinguishing between instance and database concepts.
- Understanding 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
- Exploring the basics and common tasks within Enterprise Manager Express.
- Leveraging SQL Developer for both administration and development workflows.
- Configuring Oracle Net Services and listeners, including dedicated and shared basics.
Database Creation and Instance Management
- Creating databases using DBCA and direct SQL commands.
- Understanding startup/shutdown modes, services, and basic PDB awareness relevant to SE2.
- Working with initialization parameters and dynamic performance views (V$).
Best Practices for Storage Management
- Managing tablespaces and datafiles, including local extent management, temp, and undo areas.
- Monitoring segments, extents, blocks, and overall space usage.
- Handling growth, moving datafiles, and considering OMF requirements.
Security and Auditing
- Designing least-privilege access through users, roles, system/object privileges, and security models.
- Enforcing password policies, profiles, and resource limits.
- Implementing auditing concepts and strategies appropriate for SE2 environments.
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 Approaches)
- Interpreting execution plans using EXPLAIN PLAN and AUTOTRACE.
- Analysing SQL tracing and understanding wait events.
- Proactively monitoring performance via the data dictionary and dynamic views.
Migration from 11g to 19c
- Evaluating upgrade paths, prerequisites, and compatibility considerations.
- Utilising pre/auto-upgrade utilities and performing validation steps.
- Completing post-upgrade tasks, addressing deprecated features, and conducting tests.
Conclusion and Recommended Next Steps
Requirements
- Foundational understanding of SQL.
- Experience with operating system administration, specifically on Linux or Windows platforms.
- 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.
