Month: August 2019

Community, Events

GUOB 2019 Review

 , , ,

Hello all!

Last August 10th I had the privilege of being again (4th in a row) speaking in Groundbreakers Tour São Paulo / aka GUOB Techday 2019!

However, this year for the first time as a GOUB Counselor, organizing this event. So, I’d like to thank you all for being there and for the friends in GUOUB for this great opportunity.

This year I had the pleasure to talk a little bit over a few tips in my session: Tips and Tricks from over 20K hours DBA oncall.

Besides those, I could also be in some other awesome sessions delivered by top speakers in the world, including:

  • Mike Dietrich: Master Product Manager on Database Upgrade / Migration team.
  • Sandesh Rao: VP – Autonomous Database Health e Machine Learning.
  • Ricardo Gonzalez: Cloud Migration Product Manager.
  • Nirmala Sundarappa: Java/DB Product Manager.
  • Ricardo Portilho: Oracle Instructor and Consultant
  • Vicent Romero: Java JDK Compiler Engineer

What I think? I can’t wait for the next one! Besides the great friends we met, it’s amazing to discuss such relevant topics with specialists on the area.

Some additional stuff:
–  Slides from GUOB Sessions
– Event Album

Thanks for everything, GOUB Community! See you soon!

Community, Events

AROUG 2019 Review

 , , , ,

Hello all!

This year I had the privilege of attending Buenos Aires Groundbreakers edition for the fist time! This event is organized by AROUG. And here goes my thank you and my congratulations to specially to Sebástian and Rita for the great reception and event organization!

There I had the pleasure to talk a little bit over a few tips in my session: Tips and Tricks from over 20K hours DBA oncall

Besides those, I could also be in some other awesome sessions delivered by top speakers in the world, including (the ones I could attend): Markus Michalewicz, Ricardo Gonzalez, Rodrigo Jorge, Alberto Salazar, Facundo Grande, Anil Niar and Vicent Romero.

What I think? I can’t wait for the next one! Besides the great friends we met, it’s amazing to discuss such relevant topics with specialists on the area.

Thanks for everything, Buenos Aires and AROUG! See you soon!

 

Community, Events

UYOUG 2019 Review

 , , , ,

Hello all!

This year I had the privilege of attending Montevideo Groundbreakers edition for the fist time! This event is organized by UYOUG. And here goes my thank you and my congratulations to Nelson, Edelweiss, Daniel and Pablo for the great reception and event organization!

There I had the pleasure deliver a session telling a story about a project I have handled recently: ODBCS+OGG+Standby in Cloud: Building an Elastic Environment for your Business.

 

What I think? I can’t wait for the next one! Besides the great friends we met, it’s amazing to discuss such relevant topics with specialists on the area.

Thanks for everything, Montevideo and UYOUG! See you soon!

Memorias.jpeg

Community, Events

CLOUG 2019 Review

 , , , ,

Hello all!

So, this is a very special review for me, once this is the most special event I have ever participated personally. Why? Because Jen and Pablo surprised me there with my ACE Director Announcement!  😀

ACEDAnnouncement.jpeg

 

SO, then, being ACED, I had the privilege to deliver 2 sessions:

  • Amazing Free Tools for Oracle DBAs
  • Tips and Tricks from over 20K hours DBA oncall

But besides those, I could also be in some other awesome sessions, as per:

  • ADWC for Developers and Data Scientists – by Edelweiss Kammermann
  • Navigating on the Exadata Architecture – by Franky Weber Faust
  • Oracle Sharding for Data Sovereignty and Massive Linear Scalability – by Markus Michalewicz
  • Oracle Partitioning for DBAs and Developers. Why, when and how to use it? – by Franky Weber Faust
  • Rogue One: Avoid the Rebels take your data using DBSAT and other Security Best Practices – by Roy Salazar Valverde

 

What I think? I can’t wait for the next one! Besides the great friends we met, it’s amazing to discuss such relevant topics with specialists on the area.

Thanks for everything, Chile! See you soon!

Database, Errors and Bugs, MySQL

MySQL 8 requested authentication method unknown

 , , ,

Hey folks,
Be aware when you’re migrating from MySQL 5.7 to 8.0 on how you’re doing and what kind of applications have access to it. The version 8.0 introduced a new authentication plugin called caching_sha2_password and it’s the default auth plugin now.  Here is the list of compatible connectors to check if your app is ok with that or if you should call the dev team.

Example: If, for some reason, you get stuck with the following error (PHP sample), you have to do a few changes.

Connect Error: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

Edit your config file and set the option default-authentication-plugin with mysql_native_password value, restart the server and set the password again with the following command.

Config File:

[mysqld]
/... other configs .../
default-authentication-plugin=mysql_native_password

SQL:

ALTER USER 'adv'@'localhost' IDENTIFIED WITH mysql_native_password BY '1AB@8CD#E91F22!';

New users should be created the same way. Be aware that you have to do that just for users that the application will use. Regular users for DBAs and queries you don’t have to do that change.

So, look out before just doing a update on your server, or you could break your app 😉

Community, Events

Formação DBA em Três de Maio (em 19c!)

 , ,

Olá pessoal,

