Happy New Year 2018!

Dear all, there was silence on the blog for more than 2 weeks now. And 2018 started already. Let me wish you all a happy and exciting new year 2018. Stay safe and healthy, take care and all the best for 2018 to you, your families and friends! There will be more updates in the next few days 🙂 Happy New Year! Mike

Can you simply switch from SE2 to EE with Oracle Multitenant

This question is coming up from time to time – and currently not covered in the official Oracle documentation as far as I know: “Can you simply switch from SE2 to EE with Oracle Multitenant?” Yes, you can! First of all, the switch is possible and tested. But you’ll have to satisfy a few requirements: Both database versions must be the same Both databases must have the same character set (in Oracle Database 12.1) That’s it. Simply unplug your Standard Edition 2 PDB and plug it into your Enterprise Edition CDB. In addition you may have to run several component…

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…

PERL scripts for large migrations supported on all platforms (except Windows)

This topic fits very well as I present about +100 TB migrations today at the “Harmony” User Group Conference in Finland. The question whether the PERL scripts for RMAN incrementally rolled forward backups we deliver via MOS Note 1389592.1 (11G – Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup) will be supported for migrations to non-Exadata systems such as Oracle SuperCluster as well. And yes, now we got an update into the note saying: Although preferred destination system is Linux (either 64-bit Oracle Linux or a certified version of RedHat Linux), this procedure can be used with other Unix…