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
Setting Up the Environment: Installation and Configuration (SE2 Focus)
- Prerequisites and supported operating platforms
- Installing Oracle Database 19c SE2 and initializing the database
- Configuring post-installation elements such as listeners, services, and EM Express
Oracle Database Architecture and Fundamental Infrastructure
- Distinguishing between instance and database concepts
- Detailed look at SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes
- Managing parameter files, diagnostic destinations, and alert/trace files
Administrative Tools and Network Connectivity
- Basics of Enterprise Manager Express and routine tasks
- Utilizing SQL Developer for both administration and development workflows
- Configuring Oracle Net Services and listeners (covering dedicated/shared basics)
Database Creation and Instance Oversight
- Creating databases using DBCA and SQL commands
- Understanding startup/shutdown modes, services, and basic PDB awareness (tailored for SE2)
- Managing initialization parameters and dynamic performance views (V$)
Best Practices in Storage Management
- Handling tablespaces and datafiles, including local extent management, temp/undo segments
- Monitoring segments, extents, blocks, and space usage
- Controlling growth, relocating datafiles, and considering OMF
Security Protocols and Auditing
- Managing users, roles, system/object privileges, and designing for least privilege
- Setting password policies, profiles, and resource limits
- Implementing auditing concepts suitable for SE2 environments
Backup and Recovery Strategies Using RMAN
- Understanding backup types, retention policies, and recovery objectives
- Configuring RMAN, managing catalogs (where relevant), and performing validation
- Executing media recovery, point-in-time recovery, and handling failure scenarios
Performance Monitoring and Troubleshooting (SE2-Appropriate Methods)
- Interpreting execution plans (using EXPLAIN PLAN, AUTOTRACE)
- Basic SQL tracing and understanding wait events
- Proactive monitoring via data dictionary and dynamic views
Migration from 11g to 19c
- Reviewing upgrade paths, prerequisites, and compatibility factors
- Utilizing pre/auto-upgrade utilities and performing validation checks
- Completing post-upgrade tasks, addressing deprecated features, and testing
Course Summary and Future Steps
Requirements
- Fundamental understanding of SQL
- Familiarity with operating system management (Linux or Windows)
- Knowledge of core networking concepts, such as ports, services, and hostnames
Target Audience
- System administrators
- Technical consultants
- Database administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
