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 (SE2 Focus)
- Review of prerequisites and supported platforms
- Process for installing Oracle Database 19c SE2 and establishing the initial database
- Configuring post-installation elements (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
- Managing parameter files, diagnostic destinations, and alert/trace files
Administration Tools and Connectivity
- Fundamentals of Enterprise Manager Express and common administrative tasks
- Utilizing SQL Developer for both administration and development purposes
- Configuration of Oracle Net Services and listeners (basics of dedicated/shared)
Database Creation and Instance Management
- Building databases using DBCA and SQL
- Managing startup/shutdown modes, services, and basic PDB awareness (suited for SE2)
- Handling initialization parameters and dynamic performance views (V$)
Best Practices in Storage Management
- Managing tablespaces and datafiles (local extent management, temp/undo)
- Monitoring segments, extents, blocks, and space usage
- Overseeing growth, relocating datafiles, and considering OMF
Security and Auditing Protocols
- Managing users, roles, system/object privileges, and applying least-privilege design
- Enforcing password policies, profiles, and resource limits
- Implementing auditing concepts appropriate for SE2
Backup and Recovery Strategies via RMAN
- Defining backup types, retention policies, and recovery objectives
- Setting up RMAN, catalogs (where relevant), and performing validation
- Executing media recovery, point-in-time recovery, and handling failure scenarios
Performance Monitoring and Troubleshooting (SE2-Compatible Methods)
- Analyzing execution plans (EXPLAIN PLAN, AUTOTRACE)
- Basics of SQL tracing and wait events
- Implementing proactive monitoring through data dictionary and dynamic views
Migrating from 11g to 19c
- Evaluating upgrade paths, prerequisites, and compatibility factors
- Utilizing pre/auto-upgrade utilities and conducting validation steps
- Completing post-upgrade tasks, addressing deprecated features, and testing
Conclusion and Future Directions
Requirements
- Fundamental understanding of SQL
- Experience with operating system administration (Linux or Windows)
- 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.