Course Outline
ODA X11 Model Family and Platform Architecture
- Positioning of X11-S, X11-L, and X11-HA models.
- Compute, memory, and NVMe flash capacity ranges.
- X11-HA paired servers for Oracle RAC.
Oracle Linux, Appliance Software Stack, and Oracle Appliance Manager
- Oracle Linux and appliance software layers.
- Oracle Appliance Manager and odacli command-line interface.
- Integration of Oracle Grid Infrastructure and ASM.
Deployment Planning, Network Design, and Checklists
- Site, power, and rack planning considerations.
- Network topology, bonding, and VLAN design.
- Pre-deployment checklists and validation gates.
Appliance Deployment, Provisioning, and Validation
- Initial appliance configuration and registration.
- Network and storage provisioning tasks.
- Post-deployment validation and health checks.
Oracle AI Database 26ai on ODA: AI-Native Capabilities
- 26ai feature set on appliance hardware.
- Coexistence with Oracle Database 19c homes.
- AI-native architecture and workload suitability.
AI Vector Search: Data Model and Vector Indexes
- VECTOR data type and embedding dimensions.
- HNSW and IVF vector index structures.
- Distance metrics and index selection.
AI Vector Search in Practice: Hybrid Search and Tuning
- Hybrid vector indexing with keyword filtering.
- Trade-offs between recall, accuracy, and latency.
- Performance patterns for vector workloads.
Embedded Machine Learning and Select AI
- Converting natural language to SQL via Select AI.
- AI Profiles and provider configuration.
- In-database ONNX embedding models via DBMS_VECTOR_CHAIN.
- Oracle Machine Learning using OML4SQL and OML4Py.
Database Provisioning, DB Systems, and Templates
- Creating database systems with odacli.
- Custom database templates and configuration.
- Consolidation patterns on a single appliance.
Oracle ASM and ACFS Storage Management
- ASM disk groups and redundancy levels.
- ACFS file systems and shared storage.
- Rebalancing and capacity planning.
Database Security and Data Protection
- User, role, and privilege management.
- Transparent Data Encryption and key management.
- Auditing, masking, and compliance controls.
Backup and Recovery with RMAN
- RMAN backup strategies for appliance databases.
- Local and remote backup destinations.
- Restore and recovery validation drills.
Performance Monitoring, Diagnostics, and Query Optimization
- AWR, ASH, and SQL tuning workflows.
- Appliance-level resource monitoring.
- Identifying I/O and storage bottlenecks.
Patching, Upgrades, and Migration to 26ai
- Appliance software release 19.32 and clone files.
- Patching database homes and grid infrastructure.
- Migrating 19c databases to 26ai.
High Availability, RAC, and Disaster Recovery
- RAC configuration on X11-HA.
- Failover behavior and service placement.
- Data Guard and standby strategies.
Hardware Architecture, FRU Replacement, and Health Monitoring
- Component layout and field replaceable units.
- FRU replacement and service procedures.
- Health monitoring and alert thresholds.
Oracle ILOM and Out-of-Band Management
- ILOM access and user administration.
- Remote console and power control.
- Firmware and event log management.
Oracle Linux KVM Virtualization and VM Administration
- Oracle Linux KVM on ODA.
- Database systems and application VMs.
- VM lifecycle and resource allocation.
- Hard partitioning for licensing.
Network Configuration, Redundancy, and Monitoring
- Bonded interfaces and link redundancy.
- VLANs and client network separation.
- Network monitoring and fault isolation.
Troubleshooting Workshop and Operational Handover
- Structured fault isolation scenarios.
- Review of log, alert, and diagnostic evidence.
- Runbooks, escalation, and handover checklist.
Requirements
- Practical experience with Oracle Database administration.
- Familiarity with Oracle Linux command-line operations.
- Foundational understanding of storage, networking, and virtualization concepts.
- Exposure to Oracle Grid Infrastructure or Oracle RAC is beneficial.
Target Audience
- Database administrators responsible for Oracle Database Appliance platforms.
- Infrastructure and networking engineers supporting appliance deployments.
- Technical professionals transitioning to Oracle AI Database 26ai on engineered systems.
Testimonials (3)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
presentation skills, prompt answers to all questions
Oana - OPEN COURSE
Course - Oracle SQL LP - Fundamentals
it was structured very well both by days and by modules, easy to follow
