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 49 hours
Course Outline
Introduction and Core Fundamentals
- Overview of Oracle Database architecture.
- Distinction between a database instance and the database itself.
- Memory and process architecture, including SGA, PGA, and background processes.
- Review of parameter files, control files, redo logs, alert logs, and trace files.
- General introduction to Oracle Multitenant, covering CDB and PDB, and their scope in SE2.
Environment Setup and Installation
- Prerequisites and identification of supported platforms.
- Step-by-step installation of Oracle Database 19c SE2.
- Creation of the initial database using DBCA.
- Post-installation configuration involving listeners, services, and Enterprise Manager Express.
Administrative Tools and Connectivity
- Establishing connections to Oracle Database instances.
- SQL*Plus: Essential commands for administration.
- Utilizing Oracle SQL Developer.
- Oracle Enterprise Manager Express: Monitoring and routine tasks.
- Configuring Net Services and listeners.
Instance and Database Operations
- Managing startup and shutdown modes.
- Database creation via DBCA and SQL.
- Initialization parameters and dynamic performance views (V$).
- Administration of alert logs, trace files, and the Automatic Diagnostic Repository.
- Exploring the data dictionary.
Connectivity and Naming Conventions
- Establishing network connections.
- Naming methods: Easy Connect, Local Naming, and Directory Naming.
- Database service management.
- Configuration of the Listener agent (dynamic and static).
Multitenant Architecture (CDB and PDB) – SE2 Scope
- Concepts of CDB and PDB.
- PDB creation utilizing PDB$SEED, OMF, and PDB_FILE_NAME_CONVERT parameters.
- PDB management, including modes, parameters, and host/port settings.
- Procedures for PDB removal.
- Shared server configuration involving SGA, PGA, and shared server mode.
Storage Management
- Tablespaces and datafiles.
- Temporary and undo tablespaces.
- Segments, extents, blocks, and space management strategies.
- File growth, Oracle Managed Files (OMF), and datafile relocation.
Security and Auditing
- Users, roles, and privileges, adhering to the principle of least privilege.
- Profiles, password policies, and resource constraints.
- Auditing concepts specific to Oracle SE2.
- Auditing of critical operations.
Backup and Recovery (RMAN)
- Backup strategies: Types, retention policies, and recovery objectives.
- RMAN configuration and catalog management.
- Recovery scenarios: Media, point-in-time, and common failure modes.
- Backup validation processes.
Monitoring and Performance Optimization
- Analyzing execution plans using EXPLAIN PLAN and AUTOTRACE.
- Diagnosing wait events and common performance issues.
- Proactive monitoring leveraging the data dictionary and dynamic views.
- Tuning methodologies tailored for SE2.
Migration from Oracle 11g to 19c
- Upgrade paths and pre-requirements.
- Utilization of pre- and auto-upgrade tools.
- Validation steps and resolving incompatibilities.
- Post-upgrade tasks and addressing deprecated features.
- Testing following migration.
Course Conclusion
- Comprehensive summary of key concepts.
- Recommendations for best practices.
Summary and Future Directions
Requirements
- A foundational understanding of relational database principles.
- Proficiency in SQL.
- Basic working knowledge of operating systems such as Windows or Linux.
Target Audience
- Database Administrators.
- System Administrators.
- IT professionals tasked with overseeing Oracle environments.
Testimonials (1)
good explanation on each points and provide assignment for practices.
