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)
- Prerequisites and supported platforms
- Installing Oracle Database 19c SE2 and establishing the initial database
- Post-installation setup, including 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 Logs, and background processes
- Managing parameter files, diagnostic destinations, and alert/trace files
Administration Tools and Connectivity
- Mastering Enterprise Manager Express for basic tasks
- Leveraging SQL Developer for administration and development workflows
- Configuring Oracle Net Services and listeners (dedicated/shared basics)
Database Creation and Instance Management
- Building databases using DBCA and SQL
- Managing startup/shutdown modes, services, and basic PDB awareness (suitable for SE2)
- Working with initialization parameters and dynamic performance views (V$)
Storage Management Best Practices
- Handling tablespaces and datafiles (local extent management, temp/undo)
- Monitoring segments, extents, blocks, and space usage
- Managing growth, moving datafiles, and considering OMF
Security and Auditing
- Designing least-privilege access 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, catalogs (where applicable), and performing validation
- Executing media recovery, point-in-time recovery, and handling failure scenarios
Performance Monitoring and Troubleshooting (SE2-Appropriate Methods)
- Interpreting execution plans (EXPLAIN PLAN, AUTOTRACE)
- Conducting SQL tracing and analyzing wait events
- Performing proactive monitoring via data dictionary and dynamic views
Migration from 11g to 19c
- Reviewing upgrade paths, prerequisites, and compatibility issues
- Utilizing pre/auto-upgrade utilities and verification steps
- Completing post-upgrade tasks, addressing deprecated features, and testing
Summary and Next Steps
Requirements
- Foundational knowledge of SQL
- Experience 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.
