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 specifications
- X11-HA paired server configurations for Oracle RAC
Oracle Linux, Appliance Software Stack and Oracle Appliance Manager
- Overview of Oracle Linux and appliance software layers
- Usage of Oracle Appliance Manager and the odacli command line
- Integration with Oracle Grid Infrastructure and ASM
Deployment Planning, Network Design and Checklists
- Site, power, and rack planning requirements
- Network topology, bonding, and VLAN design strategies
- Pre-deployment checklists and validation milestones
Appliance Deployment, Provisioning and Validation
- Initial appliance configuration and registration processes
- Network and storage provisioning procedures
- Post-deployment validation and health assessment checks
Oracle AI Database 26ai on ODA: AI-Native Capabilities
- Features 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
- Selection of distance metrics and indexes
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
- Select AI capabilities for natural language to SQL
- Configuration of AI Profiles and providers
- In-database ONNX embedding models via DBMS_VECTOR_CHAIN
- Oracle Machine Learning with OML4SQL and OML4Py
Database Provisioning, DB Systems and Templates
- Creation of database systems using odacli
- Custom database templates and configuration options
- Consolidation patterns on a single appliance
Oracle ASM and ACFS Storage Management
- ASM disk groups and redundancy levels
- ACFS file systems and shared storage environments
- Rebalancing and capacity planning strategies
Database Security and Data Protection
- Management of users, roles, and privileges
- 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 destination management
- Restore and recovery validation drills
Performance Monitoring, Diagnostics and Query Optimization
- AWR, ASH, and SQL tuning workflows
- Appliance-level resource monitoring
- Diagnosing 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
- Migration of 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 checklists
Requirements
- Professional experience in Oracle Database administration
- Familiarity with Oracle Linux command line operations
- Foundational understanding of storage, networking, and virtualization concepts
- Experience with 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 staff transitioning to Oracle AI Database 26ai on engineered systems
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
