Tuesday Jul 29, 2014

Today the Upgrade Blog has its Fifth Anniversary :-)

Not sure if 5 is a lucky number :-)

But in fact today the Upgrade Blog "Upgrade Your Database Now!" has its fifth anniversary.

Well, there's not an update every day - and there are spans of silence for weeks when I'm either too busy (traveling most likely, writing etc) or when I feel there's not much important to say.  

So it's time to say THANK YOU to all our visitors and readers. I can't say exactly how many people have visited the blog so far as I have put up the Flag Counter only less than 3 years ago. And it does not count people logged into the Oracle network as our IT folks have blacklisted the Flag Counter for whatever reason (opened tickets never get a response). Guessing that we've had over 500,000 hits within the past 5 years. And almost 40,000 downloads of our "Upgrade, Migrate and Consolidate to Oracle 12c" deck. That it impressive. And the new version with new layout, new content and some corrections and enhancements will follow soon. 

So thanks to all of you for stoping by, coming back, commenting, sending mails, discussing and downloading our stuff - and we'll do our best to keep you updated on Database Upgrades and Migrations in the future, and serve you well with useful tech slide decks :-)

-Mike

Thursday Jul 24, 2014

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.

I'm probably not the only person who would love to see if we'd remove this "first" and "second" release tags. This has become obsolete with Oracle 11.1. We were telling customers officially that this is the brand new fantastic Oracle Database 11g release. But in fact it was - from the coding perspective - more or less a very stable 10g. In my workshops I did call it Oracle 10.3 with a marketing sticker on it. And as far as I can see the customer's I've had helped with going live on Oracle Database 11.1.0.7 were quite happy. Some really large shops still work with this release today with hundreds of databases in production.

But honestly most of the changes got introduced with Oracle Database 11.2. And not for a small number of customers this meant waiting for the first patch set (which since then has become a full release). Plenty of people went live with Oracle Database 11.2.0.2. But a lot of the remarkable changes got introduced not in Oracle 11.1 but in Oracle 11.2. Just remember things such as the move from Clusterware to Grid Infrastructure. But also minor things such as DEFERRED_SEGMENT_CREATION and plenty of optimizer news.

Now with Oracle Database 12c and the first patch set (full release) 12.1.0.2 I have heard this again - and I see it on the mailing list as well once a week:

"When will Oracle 12.2 be available?"

Well, that's the misconception. It's true, Oracle Database 12.1.0.2 has new features and extensions. But it has also many fixes over the already very stable Oracle 12.1.0.1. Why should anybody wait for Oracle 12.2 now? Because it's supposed to be THE SECOND release? Forget this - this is thinking from the old days.
We are in year 2014 now.

And then spend a minute to look closer to the Support Policy.

  • Oracle Database 11.2 will go out of Premier Support in 6 months. Yes!!! 6 months
  • And correct, we'll give everybody on Oracle 11.2.0.4 one full year of Extended Support for free
  • For Oracle 11.2.0.3 Extended Support will end 28-AUG-2015

That means if you plan to stay on Oracle 11.2.0.3/4 for a longer period you'll either have to calculate 20% extra of your support fee for the 2nd year of Extended Support. Or you prefer to "hope".

I can't tell you when Oracle 12.2 will be available - and I don't care. Usually people wait for the first patch set anyways which gets releases based on experience from the past 3 databases releases roughly a year and a bit after the initial release. Just do the math and you'll see where you end up with this strategy.

My recommendations are:

  • Stop thinking about THE SECOND release
  • Evaluate Oracle Database 12.1.0.2 now - not tomorrow
  • Look at the Support Policy - you need to start your upgrades as soon as possible
-Mike 

 

 

Tuesday Jul 22, 2014

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 further details.

And it contains a bunch of new things and improvements:

  • Oracle Database In-Memory
  • Oracle Big Data SQL
  • Oracle JSON Document Store
  • Oracle REST Data Services
  • Improvements to Oracle Multitenant
  • Advanced Index Compression
  • Zone Maps
  • Approximate Count Distinct
  • Attribute Clustering
  • Full Database Caching
  • Rapid Home Provisioning
Availability is for the following platforms right now:

Time to upgrade!!! 

-Mike

PS: Kudos to Morohashi-san for alerting me about the link to the internal MOS - exchanged the link address!
PPS: Updated entry on Sept 30 with links for MS Windows

Monday Jul 14, 2014

Deutschland ist Weltmeister!!!

No tech stuff this morning :-)

I'm still so exited. It was a true thriller yesterday with 127 minutes of suspense, fights and even blood - and chances on both sides. But overall I think Germany was the better team not only yesterday but throughout the entire tournament. Last time when Germany became Weltmeister (World Champion) in Italy in 1990 I was in Turkey on after-school-vacation celebrating a win over ... well, Argentina :-)

And this time I watched the match again with friends in an Italian restaurant in Munich - and the best team of the World Cup 2014 won over ... well, Argentina again :-) I'm still so exited :-)

And obrigado also to all the wonderful people in Brazil. In previous world cups often matches such as Honduras vs Switzerland had just a small crowd of people in the stadium. This time it seemed like a huge party :-) Obrigado, Brazil!

-Mike 

Monday Jul 07, 2014

Remote Cloning of Pluggable Databases
in Oracle Database 12.1.0.1

Cloning of Pluggable Database in Oracle Multitenant is a great feature and very useful. It had just a tiny flaw in Oracle Database 12.1.0.1: Remote cloning from one to another CDB fails

This will work flawless beginning with the first patch set Oracle 12.1.0.2 - but if you want to use that feature still in Oracle 12.1.0.1 you need to apply at least PSU3 or a single patch 18898403.

See the documentation

-Mike 

Back on Track :-)

No updates for almost 3 weeks? Well ... sometimes I need a bit of vacation as well ... and for sure I didn't board an airplane. Thanks for staying tuned and you'll see the next update within a few hours :-)

 -Mike

About

Mike Dietrich - Oracle Mike Dietrich
Master Product Manager - Database Upgrade & Migrations - Oracle Corp

Based near Munich/Germany and spending plenty of time in airplanes to run either upgrade workshops or work onsite or remotely with reference customers. Acting as interlink between customers/partners and the Upgrade Development.

Follow me on TWITTER

Contact me via LinkedIn or XING

Search

Archives
« July 2014 »
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
8
9
10
11
12
13
15
16
17
18
19
20
21
23
25
26
27
28
30
31
  
       
Today
Oracle related Tech Blogs
Slides Download Center
Visitors since 17-OCT-2011
White Paper and Docs
Workshops
Viewlets and Videos
Workshop Map
This week on my Rega & Pono
Upgrade Reference Papers