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 (SE2 Focus)
- Prerequisites and supported platforms.
- Installing Oracle Database 19c SE2 and creating the initial database instance.
- Post-installation configuration, including listeners, services, and EM Express setup.
Oracle Database Architecture and Core Infrastructure
- Concepts distinguishing instances from databases.
- Components including SGA, PGA, Shared Pool, Database Buffer Cache, Redo Logs, and background processes.
- Parameter files, diagnostic destinations, and alert/trace file management.
Administration Tools and Connectivity
- Basics and common tasks within Enterprise Manager Express.
- Using SQL Developer for administrative and developmental tasks.
- Oracle Net Services and listener configuration, covering dedicated and shared server basics.
Database Creation and Instance Management
- Creating databases using DBCA and SQL commands.
- Startup and shutdown modes, services management, and basic Pluggable Database (PDB) awareness suitable for SE2.
- Initialization parameters and dynamic performance views (V$).
Storage Management Best Practices
- Tablespaces and datafiles, including local extent management and temporary/undo tablespace usage.
- Understanding segments, extents, blocks, and space monitoring techniques.
- Managing growth, relocating datafiles, and considerations for Oracle Managed Files (OMF).
Security and Auditing
- Managing users, roles, system and object privileges, and implementing least-privilege design principles.
- Configuring password policies, profiles, and resource limits.
- Auditing concepts and implementation methods appropriate for SE2.
Backup and Recovery Strategies with RMAN
- Backup types, retention policies, and defining recovery objectives.
- Configuring RMAN, utilizing catalogs (where applicable), and performing validation.
- Executing media recovery, point-in-time recovery, and handling various failure scenarios.
Performance Monitoring and Troubleshooting (SE2-Safe Methods)
- Analyzing execution plans using EXPLAIN PLAN and AUTOTRACE.
- Basics of SQL tracing and wait events.
- Proactive monitoring using the data dictionary and dynamic performance views.
Migrating from 11g to 19c
- Understanding upgrade paths, prerequisites, and compatibility considerations.
- Utilizing pre/auto-upgrade utilities and performing validation steps.
- Completing post-upgrade tasks, addressing deprecated features, and conducting testing.
Summary and Next Steps
Requirements
- Fundamental knowledge of SQL.
- Familiarity with operating system administration (Linux or Windows).
- Understanding of core networking concepts, including ports, services, and hostnames.
Audience
- System administrators.
- Technical consultants.
- Database administrators.
35 Hours
