Oracle Database 18c for AIX, HP-UX and zLinux available

I rarely blog twice a day – but this message is the one a good number of people have waited for quite a while. Oracle Database 18c for AIX, HP-UX and zLinux available for download from eDelivery as of now. The software is not on OTN or oracle.com yet in the usual download section. I’m blindly guessing that it will be there soon, maybe tonight already. Oracle Database 18c for AIX, HP-UX and zLinux available → Please go to eDelivery (also known as the Oracle Software Cloud) and type into the search line: “Oracle Database” – then hit “Search“. →…

Oracle Express Edition XE 18c available for download

This was hard work right before Oracle Open World – and you had to wait a very long time. The last Oracle Express Edition we delivered was based on Oracle 11.2.0.2. Not exactly the most modern release these days. And my mates, especially Gerald Venzl, but of course also the involved developers and managers worked hard to have Oracle Express Edition XE 18c available for download. It of course has some restrictions. And you can’t get support for it. If you need support for anything, please visit the Community Forum. But it’s pretty cool Oracle database with many of the…

New Oracle Database Upgrade Lab for Oracle 18.3.0

New Oracle Database Upgrade Lab for Oracle 18.3.0 Our new and updated Oracle Database Upgrade Hands-On Lab for Oracle 18.3.0 is finally live and can be downloaded via this link: Download Database Upgrade 18.3.0 Hands-On Lab What’s new? Of course, Oracle 18.3.0 is inside to upgrade to. But we changed the entire instructions set a bit. We included a simple load generator. And we added way more performance stuff. And of course fallback. As soon as Oracle 18.4.0 becomes available, patching will be included in the instructions as well. Everybody should have used OPatch at least once 🙂 What’s in…

Improved preupgrade.jar for Oracle 12.2 and 18c

My team mates are really quick. We received an information early this week about a missing or wrong DV check in the preupgrade – and they implemented it within a day or so. The September 2018 version of the improved preupgrade.jar for Oracle 12.2 and 18c is available for download. Improved preupgrade.jar for Oracle 12.2 and 18c What’s new in this version: It adds a recycle bin check when the autofixup for dictionary statistics is run And it updates DV_AUDIT_CLEANUP  to 11.2.0.4 Please find the new September versions of: Oracle 12.2.0.1 preupgrade.jar – build 17 There’s issue with “creating directories”…

Oracle Database 18c on-prem for MS Windows is available

I know it got delayed a bit. But there’s a good reason for the delay. In addition, my post is a bit late as well but I was on vacation. Anyway, you can download it since Aug 22, 2018. Oracle Database 18c on-prem for MS Windows is available. Oracle Database 18c on-prem for MS Windows is available You can download it from oracle.com and eDelivery: Download Oracle Database 18c from oracle.com Download Oracle Database 18c from eDelivery Start here with the Oracle 18c on Windows Installation Guide. As far as I see, the certification information has not been updated yet…

New August 2018 preupgrade.jar for upgrades to 18c and 12.2.0.1

My team mates worked hard to improve release the new August 2018 preupgrade.jar for upgrades to 18c and 12.2.0.1. You can download both from myOracle Support. New August 2018 preupgrade.jar for upgrades to 18c and 12.2.0.1 As usual, MOS Note: 884522.1 gives you access to the most recent versions of the preupgrade.jar tools (and of course the previous preupgrd.sql and utlu112i.sql scripts). One of the major changes is the inclusion for a check for the XMLCONCAT synonym. Please find the most recent versions here and exchange your current version of preupgrade.jar with the newer ones. –Mike

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