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 Oracle Database architecture
- Distinction between database instance and 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 within SE2)
Environment Setup and Installation
- Prerequisites and supported platforms
- Installing Oracle Database 19c SE2
- Creating the initial database via DBCA
- Post-installation configuration: listeners, services, and Enterprise Manager Express
Administrative Tools and Connectivity
- Establishing connections to an Oracle Database instance
- SQL*Plus: fundamental commands and administrative tasks
- Utilizing Oracle SQL Developer
- Oracle Enterprise Manager Express: monitoring and routine tasks
- Net Services and listener setup
Instance and Database Administration
- Startup and shutdown modes
- Database creation using DBCA and SQL
- Initialization parameters and dynamic performance views (V$)
- Managing alert logs, trace files, and the Automatic Diagnostic Repository
- Data dictionary exploration
Connectivity and Naming Strategies
- Establishing network connections
- Naming methods: Easy Connect, Local Naming, and Directory Naming
- Database service management
- Listener agent configuration (dynamic and static)
Multitenant Architecture (CDB and PDB) – SE2 Focus
- Concepts of CDB and PDB
- PDB creation (utilizing PDB$SEED, OMF, and PDB_FILE_NAME_CONVERT parameters)
- PDB management (modes, parameters, and host/port configuration)
- PDB removal procedures
- Shared server configuration (SGA, PGA, and shared server mode)
Storage Management
- Tablespaces and datafiles
- Temporary and undo tablespaces
- Segments, extents, blocks, and space administration
- File growth, OMF (Oracle Managed Files), and datafile relocation
Security and Auditing
- Users, roles, and privileges (principle of least privilege)
- Profiles, password policies, and resource limits
- Auditing concepts within 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, and common failures
- Backup validation procedures
Monitoring and Performance Tuning
- Utilizing execution plans (EXPLAIN PLAN, AUTOTRACE)
- Diagnosing waits and common events
- Proactive monitoring via data dictionary and dynamic views
- Tuning methods specific to SE2
Migration 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
- Best practice recommendations
Summary and Future Steps
Requirements
- A solid grasp of relational database principles
- Practical experience with SQL
- Fundamental knowledge of operating systems like Windows or Linux
Target Audience
- Database administrators
- System administrators
- IT specialists responsible for overseeing Oracle environments
Testimonials (1)
good explanation on each points and provide assignment for practices.
