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 compatible platform specifications
- Deploying Oracle Database 19c Standard Edition 2 and establishing the foundational database instance
- Finalizing post-installation settings, including network listeners, services, and Enterprise Manager Express
Oracle Database Architecture and Core Infrastructure
- Distinguishing between database instances and the physical database structure
- Components of the System Global Area (SGA), Program Global Area (PGA), Shared Pool, Buffer Cache, Redo Logs, and essential background processes
- Managing parameter files, diagnostic log locations, and alert/trace file generation
Administrative Toolsets and Connectivity Protocols
- Core functionalities and routine operational tasks within Oracle Enterprise Manager Express
- Utilizing Oracle SQL Developer for administrative oversight and development workflows
- Configuring Oracle Net Services and managing listener settings, including dedicated and shared connection models
Database Provisioning and Instance Lifecycle Management
- Establishing new database environments using Database Configuration Assistant (DBCA) and SQL commands
- Controlling instance startup and shutdown sequences, service management, and basic Pluggable Database (PDB) awareness for SE2 contexts
- Configuring initialization parameters and leveraging dynamic performance views (V$) for monitoring
Storage Management Best Practices
- Managing tablespaces and datafiles, including local extent management, temporary tablespaces, and undo segments
- Understanding segments, extents, and blocks, along with methods for monitoring space utilization
- Strategies for managing database growth, relocating datafiles, and considerations for Oracle Managed Files (OMF)
Security Hardening and Auditing Standards
- Defining users and roles, granting system/object privileges, and adhering to least-privilege security design principles
- Enforcing password policies, user profiles, and resource usage limits
- Implementing auditing mechanisms and controls suitable for Standard Edition 2 environments
Data Protection and Recovery Strategies via RMAN
- Selecting backup methods, defining retention policies, and meeting recovery objectives
- Configuring Recovery Manager (RMAN), managing recovery catalogs where applicable, and validating backup integrity
- Executing media recovery, point-in-time recovery, and resolving common failure scenarios
Performance Monitoring and Diagnostic Techniques (SE2-Compliant)
- Interpreting execution plans using EXPLAIN PLAN and AUTOTRACE features
- Analyzing SQL tracing outputs and understanding fundamental wait events
- Implementing proactive monitoring strategies utilizing the data dictionary and dynamic performance views
Migration Path from Oracle 11g to 19c
- Evaluating upgrade routes, verifying prerequisites, and addressing compatibility requirements
- Employing pre-upgrade and automated upgrade utilities, along with comprehensive validation procedures
- Completing post-upgrade actions, addressing deprecated features, and conducting thorough testing
Course Summary and Recommended Next Steps
Requirements
- Foundational proficiency in Structured Query Language (SQL)
- Demonstrated familiarity with operating system administration tasks, specifically within Linux or Windows environments
- Working understanding of core networking concepts, including port management, service definitions, and hostname resolution
Target Audience
- System administrators
- Technical consultants
- Database administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
