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 Setup, Installation, and Configuration (Focus on SE2)
- Reviewing prerequisites and supported platforms
- Installing Oracle Database 19c SE2 and initializing the first database
- Configuring post-installation settings, including listeners, services, and EM Express
Oracle Database Architecture and Core Infrastructure
- Distinguishing between instance and database concepts
- Examining the SGA, PGA, Shared Pool, Database Buffer Cache, Redo Logs, and background processes
- Managing parameter files, diagnostic destinations, and alert/trace files
Administrative Tools and Connectivity
- Introduction to Enterprise Manager Express and routine tasks
- Utilizing SQL Developer for both administration and development tasks
- Configuring Oracle Net Services and listeners (covering dedicated and shared basics)
Database Creation and Instance Management
- Creating databases using 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
- Handling tablespaces and datafiles (local extent management, temp/undo)
- Monitoring segments, extents, blocks, and space usage
- Managing growth, relocating datafiles, and considering OMF implementations
Security Protocols and Auditing
- Defining users, roles, system/object privileges, and designing for least privilege
- Establishing password policies, profiles, and resource limits
- Implementing auditing concepts and practices appropriate for SE2
Backup and Recovery Strategies utilizing RMAN
- Understanding backup types, retention policies, and recovery objectives
- Configuring RMAN, managing catalogs (where applicable), and performing validations
- Executing media recovery, point-in-time recovery, and addressing failure scenarios
Performance Monitoring and Troubleshooting (SE2-Compatible Methods)
- Interpreting execution plans (EXPLAIN PLAN, AUTOTRACE)
- Analyzing SQL tracing and fundamental wait events
- Implementing proactive monitoring through data dictionaries and dynamic views
Migration Process from 11g to 19c
- Evaluating upgrade paths, prerequisites, and compatibility factors
- Employing pre/auto-upgrade utilities and executing validation steps
- Completing post-upgrade tasks, addressing deprecated features, and conducting testing
Summary and Recommended Next Steps
Requirements
- Foundational knowledge of SQL
- Proficiency in operating system administration (either Linux or Windows)
- A solid grasp of core networking concepts, such as ports, services, and hostnames
Target Audience
- System administrators
- Technical consultants
- Database administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
