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
Preparing the Environment, Installation, and Configuration (Focus on SE2)
- Prerequisites and supported platforms
- Installing Oracle Database 19c SE2 and initializing the database
- Post-installation setup, including listeners, services, and EM Express
Oracle Database Architecture and Foundational Infrastructure
- Distinguishing between instance and database concepts
- Components such as SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes
- Managing parameter files, diagnostic destinations, and alert/trace files
Management Tools and Connectivity
- Overview of Enterprise Manager Express and common administrative tasks
- Utilizing SQL Developer for both administration and development workflows
- Configuring Oracle Net Services and listeners (covering dedicated and shared basics)
Database Creation and Instance Oversight
- Creating databases via DBCA and SQL commands
- Managing startup/shutdown modes, services, and basic PDB awareness suitable for SE2
- Working with initialization parameters and dynamic performance views (V$)
Best Practices in Storage Management
- Managing tablespaces and datafiles, including local extent management, temp, and undo
- Monitoring segments, extents, blocks, and overall space usage
- Handling growth, relocating datafiles, and considering OMF
Security and Audit Procedures
- Designing least-privilege models through users, roles, and system/object privileges
- Enforcing password policies, profiles, and resource limits
- Implementing auditing concepts tailored to SE2 environments
RMAN-Based Backup and Recovery Strategies
- Understanding backup types, retention policies, and recovery goals
- Configuring RMAN, managing catalogs (when applicable), and validating backups
- Executing media recovery, point-in-time recovery, and handling failure scenarios
Performance Monitoring and Troubleshooting (SE2-Compliant Methods)
- Analyzing execution plans using EXPLAIN PLAN and AUTOTRACE
- Fundamentals of SQL tracing and wait events
- Proactive monitoring through data dictionaries and dynamic views
Migrating from 11g to 19c
- Evaluating upgrade paths, prerequisites, and compatibility factors
- Utilizing pre- and auto-upgrade utilities along with validation steps
- Addressing post-upgrade tasks, deprecated features, and testing requirements
Summary and Future Recommendations
Requirements
- Fundamental understanding of SQL
- Experience with operating system administration (specifically Linux or Windows)
- Basic grasp of core 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.