Review: OCI for Oracle DBA’s: Introduction and Key Concepts

Pessoal,

Passo apenas para agradecer a excelente participação no Webinar do GUORS realizado na última quinta-feira. Neste que foi o primeiro evento do GUORS no formato online , discutimossobre a arquitetura do OCI (Oracle Cloud Infrastructure), conceitos-chave e os desafios de um DBA Oracle na conversão de sua carreira para arquiteto Cloud.

  • Título da palestra: OCI for Oracle DBA’s: Introduction and Key Concepts
  • Palestrante: Marcus Vinicius
  • Sobre o palestrante: Marcus Vinicius é DBA Oracle Sênior, Oracle ACE e possui diversas certifiações em Bancos de Dados Oracle. Possui mais de 15 anos de experiência na área. Foi professor de pós-graduação no curso “MBA em Administração de Banco de Dados Oracle” no Veris IBTA, unidades de São Paulo e Campinas. Foi DBA Oracle e Gerente de Operações na Discover Technology e Consultor Oracle Sênior na Oracle (ACS). Atualmente é Consultor Oracle Sênior na Accenture Enkitec Group. Também é conselheiro técnico do GUOB. Mantém um blog sobre Oracle há mais de 10 anos.

unnamed

Para quem não teve oportunidade de particiar, a gravação do evento realizado já está disponível aqui!

Obrigado!

Oracle Code One 2020 Call for Papers is Open!

Hi all!

Is it happening this year? So far we know, yes!

So unless something happens, I’m submitting my paper. Aren’t you?

Before starting your proposal, review the Call for Papers Guidelines and Instructions for submitter, track, and session information, and key dates for Oracle Code One 2020.

The submission tool supports current versions of Firefox, Chrome, and Safari.

Note: When you submit a proposal, you authorize Oracle Code One 2020 to promote, publish, display, and disseminate the content you submit to Oracle, including speakers’ names and likenesses, for use associated with Oracle Code One 2020. Press, analysts, bloggers, and social media users might be in attendance at Oracle Code One 2020.

After you submit your proposal, note your confirmation number (session ID).

Key Dates
(Subject to change)

Oracle Code One Call for Papers — Open March 5, 2020
Oracle Code One Call for Papers — Close June 8, 2020 (5 pm PT)
Notifications for accepted and declined submissions sent Mid July

 

 

Click START to Create and Submit Your Proposal

Important: The submission tool times out after 15 minutes of inactivity. If it times out, you’ll lose the submission you were working on.

More info: https://reg.rainfocus.com/flow/oracle/oow20/codeone20cfp/cfpHome

If you have more questions, contact speaker-services_ww@oracle.com

Oracle Groundbreakers Yatra 2020 (AIOUG) – Online – CFP is Open!

Hi all,

Just sharing the word about this tour I always wanted to attend, maybe now it’s online I can be there!

It is going to happen from 1st -15th July 2020.

From the organization committee:

The health of All India Oracle Users Community (AIOUG) is our primary concern. Considering global precautions for the COVID-19 Coronavirus, and building upon recommendations from the World Health Organization, AIOUG is taking a new approach to its Oracle Groundbreaker Yatra event. The event is a highly concentrated 15-day collaboration and transformation while providing the deep technical education needed for our Indian Oracle Community.

We will accept papers on any topic related to Oracle Cloud, Oracle Database, Oracle Applications, Middleware, Engineered Systems, BigData, Virtualization and Servers, and Storage. Please follow the following guidelines to submit your papers.

Please note that presentations should not have sales or marketing content. This is a user’s conference and should have technical value to the attendees. Presentations containing any kind of sales or marketing information will be disqualified.

Important Dates for Speakers:

• Deadline to submit abstracts: 7th June 2020

• Approximate date you will be notified: 14th June 2020

How to submit a paper:

A simple process to fill following Google Formhttps://forms.gle/PJSzBCFXa7dZ1xEA6

Selection Process:

Once the CFP closes, the presentations will be selected by a panel of judges who have attended previous AIOUG events.

Contact:

For questions regarding the Call for Proposals, send an e-mail to ogyatra@aioug.org

I did mine submissions already!

NewScreenshot 2020-05-27 às 21.05.56

Live GUOB: Qual o Futuro do DBA?

