Course Outline
ODA X11 Model Family and Platform Architecture
- Positioning of X11-S, X11-L, and X11-HA models
- Ranges of compute, memory, and NVMe flash capacity
- Paired servers in X11-HA for Oracle RAC implementations
Oracle Linux, Appliance Software Stack, and Oracle Appliance Manager
- Layers of Oracle Linux and appliance software
- Overview of Oracle Appliance Manager and the odacli command line
- Integration with Oracle Grid Infrastructure and ASM
Deployment Planning, Network Design, and Checklists
- Inputs for site, power, and rack planning
- Design of network topology, bonding, and VLANs
- Pre-deployment checklists and validation milestones
Appliance Deployment, Provisioning, and Validation
- Initial appliance setup and registration processes
- Tasks for network and storage provisioning
- Post-deployment validation and health assessments
Oracle AI Database 26ai on ODA: AI-Native Features
- Feature set of 26ai 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 criteria for index selection
AI Vector Search in Practice: Hybrid Search and Optimization
- Hybrid vector indexes combined with keyword filtering
- Trade-offs between recall, accuracy, and latency
- Performance patterns in vector workloads
Embedded Machine Learning and Select AI
- Select AI for converting natural language to SQL
- Configuration of AI Profiles and providers
- In-database ONNX embedding models using DBMS_VECTOR_CHAIN
- Oracle Machine Learning utilizing OML4SQL and OML4Py
Database Provisioning, DB Systems, and Templates
- Creating database systems using odacli
- Custom database templates and configuration settings
- Consolidation patterns on a single appliance
Oracle ASM and ACFS Storage Management
- ASM disk groups and redundancy levels
- ACFS file systems and shared storage arrangements
- Rebalancing processes and capacity planning
Database Security and Data Protection
- Management of users, roles, and privileges
- Transparent data encryption and key management
- Auditing, data masking, and compliance controls
Backup and Recovery with RMAN
- RMAN backup strategies for appliance-hosted databases
- Local and remote backup destinations
- Restore and recovery validation exercises
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 systems
- Failover behaviour and service placement strategies
- Data Guard and standby approaches
Hardware Architecture, FRU Replacement, and Health Monitoring
- Component layout and field replaceable units (FRUs)
- Procedures for FRU replacement and service
- Health monitoring and alert thresholds
Oracle ILOM and Out-of-Band Management
- ILOM access and user administration
- Remote console and power control features
- Management of firmware and event logs
Oracle Linux KVM Virtualization and VM Administration
- Implementation of Oracle Linux KVM on ODA
- Database systems and application virtual machines
- VM lifecycle management and resource allocation
- Hard partitioning for licensing purposes
Network Configuration, Redundancy, and Monitoring
- Bonded interfaces and link redundancy
- VLANs and separation of client networks
- Network monitoring and fault isolation techniques
Troubleshooting Workshop and Operational Handover
- Structured fault isolation scenarios
- Review of logs, alerts, and diagnostic evidence
- 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 overseeing Oracle Database Appliance platforms
- Infrastructure and networking engineers supporting appliance rollouts
- Technical professionals transitioning to Oracle AI Database 26ai on engineered systems
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 5200 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
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
