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 the database instance and the 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 (CDB and PDB), specifically within the SE2 scope
Environment Setup and Installation
- Prerequisites and supported platforms
- Installing Oracle Database 19c SE2
- Creating the initial database using DBCA
- Post-installation configuration, covering listeners, services, and Enterprise Manager Express
Administrative Tools and Connectivity
- Connecting to an Oracle Database instance
- SQL*Plus: essential commands and administration tasks
- Utilizing Oracle SQL Developer
- Oracle Enterprise Manager Express: monitoring and routine tasks
- Configuring Net Services and listeners
Managing Instances and Databases
- Startup and shutdown modes
- Database creation via DBCA and SQL
- Initialization parameters and dynamic performance views (V$)
- Managing alert logs, trace files, and the Automatic Diagnostic Repository
- Understanding the data dictionary
Connectivity and Naming Methods
- Establishing network connections
- Naming methods: Easy Connect, Local Naming, and Directory Naming
- Managing database services
- Configuring the listener agent (dynamic and static)
Multitenant Architecture (CDB and PDB) – SE2 Scope
- Core concepts of CDB and PDB
- Creating PDBs (utilizing PDB$SEED, OMF, and PDB_FILE_NAME_CONVERT parameters)
- PDB management, including modes, parameters, and host/port configuration
- Removing PDBs
- Shared server configuration (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 moving datafiles
Security and Auditing
- Users, roles, and privileges, adhering to the principle of least privilege
- Profiles, password policies, and resource limits
- Auditing concepts within Oracle SE2
- Auditing critical operations
Backup and Recovery (RMAN)
- Backup strategies: types, retention policies, and recovery objectives
- RMAN configuration and cataloging
- Recovery scenarios, including media, point-in-time, and common failures
- Validating backups
Monitoring and Performance Optimization
- Utilizing execution plans (EXPLAIN PLAN, AUTOTRACE)
- Diagnosing waits and common events
- Proactive monitoring using the data dictionary and dynamic views
- Tuning methods specific to SE2
Migrating from Oracle 11g to 19c
- Upgrade paths and prerequisites
- Pre- and auto-upgrade tools
- Validation steps and resolving incompatibilities
- Post-upgrade tasks and handling deprecated features
- Post-migration testing
Course Conclusion
- General summary of key points
- Recommendations for best practices
Summary and Future Steps
Requirements
- A foundational understanding of relational database concepts
- Experience working with SQL
- Basic familiarity with operating systems such as Windows or Linux
Target Audience
- Database administrators
- System administrators
- IT professionals responsible for managing Oracle environments
Testimonials (1)
good explanation on each points and provide assignment for practices.