O que você vai fazer amanhã a noite? Que tal participar de uma conversa sobre o futuro da sua profissão?

Amanhã (26/maio) a partir das 20:00 teremos um papo sobre expectativas pro futuro do DBA organizado pelo GUOB (Grupo de Usuários Oracle do Brasil).

Se já é difícil conseguir reunir essa galera topzera,  mais difícil ainda é poder participar do conforto do seu sofá. Não vai perder essa, hein!

Como participar? Basta ficar ligado no Canal do GUORS no Youtube!

WhatsApp Image 2020-05-23 at 16.21.49

 

Te vejo por lá!

Quer ser um Speaker no GUOB? Essa é sua chance!

Olá pessoALL!

Suponho que estejam todos familiarizados com o Tour de eventos Oracle na America Latina organizado anualmente pela LAOUC (Latin American Oracle Users Group Community) em parcerias com os grupos locais, organizado no Brasil pelo GUOB.

Por razões conhecidas, este ao o tour será e 100% online! E GRATUITO!

O Call for Papers está aberto para quem quiser submeter suas palestras.

WhatsApp Image 2020-05-18 at 20.53.47

Não havendo dias específicos para cada país, segue a expectativa de agenda para este ano:

Dia da Semana Dia do Mês Track
Segunda-Feira 17/08/2020 Database Track
Terça-Feira 18/08/2020 APEX track
Quarta-Feira 19/08/2020 Big Data, Analytics, and Machine Learning Track
Quinta-Feira 20/08/2020 Java Development Track
Sexta-Feira 21/08/2020 Cloud-Native Track
Segunda-Feira 24/08/2020 IoT, Chatbots, Mobile Development Track
Terça-Feira 25/08/2020 Oracle Cloud Infrastructre
Quarta-Feira 26/08/2020 Java Development Track
Quinta-Feira 27/08/2020 Database Track

Sei que você tem algo a dizer!

Participa da comunidade e compartilha teu conhecimento!

Want to be a Speaker? This is your chance! Speak to entire Latin America in August!

Hi!

Are you wondering how to become a Speaker? This is your golden ticket!

We are announcing the Call for Paper for LAOUC!

What is LAOUC? Well, this is an Oracle Users Groups Tour around Latin America where local communities engage their Oracle Professionals for a meeting discussion about experiences and technology. This is all organized by the LAOUC – Latin American Oracle Users Group Community with the local user’s groups (GUOB – Brazilian Oracle User Group in the case of Brazil, for instance).

In general, we have people from other countries and continents doing a crossover to increase the value of any discussions. And if this is your case, even better this year!

With all this COVID thing, this year’s tour will be 100% online! AND FREE!

Click HERE or in the image below to submit your papers!

LOGO-LAOUC

Here is the expected tracking agenda for the Tour:

Weekday Month Day Track
Monday August 17th Database Track
Tuesday August 18th APEX track
Wednesday August 19th Big Data, Analytics, and Machine Learning Track
Thursday August 20th Java Development Track
Friday August 21th Cloud-Native Track
Monday August 24th IoT, Chatbots, Mobile Development Track
Tuesday August 25th Oracle Cloud Infrastructre
Wednesday August 26th Java Development Track
Thursday August 27th Database Track

Things I use to hear:

“I’m shy” / “I don’t have have a topic” / “I never did it before”:

  • You’ll never know if you never try.
  • If you know anything that is interesting or others may appreciate knowing, you HAVE a topic.
  • If you are not experienced, you have time to become. Make your session a few times for friends, colleagues at work, and so on.

“How to prepare?”

  • Have a topic and know what you want to share about it.
  • Prepare your material in a way you’d like to see it: Be dynamic, be quick, be objective.
  • Try, try and try: Measure the time, present it a couple times, know what people like more or less regarding what you speak.

Still have questions? Be my guest: Reach me out and I’ll see how I can help you with this.

Take this chance!

19c: Could not execute DBMS_LOGMNR.START_LOGMNR: ORA-44609: CONTINOUS_MINE is desupported for use with DBMS_LOGMNR.START_LOGMNR.

Hi all,
This is to show you we should never trust 100% on documentation and how running on new versions yearly can put additional pressure on the documentation and cause errors…

