Author: Adriano Tanaka

Resolving ORA-01031: Insufficient Privileges When Using UTL_HTTP

If you’re using an Autonomous Database Serverless (ADB-S) and attempting to call HTTP (not HTTPS) endpoints, encountering the ORA-01031 error is common. While your first step might be to check the Access Control List (ACL) or grant permissions to the user calling the package, this alone won’t resolve the issue. Here’s how to fix it: […]
Adriano Tanaka

Loading an ONNX Model for Oracle AI Vector Search

While preparing for the Oracle AI Vector Search Certified Professional Certification (1Z0-184-25), one of the most fascinating topics I encountered was Using Vector Embeddings, particularly with the new VECTOR DBMS/Packages. Here, I’ll share an example of how to load an ONNX model into your Oracle Database.  For reference, I’m running Oracle 23ai Free Edition and […]
Adriano Tanaka

Oracle 23ai – SQL Firewall

O SQL Firewall é um recurso que foi introduzido na versão 23ai do Oracle Database (aqui você pode conferir as New features desse release) e como o nome já diz, ele atual como um Firewall para comandos SQL tendo como principal vantagem estar integrado diretamente no banco de dados (diferente de outras  abordagens que precisam […]
Adriano Tanaka

GoldenGate 23ai – Monitoramento com StatsD
Adriano Tanaka

How to apply GoldenGate 23ai Patch

Keeping your application updated is crucial for several reasons. With each new update, you can access the latest features, security patches, and performance improvements that enhance the overall efficiency and safety of your application. Here I will show how to move from 23.4 to 23.6 but the procedure applies to other versions too. Opatch To […]
Adriano Tanaka

ORA-40842 unsupported value EMBEDDED_OID in the metadata

I was assisting a customer with an issue related to the SODA/MongoDB API. They were encountering the ORA-40842 error in Autonomous Database – Shared (19c). After several troubleshooting sessions, we determined that updating the application driver to the latest version resolves the problem. For Java, specifically, you need orajsoda-1.1.27(or newer) to accommodate some internal changes […]
Adriano Tanaka

A script to work with OCI Cost API (usage-api)

OCI has a great interface to gather Cost and Usage reports, but imagine that you have a tenancy with almost 300 compartments and you need to build a report with the cost by each one? I know that you can export the reports in PDF format(or CSV), but you will need to do some type […]
Adriano Tanaka

GoldenGate 23ai with Data Stream and AsyncAPI

GoldenGate 23ai introduces a powerful new feature called Data Streams, which leverages the AsyncAPI specification and you publish your trail file directly from GoldenGate(and you can specify the CloudEvents format), according to the documentation: Oracle GoldenGate Data Streams utilizes the AsyncAPI specification for defining asynchronous APIs. This approach enables applications to efficiently subscribe to data […]
Adriano Tanaka

Network for OCI GoldenGate

New to deploying OCI GoldenGate and unsure about networking? No worries, this guide will walk you through some key points.
Adriano Tanaka

GoldenGate – Downstream architecture

How to extract data using GoldenGate without overloading your primary database or connecting to it directly You have received a request to extract data using GoldenGate, but your primary database is overloaded or you have a strong security posture that prohibits other applications besides your main application to connect to your database. How do you […]
Adriano Tanaka
Next Page »