Datapatch fails with ORA-29516, ORA-00604 and ORA-29532 java.lang.ArrayIndexOutOfBoundsException

Those days, while trying to apply 19.5 RU over a 19c Oracle Database (clean 19.2 installation), the datapatch apply phase was trowing me an error: $ datapatch -verbose SQL Patching tool version 19.5.0.0.0 Production on Mon Oct 21 07:46:31 2019 Copyright (c) 2012, 2019, Oracle. All rights reserved. Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_824_2019_10_21_07_46_31/sqlpatch_invocation.log Connecting …

Continue lendo

How to export all your Oracle Cloud Infrastructure billing information

As of today (October 2019), there is still no internal capability in Oracle Cloud Infrastructure to export the metadata of all the billing information you have in your OCI to a CSV, JSON or any other file that would allow us to easily import in other tools to create our own graphs. Meanwhile, I have …

Continue lendo

Deploying a highly available MySQL Cluster with DRBD on OCI

This tutorial walks you through the process of deploying a MySQL database to Oracle Cloud Infrastructure (OCI) by using Distributed Replicated Block Device (DRBD). DRBD is a distributed replicated storage system for the Linux platform. PS: This post was based in many other articles that I've read over internet and I adapted them for OCI. …

Continue lendo

GUOB 2019 está chegando!

O Grupo de Usuários Oracle do Brasil ( GUOB ) está preparando outra edição para seu evento anual que ocorrerá em 10/Agosto/2019 em São Paulo, na Univeridade Nove de Julho, UNINOVE, que proporcionará um ótimo encontro da tecnologia Oracle usuários do Brasil com a participação de palestrantes internacionais e nacionais. Palestrantes Neste ano, teremos palestrantes …

Continue lendo

Cloning Security List Rules among different SLs in OCI

On the last year, I've been working for a customer that uses one of the Oracle OCI regions as his primary DC and the other as a Standby environment. As they are pretty identical regarding the routes and network access rules, I needed to constantly get their Standby region in sync with the primary regarding …

Continue lendo