Skip to content

OCI

Oracle Cloud Infrastructure in practice: Autonomous Database, Base Database and Exadata services, compute, networking, identity, licensing and migrating to OCI.

OCI-managed MCP Server: Troubleshooting ORA-12170 errors with Private Endpoint connectivity

We recently worked on a customer proof of concept (PoC) involving Oracle databases hosted in Oracle Cloud Infrastructure (OCI) within private VCN subnets. The goal was to evaluate OCI-managed MCP servers and determine whether extending their available toolsets with additional database operations could reduce reliance on agent skills. By exposing reusable operations as MCP tools, we aimed to reduce token… 

Oracle: Failed to create Cloud Base DB Service DB-System with RU 19.32.

Issue I recently had to create a 19c Oracle Database on the Base Database Service on Oracle@Azure. Creating the DB-System failed with the following error: We didn’t see that issue before Database Release Update 19.32. A first test on native Oracle Cloud Infrastructure (OCI) to create a Base DB Service DB-system was successful. However further tests showed that shape “VM.StandardDB.x86”… 

Exascale new clone and snapshot capabilities

One of the most game changing capabilities of Exascale are the new clone and snapshot features compared to previous options available with ASM / ACFS. And since the business requirements for clones or snapshots to be made available rapidly and conveniently are rising, Exascale comes in rescue for IT operations to quickly provide storage efficient copies of production databases, even… 

Creating an Oracle Cloud Infrastructure VM using the CLI

Oracle Cloud Infrastructure (OCI) provides an easy-to-use command line interface named oci, with which you can do a lot of administrative tasks. Let’s see in this blog how to create virtual machines in OCI with this. Setting up oci-cli If you are already connected to your OCI tenancy with the command line, you can skip this part. Otherwise, let’s begin.… 

Using Oracle API for MongoDB on OCI

If you’ve ever had to deal with MongoDB after years (or even decades) of working with SQL, you’ve probably realized that querying JSON documents can sometimes be painful, to say the least. In response to this, Oracle (and others) use a not-so-native adaptation of SQL to query JSON documents. And if you’ve ever had to deal with these SQL-based JSON… 

Creating&Refreshing a refreshable PDB (from a Standby Database)

I’m used to work with refreshable clones in several Oracle multitenant environments. However, due to the amount of Archived Redo Log generated we never really tried to offload the the “refresh” process on the Active Data Guard Standby database. Let’s quickly check what is required to achieve this together. What is required to create a refreshable ? Well, to create… 

ExaCC/CS: modify database parameters in batch mode using dbaascli

This post briefly describes how to use a JSON responseFIle to modify (container) database parameters on Oracle Cloud ExaCC/ExaCS service. What are our options with dbaascli? Well, we can simply go ahead and apply single changes one by one. What a lucky test, we just set a single hidden parameter without any database restart. But hold on, more then 20… 

Optimize materialization of Exadata PDB sparse clones

Well, this blog is unfortunately reserved to DBA folk running Oracle engineered systems #Exadata, #ExaCC, #ExaCS and Oracle Multitenant database (aka. CDB) architecture. One of our #ExaCC customer has a strong DevOps focused business and heavily relies on Exadata sparse clones to quickly provision “lightweight” database clones for their development teams. As part of the move of an mission critical… 

YaK Core – The Holy Grail for Deploying Ansible Code Everywhere

YaK core Multi-Platform open source Automation Tool simplifies the deployment of Ansible playbooks through a clean UI and API. It offers an intuitive interface where users can upload playbooks, configure parameters, and deploy them seamlessly across various platforms, and all managed through a centralized inventory stored in a PostgreSQL database. With YaK Core, developers can focus on writing application code… 

Oracle Technology Roundtable for Digital Natives – Let’s have a look at AI, Cloud and HeatWave

Yesterday I participated to the Oracle Technology Roundtable for Digital Natives in Zurich. It was a good opportunity to learn more about AI, Cloud and HeatWave with the focus on very trendy features of this product: generative AI, machine learning, vector processing, analytics and transaction processing across data in Data Lake and MySQL databases. It was also great to share… 

ExaCC OCI integration with OEM 13.5 Cloud Control installed On-premises.

Introduction I wrote this article to show how you can integrate Legacy OEM with your Cloud environment in this case Oracle ExaCC.To have overall view on your Exadata X9M Cloud Infrastructure, statistics related to CPU/Memory/ASM Storage usage. Your on premise monitoring OEM can read data from Oracle cloud using OCI libraries and present them in combination with your standard DB/VMs…