Archived Database Upgrade Blog
Oracle Database 12c
In case you miss the downloads of Oracle Database 12.1.0.2 on OTN
Somebody asked me the other day why the download options for Oracle Database 12.1.0.2 for Linux and Solaris disappeared from OTN? The same will happen with the other platforms as soon as Oracle Database 12.2.0.1 is available on-premises for them as well. You can always download Oracle Database 12.1.0.2 and previous releases from: Oracle Software Cloud (eDelivery) . --Mike
Thursday, March 9, 2017 | Oracle Database 12c | Read More
February 2017 version of PREUPGRD.SQL is available
The new version of the preupgrd.sql (including the utluppkg.sql package) in its February 2017 version is available for download from MOS Note:884522.1. If you are going to upgrade to Oracle Database 12.1.0.2 please exchange your current preupgrd.sql/utluppkg.sql either in ?/rdbms/admin or in the location of the source system you've copied it to with the new version. . --Mike .
Friday, February 3, 2017 | Oracle Database 12c | Read More
New SPFILE parameters in Oracle Database 12.1.0.2 with July 2016 (and newer) PSU/BP
New Parameters in Oracle Database 12.1.0.2 with July 2016 PSU/BP By following an internal discussion and checking parameter changes between Patch Set Updates (PSU) and Proactive Bundle Patches (BP) I learned that we introduced two new SPFILE parameters in Oracle Database 12.1.0.2 with the July PSU and BP. One is documented in the patch readme, the other one can be found right now only in the Oracle Database 12.2.0.1 manual: ALLOW_GROUP_ACCESS_TO_SGA ENCRYPT_NEW_TABLESPACES .The...
Wednesday, February 1, 2017 | Oracle Database 12c | Read More
Enabling ADAPTIVE Features of Oracle 12.2 in 12.1
Oracle Database 12.2 introduces the new split-up adaptive parameters, OPTIMIZER_ADAPTIVE_PLANS and OPTIMITER_ADAPTIVE_STATISTICS. For more information please see: https://blogs.oracle.com/UPGRADE/entry/optimizer_adaptive_features_obsolete_in https://blogs.oracle.com/optimizer/entry/optimizer_adaptive_features_in_the But Oracle Database 12.2 on-premises is not out yet - so what should you do when upgrading to Oracle Database 12.1 - or struggling with some of the "adaptive"...
Wednesday, November 23, 2016 | Oracle Database 12c | Read More
Upgrade to Oracle Database 12c: We don't insist :-)
It's so funny - for years I discuss with customers minimal downtime upgrade strategies back and forth, up and down. I saw DBAs really hunting to save a few seconds potential downtime - and I always take this serious as there is usually a real reason behind that. Just to learn a few days later by repeating experience that my work Windows7 laptop goes down to apply upgrades ... and this takes looooooooong .... sometimes it takes a lengthy +30 minutes of quiet time. Whereas my...
Friday, April 29, 2016 | Oracle Database 12c | Read More
Parameter Recommendations for Oracle Database 12c - Part II
Parameter Recommendations for Oracle Database 12c - Part I ==> Parameter Recommendations for Oracle Database 12c - Part II Time for a new round on Parameter Recommendations for Oracle Database 12.1.0.2. The focus of this blog post settles on very well known parameters with interesting behavior. This can be a behavior change or simply something we'd like to point out. And even if you still work on Oracle Database 11g some of the below recommendations may apply to your...