List of PREUPGRADE checks executed by preupgrade.jar

Most of you may not care about the checks our Pre Upgrade Check tool preupgrade.jar does. But some may. Especially in cases where you plan to run a command line upgrade unattended via a script. Therefore this List of PREUPGRADE checks executed by preupgrade.jar may help you. List of PREUPGRADE checks executed by preupgrade.jar As a result of a joint initiative between our Upgrade Development team and the Support group dealing with upgrade-related SRs we released this MOS Note: MOS Note: 2380601.1 Database Preupgrade tool check list Purpose of the new MOS note is to give you a complete list…

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…

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

MOS Note 1454618.1: Quick Reference to Database PSUs, CPUs, BPs and Patchsets

Sometimes my mouse arm gets tired by clicking myself through MOS notes just to download a specific PSU or BP – and as I experiment a lot with PSUs and BPs right now I clicked a lot in the past days and nights. Usually I’d start with either MOS Note:161818.1 – then click on the release link (e.g. 12.1.0.x) in the left-most column, then into the Availability and Known Issues not (e.g. MOS Note:1683799.1 for Oracle Database 12.1.0.2.0) and then select the most recent patch from the list of Current Recommended Patches. Even though we all agree that you should…

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: Critical Patch Update – April 2016 Patch Availablity – Oracle Database – April 2016 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 instead…

Tech Tip: Get updates about new/important MOS Notes

There’s nothing more annoying than unwanted and useless email newsletters in your inbox. No doubt. But sometimes I wish to have an alert about important MOS Note changes, recent additions to my favorite notes, updates to the bugs I monitor etc. I would like to know about helpful new MOS articles – when they get published 😉 And this is what you need to do (and I’ll have to apologize for the small pictures but our fancy, modern blog design template does not allow to include larger pictures …). Log into MOS and change your SETTINGS Once you’ve logged in…

MOS Download for Oracle Database 12.1.0.2 including SE2

Please find all our articles about Oracle Database Standard Edition 12.1.0.2 SE2: Sept 17, 2015: SE2 – Some questions, some answers Sept 8, 2015: MOS Download for Oracle SE2 Sept 7, 2015: Support and Patches for Oracle 12.1.0.1 SE/SE1 Sept 3, 2015: Can you have Multitenant with Oracle SE2? Sept 1, 2015: Oracle Standard Edition SE2 available for download   You have 3 options to download Oracle Database Enterprise Edition 12.1.0.2 and Oracle Database Standard Edition 12.1.0.2. SE2. OTN – Oracle Technology Network eDelivery – Oracle Software Delivery Cloud MOS – MyOracle Support https://updates.oracle.com/download/21419221.html Regarding OTN and eDelivery nothing has been…

New MOS Note:1962125.1 – Overview of Database Patch Delivery Methods

Usually I don’t announce MOS Notes but this one may be very helpful to sort out between all the different patches available these days for the database only. From Patch Sets to PSUs to SPUs to Interim Patches to Bundle Patches and so on. Plus it includes also recommendations for testing and if you should apply them on a regular basis. A very important MOS Note for most DBAs: MOS Note:1962125.1 Overview of Database Patch Delivery Methods –Mike

New MOS Notes on Database Upgrades for 12c with or without Oracle Multitenant

Please find some new MyOracle Support (MOS) Notes about Database Upgrades to Oracle Database 12c, with or without Oracle Multitenant: MOS Note: 1503653.1 Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1) . MOS Note: 1932762.1 Complete checklist for manual upgrade from 12.1.0.1 to 12.1.0.N (Full CDB Upgrade) . MOS Note: 1933391.1 Complete checklist for 12c R1 PDB upgrade (Upgrading single/multiple PDB) . MOS Note: 1932340.1 How to execute sql scripts in Multitenant environment (catcon.pl) . MOS Note: 1933011.1 Complete Checklist for DBUA Upgrade from 12.1.0.1 to 12.1.0.N . Credits for the CDB/PDB Notes go to my colleague, Krishnakumar Kunka  🙂 -Mike

11.2.0.3 Pre-Upgrade Script Now Available!

It took a little while because of upgrades to My Oracle Support, but the pre-upgrade script for Oracle Database 11.2.0.3 is now available for download. If you want the latest pre-upgrade script for any supported version of the database, simply go to MOS Note 884522.1 and download the script that corresponds to your destination release. This is a lot easier than downloading the entire kit in order to obtain the script!

Database Upgrade: Most important Support Notes Oracle 11.2.0.2/3

It’s been a while … sorry for not updating the Blog this frequently in the past weeks 😉 But now I’m back in business and today I’m updating our major slide set with some new stuff. And while I’m updating it I thought about what would be the most important MOS (My Oracle Support) Notes on Database Upgrades. Actually I would say you should start here – and these Notes should guide you to the most important bits and pieces around upgrades. I won’t claim that this is THE final list so you might have a look into our comprehensive…

Database Upgrade Troubleshooting Tool

Support recently released a new helpful tool to diagnose upgrade issues post upgrade: The Database Upgrade Troubleshooting Tool. You’ll access it via MOS Note:559339.1 and click on the top link in the middle column: The guided workflow has three steps: 1) Describe Problem 2) Upload Files 3) Review Recommendation Once you have uploaded the upgrade diag log, the upgrade log, alert.log and maybe other things per request of the troubleshooting assistant you should see helpful recommendations. Try it out if you encounter any issues during database upgrade.