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.
Course Outline
Introduction and Core Fundamentals
- Overview of Oracle Database architecture
- Distinguishing between a database instance and the database itself
- Memory and process architecture (including SGA, PGA, and background processes)
- Examination of parameter files, control files, redo logs, alert logs, and trace files
- A general introduction to Oracle Multitenant (covering CDB and PDB, and their scope within SE2)
Environment Setup and Installation
- Review of 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
- Using SQL*Plus: essential commands and administrative tasks
- Leveraging 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
- Creating databases via DBCA and SQL
- Working with initialization parameters and dynamic performance views (V$)
- Managing alert logs, trace files, and the Automatic Diagnostic Repository
- Utilizing the data dictionary
Connectivity and Naming Strategies
- Setting up network connections
- Naming methods: Easy Connect, Local Naming, and Directory Naming
- Managing database services
- Configuring the Listener agent (dynamic and static registration)
Multitenant Architecture (CDB and PDB) – SE2 Focus
- Concepts of CDB and PDB
- Creating PDBs (utilizing PDB$SEED, OMF, and PDB_FILE_NAME_CONVERT parameters)
- Managing PDBs (operating modes, parameters, and host/port settings)
- Removing PDBs
- Configuring shared servers (SGA, PGA, and shared server mode)
Storage Administration
- Managing tablespaces and datafiles
- Handling temporary and undo tablespaces
- Understanding segments, extents, blocks, and space management
- Managing file growth, OMF (Oracle Managed Files), and moving datafiles
Security and Auditing
- Managing users, roles, and privileges (adhering to the principle of least privilege)
- Defining profiles, password policies, and resource limits
- Auditing concepts specific to Oracle SE2
- Auditing critical operations
Backup and Recovery (RMAN)
- Backup strategies: types, retention policies, and recovery objectives
- Configuring RMAN and catalogs
- Handling recovery scenarios: media failure, point-in-time recovery, and common failures
- Validating backups
Monitoring and Performance Optimization
- Analyzing execution plans (using EXPLAIN PLAN and AUTOTRACE)
- Diagnosing waits and common events
- Proactive monitoring via the data dictionary and dynamic views
- Applying tuning methods suitable for SE2
Migration from Oracle 11g to 19c
- Evaluating upgrade paths and prerequisites
- Using pre/auto-upgrade tools
- Performing validation steps and resolving incompatibilities
- Completing post-upgrade tasks and addressing deprecated features
- Conducting post-migration testing
Course Conclusion
- General summary
- Recommendations for best practices
Summary and Next Steps
Requirements
- A foundational understanding of relational database concepts
- Proficiency in SQL
- Basic familiarity with operating systems such as Windows or Linux
Target Audience
- Database administrators
- System administrators
- IT specialists tasked with overseeing Oracle environments
49 Hours
Testimonials (1)
good explanation on each points and provide assignment for practices.