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 supported platform specifications
- Installing Oracle Database 19c SE2 and initializing the database
- Post-installation configuration, including listeners, services, and EM Express
Oracle Database Architecture and Core Infrastructure
- Distinguishing between instance and database concepts
- Overview of SGA, PGA, Shared Pool, Database Buffer Cache, Redo Logs, and background processes
- Parameter files, diagnostic locations, and alert/trace file management
Administration Tools and Connectivity
- Essentials of Enterprise Manager Express and common administrative tasks
- Utilizing SQL Developer for both administration and development workflows
- Oracle Net Services and listener configuration (basic dedicated/shared concepts)
Database Creation and Instance Management
- Creating databases using DBCA and SQL commands
- Startup/shutdown modes, service management, and basic PDB awareness suitable for SE2
- Initialization parameters and dynamic performance views (V$)
Storage Management Best Practices
- Tablespaces and datafiles, covering local extent management, temp/undo segments
- Understanding segments, extents, blocks, and space monitoring techniques
- Managing growth, relocating datafiles, and considering OMF
Security and Auditing
- Users, roles, system/object privileges, and implementing least-privilege design
- Password policies, user profiles, and resource limit enforcement
- Auditing concepts and implementation methods appropriate for SE2
Backup and Recovery Strategies with RMAN
- Backup types, retention policies, and recovery objectives
- Configuring RMAN, managing catalogs where applicable, and data validation
- Media recovery, point-in-time recovery, and handling failure scenarios
Performance Monitoring and Troubleshooting (SE2-Safe Methods)
- Analyzing execution plans using EXPLAIN PLAN and AUTOTRACE
- Fundamentals of SQL tracing and wait event analysis
- Proactive monitoring via the data dictionary and dynamic views
Migrating from 11g to 19c
- Reviewing upgrade paths, prerequisites, and compatibility factors
- Employing pre/auto-upgrade utilities and performing validation steps
- Post-upgrade tasks, addressing deprecated features, and testing procedures
Summary and Next Steps
Requirements
- Foundational knowledge of SQL
- Proficiency in operating system administration (Linux or Windows)
- Comprehension of fundamental 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.
