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

45 thoughts on “Oracle Database 12.1.0.2 is available!!!

  1. Hi Mike,

    this is really great news!
    Do you have any idea when we can expect the Windows version? Are we talking about days or months?

  2. Thanks 🙂

    Tough question – please understand that I can’t give you any schedules 🙁 But it is right now in the hot phase …

    Sorry 😉
    Mike

  3. +1 for a Windows release. It’s a real shame that Windows Server 2012 R2 is still not supported over 10 months after its release. It’s delaying at least one major project and lost out to SQL Server on some recent work that we have undertaken.

  4. Erwin,

    great story – and if the article is:
    "according to analysis by EMC’s Kevin Closson"
    Oracle’s former Exadata champ it must be true, right?

    Well, I don’t comment on Kevin’s postings (some are excellent, others …) but in fact the feature is linked into the kernel (correct) but has not on. You’ll have to set inmemory_size to a different value than the default. If you’d never touch it inmemory_size=0 and therefore the feature is not enabled.

    Cheers, Mike

  5. Thanks for all your hints to the news about the DBA_FEATURE_USAGE_STATISTICS doing a false report on In-Memory-Usage when you’d alter a table with the inmemory attribute.

    I’d leave this to Maria, our PM. And I appologize but I can’t speak for LMS.

    Thanks
    Mike

  6. Please be patient – of course I can’t give you a date as this is not in our hands but it may be there in less than 1 month (no guarantee of course!)

    -Mike

  7. Hi Mike,

    time is running … "less than 1 month" does only have 3 more days!!! 🙂

    It would be interesting to know why Windows is so neglected in terms of Oracle Database. Is it so much worse than a linux installation? If so, in which ways? Performance?

    … Desperately waiting to test 12.1.0.2 on Windows.

    Ben

  8. As I’ve said: No guarantee 😉 Please just be patient for another 2 weeks … (no guarantee!!).

    Simply reason:
    Oracle on Win is so different from any other platform. Service concept, threads, mem model etc. As we develop on Linux x86-64bit the porting to Intel Solaris and SPARC is done asap to release the 3 Oracle-owned OS ports at the same time. We know that we have a HUGE customer base on Windows – but due to the above reasons usually the porting on Win takes a bit – and of course we’ll have to do the entire massive regression testing on Windows as well again. Advantage: usually Oracle on Win drop has some fixes already included which were not in the initial drop for Linux.

    Please be patient – Win is very important as an OS port to Oracle, believe me.

    Cheers
    Mike

  9. Mike,
    When is 12.1.0.2 likely to get to IBM Linux on z? All our databases are on this platform and I would prefer to upgrade to this directly rather than going via 12.1.0.1.
    Thanks,
    Gareth

  10. Dear Mike,

    I can see 12.1.0.2 is now available for Microsoft Windows x64 ..!!! I don’t know why still Doc ID 742060.1 is not updated..

    Regards,
    Chirag

  11. Sorry Chirag,

    but this is not in our hands. Maybe Support people will update it after OOW.

    Thanks for the hint – I have updated the above blog post with the liks to Win as well!

    Mike

  12. Dear Mike,
    Thanks..

    I have seen that, even Certifications Matrix is also not updated in Oracle Support. As this movement i’m not sure which Windows OS (2008, 2008 R2, 2012) is supported with 12.1.0.2 ? 🙂

  13. Dear Mike,
    Thanks..

    I have seen that, even Certifications Matrix is also not updated in Oracle Support. So at this movement i’m not sure which Windows OS (2008, 2008 R2, 2012) is supported with 12.1.0.2 ? 🙂

  14. Thanks for the info Mike. Is there a doc that shows the upgrade path/steps for upgrading existing 12.1.0.1 to 12.1.0.2 for production environments?

  15. Woody,

    the doc would be the same as we use for the regular 12c upgrade (if you are asking regarding the database only).

    For the software home it will be a fresh install into a new Oracle Home. Afterwards you can clean up the old home with the OUI’s "detach" option.

    Regarding the database upgrade please grab our slide deck from the right side (Slides Download Center) called "Upgrade, Migrate and Conslidate to 12c" and check the CASE 1 (with the Iron Man picture) in the Upgrade/Migration Cases section of the deck. This will apply to a 12.1.0.2 upgrade, regardless if you are coming from 12.1.0.1 or from 11.2.0.x etc.

    Hope this helps – cheers
    Mike

  16. Hi Mike.
    Sorry for asking this. I know you have answered the same question earlier, but that’s been a while ago.
    Our Java application is running against the Oracle database, but most of our installations are based on Standard or Standard Edition One.
    Several customers are asking if they can install 12.1.0.2 (of course enterprise edition), but we are not spending time testing this when it is not available in SE and SE/One, as this is the major customer base install.
    So why won’t Oracle release any news on this topic? 12.1.0.2 was released in July (Linux) and September (Windows). This is highly unusual in my opinion – and very frustrating.

    br,
    Morten (based in Denmark)

  17. Morten,

    thanks for your comment. I fully see your point, I know it is frustrating – and I don’t know any further details about 12.1.0.2 SE/SEone. As soon as we get to know anything be sure that we’ll publish it as we want you to upgrade as soon as possible.

    Sorry for any inconvenience!

    Kind regards
    Mike

  18. To piggyback on Morten’s comment, something very scary is going on – according to MOS note 742060.1, 12.1.0.1 will no longer be patched after July 26th of THIS year! That means when 12.1.0.2 does come out for SE, we’ll have less than 5 months to get all systems upgraded to 12.1.0.2 or else risk not getting patches anymore (including, I assume, the October security patch that will follow).

    Can you please ask internally whether that patch date will be extended because of this delay? I would also love to hear what the hold up is and/or an expected release date – I’m having to make planning decisions for clients without any idea when 12.1.0.2 for SE will be out. Thanks so much!

  19. Tom,

    I fully see your point. But in fact I can’t do anything here. May I ask you please use the two important communication channels to Oracle, (a) your Oracle sales rep and (b) SRs logged via MyOracle Support?

    Of course I will post news about SE 12.1.0.2 as soon as I have them.

    Thanks and kind regards
    Mike

  20. Hi Mike,

    Do we have 12.1.0.2.0 released only for Enterprise Edition. Any near date for release of 12.1.0.2.0 for Standard edition.

    Thanks in Advance
    Ruchi.

  21. The only thing I can say about SE is written into this MOS Note:1905806.1 – I appologize but you’ll have to get in touch with your Oracle contacts. At the moment I don’t have any other information. There will be an SE but I don’t know when it will be released. As soon as I have more information I will post it here on the blog.

    Thanks
    Mike

  22. Sorry but you may please check with the support portal support.oracle.com – check for certifications. In addition a service request may tell you the details.

    Cheers
    Mike

  23. I’d say as long as you leave COMPATIBLE="12.1.0" there should be no issues (you could set in addition optimizer_features_enable=12.1.0.1 but this is not a 100% solution as you’ already use 12.1.0.2 optimizer code but run with the old parameters".

    But finally it’s not Oracle’s decision as we didn’t certify the 3rd party software.

    Cheers
    Mike

  24. Derek,

    are you sure? Oracle Database 12.2.0.1 is supposed to get released within 12 months from OOW 2015 (i.e. sometime between Oct 2015 and Oct 2016).

    You can be 100% super-sure that I will post a message once 12.2 is ready to fly. Currently we are in beta state.

    Cheers
    Mike

  25. The application we are upgrading to only says "support Oracle 12.1.0.1", and it does not say it supports 12.1.0.2 (most likely it was developed and tested before 12.1.0.2 was out).
    What is the risk if I just go to 12.1.0.2 instead of 12.1.0.1 at this case?

    Thank you,
    Erin

  26. When Oracle Database 12c Release 2 was released, Was it patched with all the know patches at that time? Like CVE-2012-3137.

    Thanks,

    Tim

  27. It’s hard to say what the actual risk is.
    From the API direction you can leave COMPATIBLE=12.1.0.1 making sure no 12.1.0.2 features are visible. In addition you may switch OPTIMIZER_FEATURES_ENABLED=12.1.0.1 as well.
    Then you should be pretty safe. But I’d still do a bit of performance testing first.

    Cheers
    Mike

Leave a Reply

Your email address will not be published. Required fields are marked *