Author: 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

How to take Immutable backups in Oracle Database

Some organizations need to comply with Government regulations about backup retention and protection, in OCI we have a feature called Retention Rule in Object Storage, combine this feature with the new version of RMAN opc module and we can achieve Immutability in Oracle backups (running in cloud or on premises). In this article I will […]
Adriano Tanaka

How to prepare for Oracle Cloud Infrastructure 2023 Architect Associate (1Z0-1072-23) BR (Brazilian Portuguese)

This exam was my first Oracle Exam in Brazilian Portuguese, as a native Portuguese speaker, is nice to see this type of initiative from big companies. About the exam, I’m used to work in OCI Console using English language, so in some questions I spent time trying to translate terms from Portuguese to English. As […]
Adriano Tanaka
Next Page »