Course Outline
Introduction and Core Fundamentals
- Architectural overview of Oracle Database
- Distinguishing between the database instance and the database
- Memory and process structures (SGA, PGA, background processes)
- Key files: parameter, control, redo logs, alert logs, and trace files
- General insights into Oracle Multitenant architecture (CDB and PDB, including SE2 scope)
Environment Setup and Installation
- Prerequisites and compatible platforms
- Installing Oracle Database 19c SE2
- Creating the initial database using DBCA
- Post-installation setup: listeners, services, and Enterprise Manager Express
Administrative Tools and Connectivity
- Establishing connections to Oracle Database instances
- SQL*Plus: fundamental commands and administrative tasks
- Utilizing Oracle SQL Developer
- Monitoring and routine tasks in Oracle Enterprise Manager Express
- Configuring Net Services and listeners
Instance and Database Management
- Startup and shutdown procedures
- Database creation via DBCA and SQL
- Initialization parameters and dynamic performance views (V$)
- Managing alert logs, trace files, and the Automatic Diagnostic Repository
- Understanding the data dictionary
Connectivity and Naming Strategies
- Setting up network connections
- Naming methods: Easy Connect, Local Naming, and Directory Naming
- Database service administration
- Configuring listener agents (dynamic and static)
Multitenant Architecture (CDB and PDB) – SE2 Scope
- Concepts behind CDB and PDB
- Creating PDBs (utilizing PDB$SEED, OMF, and PDB_FILE_NAME_CONVERT parameters)
- PDB administration (modes, parameters, host/port setup)
- Removing PDBs
- Shared server setup (SGA, PGA, and shared server mode)
Storage Administration
- Tablespaces and datafiles
- Temporary and undo tablespaces
- Segments, extents, blocks, and space management
- File growth, Oracle Managed Files (OMF), and datafile relocation
Security and Auditing
- Users, roles, and privileges (least privilege principle)
- Profiles, password policies, and resource constraints
- Auditing concepts within Oracle SE2
- Monitoring critical operations through auditing
Backup and Recovery (RMAN)
- Backup strategies: types, retention policies, and recovery goals
- RMAN configuration and catalogs
- Recovery scenarios: media, point-in-time, and handling common failures
- Validating backups
Monitoring and Performance Tuning
- Analyzing execution plans (EXPLAIN PLAN, AUTOTRACE)
- Identifying waits and common events
- Proactive monitoring using data dictionaries and dynamic views
- Tuning techniques specific to SE2
Migration from Oracle 11g to 19c
- Upgrade paths and prerequisites
- Pre-auto-upgrade tools
- Validation steps and resolving incompatibilities
- Post-upgrade tasks and handling deprecated features
- Testing after migration
Course Conclusion
- Overall summary
- Recommendations for best practices
Overview and Future Steps
Requirements
- A foundational grasp of relational database principles
- Proficiency with SQL
- Basic knowledge of operating systems, including Windows or Linux
Target Audience
- Database administrators
- System administrators
- IT specialists tasked with overseeing Oracle environments
Testimonials (2)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
Learning about a new tool, the practices help a lot in understanding the topics, and that was what I liked the most.
David Vargas Alpizar - BANCO BAC SAN JOSE S.A
Course - Oracle Database 19c: Administration
Machine Translated
