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? 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…
Tag Archives: MyOracle Support
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…
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…
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
Please use the new HTML Support Portal interface
It has taken a while … 😉 But finally Oracle Support is switching the My Oracle Support Portal (MOS) from Flash to HTML. So please when you log in use the switch for HTML. If you’d like to get further information on changes, differences and such please see the following content: MOS Note: 1385682.1 Video Message –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.