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 Preparation, Installation, and Configuration (SE2 Focus)
- Reviewing prerequisites and supported platforms
- Installing Oracle Database 19c SE2 and initializing the primary database
- Configuring post-installation components, including listeners, services, and EM Express
Oracle Database Architecture and Core Infrastructure
- Distinguishing between instance and database concepts
- Exploring the 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
- Mastering Enterprise Manager Express fundamentals and essential tasks
- Utilizing SQL Developer for administrative and development workflows
- Configuring Oracle Net Services and listeners, with a focus on dedicated/shared basics
Database Creation and Instance Management
- Provisioning databases using DBCA and SQL commands
- Managing startup/shutdown modes, services, and gaining basic PDB awareness suitable for SE2
- Working with initialization parameters and dynamic performance views (V$)
Storage Management Best Practices
- Handling tablespaces and datafiles, including local extent management and temp/undo spaces
- Monitoring segments, extents, blocks, and overall space usage
- Managing growth, migrating datafiles, and considering OMF implications
Security and Auditing
- Designing least-privilege access through users, roles, and system/object privileges
- Enforcing password policies, profiles, and resource limits
- Implementing auditing concepts appropriate for the SE2 environment
Backup and Recovery Strategies with RMAN
- Defining backup types, retention policies, and recovery objectives
- Setting up RMAN, configuring catalogs where relevant, and validating backups
- Executing media recovery, point-in-time recovery, and handling failure scenarios
Performance Monitoring and Troubleshooting (SE2-Safe Methods)
- Analyzing execution plans using EXPLAIN PLAN and AUTOTRACE
- Understanding SQL tracing and fundamental wait events
- Implementing proactive monitoring via data dictionaries and dynamic views
Migrating 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 Next Steps
Requirements
- Foundational knowledge of SQL
- Proficiency in operating system administration (Linux or Windows)
- Comprehension 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.
