Oracle Database 12c

Oracle Database 12.1.0.2 EE for HP, AIX and zLinux available

Last week the remaining ports for Oracle Database 12c 12.1.0.2 became available at the usual sources:

Continue reading...

ORA-20000 Unable to gather statistics concurrently: Resource Manager is not enabled
ORA-06512: at “SYS.DBMS_STATS”

We are running a great training this week in Munich, called TECH CHALLENGE for Oracle people only. And one group hit the below issue so I thought I should share this as it is very likely it will happen with the upgrade to Oracle Database 12c in your environment as well.

During the run of catctl.pl or DBUA you may get an error saying:

ORA-20000: Unable to gather statistics concurrently:
Resource Manager is not
enabled.

ORA-06512: at “SYS.DBMS_STATS”

Even worse, the upgrade will fail and exit in phase 68 of the parallel upgrade.
This issue is new with Oracle Database …

Continue reading...

New AQ Background Architecture in Oracle 12c

Advanced Queing

I know a some really high profile customers making heavy use of Oracle Advanced Queuing. Now in Oracle Database 12c there’s a change in the background architecture of AQ. The doc describes it more clearly than I ever could:

As far as I can see there shouldn’t be any backwards compatibility issues. But (as always) I’d be happy to hear, read and learn about your experiences 🙂

And see a list of changes, additions, enhancements and new features of AQ here:

Continue reading...

Grid Infrastructure Management Repository (GIMR) database now mandatory in Oracle GI 12.1.0.2

During the installation of Oracle Grid Infrastructure 12.1.0.1 you’ve had the an option to choose YES/NO to install the Grid Infrastructure Management Repository (GIMR) database MGMTDB – but as of Oracle 12.1.0.2 Grid Infrastructure Management Repository (GIMR) database now mandatory in Oracle GI 12.1.0.2:

Grid Infrastructure Management Repository (GIMR) database now mandatory in Oracle GI 12.1.0.2

GIMR database now mandatory in Oracle GI 12.1.0.2

With Oracle Grid Infrastructure 12.1.0.2 this choice has become obsolete and the above screen does not appear anymore. The GIMR database has become mandatory.

What do we stored in the GIMR?

In addition please see the

Continue reading...

New (some undocumented) Parameters in Oracle 12.1.0.2

Every release offers some surprises – even to myself 😉

Right now Roy and I are in the final steps to refresh our big slide deck to the new layout, but more important, to have Oracle 12.1.0.2 information included as well (were necessary). So I did my usual “compare parameters” query between releases – getting unusual surprises this time.

This is the list of new parameters introduced with the patch set Oracle Database 12.1.0.2. Where applicable I have added the link to the doc.

But as you may recognize not all of them are explained in the doc 😉

Continue reading...

Why “We’ll wait for the 2nd release!” is a misconception …

Oh, how often have I heard this phrase:

“We’ll wait for the second release!”

And sometimes it makes me really anxious and angry at the same time when I hear that.

Anxious because it means that somebody has no strategy for the database upgrades/migrations and is just postponing necessary tasks to sometime in the future. Easy deal but not very clever.

Angry because this is a way of thinking from the 90s/00s when Oracle had this “10.1”, then later “10.2” strategy in database releases. But we are in 2014 now. And things have changed. Changed a lot in fact.…

Continue reading...

Oracle Database 12.1.0.2 is available!!!

Oracle Database 12.1.0.2 is available for download now. It is the most comprehensive patch set we’ve ever built. Look up the list of inclusions – and it includes the new marquee feature OracleDatabase In-Memory.

Three things important to mention:

  • It is a full release – no need to get Oracle Database 12.1.0.1
  • Even though it is a patch set it will be available on OTN and eDelivery – and Oracle Database 12.1.0.1 will be removed instantly
  • For now it is an Enterprise Edition install only – SE and SE One may follow later.
    Please see MOS Note:1905806.1 for
Continue reading...

Oracle Database 12c for AIX, HP-UX IA and zLinux now available

It took a while … but finally Oracle Database 12c is available for:

Oracle Database 12c Release 1
Standard Edition, Standard Edition One, and Enterprise Edition

Continue reading...

Very cool videos about Upgrade to Oracle 12c

Sometimes it is by far easier to watch a few short videos instead of reading an entire book 🙂

So enjoy watching Roy talking about Upgrades and Migrations to Oracle Database 12c in short videos covering also the new Upgrade and Migration features in Oracle Database 12c.

A set of five short videos discussing new features and enhancements to database upgrades in Oracle Database 12c.

Continue reading...

Full Transportable Export/Import White Paper

One of the really cool and helpful features in Oracle Database 12c is called Full Transportable Export/Import. It combines the basics of transportable tablespaces – of course cross-platform, cross-endianess, cross-version – with Data Pump taking care on all the stuff not stored in tables and indexes, such as views, synonyms, trigger, packages etc. And you can even reduce downtime by combining the feature with incrementally converted RMAN backups.

And the best thing: this will work with an Oracle Database 11.2.0.3/4 to Oracle Database 12c – so you don’t have to be on Oracle Database 12c in order to …

Continue reading...

Oracle Database 12c is available on Windows!

Good things come to those who wait … and yes, Oracle Database 12c (Oracle 12.1.0.1) is available for download from  OTN/eDelivery for MS Windows as well since last night 🙂

Windows versions being supported: 2008, 2008 R2, 7, 8

Continue reading...

New White Paper about Upgrade to Oracle Database 12c

With the release of Oracle Database 12c many new collateral will be available right now including our new White Paper:

White Paper:
Upgrading to Oracle Database 12c

This white paper outlines the methods available for you to upgrade and migrate your database to Oracle Database 12c.  Learn about different use cases and key factors to consider when choosing the method that best fits your requirements.

And if you’d like to have a look into the new Oracle 12c documentation please find it here:

Oracle Database 12c Documentation

-Mike

Continue reading...

Oracle Database 12c is available for download now!

Good things come to those who wait … finally … Oracle Database 12c (Oracle 12.1.0.1) is available for download from the Oracle Software Cloud (formerly know as eDelivery) and OTN (Oracle Tech Network) for Linux 64bit (Solaris will follow within the next few hours):

.

And yes, it will be supported on Oracle …

Continue reading...

Long time no update …

I deeply apologize for not updating the blog for some weeks now. I’m still working for Oracle, still in the same group – but due to some other things going on in preparation for Oracle Database 12c I had either no time or simply nothing to report at the moment. I didn’t want to bore you with Oracle Database 11.2 stuff as the slides don’t get changed right now. Oracle Database 11.2.0.4 patchset should be available sometime in early summer with a good bunch of fixes included.

Roy and me had delivered the first internal only Upgrade, Migrate and Consolidate

Continue reading...