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

How to prepare for Oracle Cloud Infrastructure 2023 Security Professional (1Z0-1104-23)

This exam was my first Hands-on Performance Exam and was very nice to take because it tests you against real life situations besides the usual multiple-choice questions, so be prepared to execute actions in OCI console. As stated in the exam page, is suggested to user to have at least 6 months of hands-on experience, […]
Adriano Tanaka

Goldengate – Initial Load para OSS/KAFKA

Nos meus outros posts sobre OCI Goldengate, falei sobre como configurar uma replicação entre um banco Oracle e o OSS/Kafka, nesse artigo vou demonstrar o procedimento para levar dados já existentes. Caso queira mais detalhes você pode consultar esse artigo: GoldenGate Microservices Initial Load Instantiation with WebUI Basicamente o que vamos fazer é: Criar um […]
Adriano Tanaka
Next Page »