Course Outline
ODA X11 Model Variants and Platform Architecture
- Positioning of X11-S, X11-L, and X11-HA models within the product lineup.
- Specifications for compute power, memory, and NVMe flash storage capacities.
- Utilizing paired X11-HA servers to support Oracle RAC implementations.
Oracle Linux, Software Stack, and Appliance Manager
- Overview of Oracle Linux and the layered appliance software architecture.
- Managing the platform using Oracle Appliance Manager and the odacli command line.
- Integration of Oracle Grid Infrastructure and Automatic Storage Management (ASM).
Deployment Strategy, Network Architecture, and Validation
- Assessing site requirements, power needs, and rack planning.
- Designing network topologies, including bonding and VLAN configurations.
- Executing pre-deployment checklists and ensuring validation gates are met.
Appliance Installation, Provisioning, and Verification
- Performing initial appliance setup and registration.
- Executing network and storage provisioning procedures.
- Conducting post-deployment validation and comprehensive health checks.
Oracle AI Database 26ai on ODA: AI-First Features
- Exploring the 26ai feature set optimized for appliance hardware.
- Ensuring coexistence between 26ai and Oracle Database 19c database homes.
- Aligning AI-native architectural capabilities with specific workload requirements.
AI Vector Search: Data Modeling and Indexing Strategies
- Understanding the VECTOR data type and embedding dimensions.
- Evaluating HNSW and IVF vector index structures.
- Selecting appropriate distance metrics and index types.
Practical AI Vector Search: Hybrid Queries and Optimization
- Implementing hybrid vector indexes combined with keyword filtering.
- Balancing recall, accuracy, and latency in search performance.
- Identifying performance patterns specific to vector workloads.
In-Database Machine Learning and Select AI
- Using Select AI to convert natural language queries into SQL.
- Configuring AI Profiles and provider settings.
- Leveraging in-database ONNX embedding models via DBMS_VECTOR_CHAIN.
- Working with Oracle Machine Learning using OML4SQL and OML4Py.
Database Creation, Systems, and Template Management
- Creating database systems efficiently using odacli.
- Developing and applying custom database templates and configurations.
- Implementing consolidation patterns on a single appliance.
Managing Oracle ASM and ACFS Storage
- Configuring ASM disk groups and setting redundancy levels.
- Utilizing ACFS file systems for shared storage needs.
- Executing storage rebalancing and capacity planning.
Database Security and Data Safeguarding
- Managing users, roles, and access privileges.
- Implementing transparent data encryption and key management.
- Establishing auditing, data masking, and compliance controls.
Backup and Recovery using RMAN
- Developing RMAN backup strategies tailored for appliance databases.
- Managing local and remote backup storage destinations.
- Performing restore and recovery validation exercises.
Performance Monitoring, Diagnostics, and Query Tuning
- Utilizing AWR, ASH, and SQL tuning workflows.
- Monitoring resource usage at the appliance level.
- Identifying and resolving I/O and storage bottlenecks.
Patching, Upgrades, and Migration to 26ai
- Managing Appliance software release 19.32 and clone files.
- Applying patches to database homes and grid infrastructure components.
- Migrating existing 19c databases to the 26ai environment.
High Availability, RAC, and Disaster Recovery
- Setting up RAC configurations on X11-HA models.
- Understanding failover behaviors and service placement.
- Implementing Data Guard and standby database strategies.
Hardware Architecture, FRU Handling, and Health Checks
- Understanding component layout and field-replaceable units.
- Executing FRU replacement and service procedures.
- Monitoring health status and managing alert thresholds.
Oracle ILOM and Out-of-Band Control
- Accessing ILOM and administering users.
- Utilizing remote console features and power controls.
- Managing firmware updates and event logs.
Oracle Linux KVM Virtualization and VM Management
- Implementing Oracle Linux KVM on ODA platforms.
- Managing database systems and application virtual machines.
- Controlling VM lifecycle and resource allocation.
- Using hard partitioning to manage licensing.
Network Setup, Redundancy, and Oversight
- Configuring bonded interfaces for link redundancy.
- Implementing VLANs and separating client networks.
- Monitoring network health and isolating faults.
Troubleshooting Practice and Operational Transition
- Working through structured fault isolation scenarios.
- Reviewing logs, alerts, and diagnostic evidence.
- Developing 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
- 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 deployments
- Technical professionals 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
