Community, Events

CLOUG: Oracle Groundbreakers Tour Santiago 2019!

 , , , ,

¡Hola! ¿Cómo estas?

Como ya sabes, los Grupos de Usuarios de Latinoamérica con el apoyo de OTN y LAOUC organizan por décimo año consecutivo el evento más grande de tecnología Oracle en la región. Este se llamado Oracle Groundbreakers Tour, donde reconocidos expertos en tecnologías Oracle recorren el mundo llevando su conocimiento a todas las latitudes.

Este año el tour abarca 10 países, y en Santiago será el lunes 2 de Agosto en la UNIVERSIDAD SAN SEBASTIÁN (Av Belavista 7, Recoleta, Santiago).

El motivo del presente es para invitarte a este evento, donde tendré el placer y la oportunidad de hablar sobre la tecnología Oracle y, especialmente su tecnologia en la nube.

Además, habrá presentaciones para diversas áreas de interés: Bases de Datos, Cloud Computing, DevOps, Linux y BI, así como hands-on labs.

Puedes ver la agenda completa aquí.
También, aquí para detalles de las charlas.

Es necesario registrarse aquí. Tarifas de acuerdo a la fecha:

  • Early Bird (hasta el 30 de junio 2019): 10.000 CLP
  • Precio Preferencial (1 de Julio al 15 de Julio): 15.000 CLP
  • Precio Normal: (16 de Julio al 1 de agosto): 20.000 CLP
  • Precio Dia del Evento: (2 de agosto): 25.000 CLP

Subscribe here!

Te veo allá!

Community, Events

GUOB Tech Day 2019 – Last Coupon!

 , , , ,

Hello all!

Please be aware on last 10% off coupon being shared here !

TE_VEJO_NO_GUOB

WhatsApp Image 2019-07-23 at 07.01.07

What this is about?

GUOB – Brazilian Oracle Users Group Event!

This is part of Next Oracle Groundbreaker Tour Latin America, starting this weekend!

Where: São Paulo-SP/Brazil.

When:  August 10th, 2019

Speakers da Oracle confirmed on event (besides Matheus Boesing :D):

Directly from Oracle:

  • Mike Dietrich: Master Product Manager on Database Upgrade / Migration team.
  • Anil Nair: Product Manager de RAC.
  • Sandesh Rao: VP – Autonomous Database Health e Machine Learning.
  • Ricardo Gonzalez: Cloud Migration Product Manager.
  • Nirmala Sundarappa: Java/DB Product Manager.

Besides them some global references like: Franck Pachot, Gustavo Gonzalez, Rolando Carrasco.

Complete Agenda, here!

See you there!

Community, Events

10th GUOB Tech Day! – New Coupon!

 , , ,

Hey all,
Some of you asked for an new coupon, once the one from previous post expired on last 12th.

Here it goes!

WhatsApp Image 2019-07-16 at 11.16.49

 

Where: São Paulo-SP/Brazil.

When:  August 10th 2019

Speakers da Oracle confirmed on event:

Directly from Oracle:

  • Mike Dietrich: Master Product Manager on Database Upgrade / Migration team.
  • Anil Nair: Product Manager de RAC.
  • Sandesh Rao: VP – Autonomous Database Health e Machine Learning.
  • Ricardo Gonzalez: Cloud Migration Product Manager.
  • Nirmala Sundarappa: Java/DB Product Manager.

Besides them some global references like: Franck Pachot, Gustavo Gonzalez, Rolando Carrasco.

Complete Agenda, here!

Subscribe Now!

Community, Events

10th GUOB Tech Day!

 , ,

Hello all,

I’m very happy to share about and to be part of  the next GUOB Tech Day in São Paulo-SP/Brazil on next August 10th, as part of LAOUC OTN Tour.

GUOB_PROMO

Speakers da Oracle confirmed on event:

Directly from Oracle:

  • Mike Dietrich: Master Product Manager on Database Upgrade / Migration team.
  • Anil Nair: Product Manager de RAC.
  • Sandesh Rao: VP – Autonomous Database Health e Machine Learning.
  • Ricardo Gonzalez: Cloud Migration Product Manager.
  • Nirmala Sundarappa: Java/DB Product Manager.

Besides them some global references like: Franck Pachot, Gustavo Gonzalez, Rolando Carrasco.

Complete Agenda, here!

Subscribe Now!

 

Oh, know what? GREPORA Readers have a DISCOUNT COUPON:

Discount

Community, Events

Roundtable: How are Databases adapting to Cloud architectures? – THANKS!

 , , , ,

Hi all!
I just need to thank you all for the attendance on yesterday’s Round Table event!

We had over 130 individuals in presence plus dozens following the live on YourTube. It was great to have the discussions and also to count on your questions and support.

I need also to thanks for SETREM space and support, specially Franzéli Kaspari and Prof. Valsênio Gaelzer for all the efforts on making it happen. Also for both other members of round table Simone Kosmalski, Cristiano Goelzer and Jonas Pacheco who attended physically and participated on discussions.

