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
- High-level overview of Oracle Database architecture
- Distinction between a database instance and a database
- Memory and process architecture (covering SGA, PGA, and background processes)
- Key files: parameter files, control files, redo logs, alert logs, and trace files
- General introduction to Oracle Multitenant (CDB and PDB, including their scope in SE2)
Environment Setup and Installation
- Pre-requirements and supported platforms
- Step-by-step installation of 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 for management tasks
- Oracle Enterprise Manager Express: monitoring and routine operations
- Configuration of Net Services and listeners
Instance and Database Management
- Understanding startup and shutdown modes
- Creating databases via DBCA and SQL
- Managing initialization parameters and dynamic performance views (V$)
- Handling 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
- Configuring Listener agents (dynamic and static)
Multitenant Architecture (CDB and PDB) – SE2 Context
- Concepts behind CDB and PDB
- Creating PDBs (utilizing PDB$SEED, OMF, and PDB_FILE_NAME_CONVERT parameters)
- PDB management (modes, parameters, and host/port settings)
- Removing PDBs
- Configuring shared servers (SGA, PGA, and shared server mode)
Storage Administration
- Tablespaces and datafiles
- Temporary and undo tablespaces
- Segments, extents, blocks, and space management strategies
- File growth, OMF (Oracle Managed Files), and moving datafiles
Security and Auditing
- Users, roles, and privileges (applying 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: types, retention policies, and recovery objectives
- Configuring RMAN and managing catalogs
- Recovery scenarios: media recovery, point-in-time recovery, and handling common failures
- Validating backups
Monitoring and Performance Optimization
- Leveraging execution plans (EXPLAIN PLAN, AUTOTRACE)
- Diagnosing waits and common events
- Proactive monitoring using data dictionary and dynamic views
- Tuning methods tailored for SE2
Migrating from Oracle 11g to 19c
- Upgrade paths and prerequisites
- Using pre- and auto-upgrade tools
- Validation steps and resolving incompatibilities
- Post-upgrade tasks and managing deprecated features
- Testing after migration
Course Conclusion
- Comprehensive summary
- Recommendations for best practices
Summary and Future Steps
Requirements
- Solid comprehension of relational database concepts
- Proficiency in SQL
- Fundamental knowledge of operating systems like Windows or Linux
Target Audience
- Database administrators
- System administrators
- IT professionals tasked with overseeing Oracle environments
Testimonials (1)
good explanation on each points and provide assignment for practices.
