October 2019 - DBA - Rodrigo Jorge - Oracle Tips and Guides

Oct 28

Automating clone of OCI compute instances across regions

By DBA RJ in Oracle Cloud

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 …

2 comments

Oct 27

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

By DBA RJ in Oracle Cloud

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 …

2 comments

Oct 24

Dissecting 191016 BP, PSU, RU and RUR

By DBA RJ in Database Security, Oracle Database General

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 …

2 comments

Oct 21

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

By DBA RJ in Oracle Database General

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 …

2 comments

Oct 10

How to export all your Oracle Cloud Infrastructure billing information

By DBA RJ in Oracle Cloud

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 …