Troubleshooting

Virtual Classroom Series – Episode 2: Database Upgrade on Feb 18

If you haven’t signed up, there are less than 48 hours left to sign up now to our Virtual Classroom Series – Episode 2: Database Upgrade on Feb 18. We’ll cover everything you need to know for a smooth and successful database upgrade to Oracle 19c.

Virtual Classroom Series - Episode 2: Database Upgrade on Feb 18

What’s the topic this time?

Upgrades.

What else? Haha!

No worries. We have a lot of fresh content and a full agenda. Our focus is to equip you with everything you need to know about upgrades – to make your next upgrade(s) the smoothest upgrade experience ever. We will cover mostly AutoUpgrade but …

Continue reading...

Virtual Classroom Episode 8: Upgrade Internals and so much more

This is your final chance to sign up within the next hours to our Virtual Classroom Episode 8: Upgrade Internals and so much more  We will run this session on Wednesday Feb 10 at 10:00h CET tomorrow. And in case you don’t know yet what to do on a ice-cold winter Wednesday morning, this is what you should do.

Everything You Always Wanted to Know About Upgrades (But Were Afraid to Ask)

Virtual Classroom Episode 8: Upgrade Internals and so much more

You see the agenda in the picture above. We will cover not only internals but also diagnosability, monitoring, troubleshooting, tipps, tricks, secrets, workarounds, gothas, dos and don’ts – …

Continue reading...

datapatch and OPatch documentation and MOS note

Did you ever ask yourself whether there is documentation available for OPatch and for datapatch? It is not easy to find. And you won’t find it under “Database” in the Oracle Bookshelf. So today I would like to guide you in this short blog post to the datapatch and OPatch documentation and MOS note.

OPatch? Datapatch?

Just to recap: You use OPatch (or opatchauto) to apply the binaries to an Oracle installation. As a result, you change the second or the third number of the release from Oracle 19.5.0 to Oracle 19.8.0. But …

Continue reading...

Troubleshooting, Restoring and Restarting AutoUpgrade

What if … something goes wrong during your database upgrade with AutoUpgrade? Of course, this never happens. But just in case, no worries – one of the really big advantages of AutoUpgrade (and the command line upgrade with “dbupgrade” as well) is its resumability and restartablity. But in this blog post I would like to cover a bit more. I will show you more details on Troubleshooting, Restoring and Restarting AutoUpgrade.

Troubleshooting, Restoring and Restarting AutoUpgrade

Photo by Mark Boss on Unsplash

And as often, the cause for this blog post is an email from Hervé Schweitzer, the CTO of dbi-services. Hervé told …

Continue reading...

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.…

Continue reading...