MyOracle Support

OPatch … oh OPatch … why is datapatch so stubborn?

Well, it is Friday night – and I’d rather should sleep or do something cool people tend to do on Friday night’s. But I try to verify a strange issue with DBMS_OPTIM_BUNDLE and the October 2018 Update for Oracle 12.2.0.1. I’m patching. Can you think of anything better on a Friday night than patching?

OPatch ... oh OPatch ... why is datapatch so stubborn?

Of course I know that I’m not alone. I know at least two customers I work with right now who do some maintenance jobs tonight as well. And I’m struggling with OPatch … oh OPatch … why is datapatch so stubborn?

My test setup

I have … [ Read more ]

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? [ Read more ]

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 … [ Read more ]

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

MOS Note - Patch Delivery Methods

–Mike

Share this:
[ Read more ]

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!

Share this:
[ Read more ]

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 … [ Read more ]

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:

MOS Note:559339.1

The guided workflow has three steps:
1) Describe Problem
2) Upload Files
3) Review Recommendation

Describe Ugrade Problem

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.

Share this:
[ Read more ]