Oracle Cloud Ashburn x Chicago bandwidth test

Those days I had to implement an Oracle Cloud "IAAS Classic" solution for databases and applications with DR environments, considering the primary region as Ashburn (uscom-east-1) and the standby region as Chicago (uscom-central-1). To make both regions talk securely over the internet, I had to implement a VPN connection between both regions. Before stating everything, …

Continue lendo

Resolvendo VirtualBox causando Kernel Panic no macOS

Por um longo tempo tive problema no meu VirtualBox 5.x quando eu executava um processamento pesado no meu BD Oracle pois ele crashava não apenas matando a VM mas todo o meu sistema macOS, forçando o meu MacBook Pro a reiniciar com a seguinte mensagem de erro: Quando o sistema voltava, assim que eu logava …

Continue lendo

Applying 171017 BP (26392124) over 170814 (26609769) returning "out of order" error.

Today I was trying to apply the Oracle Exadata Database 171017 BP (26392124) on top of 170814 (26609769) and I was getting the error below: [oracle@localhost 26392124]$ opatch apply Oracle Interim Patch Installer version 11.2.0.3.15 Copyright (c) 2017, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc OPatch version …

Continue lendo

Dissecting 171017 BP, PSU, RU and RUR

Starting today I will quarterly write a post dissecting the changes implemented by Oracle CPUs so we can understand better the modifications implemented by Oracle in our Databases. So what oracle internal objects were changed in 170117? VERSION PATCH OWNER TYPE TOTAL -------------------- -------- ------------------------------ ------------------------------ ---------- 11.2.0.4 BP SYS PACKAGE BODY 1 11.2.0.4 PSU …

Continue lendo

v$sga, v$sgainfo and v$sgastat matching bytes challenge

Those days I was challenging myself to make an exact match and correlate all lines returned by a select on v$sga, v$sgainfo and v$sgastat. The biggest problem on those v$ views is that they bring different visions of the same thing (SGA), and I could never make a exact match of the bytes before. Now …

Continue lendo