So, I started supporting a new tool for data mining. There were no version restrictions as per their documentation, so I was more than happy about creating a PDB on my brand new 19c CDB, proudly using 19c for this new tool!

What happened?

Could not execute DBMS_LOGMNR.START_LOGMNR: ORA-44609: CONTINOUS_MINE is desupported for use with DBMS_LOGMNR.START_LOGMNR.

Doing my validation against the database:

SQL> execute dbms_logmnr.start_logmnr( options => dbms_logmnr.dict_from_online_catalog + SYS.DBMS_LOGMNR.CONTINUOUS_MINE);
BEGIN dbms_logmnr.start_logmnr( options => dbms_logmnr.dict_from_online_catalog + SYS.DBMS_LOGMNR.CONTINUOUS_MINE); END;

*
ERROR at line 1:
ORA-44609: CONTINOUS_MINE is desupported for use with DBMS_LOGMNR.START_LOGMNR.

Why is this happening?

This happens because the continuous_mine feature is deprecated since 12.2 and desupported/unavailable 19c on.

It seems this LogMining tool devs don’t check what changes on the new DBs versions before confirm compatibility, right?

And they don’t do it or a while, as this as announced as deprecated on 12.2…

Which makes me ask myself how are their confidence on the tool running on other clients they have… LOL

Anyway, are you facing the same? Here is some reference documentation to answer your boss about:

From: 19.1 Announcement – ORA-44609: CONTINOUS_MINE is Desupported For Use With DBMS_LOGMNR.START_LOGMNR (Doc ID 2456684.1):

  • CONTINUOUS_MINE was deprecated in Oracle Database 12c release 2 (12.2) and starting with 19.1 is desuppported. There is no replacement functionality.
  • The continuous_mine option for the dbms_logmnr.start_logmnr package is desupported in Oracle Database 19c (19.1), and is no longer available.

The real reasoning behind is: Nothing seems to be populating the V$LOGMNR_LOGS, so the ORA-1291 occurs.

Here is a quick test case or you, from the 19c version for Oracle Utilities Guide version 19c “Mining without specifying the list of redo log files“. (19c – 22. Using LogMiner to Analyze Redo Log Files)

I just put it all together to show you how it does [not] work:

  • Setting up it all:
ALTER DATABASE add SUPPLEMENTAL LOG DATA;
SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;
EXECUTE DBMS_LOGMNR_D.BUILD (OPTIONS=>DBMS_LOGMNR_D.STORE_IN_REDO_LOGS);
@?/rdbms/admin/dbmslm.sql
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
create user BLABLA identified by BLABLA default tablespace users quota unlimited on users profile default;
grant connect, resource to ;
  • Doing some stuff to generate logs:
connect BLABLA/BLABLA
alter session set nls_date_format='dd-mon-yyyy hh24:mi:ss';
set time on
CREATE TABLE TEST_NULLS (COLUMNA1 NUMBER(3,0));
ALTER TABLE TEST_NULLS ADD (COLUMNA2 NUMBER(3) DEFAULT 0 NOT NULL);
insert into TEST_NULLS(columna1) values (4);
commit;
select * from TEST_NULLS;
update TEST_NULLS set columna2=221 where columna1=4;
commit;
select * from TEST_NULLS;
  • Gathering info or mining:
connect / as sysdba;
set echo on
set serveroutput on
alter session set nls_date_format='dd-mon-yyyy hh24:mi:ss';
set linesize 254
set pagesize 3000
column name format a40;
SELECT FILENAME name FROM V$LOGMNR_LOGS;
SELECT NAME, FIRST_TIME FROM V$ARCHIVED_LOG;
SELECT NAME, FIRST_TIME FROM V$ARCHIVED_LOG WHERE SEQUENCE# = (SELECT MAX(SEQUENCE#) FROM V$ARCHIVED_LOG WHERE DICTIONARY_BEGIN = 'YES');
  • Introduce the first_time to recover for the previous query:
EXEC DBMS_LOGMNR.START_LOGMNR(STARTTIME =>'&1',ENDTIME => SYSDATE,OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.COMMITTED_DATA_ONLY + DBMS_LOGMNR.PRINT_PRETTY_SQL);
EXEC BEGIN DBMS_LOGMNR.START_LOGMNR(STARTTIME =>'&1',ENDTIME => SYSDATE,OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.COMMITTED_DATA_ONLY + DBMS_LOGMNR.PRINT_PRETTY_SQL);
select FIRST_CHANGE#,NEXT_CHANGE# from V$archived_log;
SELECT CHECKPOINT_CHANGE#, CURRENT_SCN FROM V$DATABASE;
  • Use the checkpoint at startscn and the current_scn at endscn:
