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.
- Distinguishing between a database instance and a database.
- Memory and process architecture, including SGA, PGA, and background processes.
- Parameter files, control files, redo logs, alert logs, and trace files.
- General overview of Oracle Multitenant architecture, covering CDB and PDB, and its scope in SE2.
Environment Preparation and Installation
- Prerequisites and supported platforms.
- Installing Oracle Database 19c SE2.
- Creating the initial database using DBCA.
- Post-installation configuration, including listeners, services, and Enterprise Manager Express.
Administration Tools and Connectivity
- Connecting to an Oracle Database instance.
- SQL*Plus: basic commands and administrative tasks.
- Utilizing Oracle SQL Developer.
- Oracle Enterprise Manager Express: monitoring and common administrative tasks.
- Net Services and listener configuration.
Instance and Database Management
- Startup and shutdown modes.
- Creating databases with DBCA and SQL.
- Initialization parameters and dynamic performance views (V$).
- Managing alert logs, trace files, and the Automatic Diagnostic Repository.
- The data dictionary.
Connectivity and Naming Methods
- Establishing network connections.
- Naming methods: Easy Connect, Local Naming, and Directory Naming.
- Database service management.
- Listener agent configuration, both 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 configuration.
- PDB removal procedures.
- Shared server configuration, covering SGA, PGA, and 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, adhering to the principle of least privilege.
- Profiles, password policies, and resource limits.
- Auditing concepts specific to Oracle SE2.
- Auditing of critical operations.
Backup and Recovery (RMAN)
- Backup strategies, including types, retention policies, and recovery objectives.
- RMAN configuration and catalogs.
- Recovery scenarios, covering media, point-in-time, and common failures.
- Backup validation procedures.
Monitoring and Performance Optimization
- Utilizing execution plans via EXPLAIN PLAN and AUTOTRACE.
- Diagnosing waits and common events.
- Proactive monitoring using the data dictionary and dynamic views.
- Tuning methods applicable to SE2.
Migration from Oracle 11g to 19c
- Upgrade paths and prerequisites.
- Pre-upgrade and auto-upgrade tools.
- Validation steps and resolving incompatibilities.
- Post-upgrade tasks and deprecated features.
- Post-migration testing.
Course Closure
- General summary.
- Recommendations for best practices.
Summary and Next Steps
Requirements
- A foundational understanding of relational database concepts.
- Proficiency in writing SQL queries.
- Basic familiarity with operating systems such as Windows or Linux.
Target Audience
- Database administrators.
- System administrators.
- IT professionals responsible for overseeing Oracle environments.
Testimonials (1)
good explanation on each points and provide assignment for practices.
