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 compatible platforms
- Installing Oracle Database 19c SE2 and initializing the database
- Post-installation setup (listeners, services, EM Express)
Oracle Database Architecture and Core Infrastructure
- Distinguishing 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 logs
Management Tools and Connectivity
- Fundamentals of Enterprise Manager Express and typical tasks
- Utilizing SQL Developer for administrative and development purposes
- Oracle Net Services and listener setup (basic dedicated/shared modes)
Database Creation and Instance Control
- Creating databases via DBCA and SQL commands
- Startup/shutdown modes, service management, and basic PDB awareness (relevant to SE2)
- Initialization parameters and dynamic performance views (V$)
Best Practices for Storage Management
- Tablespaces and datafiles (local extent management, temp/undo segments)
- Monitoring segments, extents, blocks, and space usage
- Managing growth, relocating datafiles, and considering OMF
Security and Auditing
- Managing users, roles, system/object privileges, and implementing least-privilege design
- Configuring password policies, profiles, and resource limits
- Auditing principles and implementation suitable for SE2
RMAN-Based Backup and Recovery Strategies
- Defining backup types, retention policies, and recovery objectives
- Configuring RMAN, catalogs (where relevant), and validation processes
- Executing media recovery, point-in-time recovery, and handling failure scenarios
Performance Monitoring and Troubleshooting (SE2-Appropriate Methods)
- Interpreting execution plans (EXPLAIN PLAN, AUTOTRACE)
- Basics of SQL tracing and wait events
- Proactive monitoring using data dictionaries and dynamic views
Migration from 11g to 19c
- Evaluating upgrade paths, prerequisites, and compatibility factors
- Employing pre/auto-upgrade utilities and verification steps
- Completing post-upgrade tasks, addressing deprecated features, and conducting tests
Summary and Recommended Next Steps
Requirements
- Fundamental understanding of SQL
- Proficiency in operating system administration (Linux or Windows)
- Basic comprehension of core networking concepts (ports, services, hostnames)
Target Audience
- System administrators
- Technical consultants
- Database administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
