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.
Course Outline
Environment Preparation, Installation, and Configuration (Focus on SE2)
- Prerequisites and supported platforms.
- Installing Oracle Database 19c SE2 and creating the initial database.
- Post-installation configuration, including listeners, services, and EM Express.
Oracle Database Architecture and Core Infrastructure
- Distinction between instance and database concepts.
- Overview of SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes.
- Parameter files, diagnostic destinations, and alert/trace files.
Administration Tools and Connectivity
- Basics of Enterprise Manager Express and common tasks.
- Utilizing SQL Developer for administration and development.
- Oracle Net Services and listener configuration (covering dedicated/shared server basics).
Database Creation and Instance Management
- Creating databases using DBCA and SQL.
- Startup/shutdown modes, services, and basic Pluggable Database (PDB) awareness (appropriate for SE2).
- Initialization parameters and dynamic performance views (V$).
Storage Management Best Practices
- Tablespaces and datafiles, including local extent management and temporary/undo tablespaces.
- Understanding segments, extents, blocks, and space monitoring.
- Managing growth, moving datafiles, and considerations for Oracle Managed Files (OMF).
Security and Auditing
- Managing users, roles, system/object privileges, and implementing least-privilege design.
- Configuring password policies, profiles, and resource limits.
- Concepts and implementation of auditing, tailored for SE2.
Backup and Recovery Strategies with RMAN
- Backup types, retention policies, and recovery objectives.
- Configuring RMAN, catalogs (where applicable), and validation processes.
- 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.
- SQL tracing and understanding wait events.
- Proactive monitoring using data dictionary views and dynamic performance views.
Migrating from 11g to 19c
- Upgrade paths, prerequisites, and compatibility considerations.
- Utilizing pre-/auto-upgrade utilities and validation steps.
- Post-upgrade tasks, identifying deprecated features, and testing procedures.
Summary and Next Steps
Requirements
- Fundamental knowledge of SQL.
- Familiarity with operating system administration (Linux or Windows).
- Understanding of core networking concepts, such as ports, services, and hostnames.
Target Audience
- System administrators
- Technical consultants
- Database administrators
35 Hours
Testimonials (1)
good explanation on each points and provide assignment for practices.