I’d also specially want to thank Ricardo Gonzalez for attending remotely from over 10kkm our event. Thanks Ricardo!


Hope to join you guys soon again in a second round.

Cheers!

Community, Events

Roundtable on “How are Databases adapting to Cloud architectures?”

 , , ,

Hello all!
Tomorrow we are having a Roundtable on the topic  “How are Databases adapting to Cloud architectures?”
It’s being placed at SETREM in Três de Maio/RS-Brazil, June 27th (TOMORROW) at 19:30 BRT (6:30PM EST).

Good news? We’ll have a Live Stream for this one.
And it’s on the brand new GREPORA Youtube Channel! (more to come about it here on the blog soon).
NOTE: It will be all in portuguese, so be aware. 🙂

Wait you there!
Access on youtube to make questions!

Database

Value FROM v$option where parameter = ‘Unified Auditing’

 , ,

Hi all,
So, just a quick post to clarify once it cost me a few mins to explain this to a client and, indeed, Oracle could have made it easier.

So, facing the info below, doesn’t mean that you don’t have Unified Auditing enabled:

SELECT value FROM v$option WHERE parameter = 'Unified Auditing';
VALUE
-----------------
FALSE

It does mean you just don’t have PURE Unified auditing, but a MIXED configuration, where old fashioned Auditing is also accepted.

See, this way, the MIXED Auditing is by default it is enabled in 12c. The idea is that you use apart from traditional auditing all the features of unified auditing. Once we are comfortable with the unified concept, we can migrate exiting audit setup to unified policy , we can enable pure auditing. This serves as a good mediator for an easy and hassle free switch to the preferred Unified auditing.

HOWEVER, let’s agree that Oracle could have made the value column a little bit m ore meaningful, if this was the case. The actual values actually mean:

FALSE – > MIXED AUDTING
TRUE –> PURE AUDITING

OK, but what if I want to enable ONLY the PURE Auditing, disabling the ‘Classic’ Auditing and changing this value on v$option to TRUE? Well, then you need to relink library for your instance. Note, for RAC linking need to be done all the nodes.

Steps to Change to PURE Unified Auditing Only:

SELECT value FROM v$option WHERE parameter = 'Unified Auditing';
VALUE
-----------------
FALSE

sqlplus / as sysdba <<
shutdown immediate;
exit;

cd $ORACLE_HOME/rdbms/lib
 
make -f ins_rdbms.mk unaiaud_on ioracle
 
sqlplus / as sysdba<<
startup
 
SELECT value FROM v$option WHERE parameter = 'Unified Auditing';
VALUE
-----------------
TRUE

Reference: https://docs.oracle.com/database/121/DBSEG/auditing.htm#DBSEG824

Hope it helps, cheers!

Database

Preventing License Violation with CHOPT

 , , ,

Hi all,
So, in past weeks I’ve been publishing some material on how to prevent Licensing violations. Check below for my posts on last weeks:

Cool, but what about RAT, OLAP, Data Mining and Partitioning?

Well, we can use the chopt tool to disable the unlicensed options in the binaries. Check below:
Note: In a RAC with non shared Oracle homes, this has to be executed on every node.

For 12.1:

  1. Oracle Data Mining RDBMS Files (dm)
  2. Oracle OLAP (olap)
  3. Oracle Partitioning (partitioning)
  4. Oracle Real Application Testing (rat)

For 12.2:

  1. Oracle Advanced Analytics (oaa)
  2. Oracle OLAP (olap)
  3. Oracle Partitioning (partitioning)
  4. Oracle Real Application Testing (rat)

1. Shutdown all Oracle services running out of the Oracle RDBMS home (srvctl, SQL*Plus or lsnrctl as required)

srvctl stop home -oraclehome Oracle_home -statefile state_file

2 Disable the options as required

cd $ORACLE_HOME/bin
chopt disable dm # If Oracle version is 12.1
chopt disable oaa # If Oracle version is 12.2
chopt disable olap
chopt disable partitioning
chopt disable rat

3. Startup all Oracle services running out of the Oracle RDBMS home using either

srvctl, SQL*Plus or lsnrctl as required
srvctl start home -oraclehome Oracle_home -statefile state_file


EXTRA) It’s even easier for a 18c databases. The execution takes only a few seconds to complete.

[oracle@greporasrv ~]$ chopt disable oaa dm # If Oracle version is 18c

Writing to /opt/oracle/product/18c/dbhome_1/install/disable_oaa_2019-05-13_34-18-06PM.log...
/usr/bin/make -f /u01/oracle/product/18c/dbhome_1/rdbms/lib/ins_rdbms.mk dm_off ORACLE_HOME=/u01/oracle/product/18c/dbhome_1
/usr/bin/make -f /u01/oracle/product/18c/dbhome_1/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/u01/oracle/product/18c/dbhome_1