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
Fundamentals and Introduction
- Overview of the Oracle Database architecture
- Distinguishing between a database instance and a database
- Memory and process structures (SGA, PGA, background processes)
- Key files: parameter, control, redo logs, alert logs, and trace files
- Introduction to Oracle Multitenant technology (CDB and PDB, with a focus on SE2 scope)
Environment Setup and Installation
- Reviewing prerequisites and supported platforms
- Installing Oracle Database 19c SE2
- Creating the initial database using DBCA
- Post-installation setup: configuring listeners, services, and Enterprise Manager Express
Administration Tools and Connectivity
- Establishing connections to an Oracle Database instance
- SQL*Plus: essential commands and administrative tasks
- Utilizing Oracle SQL Developer
- Oracle Enterprise Manager Express: monitoring and routine operations
- Configuring Net Services and listeners
Instance and Database Management
- Understanding startup and shutdown modes
- Database creation via DBCA and SQL
- Managing initialization parameters and dynamic performance views (V$)
- Overseeing alert logs, trace files, and the Automatic Diagnostic Repository
- Exploring the data dictionary
Connectivity and Naming Strategies
- Setting up network connections
- Naming methods: Easy Connect, Local Naming, and Directory Naming
- Managing database services
- Listener agent configuration (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 (modes, parameters, and host/port settings)
- 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 datafile relocation
Security and Auditing
- Users, roles, and privileges (applying the principle of least privilege)
- Profiles, password policies, and resource limits
- Auditing principles in Oracle SE2
- Auditing critical operational activities
Backup and Recovery (RMAN)
- Backup strategies: types, retention policies, and recovery objectives
- RMAN configuration and catalogs
- Recovery scenarios: media failure, point-in-time, and common errors
- Validating backups
Monitoring and Performance Optimization
- Analyzing execution plans (EXPLAIN PLAN, AUTOTRACE)
- Diagnosing wait events and common issues
- Proactive monitoring using the data dictionary and dynamic views
- Tuning techniques 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 addressing deprecated features
- Post-migration testing
Course Conclusion
- Comprehensive summary
- Recommendations for best practices
Summary and Future Steps
Requirements
- A 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 specialists tasked with overseeing Oracle environments
Testimonials (1)
good explanation on each points and provide assignment for practices.
