Category Archives: Data Guard

Oracle 19c New Features

Hello, friends!

Oracle 19c is now available for Oracle Cloud and Exadata.  It’s not yet available for “on-premises”, but it will no doubt be available shortly.  Well, hopefully.

19c is the terminal release of 12.2, which means that prior to Oracle’s versioning changes, it would have been referred to as 12.2.0.3.  As of the time of writing, it will be supported for the next 4 years under Premium Support and 3 years under Extended Support.

This is probably going to be the version that those waiting to pull the plug on upgrading to 12c are going to move to as 18c is still quite buggy (especially for versions < 18.1.5)

Bear in mind that there is no support for 19c on Linux 6.  The minimum versions of the O/S and kernels are as follows:

  • Oracle Linux 7.4 with the Unbreakable Enterprise Kernel 4: 4.1.12-112.16.7.el7uek.x86_64 or later
  • Oracle Linux 7.4 with the Unbreakable Enterprise Kernel 5: 4.14.35-1818.1.6.el7uek.x86_64 or later
  • Oracle Linux 7.4 with the Red Hat Compatible kernel: 3.10.0-693.5.2.0.1.el7.x86_64 or later
  • Red Hat Enterprise Linux 7.4: 3.10.0-693.5.2.0.1.el7.x86_64 or later
  • SuSE Linux Enterprise Server 12 SP3: 4.4.103-92.56-default or later

It’s been 17 years since I worked with an Oracle database running on SuSE, but there must be some hiding out there somewhere!

One thing to bear in mind, though, is that the upgrade to 19c on Exadata can be quite painful.  If you moved to 18c and found it to be nice and (relatively) easy, don’t be surprised if 19c is trickier.

As we try and contain our excitement, here are some of the features I think are going to be the most useful.

Continue reading

Tagged

My Collaborate IOUG 2015 Abstract

I will be presenting DBA 3.0 or “How to Become a Real-World Exadata DBA” at Collaborate 2015 – IOUG’s annual user conference – from April 12th to 16th at the Mandalay Bay Resort and Casino in Las Vegas. I submitted this as my abstract:

“DBA resources are more scarce than ever before and it can be very difficult to allocate time on anything but keeping the lights on – even when an organization has made a (substantial) hardware investment in Exadata.

However, if Exadata is treated like any other Oracle database, the promised “extreme performance” will likely be very underwhelming to developers, users and managers and can become unwieldy for DBAs to support.

On the other hand, when an organization configures and supports Exadata properly, they can realize exponential performance improvements in key IT infrastructure, can facilitate better business decisions and may actually reduce infrastructure costs.

The customer has bought a sports car – but might not realize that they haven’t taken it out of second gear (yet).

I will talk about the evolution of Exadata and then get into the “nuts and bolts” of how to support a high-performance Exadata environment as a Production DBA.

I will discuss how to get performance improvements of up to 20x, what NOT to do as an Exadata DBA and how Exadata can become the foundation of your organization’s high-performance enterprise infrastructure.”

I hope to see you in Las Vegas!

Tagged , , ,

Data Guard Licensing

BREAKING NEWS: Oracle does NOT charge you for an advanced feature which is crucial in providing disaster recovery and is a key part of their Maximum Availability Architecture.

Today, I found out that Oracle Data Guard is NOT a cost option in its own right (like RAC, partitioning, etc), but that the Enterprise Edition “includes” it.

There is no entry in the Price List for “Data Guard”.

I could have SWORN I’d seen it before – many times, in fact. I’ve been working with Data Guard or its predecessor for 10 years, so this came as a bit of a surprise.

But then again, so did the fact that Oracle DO charge for the 12c multi-tenancy option.

Tagged , , ,
%d bloggers like this: