Oracle Database 18c: A new preupgrade.jar is available

In case you plan to upgrade a database to Oracle Database 18c: A new preupgrade.jar is available for download from MyOracle Support (MOS). Oracle Database 18c: A new preupgrade.jar is available Please download it – as always – from MOS Note:884522.1. The same MOS note will get you also the most recent versions of the preupgrade.jar for Oracle Database 12.2.0.1 upgrades. Of course you can download also all previous incarnations such as preupgrd.sql for 12.1.0.2 upgrades and even utlu112i.sql for 11g upgrades. What’s new in preupgrade.jar for Oracle 18c upgrades? There are a few important and good Improvements and new…

preupgrade.jar January 2018 (Build 11) is available now

A new version of the preupgrade.jar January 2018 (Build 11) is available now. Please download it from MOS Note:884522.1.: Please always download the most recent version as this one is much newer with a lot of improvements compared to the version you get with the default installation. Major changes since the first drop are: Added load only capabilities. Improved the interaction with OS Added more obsolete/deprecated parameters Improved IPC calls on Windows Added functionality for aud$unified table partitions. Added preupgrade and postupgrade automatic fixups Check for JAVAVM mitigation patch Added parameters checking when a dynamic parameter has been changed at…

Slides and Recap – DOAG 2017 and UKOUG 2017

Thanks for your patience. I have received a good amount of calls, emails and messages in the past weeks when the slides for DOAG and UKOUG will be available. And they are now including the “New Release and Patching Model” talk. Find slides and recap – DOAG 2017 and UKOUG 2017 here. Recap DOAG 2017 and UKOUG 2017 Wow – the year is almost over. Time flies. Time for a quick recap of the last two conferences I attended and spoke at in 2017: DOAG and UKOUG. DOAG 2017 DOAG (German Oracle User Group Conference) is always very special to…

Download Assistant for RUs, RURs, BPs, PSUs, Patch Sets and Releases

How often did I launch a search in MyOracle Support (MOS) for a specific Bundle Patch or Patch Set Update. And usually the MOS search results don’t get me what I’m looking for no matter how clever I search. But there was relief. A MOS Note combined all PSUs and BPs and much more into table format including the links. But what if there would be a Download Assistant for RUs, RURs, BPs, PSUs, Patch Sets and Releases? I did blog about the previous magic note a while back: Where is the Jan 2017 PSU for Oracle Database 11.2.0.4? But…

OOW 2017 – Slides Download: Migrate 100 TB databases in less than one day

I was shocked. Positively. We’ve had a packed room on Wednesday at Oracle Open World 2017 for our talk together with Jay Barnhart of Centric Consulting on How to Migrate 100 TB databases in less than one day. And we’ve had so much fun. Thanks for coming by, thanks for being so active. This makes all the travel and the stress really worth it. OOW 2017 – Slides Download: Migrate 100 TB databases in less than one day I gave a quick overview about all Transportable Tablespaces techniques, about how to use the PERL scripts to deal with very large…

OOW 2017 – Slides Download: Migrate to the Oracle Cloud

Thanks for coming to Roy’s and Julian Dontcheff‘s presentation about How to migrate to the Oracle Cloud – 13 different techniques and customer experiences on Tuesday at Oracle Open World 2017. The talk was very well attended, I saw many people taking pictures and notes. OOW 2017 – Slides Download: Migrate to the Oracle Cloud Personally I liked the talk a lot as it gives a very good (and very rare) complete overview on techniques how to migrate to the Oracle Cloud, advantages, use cases, database versions, where to use it. This all garnished with the experience Accenture has –…

OOW 2017 – Slides Download: Upgrade to Oracle 12.2 – Customer Cases

Thank you for coming by to our talk at Oracle Open World 2017: Upgrade to Oracle Database 12.2 – Customer Cases. It was a pleasure to have so many people attending. And I’m really proud about the support we’ve had by Alain Fuhrer and Paolo Kreth from Swiss Mobiliar Insurance and Daniel Overby Hansen from Danish SimCorp. As we promised, we did no marketing. Only real customers with real environments. All on Oracle Database 12.2.0.1 live and in production. Alain was with me on stage and he did a fantastic job showcasing Mobiliar’s project about upgrading over 300 databases to…

September 2017 releases of preupgrade.jar and preupgrd.sql are available

On a regular basis the Database Upgrade Team releases new and improved versions of the preupgrade tools via a MyOracle Support note. And it’s time again: the September 2017 releases of preupgrade.jar and preupgrd.sql are available for download. September 2017 releases of preupgrade.jar and preupgrd.sql are available Please ALWAYS download the most recent versions of preupgrade.jar for upgrades to Oracle Database 12.2 and preupgrd.sql (including utluppkg.sql) for Oracle Database 12.1.0.2 upgrade from MOS Note: 884522.1. The version you’ll download is way newer than the version you’ll get with the base installation. preupgrade.jar – Rel.7 – September 2017 Please find the…

OTN Tour South America 2017: Uruguay, Argentina and Brazil

Time flies – and the OTN Tour South America 2017: Uruguay, Argentina and Brazil is over for me. I’m back home. OTN Tour South America 2017: Uruguay, Argentina and Brazil But Id like to thank many people. It was an awesome tour again. I participated for the forth time. And I learned a lot again. From customers who discussed their upgrades and migrations with me. From the other presenters who did a terrific job. A very big Thank You to all the people who organized the events. I liked it a lot. And you deserve a lot of credits for…

New version of preupgrade.jar (build 5) is available

There’s a new and improved version of the preupgrade.jar (build 5 – May 2017) available for download from MyOracle Support: MOS Note:884522.1: How to Download and Run Oracle’s Database Pre-Upgrade Utility The same note will get you access also to the most recent builds of preupgrd.sql for upgrades to Oracle Database 12.1 and utlu112i.sql for the unlikely event you’ll have to upgrade a database to Oracle 11.2.0.4. Please always exchange the version getting installed by default with the version we offer via MOS Note:884522.1 as the downloadable version is usually much newer and improved over the one getting deployed with the…