Atipicamente post em português hoje, para lembrar a todos que no próximo dia 14/09 começa a Formação DBA em Três de Maio/RS, no Campus SETREM. Aulas somente em Sábados.

Não perde tempo e se increve já!

A formação é resultado da parceria entre a SETREM e a TargetTrust, que ministra cursos de TI há mais de 26 anos. Eu serei o instrutor da formação que é de 132 horas no total, dividida em 5 módulos.

O primeiro módulo “SQL e SQL ANSI” a se iniciar no dia 14/9 e tem 24 horas aula (3 sábados: 14/9, 28/9 e 5/10) , tratará de entre outros:

  • Comando SELECT, suas cláusulas e operadores
  • Funções single row, de conversão e expressões de condição
  • Sub-consultas e operadores SET.
  • Criação, gerenciamento e manipulação de tabelas
  • Implementação de constraints e utilização de views
  • Construção de SQLs avançados.
  • Performance de SQL e ferramentas para análise

Inscrições até 30/8!
Valores promocionais pra egressos, colaboradores SETREM e Pacotes Empresariais disponíveis.

Community, Events

HrOUG: Croatian Oracle Users Group Conference 2019!

 , , , , ,

Hello all,

I’m very happy to announce I’ll be at this years Croatia Oracle Users Group annual event, in Rovinj, at Hotel Istra 4, in St. Andrew island. When? October 15-18th.

This is one of 6 events on european Oracle Groundbreakers Tour this year.

Lectures will have 20 speakers from Oracle ACE Program (11 directors, 5 ace, 3 associate, 1 alumni). I’m happy to be one of those 11. 🙂

The event also has:

  • 4 keynotes
  • 20 Oracle ACE program speakers
  • 10 Oracle Corp. speakers
  • 3-4 Social evening events

More info:

 

Just a few pics to give a taste…

See you there!

Database, Migration | Upgrades | Patching

Stop Migrating Databases to 12c!

 , ,

If you are starting an upgrade plan, do it directly to 19c. Why?

Well, first let’s say that 19c is “equal” to 12.2.0.3 on previous version model, while 18c is 12.2.0.2, after latest 12.2.0.1. So, thinking reasonably, you would already plan for latest PSU on the future version, right? So this is 19c.

But not only this. It’s well known that Oracle’s Terminal Patchset is the Long Term Release for each version. And for 12.2 family this is 19c.

The image below (From Doc ID 742060.1) should help on clarifying this:

versions

In summary, since August 1st 2019:
– 11.2.0.4 is already on Extended Support (20% more expensive unless you have ULA)
– 12.1 family is already on Extended Support (20% more expensive unless you have ULA)

Which only leave us with 12.2 Family. Now I ask you, why jump to any “PSU” other than the final one?
Also, support on 12.2.0.1 goes only up to Nov 2020 and for 18c (12.2.0.2) only to Jun 2021, while 19c goes up to 2026 with ES/ULA!

I’m not even raising the great improvements we have on newer versions (if you are in 11.2, shame on you, you are basically 6 years behind the world technology wise).
Myself , I already migrated several databases on different clients to 19c and it’s running preeeetty fine. So trust on it!

Ok, so to migrate to 19c? (Some tips):
– To migrate directly to 19c you need to be on supported terminal patch set (11.2.0.4, 12.1.0.2) or on 12.2 family (12.2.0.1, 18c).
– Get in touch and use AutoUpgrade mechanism (you’ll love it!) – AutoUpgrade Tool (Doc ID 2485457.1)
– Check Upgrade Guide: https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/index.html
– Have a look on Mike Dietrich blog for news: https://mikedietrichde.com/
– Test it before doing in prod.

Additional Reference:
Release Schedule of Current Database Releases (Doc ID 742060.1)
Very nice and complete post (in portuguese) on this topic from Ricardo Portilho.

I like very much the table below as well:

NewScreenshot 2019-08-13 às 15.11.34

See you!

Community

ACE Director Announcement

 , ,

Hello all!
I’m proud to announce that last August 2nd Oracle promoted me from Oracle ACE to Oracle ACE Director!

And for this I can only thank:

  • ACE Program and Community itself for challenging me on this, which I discovered to be a passion after a while.
  • Friends and family for all your support and encouragement on literally every single step of this journey.
  • GREPORA and all our fellow authors on making it great on Community.
  • Pythian for all great team mates and encouragement regarding community programs.

But what is an Oracle ACE?

The Oracle ACE Program highlights excellence within the global Oracle community by recognizing individuals who have demonstrated both technical skill and strong credentials as enthusiasts and community advocates.

There are 3 levels of (active) Oracle ACEs:
ACE Associate: The entry level.
ACE: Proficient Community Advocate.
ACE Director: Expert Community Advocate.

To learn more about the program, visit Oracle ACE Program – FAQ

I’m glad to say I have covered all those steps (, , ) to be where I am right now.
Also, I got originally nominated in 3 Expertises: Database Management & Performance, Cloud, MySQL.

Some additional facts:

  • I’m the first Brazilian ACE Cloud.
  •  I’m the actual youngest ACE Director in the world.
  • I’m the only ACE Director living in Brazil.

In summary, I just want to share my happiness on having this logo now on with you all.

Thanks for all your support!

O_ACEDirectorLogo_clr