Download

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?

Continue reading...

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 …

Continue reading...

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 …

Continue reading...

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 …

Continue reading...

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 …

Continue reading...

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.

OTN Tour South America 2017: Uruguay, Argentina and Brazil

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 …

Continue reading...

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:

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 …

Continue reading...

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.

APEX 5.1.1 Full Version Download

Oracle APEX 5.1.1 download on OTN

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 …

Continue reading...

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.

Looked pretty simply, huh?

Well, here’s quick “how to” to access older Oracle Software downloads from eDelivery aka Oracle Software Cloud.

  1. Login to https://edelivery.oracle.com/, the Oracle Software Cloud
  2. Start typing “Oracle Database Enter” into the Search by field. It will display you the option below – mark it with a click:

    Search - eDelivery - Oracle

    Search Box in the Oracle Software Cloud

  3. Then use
Continue reading...

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:

If you can’t locate the older release you are looking for please see this blog post I did in addition:

–Mike…

Continue reading...

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.

–Mike…

Continue reading...

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 …

Continue reading...

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.

New Preupgrd.sql - 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…

Continue reading...

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

Slides Oracle 12.2 Upgrade Migrate Consolidate

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 …

Continue reading...

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:

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.

New Preupgrd.sql - MOS Note 884522.1

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 …

Continue reading...

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:

and in the Slides Download Center.

Thanks again to the organizers of SANGAM and DOAG for such i…

Continue reading...

New preupgrd.sql is available – MOS 884522.1

A new preupgrd.sql got released this week via MOS Note:884522.1.

Plus use this one for upgrades to Oracle Database 12.1.0.2 instead of the deployed (or any other earlier version).

New Preupgrd.sql - MOS Note 884522.1

Changes since initial release of 12.1.0.2

  • Do not recommend pga_aggregate_limit for 12.1 databases
  • Fix miscalculation of upgrade parallel pdb count
  • Updates to the memory sizing uploaded in build #12
  • Removed the 32-bit and 64-bit values in the manual display.
  • Added a pga_aggregate_limit.
  • Shared_pool_size has gone from 472M to 660M for non-CDB.
  • Memory_target algorithm is more robust now that we’ve added a pga_aggregate_target to its sizing.
  • CDB sizing also in  (And
Continue reading...

OOW 2016: Slides and HOL Download

Sorry for any delay but Roy and I promised to make our OOW 2016 slides available right after the talks. And some people were asking already where they are.

For internal people you’ll find them via the usual sources on database.us.

But customers will have to wait until Oracle Database 12.2 is available in the Cloud as it got announced at OOW during the keynotes.

What you can get right now:

Continue reading...

Proactive Bundle Patches – Change reflected now in MOS as well

Now the Known Isuses and Alerts and Recommended Patches Notes in MOS reflect the naming and classification change of the different types of patches as well.

See in:

MOS Note:1683799.1 – 12.1.0.2 Patch Set – Availability and Known Issues

We don’t speak about Bundle Patches for Exadata and DBIM anymore making it easier to find the correct patch for your platform.

Just wanted to share this as I’m refreshing our upgrade slide deck at the moment 🙂

–Mike…

Continue reading...

New PREUPGRD.SQL is available – Upgrade 12c – Apr16

It’s time for a new and improved version of our team’s preupgrd.sql (comes with the preupgrade package utluppkg.sql).

The April 2016 preupgrd.sql 

Please always download and use the most recent version from:

as this version is 3 years newer than the one you’ll get with a fresh install of Oracle Database 12.1.0.2

preupgrd.sql - April 2016 - MOS Note:884522.1
.

Included in the April 2016 PSU and BP as well

Great news – and very important. Once you apply the most recent April 2016 PSU or BP (recommended – please see here: April 2016 PSU/BP

Continue reading...

Oracle April 2016 PSU and Proactive BPs are there

Hurray, it’s Patching Day!

Sounds a bit like D-Day 😉 But April 19, 2016 the most recent April PSUs (Patch Set Updates) and BPs (Bundle Patches) got released.

Find all the necessary information with the below links:

The important change in the April PSU/BP release:
The database patch for “Engineered Systems and Database In-Memory 12.1.0.2” luckily got renamed into “Proactive Bundle Patch 12.1.0.2”. That is not only a rebranding but it should express that we would like to encourage you to apply the Bundle Patches

Continue reading...

New PREUPGRD.SQL is available for Upgrades to 12c

üreupgrd.sql

As of today a new version of our upgrade tool preupgrd.sql (including the package utluppkg.sql) for upgrades to Oracle Database 12.1.0.2 is available as download from MOS:

Download it and exchange the existing preupgrd.sql and utluppkg.sql in your current Oracle 12.1.0.2 ?/rdbms/admin directory.

–Mike

Continue reading...

New version of our Hands-On Lab available for download “Upgrade/Migrate/Consolidate to Oracle 12c” HOL

Yes! Finally …

Roy did all the hard work and patched all our environments with the most recent PSUs. And he managed also to upload our Hands-On Lab not only internally to retriever (Oracle internally) but also to OTN.

What you’ll be able to do?

  • Upgrade an 11.2.0.4 database UPGR to Oracle Database 12.1.0.2
  • Plug in UPGR into the CDB2, an Oracle Database 12.1.0.2 Container database, and make it a PDB
  • Migrate an 11.2.0.4 database FTEX into another PDB using the Full Transportable Export/Import feature
  • Unplug an Oracle Database 12.1.0.1 PDB and plug it into an Oracle Database 12.1.0.2
Continue reading...

MOS Note:884522.1 – New preupgrd.sql available

Whenever you attempt to upgrade an Oracle database to Oracle Database 12.1.0.2 please get the most recent version of preupgrd.sql, the preupgrade check script, (including the utluppkg.sql package) from MOS Note:884522.1 first.

MOS Note 884522.1
How to Download and Run Oracle’s Database Pre-Upgrade Utility

preupgrd.sql

The new version has many improvements over the previous one – and it is more than 2 years “younger” then the one you’ll get with a standard installation of Oracle Database 12.1.0.2. It will give you also good advice when you are planning a migration.

–Mike…

Continue reading...