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 Concepts
- Overview of the Oracle Database architectural design.
- Distinguishing between a database instance and the database itself.
- Memory and process structures (SGA, PGA, background processes).
- Configuration elements: parameter files, control files, redo logs, alert logs, and trace files.
- Introduction to Oracle Multitenant architecture (CDB and PDB, with a focus on SE2 scope).
Setting Up the Environment and Installation
- Prerequisites and compatible platforms.
- Installing Oracle Database 19c SE2.
- Initializing the first database using DBCA.
- Post-installation setup: configuring listeners, services, and Enterprise Manager Express.
Administrative Utilities and Connectivity
- Establishing connections to an Oracle Database instance.
- SQL*Plus: essential commands and administrative functions.
- Utilizing Oracle SQL Developer.
- Oracle Enterprise Manager Express: monitoring and routine tasks.
- Configuring Net Services and listeners.
Instance and Database Operations
- Startup and shutdown procedures.
- Creating databases via 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 Strategies
- Establishing network pathways.
- Naming methods: Easy Connect, Local Naming, and Directory Naming.
- Managing database services.
- Configuring the listener agent (both dynamic and static modes).
Multitenant Architecture (CDB and PDB) – SE2 Focus
- Understanding CDB and PDB concepts.
- Creating PDBs (using PDB$SEED, OMF, and PDB_FILE_NAME_CONVERT parameters).
- Managing PDBs (operating modes, parameters, and host/port settings).
- Removing PDBs.
- Shared server configuration (SGA, PGA, and shared server mode).
Storage Management
- Tablespaces and datafiles.
- Temporary and undo tablespaces.
- Segments, extents, blocks, and space management strategies.
- File expansion, OMF (Oracle Managed Files), and datafile relocation.
Security and Audit Protocols
- Users, roles, and privileges (applying the principle of least privilege).
- Profiles, password policies, and resource constraints.
- Auditing principles within Oracle SE2.
- Monitoring critical operational activities.
Backup and Recovery (RMAN)
- Backup methodologies: types, retention policies, and recovery goals.
- RMAN setup and catalog management.
- Recovery scenarios: media failures, point-in-time recovery, and common errors.
- Verifying backup integrity.
Monitoring and Performance Tuning
- Analyzing execution plans (EXPLAIN PLAN, AUTOTRACE).
- Identifying wait states and common events.
- Proactive monitoring via the data dictionary and dynamic views.
- Tuning techniques specific to SE2.
Migrating from Oracle 11g to 19c
- Upgrade pathways and prerequisites.
- Pre- and auto-upgrade utilities.
- Validation procedures and resolving incompatibilities.
- Post-upgrade actions and handling deprecated features.
- Testing after migration.
Conclusion
- Comprehensive recap.
- Recommendations for best practices.
Recap and Future Directions
Requirements
- A solid grasp of relational database principles.
- Proficiency in SQL.
- Foundational 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.
