Monitoring catctl.pl progress during upgrades

The parallel upgrade catctl.pl can resume once an upgrade has stopped for unexpected reasons. Before Oracle 12.2 you can restart it with the -p option specifying the phase it stopped. And since Oracle 12.2 you can only use the -R option to resume it. This blog post will give you a bit more insights in monitoring catctl.pl progress during upgrades. Monitoring catctl.pl progress during upgrades I blogged about the resume options for catctl.pl a while ago: Restarting a failed database upgrade with catctl.pl But you may ask yourself: How does the tool know where to resume? And do you need…

Oracle 12.2.0.1 RESTART: Make sure you’ve patched your Oracle 12.1.0.2 homes

This blog post title sounds a bit weird, doesn’t it? Oracle 12.2.0.1 RESTART: Make sure you’ve patched your Oracle 12.1.0.2 homes. Why the heck should you patch your 12.1.0.2 database homes upfront? Oracle 12.2.0.1 RESTART: Make sure you’ve patched your Oracle 12.1.0.2 homes Well, there’s an interesting issue happening. When you work with Oracle Grid Infrastructure, no matter if you operate a cluster or “just” use Oracle Restart, you’ll have to upgrade GI to Oracle 12.2 first before you can manage 12.2 databases with it. That’s not new. It’s a well understood rule. Now guess you operate Oracle RESTART (SIHA…

Oracle RESTART deprecation announcement got withdrawn

Very good news for all customers using Oracle RESTART: The Oracle RESTART deprecation announcement got withdrawn. I have blogged in the past several times about Oracle RESTART of course either regarding upgrade, downgrade and patching: Upgrading from Oracle RESTART from 11.2 to 12.1 Downgrade Oracle RESTART from 12c And one of the customers I work with for quite a while, Swiss Mobiliar Insurance uses Oracle RESTART for all their Oracle Database environments: Customer Success: Swiss Mobiliar Insurance The question all customers I deal with who use Oracle RESTART: How long will Oracle support it? And will there be a successor…

Restarting a failed Database Upgrade with DBUA 12.2

In my previous blog post I did showcase how to restart a failed database upgrade on the command line before Oracle Database 12c, with Oracle Database 12.1.0.x and with the new Oracle Database 12.2.0.x: Restarting a failed Database Upgrade with catctl.pl Here I’d like to show the new capability of the Database Upgrade Assistant (DBUA) to restart an upgrade, a functionality the DBUA was missing until now. Please note that you can always go back to the command line, no matter in which version you have used the DBUA. I won’t describe an upgrade with the DBUA in this blog…

ORAchk 12.1.0.2.3 with new checks + Restart support

Never used or heard about ORAchk? Then it’s time to give it a try!  ORAchk 12.1.0.2.3 has now be released. ORAchk 12.1.0.2.3 has so many great features, especially more than 50 new health checks, OL7 Support – and is now aware of Oracle Restart environments. New features include: Linux on System Z (RHEL 6, RHEL 7, SuSE 12) Oracle Enterprise Linux 7 Single Instance ASM Checks Upgrade Validation checks for 12.1.0.2 Enhanced Golden Gate Checks Enterprise Manager Agent Checks Enhanced Reporting to highlight checks that ORAchk cannot gain full visibility for (checks that require manual validation) Improved health Score Calculation…

Downgrade Oracle Restart 12c – Grid Infrastructure only?

Can you downgrade your Oracle Restart installation from Oracle 12c back to Oracle 11g? Actually there’s no real direct downgrade supported for Oracle Restart. But of course there’s a way to do it. Basically it is: Deconfigure Oracle Restart in 12c Configure Oracle Restart in 11g But wait a minute. It is very important to know if you have upgraded your database already. If that is the case then first you MUST downgrade your database(s) as you can’t manage a higher version Oracle Database with a lower version Clusterware. So first of all, please downgrade your Oracle database(s) first: Downgrade…