Bedankt voor uw aanvraag! Een van onze medewerkers neemt binnenkort contact met u op
Bedankt voor uw boeking! Een van onze medewerkers neemt binnenkort contact met u op.
Cursusaanbod
Introduction and Fundamentals
- Overview of Oracle Database architecture
- Database instance vs. 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 in SE2)
Environment Preparation and Installation
- Prerequisites and supported platforms
- Installation of Oracle Database 19c SE2
- Creation of the initial database (DBCA)
- Post-installation configuration: listeners, services, Enterprise Manager Express
Administration Tools and Connectivity
- Connecting to an Oracle Database instance
- SQL*Plus: basic commands and administration
- Using Oracle SQL Developer
- Oracle Enterprise Manager Express: monitoring and common tasks
- Net Services and listener configuration
Instance and Database Management
- Startup and shutdown modes
- Database creation with DBCA and SQL
- Initialization parameters and dynamic performance views (V$)
- Managing alert logs, trace files, and Automatic Diagnostic Repository
- Data dictionary
Connectivity and Naming Methods
- Establishing network connections
- Naming methods: Easy Connect, Local Naming, Directory Naming
- Database service management
- Listener agent configuration (dynamic and static)
Multitenant Architecture (CDB and PDB) – SE2 Scope
- CDB and PDB concepts
- PDB creation (with PDB$SEED, OMF, PDB_FILE_NAME_CONVERT parameters)
- PDB management (modes, parameters, host/port configuration)
- PDB removal
- Shared server configuration (SGA, PGA, 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 movement
Security and Auditing
- Users, roles, and privileges (principle of least privilege)
- Profiles, password policies, and resource limits
- Auditing concepts in 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, common failures
- Backup validation
Monitoring and Performance Optimization
- Using execution plans (EXPLAIN PLAN, AUTOTRACE)
- Diagnosing waits and common events
- Proactive monitoring with data dictionary and dynamic views
- Tuning methods for SE2
Migration from Oracle 11g to 19c
- Upgrade paths and prerequisites
- Pre/auto-upgrade tools
- Validation steps and incompatibility resolution
- Post-upgrade tasks and deprecated features
- Post-migration testing
Course Closure
- General summary
- Best practice recommendations
Summary and Next Steps
Vereisten
- An understanding of relational database concepts
- Experience with SQL
- Basic familiarity with operating systems such as Windows or Linux
Audience
- Database administrators
- System administrators
- IT professionals responsible for managing Oracle environments
56 Uren
