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 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.
- Management of parameter files, control files, redo logs, alert logs, and trace files.
- General introduction to Oracle Multitenant features (CDB and PDB, with specific scope in SE2).
Environment Preparation and Installation
- Review of prerequisites and supported platforms.
- Step-by-step installation of Oracle Database 19c SE2.
- Creation of the initial database using DBCA.
- Post-installation configuration, covering listeners, services, and Enterprise Manager Express.
Administration Tools and Connectivity
- Methods for connecting to an Oracle Database instance.
- SQL*Plus: essential commands and administrative usage.
- Utilization of Oracle SQL Developer.
- Monitoring and routine tasks via Oracle Enterprise Manager Express.
- Configuration of Net Services and listeners.
Instance and Database Management
- Various startup and shutdown modes.
- Creating databases using DBCA and SQL.
- Understanding initialization parameters and dynamic performance views (V$).
- Managing alert logs, trace files, and the Automatic Diagnostic Repository.
- Exploring the data dictionary.
Connectivity and Naming Methods
- Establishing network connections.
- Naming methods: Easy Connect, Local Naming, and Directory Naming.
- Managing database services.
- Listener agent configuration, including dynamic and static registration.
Multitenant Architecture (CDB and PDB) – SE2 Scope
- Core 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.
- Procedures for PDB removal.
- Shared server configuration, involving SGA, PGA, and shared server mode.
Storage Administration
- Tablespaces and datafiles.
- Management of temporary and undo tablespaces.
- Segments, extents, blocks, and space management strategies.
- File growth, Oracle Managed Files (OMF), 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 critical operations.
Backup and Recovery (RMAN)
- Backup strategies, including types, retention policies, and recovery objectives.
- RMAN configuration and catalog management.
- Recovery scenarios: media recovery, point-in-time recovery, and handling common failures.
- Validating backups.
Monitoring and Performance Optimization
- Analyzing execution plans using EXPLAIN PLAN and AUTOTRACE.
- Diagnosing wait events and common performance issues.
- Proactive monitoring via the data dictionary and dynamic views.
- Tuning methodologies applicable to SE2.
Migration from Oracle 11g to 19c
- Upgrade paths and prerequisites.
- Utilization of pre- and auto-upgrade tools.
- Validation steps and resolving incompatibilities.
- Post-upgrade tasks and management of deprecated features.
- Post-migration testing procedures.
Course Closure
- General summary of key learnings.
- Recommendations for best practices.
Summary and Next Steps
Requirements
- Solid grasp of relational database concepts.
- Proficiency in SQL.
- Foundational knowledge of operating systems, such as Windows or Linux.
Target Audience
- Database administrators.
- System administrators.
- IT professionals tasked with managing Oracle environments.
Testimonials (1)
good explanation on each points and provide assignment for practices.
