October 2019 archive

Automating clone of OCI compute instances across regions

Oracle is constantly releasing new regions around the globe for the Oracle Cloud Infrastructure, and geolocation is something very important for companies specially to achieve low latencies and high throughput. After those regions are out, I've been asked for some customers to move their existing computes from one region to another. After doing the same …

Continue reading

Bucket named 'X' has pending multipart uploads. Stop all multipart uploads first.

Those days, I was trying to remove a bucket from my Oracle Cloud Infrastructure and I kept receiving the error when confirming the delete operation: Bucket named 'REGION_MIGRATION' has pending multipart uploads. Stop all multipart uploads first. There is (still) no way to view through the console what are those "multipart downloads" that are blocking …

Continue reading

Dissecting 191016 BP, PSU, RU and RUR

I am quarterly writing a post dissecting the changes implemented by Oracle CPUs so we can understand better the modifications implemented by Oracle in our Databases. To check previous changes, follow the links below: Dissecting 190716 BP, PSU, RU and RUR Dissecting 190416 BP, PSU, RU and RUR Dissecting 190115 BP, PSU, RU and RUR …

Continue reading

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 reading

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 reading