Oracle ORAchk and EXAchk Version 18.3.0 are released

If you are a regular user of ORAchk and/or EXAchk, you should download the most recent and newest version as Oracle ORAchk and EXAchk Version 18.3.0 are released now. Oracle ORAchk and EXAchk Version 18.3.0 are released The new features you’ll find in ORAchk 18.3.0 and EXAchk 18.3.0 include: Beta Support for Oracle Private Cloud Appliance In EXAchk Health Check Catalog under the Engineered systems of Private Cloud Appliance and Private Cloud Appliance Plane. Automatic start from TFA install Oracle Trace File Analyzer root installations on Linux or Solaris on non-engineered systems will automatically setup and run the ORAchk daemon.The…

Oracle Database 18.3.0 on SPARC Solaris is available

Usually I don’t post twice on a day, especially not on a Friday and not in the holiday season. But since last night, Aug 2, Oracle Database 18.3.0 on SPARC Solaris is available for download from OTN. Oracle Database 18.3.0 on SPARC Solaris is available You can download it from OTN: https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html And I couldn’t find it on eDelivery – where I find only the 18.1.0 version. But I simply may be not clever enough to use the right search phrase (I used “Oracle Database” as “18” leads to something different). Further Information Oracle Database 18.3.0 on premises is available…

Oracle Database 18.3.0 on premises available for download on Linux

Finally … it took a bit longer than expected and many people have mailed me in the past days. But Oracle Database 18.3.0 on premises available for download on Linux. Oracle Database 18.3.0 on premises available for download on Linux The other ports may follow soon after. I can’t give dates but you can download Oracle Database 18.3.0 on-prem for Linux now from OTN: Follow this link to access the download location: Oracle Database 18c 18.3.0 for Linux The download gets you the zip file but not the rpm. Those may take a couple of weeks for unknown reasons. And…

Upgrade Hands-On Lab – Oracle Database 12.2.0.1 – May 2018

Roy just uploaded a newer version of our Upgrade Hands-On Lab – Oracle Database 12.2.0.1 – May 2018. The previous version had – I believe – and early drop of Oracle 12.2.0.1 installed. And recently somebody complained that certain Multitenant operations such as Hot Cloning with Oracle Database 12.2.0.1 don’t work but result in errors. Therefore, we updated it. Upgrade Hands-On Lab – Oracle Database 12.2.0.1 – May 2018 The size requirements unfortunately are still the same. Your machine should have 8GB of RAM and you will need a bit more than 60GB free space on disk. You “could” run…

Why should you use the most recent version of OPatch?

Opatch. A tool nobody really loves but everybody has to use (at least those of you who patch or aren’t in our cloud deployment). Opatch gets distributed via MOS. And you often can apply patches with an older version of OPatch. So why should you use the most recent version of OPatch? Why should you use the most recent version of OPatch? First of all, you have a base installation of Opatch in your $ORACLE_HOMEs: [CDB2] oracle@localhost:/u01/app/oracle/product/12.2.0.1 $ ls OPatch auto jlib opatchauto.cmd operr.bat scripts config jre opatch.bat operr_readme.txt version.txt datapatch modules opatch_env.sh oplan datapatch.bat ocm opatch.pl oracle_common docs opatch…

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…

Use the correct download to patch APEX from 5.1.0 to 5.1.1

When you plan to upgrade Oracle Application Express (APEX) from version 5.1.0 to 5.1.1 please be aware to download a patch from MOS instead the 5.1.1 version from OTN. The text on the OTN page is a bit misleading – and a customer I work with downloaded the wrong version which led to a failed upgrade – even though the scripts seem to be made for this patch upgrade. Even though the page says “This is a cumulative patch set for Application Express 5.1.0” the page offers you a full install and not the patch for an existing APEX 5.1.0…

Download Oracle Database 12.1.0.2 or older versions from the Oracle Software Cloud

