Course Outline
ODA X11 Model Family and Platform Architecture
- Positioning of X11-S, X11-L, and X11-HA models.
- Overview of compute, memory, and NVMe flash capacity ranges.
- Utilization of paired X11-HA servers for Oracle RAC.
Oracle Linux, Appliance Software Stack, and Oracle Appliance Manager
- Layers of Oracle Linux and appliance software.
- Managing via Oracle Appliance Manager and the odacli interface.
- Integration with Oracle Grid Infrastructure and ASM.
Deployment Planning, Network Design, and Checklists
- Inputs for site, power, and rack planning.
- Designing network topology, bonding, and VLANs.
- Pre-deployment checklists and validation criteria.
Appliance Deployment, Provisioning, and Validation
- Initial appliance setup and registration.
- Provisioning tasks for network and storage.
- Post-deployment health checks and validation.
Oracle AI Database 26ai on ODA: AI-Native Capabilities
- 26ai feature set implemented on appliance hardware.
- Coexistence strategies with Oracle Database 19c homes.
- AI-native architecture and appropriate workload fit.
AI Vector Search: Data Model and Vector Indexes
- The VECTOR data type and embedding dimensions.
- Structures for HNSW and IVF vector indexes.
- Selecting distance metrics and indexes.
AI Vector Search in Practice: Hybrid Search and Tuning
- Implementing hybrid vector indexes with keyword filtering.
- Balancing recall, accuracy, and latency.
- Performance patterns for vector workloads.
Embedded Machine Learning and Select AI
- Translating natural language to SQL with Select AI.
- Configuring AI Profiles and providers.
- Using in-database ONNX embedding models via DBMS_VECTOR_CHAIN.
- Leveraging Oracle Machine Learning with OML4SQL and OML4Py.
Database Provisioning, DB Systems, and Templates
- Creating database systems using odacli.
- Developing custom database templates and configurations.
- Consolidation patterns on a single appliance.
Oracle ASM and ACFS Storage Management
- Managing ASM disk groups and redundancy levels.
- Utilizing ACFS file systems and shared storage.
- Rebalancing strategies and capacity planning.
Database Security and Data Protection
- Managing users, roles, and privileges.
- Transparent data encryption and key management.
- Implementing auditing, masking, and compliance controls.
Backup and Recovery with RMAN
- RMAN backup strategies for appliance databases.
- Configuring local and remote backup destinations.
- Conducting restore and recovery validation drills.
Performance Monitoring, Diagnostics, and Query Optimization
- Utilizing AWR, ASH, and SQL tuning workflows.
- Monitoring resource usage at the appliance level.
- 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
- Configuring RAC on X11-HA.
- Understanding failover behavior and service placement.
- Strategies for Data Guard and standby environments.
Hardware Architecture, FRU Replacement, and Health Monitoring
- Component layout and Field Replaceable Units.
- Procedures for FRU replacement and service.
- Health monitoring and alert threshold management.
Oracle ILOM and Out-of-Band Management
- Accessing and administering ILOM users.
- Controlling remote console and power.
- Managing firmware and event logs.
Oracle Linux KVM Virtualization and VM Administration
- Implementing Oracle Linux KVM on ODA.
- Managing database systems and application VMs.
- VM lifecycle and resource allocation.
- Hard partitioning for licensing purposes.
Network Configuration, Redundancy, and Monitoring
- Configuring bonded interfaces and link redundancy.
- Setting up VLANs and client network separation.
- Monitoring networks and isolating faults.
Troubleshooting Workshop and Operational Handover
- Scenario-based structured fault isolation.
- Reviewing log, alert, and diagnostic evidence.
- Establishing runbooks, escalation paths, and handover checklists.
Requirements
- Practical experience in Oracle Database administration.
- Proficiency with Oracle Linux command-line operations.
- Foundational knowledge of storage, networking, and virtualization concepts.
- Background exposure to Oracle Grid Infrastructure or Oracle RAC is advantageous.
Target Audience
- Database administrators tasked with managing Oracle Database Appliance platforms.
- Infrastructure and networking engineers involved in appliance deployment and support.
- 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
Greg was very patient and helpful
Chris Havel - Encyclopaedia Britannica
Course - ORACLE SQL Fundamentals
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
