Connor McDonald writes that there was lots of buzz around AI but it was great to still see the high level of interest in the core database tech.
Read his wrap up here.
Implementing the Model Context Protocol (MCP) in Oracle Database 26ai
Bruno Reis writes:
“As applications using AI evolve, databases are no longer just data stores since they are becoming intelligent endpoints that can interact directly with large language models (LLMs) and AI agents. The Model Context Protocol (MCP) is the key standard that makes this possible: it provides a uniform way for AI agents to query, reason, and act on data sources such as relational databases.
In this post, I will walk through two practical implementations of MCP:
- Rolling your own MCP server with Python for finer control.
- Using Oracle’s built-in SQLcl MCP Server.”
How to Set Up RMAN Backups for a DBCS Instance Using a Private Object Storage Bucket on OCI
This blog starts with:
“According to Oracle documentation, Autonomous Recovery Service (ARS) — a fully managed service built on Oracle’s on-premises Zero Data Loss Recovery Appliance (ZDLRA) technology — is the recommended solution for performing database backups. ARS provides modern cybersecurity protection and ensures reliable, low-risk recovery for Oracle Databases. Alternatively, you can also configure Automatic Backups for a database using Object Storage, which can be easily set up through the OCI Console.”
Bringing Interactive Guidance to Oracle Analytics with OGL Custom Extensions
In this article, Prasenjit Thakur explains:
- Integrating and using OGL in Oracle Analytics Cloud (OAC) using the data visualization and workbook extensions
- Creating a guide in the Oracle Guided Learning (OGL) authoring environment
The AI World 2025 mega download!
Connor McDonald writes: “We’ve all been there… You head over to the Session Catalog for AI World and you want to download the files for all of the sessions you have been to, and all of the sessions you have missed.
Then you discover… you need to click on each session to see the file name to download…. Ugh!”
QUALIFY: The WHERE Condition for Analytic Functions
Dani Schnider says, “Filtering analytic functions was not straight-forward in Oracle and most other databases. Oracle 26ai now supports the QUALIFY clause in SQL. It works like a WHERE condition, but can be used for analytic functions.”
Make Chrome trust your self-signed Root CA on macOS
This blog goes through the problem:
Harbor: Self-signed certificates are suitable for quick localhost tests, but they are not recommended for production or shared environments.
Chrome shows “Not Secure” for my test Golden Gate 23ai setup, where I decided to use a self-signed certificate.
Then goes into the solution.
Datapatch Fails in Oracle 12c on Windows – Root Cause and Step-by-Step Fix
Soumya writes, “Recently, while applying a patch on an Oracle 12c (12.2.0.1) database on Windows, I ran into a frustrating issue: datapatch kept failing with cryptic errors.”
The issue and solution is then explored within the blog post.
David Fitzjarrell examines the pathway of redo transport in a Data Guard configuration in this blog.