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!

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

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!

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!

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

BGOUG Spring Conference 2019: Review!

Hi all,
This year I had the pleasure to be in BGOUG Spring Conference 2019 in Borovets (Bulgaria, of course) as a speaker. We had great sessions and speakers in a way I almost felt stupid to be there speaker while I could be watching other sessions… LOL

From those, my top 5:
– Oracle Hacking Session 2 – by Kamil Stawiarski
– How To Do Performance Tuning – Martin Widlake
– Test Drive Automatic Index Creation in Oracle Autonomous Database – Maria Colgan
– Deep Dive into the Implementation of Oracle’s Join Methods: Past, Present and Future – Shasank Chavan
– How to Diagnose Oracle Database Upgrade Issues – Roy Swonger

Some links:
Agenda
Sessions and Speakers
My Slides

It was 2 days of sessions on several topics of Oracle stack from people all over the globe. In between, some good timing coffees all day long allowing some great networking time as well. All very organized, well communicated and well timed.

Thank you Bulgaria for receiving me so well and the organization for such a great time and for the opportunity to be among those names.

BGOUG

See you soon!

Roundtable: How are Databases Adapting to New Cloud Architectures?

Hi all!
Stay sharp, it’s confirmed event for next 27th evening Brazilian Time. If you around Três de Maio, hope you can make it in person!
Otherwise, we are looking forward to record and share session, still evaluating streaming options and requirements.

Note Grepora is sponsoring this roundtable, so count with you all!
Oh, it will be fully in portuguese. Hope you don’t mind. 🙂

Event: Round Table: “How are Databases Adapting to New Cloud Architectures”
Date: 27/6/2019 19:30 BRT (18:30 EST) to 21:00 (20:00 EST)
Estimated Duration: 1:30 hours

We count with great names, see below:

MesaRedonda.jpeg

See you there, cheers!

How to Prevent Violate Active Dataguard License?

Hey folks,
As you all liked last week posts about preventing to violate Oracle Licensing, so let’s go another one, a quick one this time: Active Dataguard.

Matheus, is there a way to prevent using the Active Dataguard Option?

Well, there is. If you consider that this is basically a regular Dataguard that is opened in Read Only mode, here you go:

srvctl modify database -d GREPORADB_STBY -s MOUNT

By preventing the database open, we are preventing it to violate the Active Dataguard feature.

Quick reference on this:
– Which are Supported Methods to Prevent Active Data Guard Usage When License is Not Available? (Doc ID 2269239.1)

Hope it helps!

How to Disable AWR and Prevent Violating Diagnostic Tuning Pack License

Hey folks,
Seems you like it, so on same line that the post from last week: Let’s say you want to prevent yourself to violate Oracle licensing of your Enterprise Edition database… But as you know, Oracle is tricky sometimes. For example, all Diagnostic Pack features are enabled by default, you just need a JR DBA to go there and used for you to be stuck.

By the way, here is the first mistake: No, AWR is not part of Enterprise Edition, it also requires Diagnostic Pack!

Ok Matheus, so how to prevent it? Here it goes:

Disable AWR with Oracle provided script

Use the script dbmsnoawr.plb provided in MOS Doc ID 1909073.1 to disable AWR once the database has been created.

To install, run the package as SYS from SQL*Plus:
SQL> @dbmsnoawr.plb

To execute the package, use the command:
SQL> begin dbms_awr.disable_awr(); end;

Modify the CONTROL_MANAGEMENT_PACK_ACCESS init parameter to NONE and disable the AWR related advisors.

Disable AWR Related Options

ALTER SYSTEM SET control_management_pack_access=NONE;

SQL> select client_name, operation_name, status from dba_autotask_operation;

CLIENT_NAME                                                      OPERATION_NAME                                                   STATUS 
---------------------------------------------------------------- ---------------------------------------------------------------- --------
auto optimizer stats collection                                  auto optimizer stats job                                         ENABLED
auto space advisor                                               auto space advisor job                                           ENABLED
sql tuning advisor                                               automatic sql tuning task                                        ENABLED


BEGIN
  dbms_auto_task_admin.disable(
    client_name => 'sql tuning advisor',
    operation   => NULL,
    window_name => NULL);

  dbms_auto_task_admin.disable(
    client_name => 'auto space advisor',
    operation   => NULL,
    window_name => NULL);

END;
/

SQL> select client_name, operation_name, status from dba_autotask_operation;

CLIENT_NAME                                                      OPERATION_NAME                                                   STATUS 
---------------------------------------------------------------- ---------------------------------------------------------------- --------
auto optimizer stats collection                                  auto optimizer stats job                                         ENABLED
auto space advisor                                               auto space advisor job                                           DISABLED
sql tuning advisor                                               automatic sql tuning task                                        DISABLED

Some reference on it?
– How To Avoid the AWR Usage Without Having Diagnostic Pack License (Doc ID 2276199.1)
– Controlling Diagnostic and Tuning Pack Usage (Doc ID 436386.1)
– Disabling and Uninstalling AWR (Doc ID 1909073.1)

Hope it helps!