EXEC DBMS_LOGMNR.START_LOGMNR(STARTSCN =>&1,ENDSCN => &2,OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.COMMITTED_DATA_ONLY + DBMS_LOGMNR.PRINT_PRETTY_SQL);
EXEC DBMS_LOGMNR.START_LOGMNR(STARTSCN =>&1,ENDSCN => &2,OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.COMMITTED_DATA_ONLY + DBMS_LOGMNR.PRINT_PRETTY_SQL);
EXEC DBMS_LOGMNR.START_LOGMNR(STARTTIME =>SYSDATE, ENDTIME => SYSDATE +5/24,OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.COMMITTED_DATA_ONLY + DBMS_LOGMNR.PRINT_PRETTY_SQL);
EXEC DBMS_LOGMNR.START_LOGMNR(STARTTIME =>SYSDATE ,ENDTIME => SYSDATE +5/24 ,OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.COMMITTED_DATA_ONLY + DBMS_LOGMNR.PRINT_PRETTY_SQL);

Ref: 19c – 22. Using LogMiner to Analyze Redo Log Files

  • You can expect or this:
ERROR at line 1:
ORA-01291: missing log file
ORA-06512: at "SYS.DBMS_LOGMNR", line 72
ORA-06512: at line 1

Hmmmm… So, the 19c Documentation is not working? Precisely.

As per (Doc ID 2613490.1), this will be fixed in 20.1 documentation.

  • Sections 22.13.2 Examples of Mining without specifying the list of redo log files explicitly and child example topics will be removed.
  • Section 22.4.2. Automatic Redo log Files options will be changed to Specifying Redo Log Files for Data Mining.
  • Section 22.7.4 The next sentence will be removed too.

In summary, whatever reference related to automatic mining in the documentation will be removed as this feature it’s not supported in 19.1 version and higher.

Ok, but this doesn’t solve my problem. What should I do with the client tool?

So, The continous_mine was the only method of starting LogMiner without first adding logfiles using dbms_logmnr.add_logfile.

What can I do, to workaround it:

  1. Add a logfile manually with dbms_logmnr.add_logfile for each logfile.
  2. Remove SYS.DBMS_LOGMNR.CONTINUOUS_MINE from the code.
    1. For this, you’ll need to specify the logfile explicitly. So I guess, some additional codding will be needed from your side…

I hope it helps!
Matheus.

GUORS: I Encontro de Usuários Oracle do RS 2020 (Online)

Olá pessoal,

Teremos evento dos GUORS no primeiro semestre, como de costume!

Porém desta vez será online!

Será no dia 21/5 (quinta-feira) as 20:00.
Onde? No conforto de sua casa!

Contaremos com a presença ilustre do Oracle ACE Marcus Vinicius falando sobre OCI for Oracle DBA’s: Introduction and Key Concepts.

Nessa sessão o nosso convidado falará sobre o OCI (Oracle Cloud Infrastructure), conceitos-chave e os desafios de um DBA Oracle na conversão de sua carreira para arquiteto Cloud a partir da perspectiva de quem vive esta experiência cotidianamente.

O Marcus Vinicius é DBA Oracle Sênior, Oracle ACE e possui diversas certificações em Bancos de Dados Oracle. Possui mais de 15 anos de experiência na área. Foi professor de pós-graduação no curso “MBA em Administração de Banco de Dados Oracle” no Veris IBTA, unidades de São Paulo e Campinas. Foi também DBA Oracle e Gerente de Operações na Discover Technology e Consultor Oracle Sênior na Oracle (ACS). Atualmente é Consultor Oracle Sênior na Accenture Enkitec Group. Também é conselheiro técnico do GUOB. Mantém um blog sobre Oracle há mais de 10 anos – https://www.viniciusdba.com.br/blog (não deixa de conhecer o Blog do Vini também!).

Não vai perder essa né?

Faça a sua inscrição AQUI!

Cloud computing