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.
Course Outline
Introduction and Fundamentals
- Overview of Oracle Database architecture.
- Differences between a database instance and a database.
- Memory and process architecture (SGA, PGA, background processes).
- Parameter files, control files, redo logs, alert logs, and trace files.
- General overview of Oracle Multitenant (CDB and PDB, scope in SE2).
Environment Preparation and Installation
- Prerequisites and supported platforms.
- Installation of Oracle Database 19c SE2.
- Creation of the initial database using DBCA.
- Post-installation configuration: listeners, services, and Enterprise Manager Express.
Administration Tools and Connectivity
- Connecting to an Oracle Database instance.
- SQL*Plus: basic commands and administration.
- Using Oracle SQL Developer.
- Oracle Enterprise Manager Express: monitoring and common tasks.
- Net Services and listener configuration.
Instance and Database Management
- Startup and shutdown modes.
- Database creation with DBCA and SQL.
- Initialization parameters and dynamic performance views (V$).
- Managing alert logs, trace files, and Automatic Diagnostic Repository.
- Data dictionary.
Connectivity and Naming Methods
- Establishing network connections.
- Naming methods: Easy Connect, Local Naming, Directory Naming.
- Database service management.
- Listener agent configuration (dynamic and static).
Multitenant Architecture (CDB and PDB) – SE2 Scope
- CDB and PDB concepts.
- PDB creation (with PDB$SEED, OMF, PDB_FILE_NAME_CONVERT parameters).
- PDB management (modes, parameters, host/port configuration).
- PDB removal.
- Shared server configuration (SGA, PGA, shared server mode).
Storage Administration
- Tablespaces and datafiles.
- Temporary and undo tablespaces.
- Segments, extents, blocks, and space management.
- File growth, OMF (Oracle Managed Files), and datafile movement.
Security and Auditing
- Users, roles, and privileges (principle of least privilege).
- Profiles, password policies, and resource limits.
- Auditing concepts in Oracle SE2.
- Auditing of critical operations.
Backup and Recovery (RMAN)
- Backup strategies: types, retention policies, and recovery objectives.
- RMAN configuration and catalogs.
- Recovery scenarios: media, point-in-time, common failures.
- Backup validation.
Monitoring and Performance Optimization
- Using execution plans (EXPLAIN PLAN, AUTOTRACE).
- Diagnosing waits and common events.
- Proactive monitoring with data dictionary and dynamic views.
- Tuning methods for SE2.
Migration from Oracle 11g to 19c
- Upgrade paths and prerequisites.
- Pre/auto-upgrade tools.
- Validation steps and incompatibility resolution.
- Post-upgrade tasks and deprecated features.
- Post-migration testing.
Course Closure
- General summary.
- Best practice recommendations.
Summary and Next Steps
Requirements
- A solid understanding of relational database concepts.
- Experience with SQL.
- Basic familiarity with operating systems such as Windows or Linux.
Audience
- Database administrators.
- System administrators.
- IT professionals responsible for managing Oracle environments.
49 Hours
Testimonials (1)
good explanation on each points and provide assignment for practices.