I did blog a few weeks back about the download of older versions of the Oracle Database as OTN offers you only the most recent ones. In case you miss the downloads of Oracle Database 12.1.0.2 on OTN Looked pretty simply, huh? Well, here’s quick “how to” to access older Oracle Software downloads from eDelivery aka Oracle Software Cloud. Login to https://edelivery.oracle.com/, the Oracle Software Cloud Start typing “Oracle Database Enter” into the Search by field. It will display you the option below – mark it with a click: Then use the Select Platform drop down list to chose your…

Oracle Database 12.2.0.1 for Windows available

Oracle Database 12.2.0.1 for MS Windows is available as of today for download. Download it from: OTN Oracle Software Cloud The 64bit and 32bit clients are downloadable as well – click on the “See All” link and scroll down a bit on OTN. For future dates and other platforms please see MOS Release Schedule 742060.1 . –Mike

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) If you can’t locate the older release you are looking for please see this blog post I did in addition: Download Oracle Database 12.1.0.2 or older versions from the Oracle Software Cloud –Mike

Oracle Database 12.2.0.1 on-premises is now available, too

Yep – it’s available … Oracle Database 12.2.0.1 on-premises is available for download now not only on Exadata and SuperCluster but on Linux x86-64, SPARC and Intel Solaris. For other platform plans please see MOS Note:742060.1. Oracle Software Delivery Cloud OTN Oracle Database 12c Release 2 (12.2.0.1.0) – Standard Edition 2 and Enterprise Edition Linux x86-64 File 1  (3.2 GB)  See All Oracle Solaris (SPARC systems, 64-bit) File 1  (3.1 GB)  See All Oracle Solaris (x86 systems, 64-bit) File 1  (2.8 GB)  See All –Mike

Oracle Database 12.2 for Exadata/SuperCluster available

Oracle Database 12.2.0.1 on-premises for Exadata and SuperCluster is now available for download from Oracle eDelivery/SoftwareCloud. Connect to eDelivery and login. Search for: “Oracle Database” and mark “Oracle Database Enterprise Edition …” . Click on “Select Platforms” and select “Linux x86-64“, then hit “Continue“: Once you accepted the license agreement you’ll be able to download the software: Please be aware that the software can be installed on Oracle Exadata and Oracle SuperCluster ONLY. To take advantage of the full potential of Oracle Database 12c Release 2 you should upgrade to the latest Exadata Software Release 12.2.1.1.0 before upgrading databases to…

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

Upgrade to Oracle Database 12.2 – Slides are available

The workshops in Brussels and Utrecht were awesome with great audience – I enjoyed both events a lot. And thanks for your patience with my voice and the microphone issues we’ve had in Brussels before lunch. I promised the workshop slides – and here they are, ready for download: Upgrade, Migrate and Consolidate to Oracle Database 12.2 and the Cloud Please be aware: It’s the first drop of the slides, not everything has been updated yet for Oracle Database 12.2, and of course there are no 12.2 customer examples in the slides yet. But as usual, if you plan to…

New PREUPGRADE.JAR is available – MOS 884522.1

As promised – and thanks to everybody from the Database Upgrade Development Team – the new preupgrade.jar for Oracle Database 12.2 is available: MOS Note:884522.1 – Download and Run Oracle’s Database Pre-Upgrade Utility And of course the previous preupgrd.sql with the package utlupkkg.sql and the old utlu112i.sql for upgrade to Oracle 11.2.0.4 (which I wouldn’t do anymore) are available as well. Please ALWAYS use the version downloaded from this MOS note as this version is much newer and better than the version getting shipped due to code freeze dates. And you will recognize that the new preupgrade.jar is now identical…

SANGAM and DOAG Conferences 2016 – Recap + Slides

The past weeks were very intense. I’ve been to Japan for customer meetings and a Dev Day and an internal workshop, then on to China for an internal training, then to India for SANGAM conference and afterwards to Nürnberg for DOAG, the German Oracle User’s Group conference. And UKOUG is just in two weeks … You’ll find the slides of my talks here: Upgrade to Oracle Database 12c – Live and Uncensored How to Ensure Performance Stability when Upgrading Oracle Databases and in the Slides Download Center. Thanks again to the organizers of SANGAM and DOAG for such intense conferences…