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:
-
(12.1.0.2.0) – Enterprise Edition
Microsoft Windows x64 (64-bit)File 1, File 2 (2.5 GB) See All Linux x86-64File 1, File 2 (2.5 GB) See All Oracle Solaris (SPARC systems, 64-bit)File 1, File 2 (2.6 GB) See All Oracle Solaris (x86 systems, 64-bit)File 1, File 2 (2.3 GB) See All HP-UX ItaniumFile 1, File 2 (3.1 GB) See All AIX (PPC64)File 1, File 2 (2.7 GB) See All zLinux64File 1, File 2 (2.3 GB) See All (12.1.0.2.0) – Standard Edition (SE2)
Microsoft Windows x64 (64-bit)File 1, File 2 (2.6 GB) Linux x86-64File 1, File 2 (2.5 GB) Oracle Solaris (SPARC systems, 64-bit)File 1, File 2 (2.7 GB) Oracle Solaris (x86 systems, 64-bit)File 1, File 2 (2.5 GB) HP-UX ItaniumFile 1, File 2 (3.3 GB) AIX (PPC64)File 1, File 2 (2.9 GB) zLinux64File 1, File 2 (2.5 GB) - Documentation for Oracle Database 12.1.0.2
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
Any word on when the Windows version will be released?
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?
Thanks 🙂
Tough question – please understand that I can’t give you any schedules 🙁 But it is right now in the hot phase …
Sorry 😉
Mike
+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.
You should expect announcements about Server 2012 R2 in the near future 🙂
Mike
What about this story?
http://www.infoworld.com/t/software-licensing/oracles-new-database-patch-could-cost-you-23000-processor-247035?source=footer
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
Erwin,
in regards to your post Maria Colgan asked me to point you and others to her blog explaining the facts:
https://blogs.oracle.com/In-Memory/entry/getting_started_with_oracle_database
So as I said, In-Mem is not enabled by default.
Thanks, Mike
An interesting observation:
http://www.theregister.co.uk/2014/07/31/oracle_in_memory_bug_fix/
It would be very interesting to know how this would be treated in an Oracle software audit. Any comments from the LMS scripting guys?
Software usage audits can get rather interesting with this rather expensive new feature:
http://www.theregister.co.uk/2014/07/31/oracle_in_memory_bug_fix/
Any comments from the LMS script guys?
Just an update on the In-Memory Column Store feature enablement. Check this out – http://www.theregister.co.uk/2014/07/31/oracle_in_memory_bug_fix/
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
Hi Mike
Any update on the Windows release?
Cheers
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
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
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
Thank You Mike for the explanation!
Appreciate it.
Mike, are there any news on path for the SE and SE1 editions?
Sorry but everything I can say is written into the above note: MOS Note:1905806.1
Cheers
Mike
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
As you may know I couldn’t give you a date or so. But it shouldn’t be that far away anymore.
Cheers
Mike
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
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
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 ? 🙂
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 ? 🙂
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?
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
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)
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
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!
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
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.
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
Does citrix 4.5 support oracle 12c?
Want to migrate from 10 to 12c? Possible?
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
What is Oracle’s position on using 12.1.0.2 for an application that only certifies 12.1.0.1 version so far?
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
Hi Mike,
Oracle Database 12c Release 2 has been released. When will this be available for download?
Thanks,
Derek
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
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
Let me know this software is available for AIX platform
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
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
Sure it is – but I never updated the blog post 😉
Did it now – you’ll find it here:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
Cheers
Mike
@Tim:
Oracle Database 12.2 has not been released yet so I can’t comment unfortunately.
Cheers
Mike